Generate OpenOffice calc files using PHP

php dynamically-generated openoffice-calc ods
xzdead picture xzdead · Jan 22, 2014 · Viewed 7.5k times · Source

I have been trying to find a simple way to create OpenOffice calc files with no success.

I have tried:

openTBS - Seems to work writing an xml and a template file but can't find anything about how the xml file format.

Ods php generator - I tried this one as it provides clear examples, but when I copy the files to my server I always get corrupted files

Php doc writer - Tried an example and got an sxw file. I don't even know what that is

ODS-PHP - No documentation, only one example for creating 4 cells

Everything looks old, stalled and undocumented. ¿Any suggestion?

Answer

pernils picture pernils · Jun 26, 2014

I have used opentbs successfully.

You can generate both excel and calc files. It also nice that you can "reuse" your html implementation so to speak.

Maybe this thread could get you going http://www.tinybutstrong.com/forum.php?thr=3069

Do the html version first.. then edit for calc/excel

Related questions

Automatically generate nested table of contents based on heading tags

Which one of you crafty programmers can show me an elegant php coded solution for automatically generating a nested table of contents based on heading tags on the page? So I have a html document thus: <h1> Animals &…

Read More
How do I check if a string contains a specific word?

Consider: $a = 'How are you?'; if ($a contains 'are') echo 'true'; Suppose I have the code above, what is the correct way to write the statement if ($a contains 'are')?

Read More
Get the full URL in PHP

I use this code to get the full URL: $actual_link = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['PHP_SELF']; The problem is that I use some masks in my .htaccess, so what we see in the URL is not always …

Read More