JXL and Apache POI parsing excel with attached image objects?

One thing to try is using a newer version of Apache POI - bugs like this get fixed over time.

Up vote 4 down vote favorite 1 share g+ share fb share tw.

I have tried using JXL and Apache POI to load data from an excel file, up until now the JXL mechanism has worked fine. Even if I embed an images in the file. I received a file from a source which won't parse, I get the following exception with POI Exception in thread "main" org.apache.poi.hssf.record.

RecordInputStream$LeftoverDataException: Initialisation of record 0xE2 left 2 bytes remaining still to be read. At org.apache.poi.hssf.record. RecordInputStream.

HasNextRecord(RecordInputStream. Java:124) at org.apache.poi.hssf.record.RecordFactory. CreateRecords(RecordFactory.

Java:402) at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook. Java:277) at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook. Java:202) at org.apache.poi.hssf.usermodel.HSSFWorkbook.(HSSFWorkbook.

Java:184) at testXlsParsers. Main(TestXlsParsers. Java:19) and with jxl I get an index out of bounds Exception in thread "main" java.lang.

IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList. RangeCheck(ArrayList. Java:546) at java.util.ArrayList.

Get(ArrayList. Java:321) at jxl.read.biff.WorkbookParser. GetSheet(WorkbookParser.

Java:247) at ParserXLS. Parse(ParserXLS. Java:27) at ParserXLS.

Main(ParserXLS. Java:46) The file loads into excel but not into open office and the only thing I can see in the raw data is the Adobe XMP Core 4.1 related object... which seems to be the cause of the problem, if I remove the image it works fine... if I stick another jpg in its fine. Is there some way to ignore this?

How would I go about parsing this file. Thanks. Java excel ole apache-poi jxl link|improve this question edited Apr 10 '11 at 17:12Gagravarr3,3573519 asked Sep 21 '09 at 23:21Fearstruck1216.

One thing to try is using a newer version of Apache POI - bugs like this get fixed over time. If the latest version of POI doesn't help (3.8 beta 2 as of writing), you should open a new bug in the POI bugzilla, and upload the problem file. The exception you're seeing is caused by POI believing that there should be a certain amount of data, and finding more.

With the file it'll be possible to identify why that data's there, and work around it. (That is, assuming it hasn't already been fixed! ).

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.