Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to read data from .xlsx file using poi 3.5

807588Apr 7 2009 — edited Apr 10 2009
hi

i am reading data from an .xlsx file and i am using jsp. i have importes the following files C:\Users\401345\Desktop\SE5\Tomcat 5.5\common\lib\poi-3.5-beta5-20090219.jar,C:\Users\401345\Desktop\SE5\Tomcat 5.5\common\lib\poi-ooxml-3.5-beta5-20090219.jar,C:\Users\401345\Desktop\SE5\Tomcat 5.5\common\lib\openxml4j-bin-beta-080728.jar,C:\Users\401345\Desktop\SE5\Tomcat 5.5\common\lib\xbean.jar,C:\Users\401345\Desktop\SE5\Tomcat 5.5\common\lib\xbean_xpath.jar,C:\Users\401345\Desktop\SE5\Tomcat 5.5\common\lib\xmlbeans-qname.jar,C:\Users\401345\Desktop\SE5\Tomcat 5.5\common\lib\xmlpublic.jar,C:\Users\401345\Desktop\SE5\Tomcat 5.5\common\lib\ooxml-schemas-1.0.jar.

Now i am just trying to open a new Work Book and read the contents.

when i run the program it's showing the following error.
java.lang.NoClassDefFoundError
org.apache.poi.xssf.usermodel.XSSFWorkbook.newPackage(XSSFWorkbook.java:245)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:145)
org.apache.jsp.read_jsp._jspService(org.apache.jsp.read_jsp:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

please anyone help me to correct the error. Also please send code to read the data if you have.
My code is
<%@page import="org.apache.poi.xssf.usermodel.XSSFWorkbook"%>
<%@page import="org.apache.poi.xssf.usermodel.XSSFSheet"%>
<%@page import="org.apache.poi.ss.usermodel.*"%>
<%@page import="org.apache.poi.ss.util.CellRangeAddress"%>
<%@page import="org.apache.poi.xssf.usermodel.XSSFRow"%>
<%@page import="org.apache.poi.xssf.usermodel.XSSFCell"%>
<%@page import="org.apache.poi.openxml4j.opc.Package"%>
<%@page import="org.apache.xmlbeans.*"%>

<%@page import="java.io.*" %>
<% Workbook wb = new XSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("C://test//workbook.xlsx");
wb.write(fileOut);
fileOut.close();%>.
I wrote the above code to open a WorkBook. Is it right

Please reply

Thanks friends
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2009
Added on Apr 7 2009
8 comments
3,508 views