• Post Reply Bookmark Topic Watch Topic
  • New Topic

Unable to read entire header  RSS feed

 
Ranch Hand
Posts: 244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I am trying to read an excel file created from Linux Ubuntu machine. I am using POI api to read. But I am getting below error.
Please help.

java.io.IOException: Unable to read entire header; 92 bytes read; expected 512 bytes
at org.apache.poi.poifs.storage.HeaderBlock.alertShortRead(HeaderBlock.java:226)
at org.apache.poi.poifs.storage.HeaderBlock.readFirst512(HeaderBlock.java:207)
at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:104)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:138)
at com.test.ReadExcel.ReadCSV(ReadExcel.java:28)


Java Code:- The same code is working for other excel file created in windows.



Any help is appreaciated.

Thanks,
Kousik
 
Sheriff
Posts: 23512
47
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Kousik Majumder wrote:I am trying to read an excel file created from Linux Ubuntu machine...

Java Code:- The same code is working for other excel file created in windows.



Then to me, the most likely source of the problem is that the files created in Windows are well-formed and the file created in Linux is not. Which means that looking at the code which reads those files isn't going to be helpful at all. You have to look at the process which produces them.
 
Blueberry pie is best when it is firm and you can hold in your hand. Smell it. And smell this tiny ad:
Rocket Oven Kickstarter - from the trailboss
https://coderanch.com/t/695773/Rocket-Oven-Kickstarter-trailboss
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!