how to read data from .xlsx file using poi 3.5
807588Apr 7 2009 — edited Apr 10 2009hi
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