lucifer lucifer - 6 months ago 171
Java Question

How to solve java.io.IOException: Read error when reading Excel file using apache POI

I am trying to read an Excel file using Apache POI but I get read error exception.

public class ReadExcelFileToList {

public static void main(String[] args) throws IOException {

InputStream input = null;

try {

input = new FileInputStream(
"C:\\Users\\jeet.chatterjee\\Downloads\\Book1.xls");

System.out.println("file is found");
POIFSFileSystem fs = new POIFSFileSystem(input);
XSSFWorkbook wb = new XSSFWorkbook(input);
XSSFSheet sheet = wb.getSheetAt(0);

Iterator rows = sheet.rowIterator();
while (rows.hasNext()) {
XSSFRow row = (XSSFRow) rows.next();
System.out.println("\n");
Iterator cells = row.cellIterator();
while (cells.hasNext()) {

XSSFCell cell = (XSSFCell) cells.next();
if (XSSFCell.CELL_TYPE_STRING == cell.getCellType())
System.out.print(cell.getStringCellValue() + " ");
else if (XSSFCell.CELL_TYPE_STRING == cell.getCellType())
System.out.print(cell.getStringCellValue() + " ");
else if (XSSFCell.CELL_TYPE_STRING == cell.getCellType())
System.out.print(cell.getStringCellValue() + " ");

else
System.out.print("Unknown cell type");

}

}

} catch (IOException ex) {

ex.printStackTrace();
}

}

}


The exception log is

file is found
java.io.IOException: Read error
at java.io.FileInputStream.readBytes(Native Method)
at java.io.FileInputStream.read(Unknown Source)
at java.io.FilterInputStream.read(Unknown Source)
at java.io.PushbackInputStream.read(Unknown Source)
at java.util.zip.ZipInputStream.readFully(Unknown Source)
at java.util.zip.ZipInputStream.readLOC(Unknown Source)
at java.util.zip.ZipInputStream.getNextEntry(Unknown Source)
at org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.<init>(ZipInputStreamZipEntrySource.java:51)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:83)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:228)
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:39)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:187)
at com.mj.test.ReadExcelFileToList.main(ReadExcelFileToList.java:32)


I get this error while trying to read this Excel file.

Answer

I am also try the same thing.. You should try this.. My excel is data.xlsx. You should use FileInputStream instead of POIFSFileSystem

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.util.Iterator; 
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class JavaApplication3 {

    public static void main(String[] args) {
        try {
           FileInputStream file = new FileInputStream(new File("E:/data.xlsx"));
           XSSFWorkbook wb = new XSSFWorkbook(file);
           XSSFSheet sheet = wb.getSheetAt(0);
           Iterator rows = sheet.rowIterator();
           while (rows.hasNext()) {
             XSSFRow row = (XSSFRow) rows.next();
             System.out.println("\n");
             Iterator cells = row.cellIterator();
             while (cells.hasNext()) {

                XSSFCell cell = (XSSFCell) cells.next();
                if (XSSFCell.CELL_TYPE_NUMERIC == cell.getCellType()) {
                    System.out.print(cell.getNumericCellValue() + "     ");
                } else if (XSSFCell.CELL_TYPE_STRING == cell.getCellType()) {
                    System.out.print(cell.getStringCellValue() + "     ");
                } else if (XSSFCell.CELL_TYPE_BOOLEAN == cell.getCellType()) {
                    System.out.print(cell.getBooleanCellValue() + "     ");
                } else if (XSSFCell.CELL_TYPE_BLANK == cell.getCellType()) {
                    System.out.print("BLANK     ");
                } else {
                    System.out.print("Unknown cell type");
                }
            }
        }
    } catch (IOException ex) {
        ex.printStackTrace();
    }
}
}
Comments