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]
