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!
OO ODS to/from CSV
Re: OO ODS to/from CSV
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/
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice