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

Question

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.

Keerthivasan · Accepted Answer · 2014-06-24 04:47:19Z

1

You are using the same inputstream mutiple times in your code.i.e you are reading the same inputstream multiple times. That's why this error is thrown. You need to recreate the stream.

 input = new FileInputStream("C:\\Users\\jeet.chatterjee\\Downloads\\Book1.xls");
 //Using same inputstream is not correct
 //Comment the below line
 //POIFSFileSystem fs = new POIFSFileSystem(input);
 XSSFWorkbook wb = new XSSFWorkbook(input);

As a sidenote, you have to close the stream after its usage. I don't see it in your code.

edited Jun 24, 2014 at 4:47

answered Jun 24, 2014 at 4:19

Keerthivasan

12.9k2 gold badges34 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

lucifer Over a year ago

means i should not use the input object here??

Keerthivasan Over a year ago

Comment this line POIFSFileSystem fs = new POIFSFileSystem(input); I don't think you are using fs

lucifer Over a year ago

means i should not use the input object here??but if so then how it will recognize the exel file??

lucifer Over a year ago

@ Octopus Exception in thread "main" org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException: Package should contain a content type part [M1.13] at org.apache.poi.util.PackageHelper.open(PackageHelper.java:41) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:187) at com.mj.test.ReadExcelFileToList.main(ReadExcelFileToList.java:32)

Keerthivasan Over a year ago

Check this one - stackoverflow.com/questions/6758364/…

|

Subho · Accepted Answer · 2014-12-05 08:35:50Z

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();
    }
}
}

Collectives™ on Stack Overflow

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

2 Answers 2

7 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related