Error in reading Excel data using jsp
ERROR while executing bellow code:java.io.IOException: Invalid header signature; read 576460838270094160, expected -2226271756974174256
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<table border="1">
<%
short a=0;
short b=1;
short c=2;
short d=3;
int i=0;
String value1="", value2="",value3=" ", value4="";
String filename ="C:/hello.xls";
if (filename != null && !filename.equals("")) {
try{
FileInputStream fs =new FileInputStream(filename);
HSSFWorkbook wb = new HSSFWorkbook(fs);
for (int k = 0; k < wb.getNumberOfSheets(); k++){
int j=i+1;
HSSFSheet sheet = wb.getSheetAt(k);
int rows = sheet.getPhysicalNumberOfRows();
for (int r = 0; r < rows; r++){
HSSFRow row = sheet.getRow(r);
int cells = row.getPhysicalNumberOfCells();
out.write("<br>");
HSSFCell cell1 = row.getCell(a);
value1 = cell1.getStringCellValue();
HSSFCell cell2 = row.getCell(b);
value2 = cell2.getStringCellValue();
HSSFCell cell3 = row.getCell(c);
value3 = cell3.getStringCellValue();
HSSFCell cell4 = row.getCell(d);
value4 = cell4.getStringCellValue();
%>
<tr><td><%=value1%></td><td><%=value2%></td><td><%=value3%></td><td><%=value4%></td></tr>
<%
}
i++;
}
}
catch(Exception e){
System.out.println(e);
}
}
%>
</table>
can anyone help me what is the solution for this.
View Answers
February 28, 2011 at 12:12 PM
Do you have hello.xls in your c: drive?If not then create it.Anyways do you have POI library in the lib folder of your apache tomcat?
Here is the code:
<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<table border="1">
<%
short a=0;
short b=1;
short c=2;
short d=3;
int i=0;
String value1="", value2="",value3=" ", value4="";
String filename ="C:/hello.xls";
if (filename != null && !filename.equals("")) {
try{
FileInputStream fs =new FileInputStream(filename);
HSSFWorkbook wb = new HSSFWorkbook(fs);
for (int k = 0; k < wb.getNumberOfSheets(); k++){
int j=i+1;
HSSFSheet sheet = wb.getSheetAt(k);
int rows = sheet.getPhysicalNumberOfRows();
for (int r = 0; r < rows; r++){
HSSFRow row = sheet.getRow(r);
int cells = row.getPhysicalNumberOfCells();
out.write("<br>");
HSSFCell cell1 = row.getCell(a);
value1 = cell1.getStringCellValue();
HSSFCell cell2 = row.getCell(b);
value2 = cell2.getStringCellValue();
HSSFCell cell3 = row.getCell(c);
value3 = cell3.getStringCellValue();
HSSFCell cell4 = row.getCell(d);
value4 = cell4.getStringCellValue();
%>
<tr><td><%=value1%></td><td><%=value2%></td><td><%=value3%></td><td><%=value4%></td></tr>
<%
}
i++;
}
}
catch(Exception e){
System.out.println(e);
}
}
%>
</table>
February 28, 2011 at 12:30 PM
Hi,
hello.xls and POI library files are there in respective folders.
the printStackTrce() method shows the following Error message on console.
----------
java.io.IOException: Invalid header signature; read 576460838270094160, expected -2226271756974174256
at org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java:88)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:83)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:230)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:211)
at org.apache.jsp.AdminSaaS.excelreading_jsp._jspService(excelreading_jsp.java:71)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.valves.FastCommonAccessLogValve.invoke(FastCommonAccessLogValve.java:495)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
April 19, 2012 at 1:27 PM
Your .xls is not a proper xls file. It's a text file with a .xls extension s.t. Excel can quietly convert it and display as a spreadsheet. HSSF deals with files written in Excel format only.
I know the cause but donno the solution.
Thanks.
Related Tutorials/Questions & Answers:
Error in reading Excel data using jspError in
reading Excel data using jsp
ERROR while executing bellow...() method shows the following
Error message on console...)
at org.apache.jsp.AdminSaaS.excelreading_
jsp._jspService(excelreading_jsp.java:71
excel sheet reading and using that data - JSP-Servletexcel sheet
reading and
using that data i have to do a read a
excel sheet file of a employee record and then i have to use a employee details to send mail to those employees how to do in
jsp sir please help me sir..
Thanks
Advertisements
reading data using struts and jsp javareading data using struts and
jsp java how can i read
data entered by user into a textbox (
jsp page) into struts action class ex emp id,so that after
reading emp_id it can be read into struts action class for retrieving other
Reading excel via JSP Reading excel via
JSP The problem is while
reading cells values... the space between words and get full cell value? I am
reading the value...(means while
reading the cell values space should be ignored between the words
jsp data in excel - JSP-Servlet in
jsp using table. and getting this
data from servlet which has query and this query
data has come from beans and
using beans i put it in
excel jsp in table...
jsp data in excel i have create
jsp page which has button
update excel sheet using jsp:: update
excel sheet
using jsp:: Hi Sir,...
I have a
excel... given
excel sheet and display it into
another
excel sheet
using jsp"
i am
using 'session' to get the empid from one page to another
jsp reading data from excel file and plotting graphreading data from
excel file and plotting graph I am doing a project
using NetBeans in which i have to take input an
excel file and then
using... that reads an
excel file
using POI api and
using the
data of
excel file
read excel data from jsp - JSP-Servletread
excel data from jsp Hi
how to read
excel file from
jsp?
Excel file is created manually entered
data having many sheets? and read the entire sheet and also edit with
jsp?
pls suggest me?
Hi Friend,
1
To save table format data in pdf/excel in jspTo save table format
data in pdf/
excel in jsp Hello,
I am doing web application project in
jsp. In webform ,I am displaying database
data in html table. So my question is ,I want so save this html format
data in pdf/
excel format
Dynamic table data to Excel in JSP Dynamic table
data to
Excel in
JSP Iam trying to export dynamic
data to
excel . But it is displaying only static
data .Kindly help
viewtrial.jsp.../vnd.ms-
excel");
response.setHeader("Content-Disposition", "inline
Insert data in Excel File from Database using JSP
Insert
data in
Excel File from Database
using
JSP ... developed a application to
insert data in
excel file from database in
JSP. We... will retrieve the
data from database, create an
excel file and
data
insert
JSP TO EXCELJSP TO EXCEL Hi sir/mam,
How to import
data to
excel using jsp without retrieving database.
friend,
you can't import
excel data into the middle of an HTML pages (your
JSP will result in an HTML page
export data to excel sheet - JSP-Servletexport
data to
excel sheet Hi..
how to export
data to
excel sheet from
jsp?
and how to update the
excel sheet from
jsp?
and how to get the
data from
excel sheet?
and how to make calculations in
excel sheet like total avg
reading excel sheet in javareading excel sheet in java can anyone tell me a proper java code to read
excel sheet
using poi
Here is a java code that reads an
excel file
using POI api and display the
data on the console.
import java.io.
Excel sheet image reading issueExcel sheet image
reading issue
Hello every one.I?m trying to read
images from an
excel sheet
using
OleDbDataReader. My
excel file has 6
columns of
data, the first 5 are all
text but the last is image. While I?m
Jsp to Excel an
excel file and write
data
into it
using jsp. For this, you have to import...
Jsp to
Excel
... value of any
data type into cell by
using this method.ADS_TO_REPLACE_2
Here
Reading an excel file into arrayReading an
excel file into array Hi,
I'm trying to read in an
excel file, search a column for containing key words (entered by a user) and then displaying the matching rows in a table. I'm fairly new to JavaScript. Can anyone
jsp to excel - JSP-Servletjsp to excel Hi All, I'm writing a program of
jsp to
Excel conversion with
Using POI. My problem is i'm unable to put multiple
data into
excel...)); } FileOutputStream fileOut = new FileOutputStream("c:\\
excel\\wct.xls
jsp excel code - JSP-Servletjsp excel code hi
how to store html form
data into
excel sheet by
using jsp?
and repeat this process continuously for entire sheet
Error in using java beans - JSP-ServletError in
using java beans I am getting the following
error when I run the
jsp code.
type Exception report
message
description The server encountered an internal
error () that prevented it from fulfilling this request
Set Data Format in Excel Using POI 3.0
Set
Data Format in
Excel
Using POI 3.0
In this program we are setting
data format in
excel... of this will be
11,111.1 .To set the
data format we are
using Reading and querying an Excel file in JavaScriptReading and querying an
Excel file in JavaScript Hi,
I'm trying to read in an
excel file, search a column for containing key words (entered by a user) and then displaying the matching rows in a table. I'm fairly new
Excel - JSP-ServletExcel How to export
data from
jsp to
excel sheet. I am
using struts1.2 in my application. Hi friend,
Code to
data from
Jsp to
excel...
"success.jsp"
For more information on
excel sheet
Using jsp excel code - JSP-Servletjsp excel code Hi
how to insert form
data into
excel file
using jsp? Hi Friend,
Try the following code:
1)register.jsp:
Registration Form
First Name:
Last Name:
User Name:
Password