Win a flower (🌹) or copy of Real-World Software Development: A Project-Driven Guide to Fundamentals in Java (📚) this week in the Agile and Other Processes forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Liutauras Vilda
  • Knute Snortum
  • Bear Bibeault
master stewards:
  • Devaka Cooray
  • Jeanne Boyarsky
  • Junilu Lacar
garden masters:
  • Ron McLeod
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • salvin francis
gardeners:
  • Tim Holloway
  • Piet Souris
  • Frits Walraven

excel sheet data insertion

 
pioneer
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
 
master steward
Posts: 21864
105
Eclipse IDE Spring VI Editor Chrome Java Ubuntu 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 / ...
 
You can't expect to wield supreme executive power just because
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!