Ok.... So please tell what version of POI you use and copy your stacktrace here.
Pierre Cordialement, Pierre Lavignotte Ingénieur Conception & Développement http://pierre.lavignotte.googlepages.com On Wed, Jan 28, 2009 at 4:16 PM, rfconsultant <[email protected] > wrote: > > Noooo! The contents of workbook0 row 3 cell 3 are not null but > AWBE1NI-AWBE1NO and line 22 of java code is > cell = row.getCell((short)3); > . > > > > Pierre Lavignotte wrote: > > > > Hi, > > > > Not sure where you line 22 is, but maybe your sheet 0 or row 3 is null. > > You should test it before use. > > > > Pierre > > > > Cordialement, > > Pierre Lavignotte > > Ingénieur Conception & Développement > > http://pierre.lavignotte.googlepages.com > > > > > > On Wed, Jan 28, 2009 at 3:03 PM, rfconsultant > > <[email protected] > >> wrote: > > > >> > >> 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] > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/problem-in-reading-simple-excel-sheet-tp21706313p21707719.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] > >
