Excel module for Python

[Stefan Eischet]

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 <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.
>