i using apache poi extract data excel sheet , trying save extracted values in array.
i getting java.lang.nullpointerexception
error.
i searched it, , apparently exception triggered when try assign value object value null
.
i tried many example, example codes print out cell value. want save them in array perform calculation.
package excelltotext; import java.io.*; import java.lang.*; import java.util.*; import org.apache.poi.hssf.usermodel.hssfcell; import org.apache.poi.hssf.usermodel.hssfsheet; import org.apache.poi.hssf.usermodel.hssfworkbook; import org.apache.poi.ss.usermodel.cell; import org.apache.poi.ss.usermodel.formulaevaluator; import org.apache.poi.ss.usermodel.row; import org.apache.poi.xssf.usermodel.xssfsheet; import org.apache.poi.xssf.usermodel.xssfworkbook; public class convert { @suppresswarnings("null") public static void main(string[] args) throws ioexception { double [] modify = null ; fileinputstream fs = new fileinputstream(new file ("book1.xlsx")); xssfworkbook wb = new xssfworkbook(fs); xssfsheet sheet = wb.getsheetat(0); formulaevaluator formulaevaluater = wb.getcreationhelper().createformulaevaluator(); (row row:sheet) { int num = 0; for(cell cell : row){ switch (formulaevaluater.evaluate(cell).getcelltype()) { case cell.cell_type_numeric: modify [num] = ( cell.getnumericcellvalue()); num += num; } system.out.println(modify[num]); } } } }
any suggestions appreciated.
your modify
array null num += num;
give npe. need create array egzample double [] modify = new double[1000];
instead of double [] modify = null ;
Comments
Post a Comment