my dog learned polymorphism*
The moose likes Other Open Source Projects and the fly likes excel sheet data insertion Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "excel sheet data insertion" Watch "excel sheet data insertion" New topic
Author

excel sheet data insertion

premchand Singh
Greenhorn

Joined: Mar 12, 2012
Posts: 28
Hi,
I am trying to insert data from the excel sheet file to the data base through java program..
the rpgram is running and the connection is also being established.........
The code is as follows:


but the following error i am getting while running the program..

java.io.IOException: Invalid header signature; read 43016997712, expected -2226271756974174256

Can anybody please help me.....

Thanks in advance:
Premchand
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19552
    
  16

The Apache POI classes you're using only support files created from Excel 2003 and before (*.xsl). For files created by Excel 2007 and later (*.xslx) you need to use XSSFCell, XSSFRow, XSSFSheet and XSSFWorkbook. If that's not the problem then your file has become corrupted while uploading / copying / ...


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: excel sheet data insertion
 
Similar Threads
A little help
Read Excel Sheet Using Java
How to read xls, xlsx and open office excel formats from java. Any pointers ? Kindly help.
Read Excel values and store in to Database
Java Code to export data to Excel