You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Sai Pavan Gadde <id...@gmail.com> on 2014/04/01 11:13:28 UTC
Conversion for Open Office to other files
Hi Everyone,
Is there any possibility of converting Open Office files like odt,odi, ods
to csv or xls, or xlsx by using POI tool,
Give me the way, also coding if you have
--
*THANKS & REGARDS,*
G.SAI PAVAN,
CCDH4 CERTIFIED,
Ph: 8121914494,
*www.bigdatatrendz.com <http://www.bigdatatrendz.com>*
linkedin profile <http://in.linkedin.com/pub/gadde-sai-pavan/38/44b/453/>
HYDERABAD.
Re: Conversion for Open Office to other files
Posted by Angelo zerr <an...@gmail.com>.
Hi,
I had written an article about odt, docx converters with Java at
http://angelozerr.wordpress.com/2012/12/06/how-to-convert-docxodt-to-pdfhtml-with-java/
You will see in action several solutions like JODConverter, docx4j and
XDocReport.
Regards Angelo
2014-04-02 8:29 GMT+02:00 Mark Beardsley <ma...@tiscali.co.uk>:
> I do not have any recent experience with it but JODConvertor can render
> this
> a very trivial task. Take a look here -
> http://www.artofsolving.com/opensource/jodconverter - for more information
> and do be aware that it is necessary to have OpenOffice installed.
>
>
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/Conversion-for-Open-Office-to-other-files-tp5715329p5715350.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: Conversion for Open Office to other files
Posted by Mark Beardsley <ma...@tiscali.co.uk>.
I do not have any recent experience with it but JODConvertor can render this
a very trivial task. Take a look here -
http://www.artofsolving.com/opensource/jodconverter - for more information
and do be aware that it is necessary to have OpenOffice installed.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/Conversion-for-Open-Office-to-other-files-tp5715329p5715350.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: Conversion for Open Office to other files
Posted by Darren Roberts <ro...@yahoo.com>.
Try using jOpenDocument (http://www.jopendocument.org) or the ODF Toolkit (http://incubator.apache.org/odftoolkit/) to read in the OpenDocument files contents, then use OpenCSV and/or POI to write that back out to whichever file format you need.
There exists plenty of example code for both libraries so try looking at it. Without knowing your specific use case the only code anyone could give you would be the most basic example possible, which probably doesn't meet your requirements anyway. For example how would you want to handles images or blocks of text in an ODT when saved to an XLS or CSV, especially since CSV can't contain images?
What you're trying to do is largely possible, but you're going to have to do quite a bit of work yourself I'm afraid. The listed libraries only help you with reading/writing files in their respective supported formats, the code that translates the content from one format to the other and how you want it laid out you need to write yourself.
>________________________________
> From: Sai Pavan Gadde <id...@gmail.com>
>To: POI Users List <us...@poi.apache.org>
>Sent: Tuesday, April 1, 2014 10:13 AM
>Subject: Conversion for Open Office to other files
>
>
>Hi Everyone,
>
>Is there any possibility of converting Open Office files like odt,odi, ods
>to csv or xls, or xlsx by using POI tool,
>
>Give me the way, also coding if you have
>
>--
>*THANKS & REGARDS,*
>G.SAI PAVAN,
>CCDH4 CERTIFIED,
>Ph: 8121914494,
>*www.bigdatatrendz.com <http://www.bigdatatrendz.com>*
>linkedin profile <http://in.linkedin.com/pub/gadde-sai-pavan/38/44b/453/>
>HYDERABAD.
>
>
>
Re: Conversion for Open Office to other files
Posted by Angelo zerr <an...@gmail.com>.
Hi Sai,
As Nick said you, you can use ODFToolkit for that, but pay attention it's a
very very big task.
If you are interested XDocReport provides odt->pdf and odt->xhtml
converters at https://code.google.com/p/xdocreport/wiki/ODFDOMConverterwhich
uses ODFDOM. But it's not magic,there is some limitations (don't
support conversion of draw, etc).
Regards Angelo
2014-04-01 11:44 GMT+02:00 Nick Burch <ap...@gagravarr.org>:
> On Tue, 1 Apr 2014, Sai Pavan Gadde wrote:
>
>> Is there any possibility of converting Open Office files like odt,odi,
>> ods to csv or xls, or xlsx by using POI tool,
>>
>
> You'll need to write some code. Apache ODFToolkit (in the incubator) will
> allow you to read ods files, but you'll need to write the logic to call
> Apache POI to pass over the details
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
Re: Conversion for Open Office to other files
Posted by Nick Burch <ap...@gagravarr.org>.
On Tue, 1 Apr 2014, Sai Pavan Gadde wrote:
> Is there any possibility of converting Open Office files like odt,odi,
> ods to csv or xls, or xlsx by using POI tool,
You'll need to write some code. Apache ODFToolkit (in the incubator) will
allow you to read ods files, but you'll need to write the logic to call
Apache POI to pass over the details
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org