• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

excel sheet data insertion

 
premchand Singh
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 20669
65
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 / ...
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic