You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by "KHZ (SAW)" <ka...@sawag.com> on 2006/07/26 12:06:16 UTC
AW: How to use POI for reading Excel 2.1 format?
Hi Suyog.
With OpenOffice.org (OOo) you can do it using Java. Just look at the thread
about how converting from Excel 95 (the version below) which was just 2 days
ago.
In your case it's just the other direction (some version above).
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: Suyog Mahajan [mailto:suyog.mahajan@outworx.com]
Gesendet: Mittwoch, 26. Juli 2006 12:08
An: poi-user@jakarta.apache.org
Betreff: How to use POI for reading Excel 2.1 format?
Hi,
I have this requirement of reading and then processing the read data from an
Excel file which is in Excel 2.1 format. I have tried using POI, but my
experience was that POI works well for Excel 97 above, which definitely
excludes Excel 2.1 format. Now there are 2 solutions:
a) Either I convert manually all the excel files into Excel 2000 format by
opening them using MS Office. Which SHOULD NOT be done, because as per
requirement everything needs to be done using Java code.
b) Either find a way using Java to convert the file format, or use a totally
different Java API which might support Excel 2.1 formats. (I have also tried
using JDBC-ODBC DSN for Excel, but it also fails for this old format).
The system I am working on, has office 2000 installed on it, and these excel
files are obtained from external server.
Any help in this regard will be highly appreciated.
Thanks.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
AW: How to use POI for reading Excel 2.1 format?
Posted by "KHZ (SAW)" <ka...@sawag.com>.
Hi Suyog.
I used it already some years ago. So I'm not so much inside the details.
They've a mailing list (dev@sc.openoffice.org) (SC is standing for
spreadsheet, the pendant to Excel and being able to read from and write to
Excel). I had a very good experience in that mailing list. Several people
from Sun helped a lot. Let's hope that Sun's shrinking hasn't affected this.
If I see code snippets I could compare it with my application from that
time.
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: Suyog Mahajan [mailto:suyog.mahajan@outworx.com]
Gesendet: Donnerstag, 27. Juli 2006 08:02
An: POI Users List
Betreff: Re: How to use POI for reading Excel 2.1 format?
Hi,
Sorry for a silly question, but I am really stuck and not able to run even
the OpenOffice APIs. My code is unable to instantiate the BootStrap of
OpenOffice. I have set the basic environment variables properly, and the
libs are also in place, but still not able to run the code. I know I am
missing something in configuration, but unable to figure out what.
The exception I get is the BootStrapException: "no office executable found!"
Please can anyone help me in figuring out, what might be missing in my
configuration?
Thanks,
Suyog
----- Original Message -----
From: "Tom Schindl" <li...@bestsolution.at>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Wednesday, July 26, 2006 4:52 PM
Subject: Re: How to use POI for reading Excel 2.1 format?
> No. Then you cannot use OpenOffice there is currently no possibility to
> only install the libs needed to read/write from the whole application.
>
> Tom
>
> Suyog Mahajan schrieb:
> > Hi Tom,
> >
> > Thats exactly what my concern is. I dont want to be dependent on the
> > installation of OpenOffice for this purpose. Depending on the OpenOffice
> > installation will mean that I will have to port OpenOffice along with my
own
> > application. Is there any other workaround to solve this problem?
> >
> > Thanks,
> > Suyog
> >
> > ----- Original Message -----
> > From: "Tom Schindl" <li...@bestsolution.at>
> > To: "POI Users List" <po...@jakarta.apache.org>
> > Sent: Wednesday, July 26, 2006 4:34 PM
> > Subject: Re: How to use POI for reading Excel 2.1 format?
> >
> >
> >> Suyog Mahajan schrieb:
> >>> Hi Karl,
> >>>
> >>> Thanks for your prompt response. I have already seen that thread about
> > using
> >>> OOo for format conversion. But I am unable to figure out how to use
it.
> > The
> >>> solution I am looking for, is like a JAR file, you simply port it with
> > your
> >>> application, and this JAR file contains all the necessary java classes
> > to
> >>> allow me to use the OO-UNO API and thus allow me to do the conversion.
> >>> >From the SDK I can figure out that, I will have to compile the code
> >>> separately, create such a JAR file manually and then add it to my
> > project,
> >>> which seems a very long process to me. Is this the only way or am I
> > simply
> >>> exaggarating the effort involved?
> >>>
> >>> Thanks,
> >>> Suyog
> >>>
> >> You don't have to compile anything your own you simply have to have
> >> OpenOffice installed on your system. Then the snippet can be used as
is.
> >>
> >> Tom
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >> 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@jakarta.apache.org
> > 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@jakarta.apache.org
> 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@jakarta.apache.org
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@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: How to use POI for reading Excel 2.1 format?
Posted by Suyog Mahajan <su...@outworx.com>.
Hi,
Sorry for a silly question, but I am really stuck and not able to run even
the OpenOffice APIs. My code is unable to instantiate the BootStrap of
OpenOffice. I have set the basic environment variables properly, and the
libs are also in place, but still not able to run the code. I know I am
missing something in configuration, but unable to figure out what.
The exception I get is the BootStrapException: "no office executable found!"
Please can anyone help me in figuring out, what might be missing in my
configuration?
Thanks,
Suyog
----- Original Message -----
From: "Tom Schindl" <li...@bestsolution.at>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Wednesday, July 26, 2006 4:52 PM
Subject: Re: How to use POI for reading Excel 2.1 format?
> No. Then you cannot use OpenOffice there is currently no possibility to
> only install the libs needed to read/write from the whole application.
>
> Tom
>
> Suyog Mahajan schrieb:
> > Hi Tom,
> >
> > Thats exactly what my concern is. I dont want to be dependent on the
> > installation of OpenOffice for this purpose. Depending on the OpenOffice
> > installation will mean that I will have to port OpenOffice along with my
own
> > application. Is there any other workaround to solve this problem?
> >
> > Thanks,
> > Suyog
> >
> > ----- Original Message -----
> > From: "Tom Schindl" <li...@bestsolution.at>
> > To: "POI Users List" <po...@jakarta.apache.org>
> > Sent: Wednesday, July 26, 2006 4:34 PM
> > Subject: Re: How to use POI for reading Excel 2.1 format?
> >
> >
> >> Suyog Mahajan schrieb:
> >>> Hi Karl,
> >>>
> >>> Thanks for your prompt response. I have already seen that thread about
> > using
> >>> OOo for format conversion. But I am unable to figure out how to use
it.
> > The
> >>> solution I am looking for, is like a JAR file, you simply port it with
> > your
> >>> application, and this JAR file contains all the necessary java classes
> > to
> >>> allow me to use the OO-UNO API and thus allow me to do the conversion.
> >>> >From the SDK I can figure out that, I will have to compile the code
> >>> separately, create such a JAR file manually and then add it to my
> > project,
> >>> which seems a very long process to me. Is this the only way or am I
> > simply
> >>> exaggarating the effort involved?
> >>>
> >>> Thanks,
> >>> Suyog
> >>>
> >> You don't have to compile anything your own you simply have to have
> >> OpenOffice installed on your system. Then the snippet can be used as
is.
> >>
> >> Tom
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> >> 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@jakarta.apache.org
> > 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@jakarta.apache.org
> 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@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: How to use POI for reading Excel 2.1 format?
Posted by Tom Schindl <li...@bestsolution.at>.
No. Then you cannot use OpenOffice there is currently no possibility to
only install the libs needed to read/write from the whole application.
Tom
Suyog Mahajan schrieb:
> Hi Tom,
>
> Thats exactly what my concern is. I dont want to be dependent on the
> installation of OpenOffice for this purpose. Depending on the OpenOffice
> installation will mean that I will have to port OpenOffice along with my own
> application. Is there any other workaround to solve this problem?
>
> Thanks,
> Suyog
>
> ----- Original Message -----
> From: "Tom Schindl" <li...@bestsolution.at>
> To: "POI Users List" <po...@jakarta.apache.org>
> Sent: Wednesday, July 26, 2006 4:34 PM
> Subject: Re: How to use POI for reading Excel 2.1 format?
>
>
>> Suyog Mahajan schrieb:
>>> Hi Karl,
>>>
>>> Thanks for your prompt response. I have already seen that thread about
> using
>>> OOo for format conversion. But I am unable to figure out how to use it.
> The
>>> solution I am looking for, is like a JAR file, you simply port it with
> your
>>> application, and this JAR file contains all the necessary java classes
> to
>>> allow me to use the OO-UNO API and thus allow me to do the conversion.
>>> >From the SDK I can figure out that, I will have to compile the code
>>> separately, create such a JAR file manually and then add it to my
> project,
>>> which seems a very long process to me. Is this the only way or am I
> simply
>>> exaggarating the effort involved?
>>>
>>> Thanks,
>>> Suyog
>>>
>> You don't have to compile anything your own you simply have to have
>> OpenOffice installed on your system. Then the snippet can be used as is.
>>
>> Tom
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> 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@jakarta.apache.org
> 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@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: How to use POI for reading Excel 2.1 format?
Posted by Suyog Mahajan <su...@outworx.com>.
Hi Tom,
Thats exactly what my concern is. I dont want to be dependent on the
installation of OpenOffice for this purpose. Depending on the OpenOffice
installation will mean that I will have to port OpenOffice along with my own
application. Is there any other workaround to solve this problem?
Thanks,
Suyog
----- Original Message -----
From: "Tom Schindl" <li...@bestsolution.at>
To: "POI Users List" <po...@jakarta.apache.org>
Sent: Wednesday, July 26, 2006 4:34 PM
Subject: Re: How to use POI for reading Excel 2.1 format?
> Suyog Mahajan schrieb:
> > Hi Karl,
> >
> > Thanks for your prompt response. I have already seen that thread about
using
> > OOo for format conversion. But I am unable to figure out how to use it.
The
> > solution I am looking for, is like a JAR file, you simply port it with
your
> > application, and this JAR file contains all the necessary java classes
to
> > allow me to use the OO-UNO API and thus allow me to do the conversion.
> >>From the SDK I can figure out that, I will have to compile the code
> > separately, create such a JAR file manually and then add it to my
project,
> > which seems a very long process to me. Is this the only way or am I
simply
> > exaggarating the effort involved?
> >
> > Thanks,
> > Suyog
> >
>
> You don't have to compile anything your own you simply have to have
> OpenOffice installed on your system. Then the snippet can be used as is.
>
> Tom
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> 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@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: How to use POI for reading Excel 2.1 format?
Posted by Tom Schindl <li...@bestsolution.at>.
Suyog Mahajan schrieb:
> Hi Karl,
>
> Thanks for your prompt response. I have already seen that thread about using
> OOo for format conversion. But I am unable to figure out how to use it. The
> solution I am looking for, is like a JAR file, you simply port it with your
> application, and this JAR file contains all the necessary java classes to
> allow me to use the OO-UNO API and thus allow me to do the conversion.
>>>From the SDK I can figure out that, I will have to compile the code
> separately, create such a JAR file manually and then add it to my project,
> which seems a very long process to me. Is this the only way or am I simply
> exaggarating the effort involved?
>
> Thanks,
> Suyog
>
You don't have to compile anything your own you simply have to have
OpenOffice installed on your system. Then the snippet can be used as is.
Tom
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: How to use POI for reading Excel 2.1 format?
Posted by Suyog Mahajan <su...@outworx.com>.
Hi Karl,
Thanks for your prompt response. I have already seen that thread about using
OOo for format conversion. But I am unable to figure out how to use it. The
solution I am looking for, is like a JAR file, you simply port it with your
application, and this JAR file contains all the necessary java classes to
allow me to use the OO-UNO API and thus allow me to do the conversion.
>From the SDK I can figure out that, I will have to compile the code
separately, create such a JAR file manually and then add it to my project,
which seems a very long process to me. Is this the only way or am I simply
exaggarating the effort involved?
Thanks,
Suyog
----- Original Message -----
From: "KHZ (SAW)" <ka...@sawag.com>
To: "'POI Users List'" <po...@jakarta.apache.org>
Sent: Wednesday, July 26, 2006 3:36 PM
Subject: AW: How to use POI for reading Excel 2.1 format?
Hi Suyog.
With OpenOffice.org (OOo) you can do it using Java. Just look at the thread
about how converting from Excel 95 (the version below) which was just 2 days
ago.
In your case it's just the other direction (some version above).
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: Suyog Mahajan [mailto:suyog.mahajan@outworx.com]
Gesendet: Mittwoch, 26. Juli 2006 12:08
An: poi-user@jakarta.apache.org
Betreff: How to use POI for reading Excel 2.1 format?
Hi,
I have this requirement of reading and then processing the read data from an
Excel file which is in Excel 2.1 format. I have tried using POI, but my
experience was that POI works well for Excel 97 above, which definitely
excludes Excel 2.1 format. Now there are 2 solutions:
a) Either I convert manually all the excel files into Excel 2000 format by
opening them using MS Office. Which SHOULD NOT be done, because as per
requirement everything needs to be done using Java code.
b) Either find a way using Java to convert the file format, or use a totally
different Java API which might support Excel 2.1 formats. (I have also tried
using JDBC-ODBC DSN for Excel, but it also fails for this old format).
The system I am working on, has office 2000 installed on it, and these excel
files are obtained from external server.
Any help in this regard will be highly appreciated.
Thanks.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
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@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/