CODEWITHSUNDEEP
javaandroidapache-poi
Krukiou
Krukiou

Reputation: 141

android ClassNotFoundException: com.sun.msv.datatype.xsd.XSDatatype

I have an app which use Apache POI. The Build is successfully but when I run the code there is an error (I use Android Studio 2.1) :

Execution failed for task ':app:transformClassesWithInstantRunForDebug'.
java.lang.ClassNotFoundException: com.sun.msv.datatype.xsd.XSDatatype

Here is my code :

package com.example.lionel.xls_test;

import android.app.Activity;
import android.net.Uri;
import android.os.Bundle;
import android.widget.TextView;

import com.google.android.gms.appindexing.Action;
import com.google.android.gms.appindexing.AppIndex;
import com.google.android.gms.common.api.GoogleApiClient;

import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellReference;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;

import java.io.FileInputStream;
import java.io.IOException;

/**
* Created by Lionel on 31/07/2016.
*/
public class MainActivity extends Activity {

private TextView texte = null;

/**
 * ATTENTION: This was auto-generated to implement the App Indexing API.
* See https://g.co/AppIndexing/AndroidStudio for more information.
*/


@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
texte = (TextView) findViewById(R.id.question);

try {
    FileInputStream file = new FileInputStream("C:/test.xls");
    HSSFWorkbook wb = new HSSFWorkbook(file);
    HSSFSheet sheet = wb.getSheetAt(0);
    CellReference cr = new CellReference("A1");
    Row row = sheet.getRow(cr.getRow());
    Cell cell = row.getCell(cr.getCol());
    String name = cell.getStringCellValue();
    texte.setText(name);

} catch (IOException e) {
    e.printStackTrace();
}


}
}

I think that i implemented all the .jar files of POI Apache, here the dependencies :

dependencies {
compile fileTree(include: ['*.jar'], dir: 'libs')
testCompile 'junit:junit:4.12'
compile 'com.android.support:appcompat-v7:23.3.0'
compile project(':poi-3.14-20160307')
compile project(':poi-ooxml-3.14-20160307')
compile project(':poi-ooxml-schemas-3.14-20160307')
compile project(':xmlbeans-2.6.0')
compile 'com.google.android.gms:play-services-appindexing:8.1.0'
compile project(':dom4j-1.6.1')
compile project(':poi-excelant-3.14-20160307')
compile project(':poi-scratchpad-3.14-20160307')
compile project(':commons-codec-1.10')
compile project(':commons-logging-1.2')
compile project(':log4j-1.2.17')
compile project(':junit-4.12')
}

Is there something missing in my code ? Thanks you for your help

Upvotes: 0

Views: 1058

Answers (1)

Nicolas Filotto
Nicolas Filotto

Reputation: 44985

You obviously need to add xsdlib as runtime dependency to your project

Upvotes: 1

Related Questions