Unable to read entire header

[Kousik Majumder]

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.

public Vector ReadCSV(String fileName) {
                Vector cellVectorHolder = new Vector();

                try {
                        FileInputStream myInput = new FileInputStream(fileName);
                        POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput);
                        HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem);
                        HSSFSheet mySheet = myWorkBook.getSheetAt(0);
                        Iterator rowIter = mySheet.rowIterator();

                        while (rowIter.hasNext()) {
                                HSSFRow myRow = (HSSFRow) rowIter.next();
                                Iterator cellIter = myRow.cellIterator();
                                Vector cellStoreVector = new Vector();
                                while (cellIter.hasNext()) {
                                        HSSFCell myCell = (HSSFCell) cellIter.next();
                                        cellStoreVector.addElement(myCell);
                                }
                                cellVectorHolder.addElement(cellStoreVector);
                        }
                } catch (Exception e) {
                        e.printStackTrace();
                }
                return cellVectorHolder;
        }

Any help is appreaciated.

Thanks,
Kousik

[Paul Clapham]

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.