OO ODS to/from CSV

Java, C++, C#, Delphi... - Using the UNO bridges
Post Reply
rec9140
Posts: 1
Joined: Fri Jun 12, 2009 10:00 pm

OO ODS to/from CSV

Post 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!
OOo 2.4.X on Linux-Other
User avatar
Villeroy
Volunteer
Posts: 31363
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: OO ODS to/from CSV

Post 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/
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply