Re: SpreadsheetML
| From: | Daniel Convissor | Date: | Tue, 30 May 2006 15:42:38 +0000 |
| Subject: | Re: SpreadsheetML | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-42696@lists.php.net to get a copy of this message | ||
Hey Olivier:
On Tue, May 30, 2006 at 04:52:14PM +0200, Olivier Guilyardi wrote:
>
> Because you're going to provide an answer to the need of generating
> Excel-compatible content, I suppose that outputing SpreadsheetML could be
> part of Spreadsheet_Excel_Writer itself. An option could set wether to use
> the binary or new XML format. Don't you think ?
Doing that would make things really hard to maintain.
> This way people who already use Spreadsheet_Excel_Writer would only need to
> set an option, and leave the rest of their code as it is.
My goal is to make the only thing they need to change are the class names.
> By the way, while you're at it, I must confess that a very bad limitation
> of Spreadsheet_Excel_Writer is that it needs to load all of the data into
> memory before rendering.
...
> With this XML format I suppose that you could easily implement some sort of
> buffered streaming, to avoid such memory eating.
Streaming, can't do due to the format needs. Writing to a temp file
first, perhaps, but I'm not sure it's doable due to the order things need
to happen. Will try.
Thanks,
--Dan
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
data intensive web and database programming
http://www.AnalysisAndSolutions.com/
4015 7th Ave #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409