Java Apache POI Excel reading exception

Question

I'm trying to use POI to read an Excel file. It will be a large file ( > 50k rows) so I'm using the eventusermodel rather than the simpler usermodel which reads the entire file into memory. My code looks like:

    File file = new File("C:\\bigfile.xls");
    InputStream input = new FileInputStream(file);
    EventRecordFactory factory = new EventRecordFactory(new ERFListener() {
        @Override
        public boolean processRecord(Record rec)
        {
            return true;
        }
    }, RecordFactory.getAllKnownRecordSIDs());
    factory.processRecords(input);

But I get the exception

org.apache.poi.hssf.record.RecordFormatException: The content of an excel record cannot exceed 8224 bytes

This exception was supposedly fixed in 3.5, however, I'm using 3.6 and I also tried the latest trunk pull from POI and still the same issue.

I've tried shrinking the file to just have a few rows but the same error. Has anyone dealt with this before?

thanks, Jeff

You ever get an answer on this? I'm having the same trouble and I can't seem to find an answer any where. — Henry
– Henry, Commented Jul 29, 2010 at 17:28

Thariq Nugrohotomo · Accepted Answer · 2013-09-25 08:46:41Z

1

You should use EventRecordFactory.processRecords method with DocumentInputStream type as it's parameter. (instead of pure FileInputStream).

POIFSFileSystem poifs = new POIFSFileSystem(input);
DocumentInputStream documentInputStream = poifs.createDocumentInputStream("Workbook");
factory.processRecords(documentInputStream);

answered Sep 25, 2013 at 8:46

Thariq Nugrohotomo

7531 gold badge6 silver badges14 bronze badges

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

Comments

Vinodh Ramasubramanian · Accepted Answer · 2010-02-01 21:55:26Z

0

Do you have any large comments in the excel file. If so could you try after removing the comments.

answered Feb 1, 2010 at 21:55

Vinodh Ramasubramanian

3,1951 gold badge22 silver badges17 bronze badges

1 Comment

Jeff Storey Over a year ago

I removed everything except two rows "a b c" and "d e f" but still getting the error.

Collectives™ on Stack Overflow

Java Apache POI Excel reading exception

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related