faq on the POI

View: New views
5 Messages — Rating Filter:   Alert me  

faq on the POI

by ravi shankar-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi ,

I am having one question regarding the POI support for spreadSheet.

There are many spreadSheet engines available in the market like Formula One SpreadSheet Engine.

Can we do the CRUD operations on Xls files which are created from Formula One Spread Sheet

Engine or another SpreadSheet Vendor.

How well is POI compatible with such spreadSheet engines.

Regards

Ravi


Re: faq on the POI

by Avik Sengupta :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

POI tries to be as compatible with Excel as possible. It does not know or care
about sheets produced by other products. If its a valid xls file, POI will
process it, subject to POI's own functionality limitations.

Regards
-
Avik

Quoting ravi shankar <anupindi.shankar@...>:

> Hi ,
>
> I am having one question regarding the POI support for spreadSheet.
>
> There are many spreadSheet engines available in the market like
> Formula One SpreadSheet Engine.
>
> Can we do the CRUD operations on Xls files which are created from
> Formula One Spread Sheet
>
> Engine or another SpreadSheet Vendor.
>
> How well is POI compatible with such spreadSheet engines.
>
> Regards
>
> Ravi
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Re: faq on the POI

by ravi shankar-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi Avik,
            I tried reading Excel5.0/95 using POI APIs but it failed.

            Exception in thread "main" java.io.FileNotFoundException: no such
            entry: "Workbook" at
            org.apache.poi.poifs.filesystem.DirectoryNode.getEntry(DirectoryNode.
            java:245)at  
            org.apache.poi.poifs.filesystem.POIFSFileSystem.createDocumentInputSt
            ream(POIFSFileSystem.java:322)at
            org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:1
            57)at
            org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:1
            30)
            at Excel97Read.main(Excel97Read.java:41)
 
           Does this mean that POI doesn't support Excel5.0/95.
Regards
Ravi          

Two golden Rules to Follow: Forget and Forgive



-----Original Message-----
From avik.sengupta@...
Sent Thu 7/13/2006 9:35 PM
To poi-user@...
Subject Re: faq on the POI

POI tries to be as compatible with Excel as possible. It does not know or care
about sheets produced by other products. If its a valid xls file, POI will
process it, subject to POI's own functionality limitations.

Regards
-
Avik

Quoting ravi shankar <anupindi.shankar@...>:

> Hi ,
>
> I am having one question regarding the POI support for spreadSheet.
>
> There are many spreadSheet engines available in the market like
> Formula One SpreadSheet Engine.
>
> Can we do the CRUD operations on Xls files which are created from
> Formula One Spread Sheet
>
> Engine or another SpreadSheet Vendor.
>
> How well is POI compatible with such spreadSheet engines.
>
> Regards
>
> Ravi
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


RE: faq on the POI

by Birendar Waldiya :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

POI dosent support  Excel5.0/95   this is mention in the jakarta POI site
clearly



Thanks & Regards
Birendar S Waldiya

-----Original Message-----
From: Anupindi Shankar [mailto:ANUPINDI.SHANKAR@...]
Sent: Tuesday, July 18, 2006 11:46 AM
To: POI Users List
Cc: avik.sengupta@...
Subject: Re: faq on the POI

Hi Avik,
            I tried reading Excel5.0/95 using POI APIs but it failed.

            Exception in thread "main" java.io.FileNotFoundException: no
such
            entry: "Workbook" at
 
org.apache.poi.poifs.filesystem.DirectoryNode.getEntry(DirectoryNode.
            java:245)at  
 
org.apache.poi.poifs.filesystem.POIFSFileSystem.createDocumentInputSt
            ream(POIFSFileSystem.java:322)at
 
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:1
            57)at
 
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:1
            30)
            at Excel97Read.main(Excel97Read.java:41)
 
           Does this mean that POI doesn't support Excel5.0/95.
Regards
Ravi          

Two golden Rules to Follow: Forget and Forgive



-----Original Message-----
From avik.sengupta@...
Sent Thu 7/13/2006 9:35 PM
To poi-user@...
Subject Re: faq on the POI

POI tries to be as compatible with Excel as possible. It does not know or
care about sheets produced by other products. If its a valid xls file, POI
will process it, subject to POI's own functionality limitations.

Regards
-
Avik

Quoting ravi shankar <anupindi.shankar@...>:

> Hi ,
>
> I am having one question regarding the POI support for spreadSheet.
>
> There are many spreadSheet engines available in the market like
> Formula One SpreadSheet Engine.
>
> Can we do the CRUD operations on Xls files which are created from
> Formula One Spread Sheet
>
> Engine or another SpreadSheet Vendor.
>
> How well is POI compatible with such spreadSheet engines.
>
> Regards
>
> Ravi
>
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


faq on the POI

by ravi shankar-4 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Can anybody tell me or point me where i can get the
differences between POI and Formula 1 from "ReportingEngines.com" which is a
actuate product.

Till now we were using Formula 1 to do spreadsheet calculations and now we
want to shift to POI.
I want to know using POI can we achieve the same spreadsheet calculations.
is it a safer move?

Regards
Ravi




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@...
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/