Excel module for Python
stefan at eischet.com
Mon Jan 17 15:50:06 EST 2005
I didn't catch older mails in this thread, so excuse me if this has
already been pointed out:
"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. ;-)
On 16.01.2005, at 22:19, Erwin S. Andreasen wrote:
> Simon Brunning <simon.brunning at gmail.com> writes:
>> On Wed, 12 Jan 2005 23:19:44 +0800, sam <sam.wun at authtec.com> 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.
More information about the Python-list