cancel
Showing results for 
Search instead for 
Did you mean: 

Error on downloading Excel

Former Member
0 Kudos

Hi all,

I'm tring to write java code into a servlet in order to download an excel, but I have a strange error.Part of code is:

private FileOutputStream outExcel = null;
private HSSFWorkbook workBook = null;
........
........

outExcel = new FileOutputStream("C:"Name.xls");
<i><b>workBook = new HSSFWorkbook();</b></i>
hsSheet = workBook.createSheet("Activity Report");
........

The error is:


Criterio di ricerca: 
Data inizio: 12/03/2006 00:00 
Data fine: 12/09/2006 23:59 
Exception caught java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook at temp.par.web.ProcessInput.doGet(ProcessInput.java:141) at temp.par.web.ProcessInput.doPost(ProcessInput.java:228) at javax.servlet.http.HttpServlet.service(HttpServlet.java:760) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:390) at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:264) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:347) at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:325) at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:887) at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:241) at com.sap.engine.services.httpserver.server.Client.handle(Client.java:92) at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:148) at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33) at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:100) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:170)

Do you have any idea? Thanks a lot.

Vito

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Have you placed the necessary jar file , iguess poi.jar inside your WEB-INF/lib folder?

Former Member
0 Kudos

Yes Joshi,

I inserted the following:

poi-2.5.1-final-20040804.jar

poi-contrib-2.5.1-final-20040804.jar

poi-scratchpad-2.5.1-final-20040804.jar

My Java Virtrual machine is j2sdk1.4.2_10. May be this??

Thanks a lot.

Vito