Hi Thomas, > 1) I just downloaded poi-bin-3.6-20091214.zip to my Windows XP PC. > > 2) I unzipped the file into C:\Program Files\Java\ so there is now a > poi-3.6 folder > > 3) I added the following two entries to my CLASSPATH:
You always need this first. C:\Program Files\Java\poi-3.6\poi-3.6-20091214.jar And you will probably want this one next. C:\Program Files\Java\poi-3.6\poi-scratchpad-3.6-20091214.jar > C:\Program Files\Java\poi-3.6\poi-ooxml-3.6-20091214.jar > C:\Program Files\Java\poi-3.6\poi-ooxml-schemas-3.6-20091214.jar Regards, Dave > 4) I rebooted my PC > > 5) Here is my code snippet: > > import org.apache.poi.xssf.usermodel.*; > ... > try > { > XSSFWorkbook wb = new XSSFWorkbook("C:\\MyWorksheet.xlsm"); > XSSFSheet s1 = wb.getSheet("Sheet1"); > XSSFSheet s2 = wb.getSheet("Sheet2"); > > JOptionPane.showMessageDialog( > this, "PhysicalNumberOfRows = " + > s1.getPhysicalNumberOfRows()); > > JOptionPane.showMessageDialog( > this, "LastRowNum = " + s1.getLastRowNum()); > > JOptionPane.showMessageDialog( > this, "PhysicalNumberOfRows = " + > s2.getPhysicalNumberOfRows()); > > JOptionPane.showMessageDialog( > this, "LastRowNum = " + s2.getLastRowNum()); > } > catch (Throwable e) > { > JOptionPane.showMessageDialog( > null, e.toString(), "Read Error", > JOptionPane.ERROR_MESSAGE); > } > > 6) When I compile with the command javac MyApp.java I don't get any > errors. > > 7) When I run my applet using IE (version 6) the following exception is > caught: > java.lang.NoClassDefFoundError: > org/apache/poi/xssf/usermodel/XSSFWorkbook > > What have I forgotten to do to get apache poi working on my PC? > Thomas --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org