Guess what ? This spreadsheet has 3 worksheets, but 2 are hidden. So getSheetAt(0) doesn't return what you think.
;) Pierre Cordialement, Pierre Lavignotte Ingénieur Conception & Développement http://pierre.lavignotte.googlepages.com On Thu, Jan 29, 2009 at 12:16 AM, rfconsultant < [email protected]> wrote: > > Yes those 2 lines are the whole stacktrace. I have looked into my > spreadsheet variable several times but it is not null however eclipse > debugger points the variable to be null, I dont for what reason. I have > copied and pasted the whole spreadsheet data into an other exccel file and > the program works perfectly fine. It's very weired why is it happening? If > you want I can send you the spreadsheet on your email address. I really > want to get to the root of problem. > > Cheers > > [email protected] > > > Pierre Lavignotte wrote: > > > > I the 2 lines you wrote in your first email are the whole stacktrace, > then > > I > > think you access a null variable in your code and not in POI code. > > > > > > Cordialement, > > Pierre Lavignotte > > Ingénieur Conception & Développement > > http://pierre.lavignotte.googlepages.com > > > > > > On Wed, Jan 28, 2009 at 5:29 PM, Pierre Lavignotte < > > [email protected]> wrote: > > > >> I don't need the JAR but your stacktrace. > >> > >> Cordialement, > >> Pierre Lavignotte > >> Ingénieur Conception & Développement > >> http://pierre.lavignotte.googlepages.com > >> > >> > >> On Wed, Jan 28, 2009 at 5:26 PM, rfconsultant < > >> [email protected]> wrote: > >> > >>> > >>> I am using poi-3.2-FINAL-20081019.jar. > >>> I have tried to upload both the jar and excel sheet here again and > again > >>> but > >>> I dont know if the files hav been uploaded, as I myself cant see the > >>> uploaded file. If you cant see the uploaded files give me your email > >>> address and I 'll send those files to u through my personal email. > >>> Cheers > >>> > >>> > >>> > >>> Pierre Lavignotte wrote: > >>> > > >>> > 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] > >>> >> > >>> >> > >>> > > >>> > > >>> http://www.nabble.com/file/p21709166/tkroute_oss-rc_090123_4pm.xls > >>> tkroute_oss-rc_090123_4pm.xls > >>> http://www.nabble.com/file/p21709166/poi-3.2-FINAL-20081019.jar > >>> poi-3.2-FINAL-20081019.jar< > http://www.nabble.com/file/p21709166/poi-3.2-FINAL-20081019.jarpoi-3.2-FINAL-20081019.jar > > > >>> http://www.nabble.com/file/p21709166/tkroute_oss-rc_090123_4pm.xls > >>> tkroute_oss-rc_090123_4pm.xls > >>> -- > >>> View this message in context: > >>> > http://www.nabble.com/problem-in-reading-simple-excel-sheet-tp21706313p21709166.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-tp21706313p21717398.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] > >
