On Tue, 25 Apr 2006, Alexandro Colorado wrote:

> This is a script to generate Excel sheets in xml and I want to change this
> into calc sheets. I am looking for advice on how and where to modify the
> tags so the dump is an OpenDocument compliant file.
> 
> I paste the source here:
> http://alexandrocolorado.com/excelwriter.inc.txt
> 
> The issue comes on the function GetHeader, this function basically is the
> one that insert the chunck of MSO XML code into the custom file. Herea are
> two questions, how to get around the whole Zipping file (since the sole
> xml file wont do an open document. And 2nd, how to manage the styles which
> are defined on a separate document.

You can create .zip files from PHP using the PECL .zip library at 
http://pecl.php.net/package/zip; it doesn't seem difficult to use.

> 
> Also some mapping of the tags might help, I have seen some issues
> regarding the way Excel consturct their hierarchy specially close to the
> cell level.
> 
In general, you have
 <table:table>
   <table:column /> <!-- one for each column in the table -->
   <table:row>
      <table:cell><text:p>cell data</text:p></table:cell>
   </table:row>
 </table:table>

For details, see 
http://books.evc-cit.info/odbook/ch05.html#table-content-section

-- 
J. David Eisenberg  http://catcode.com/

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to