In my experience "Program Files" causes a problem (because I think due to the space) in the classpath try "progra~1" instead
-----Original Message----- From: David Fisher [mailto:[email protected]] Sent: 11 August 2010 19:17 To: POI Users List Subject: Re: Installation Problems I am not sure how you activate an applet using IE6. If your applet is running in the browser then it is probably using a different classpath than javac. Here try google and look at the third entry - it might help you. http://lmgtfy.com/?q=java+classpath+for+IE+applet Careful it suggests you change your registry. Regards, Dave On Aug 11, 2010, at 11:00 AM, Thomas P Laford wrote: > Hello Dave, > > Thank you for your quick reply to my inquiry. As you recommended, I have > updated my CLASSPATH so it now includes: > C:\Program Files\Java\poi-3.6\poi-3.6-20091214.jar > 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 > > I rebooted my PC (just in case it was necessary). javac compiled without > any errors, but when I try to activate the applet using IE6, I still get > java.lang.NoClassDefFoundError: org/apache/poi/xssf/usermodel/XSSFWorkbook > > Thomas > > > > From: > David Fisher <[email protected]> > To: > "POI Users List" <[email protected]> > Date: > 08/11/2010 01:44 PM > Subject: > Re: Installation Problems > > > > 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: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
