Hi,
I didn't catch older mails in this thread, so excuse me if this has already been pointed out:
http://pyxlwriter.sourceforge.net/
"It's a port of John McNamara's Perl Spreadsheet::WriteExcel module" and it's really easy to use.
I'm not sure if it does formulae, but it handles formatting fine.
Putting together a file with complicated layout can be a lot of work, so for large prebuilt files (which I sometimes have to "fill in" programmatically), I just use COM with Excel. You'll have to run on Windows for that, of course. ;-)
Cheers Stefan
On 16.01.2005, at 22:19, Erwin S. Andreasen wrote:
Simon Brunning <[EMAIL PROTECTED]> writes:
On Wed, 12 Jan 2005 23:19:44 +0800, sam <[EMAIL PROTECTED]> wrote:
No, I don't use MS windows. I need to generate Excel file by printing data to it, just like Perl module Spreadsheet::WriteExcel.
If you need to write out formulae, formratting, that kind of thing, then I think you'll need to write a 'real' Excel file. I don't have a clue how to do that - sorry.
There's actually an ancient open spreadsheet format called SYLK which is a step above CSV: it allows formatting of data, formulas etc.
Google for SYLK to get the rather sparse specification (and skip over the first few links!)
If you want to generate "real" Office files from UNIX, another alternative is to automate OpenOffice (which has a COM-like interface too) or generate OO XML files and feed them to OO asking to conver them with a bit of OO macro magic.
-- http://mail.python.org/mailman/listinfo/python-list
