Re: Reading Excel 5.0/7.0 files

[bestfrieend <wa...@hotmail.com>]

when i try to run jexcel api on excel 95 files it throws the following
exception

java.lang.StringIndexOutOfBoundsException: String index out of range: 120

can anyone please tell me how to read older excel files?

Thanks,

Wasif



--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Reading-Excel-5-0-7-0-files-tp2302502p5721022.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Reading Excel 5.0/7.0 files

[Nick Burch <ap...@gagravarr.org>]

On Mon, 23 Nov 2015, bestfrieend wrote:
> can anyone please tell me how to read older excel files?

Apache POI doesn't have any high-level APIs for working with the older 
Excel file formats.

If you just want the textual contents, then there's 
org.apache.poi.hssf.extractor.OldExcelExtractor which will pull out the 
text and numbers from the file

If you need the values in specific cells, then you'll need to take an 
approach a bit like OldExcelExtractor, process the file at the record 
level, and check for the co-ordinates on OldStringRecord, NumberRecord, 
OldFormulaRecord and friends

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org