Page 1 of 1

OO ODS to/from CSV

Posted: Fri Jun 12, 2009 10:06 pm
by rec9140
I am looking to find a php 5 class that can at a minimum read in OpenOffice V2.3 to 3.1+ Calc ODS spreadsheets and save/convert to CSV.

The ability to receive a CSV and then output ODS for OpenOffice Calc would be a a huge plus

Something along the lines of PHPExcel would be great

I've seen a few on GoogleCode, SF/FM, phpclasses but they are severely outdated, not active projects, or just don't work.

I want to make sure I can receive/output Open formats and not just CSV. This is mainly for EDI, and we don't support output in proprietary formats that other spreadsheet software uses. We may take it in, but its not coming out that way.

Any one have any pointers to classes for PHP5 that will read ODS from OO Calc 2.3 to 3.1+ ? ?

Thanks!

Re: OO ODS to/from CSV

Posted: Fri Jun 12, 2009 10:27 pm
by Villeroy
http://en.wikipedia.org/wiki/OpenDocument_software
phpMyAdmin can export. For putting the raw csv-data (decimals, text and dates) into the grid of a spreadsheet it should be easy enough to use an appropriate XML-library to generate a file content.xml of an otherwise blank document. ODF is XML in a jar-archive. content.xml is the only file containing the cell data.

And then there is the promising http://odftoolkit.org/