You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Jenny Liu <je...@totaletl.com> on 2004/06/09 16:12:21 UTC
read Excel 95 with POI
Hi,
I am trying to read both Excel 97 and Excel 95 with HSSF usermodel. HSSF
usermodel can not read Excel 95 and it throws an exception.
I am looking at another package called JExcelAPI, which read both 97 and
95. From my understanding, the only difference to read Excel 97 and
Excel 95 is that to getStream("workbook") for 97 and getStream("book")
for 95.
Does POI provide the method to read Excel 95?
Thanks!
Jenny
Re: read Excel 95 with POI
Posted by ac...@apache.org.
Actually, about every record has a 95 and 97 version. When I made this
decision it was based on three things: I didn't have a copy of Excel 95, I
couldn't find anyone who cared about Excel 95, Excel 2000 used the same
format as 97.
Pretty much from this point forward it looks like all Excels will be off the
97 format + new records. Next to nothing is out there in 95 format anymore.
If someone came up with a targeting and divergent set of records for 95,
we'd take the patch but I can't see anyone getting that itch anytime soon.
--
Andrew C. Oliver
http://www.superlinksoftware.com/poi.jsp
Custom enhancements and Commercial Implementation for Jakarta POI
http://jakarta.apache.org/poi
For Java and Excel, Got POI?
The views expressed in this email are those of the author and are almost
definitely not shared by the Apache Software Foundation, its board or its
general membership. In fact they probably most definitively disagree with
everything espoused in the above email.
> From: Danny Mui <da...@muibros.com>
> Reply-To: "POI Users List" <po...@jakarta.apache.org>
> Date: Wed, 09 Jun 2004 13:17:29 -0400
> To: POI Users List <po...@jakarta.apache.org>
> Subject: Re: read Excel 95 with POI
>
> POI's base is Excel 97. If that's all the difference, feel free to dig
> into POIFS/HSSF and see if that can be done quickly (not knowing if this
> has been attempted).
>
>
> Jenny Liu wrote:
>
>> Hi,
>>
>> I am trying to read both Excel 97 and Excel 95 with HSSF usermodel. HSSF
>> usermodel can not read Excel 95 and it throws an exception.
>>
>> I am looking at another package called JExcelAPI, which read both 97 and
>> 95. From my understanding, the only difference to read Excel 97 and
>> Excel 95 is that to getStream("workbook") for 97 and getStream("book")
>> for 95.
>>
>> Does POI provide the method to read Excel 95?
>>
>> Thanks!
>>
>> Jenny
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: read Excel 95 with POI
Posted by Danny Mui <da...@muibros.com>.
POI's base is Excel 97. If that's all the difference, feel free to dig
into POIFS/HSSF and see if that can be done quickly (not knowing if this
has been attempted).
Jenny Liu wrote:
> Hi,
>
> I am trying to read both Excel 97 and Excel 95 with HSSF usermodel. HSSF
> usermodel can not read Excel 95 and it throws an exception.
>
> I am looking at another package called JExcelAPI, which read both 97 and
> 95. From my understanding, the only difference to read Excel 97 and
> Excel 95 is that to getStream("workbook") for 97 and getStream("book")
> for 95.
>
> Does POI provide the method to read Excel 95?
>
> Thanks!
>
> Jenny
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org