exporting mysql data to ODF with php

Question

I would like to know if someone triend exporting data from MySQL to an ODF format ?

Any information / documentation would be very much appreciated.

I am going to try to export a MySQL result set to ODF spreadsheet if possible.

score 2 · Answer 1 · answered Oct 26 '08 at 20:10

2

You could try looking at this: http://www.phpclasses.org/browse/package/4398.html

However looking at the source code it doesn't look great and has lots of hard coded xml strings

answered Oct 26 '08 at 20:10

Tom Haigh

57,217
21
114
142

score 1 · Answer 2 · answered Jul 11 '10 at 00:15

Another option to create OOo files with PHP is tbsOOo; however, it is mainly a templating engine.

This class allows to create OpenOffice documents dynamically by separating display formatting from logic and data. In practice, you create a template using OpenOffice with the TinyButStrong tags. Then you create a PHP script that merges the template with a data source to get a new OpenOffice document.

There is also: OpenDocument PHP which is more complex and can create the files dynamically.

exporting mysql data to ODF with php

2 Answers2