I have written a simple code to read certain cell value in excel sheet. The
program works absoulutely fine with some workbooks but some workbooks r
givin
Exception in thread "main" java.lang.NullPointerException
at Excel_test.main(Excel_test.java:22)
. I dont know whats worong as the data format and location of the excel is
unchanged.(Note: The files with error have macro in that but my program has
nothing to do with macro I am only concerned with the content) java code for
your info is given below
import org.apache.poi.hssf.usermodel.*;
import java.io.*;
public class Excel_test {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
HSSFRow row;
HSSFCell cell;
String s2;
try{
InputStream myxls= new
FileInputStream("C:\\Ericsson\\E4E\\workspace\\Route_updater\\tkroute_oss-rc_090123_4pm.xls");
HSSFWorkbook wb = new HSSFWorkbook(myxls);
HSSFSheet sheet = wb.getSheetAt(0);
row = sheet.getRow(3);
cell = row.getCell((short)3);
if (cell!=null){
s2=cell.getStringCellValue();
System.out.println(s2);
}
}
catch(FileNotFoundException ex)
{
System.out.println("FileNotFoundException : " + ex);
}
catch(IOException ioe)
{
System.out.println("IOException : " + ioe);
}
}
}
--
View this message in context:
http://www.nabble.com/problem-in-reading-simple-excel-sheet-tp21706313p21706313.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
