Module question

[Bill Turczyn]

Does python have a module similiar to the perl Spreadsheet::WriteExcel
Thanks,
Bill

[elbertlev]

Goggle: keyword pyXLWriter - ported from Perl. Does not support newer
exel files. F.e. if you create a table and write headers (names) they
will be in the table as row 0. But it is fast and it works. Has a lot
of examples.

[Grumman]

Bill Turczyn wrote:

Does python have a module similiar to the perl Spreadsheet::WriteExcel
Thanks,
Bill

In a pinch, you can output an HTML table, give the file an .xls
extension, and Excel will read it just fine.

There's probably a better option in python (under win32, you
could use win32com and drive Excel via COM for ex.) but this works
in a pinch.

[Mike Meyer]

Grumman <gr*****@example.com> writes:

Bill Turczyn wrote:

Does python have a module similiar to the perl Spreadsheet::WriteExcel
Thanks,
Bill

In a pinch, you can output an HTML table, give the file an .xls
extension, and Excel will read it just fine.

Welll, someone pointed out a third party package to do the job. I want
to point out the csv module included in the standard
distribution. That should work as well as an HTML table, with less
clutter in the file.

<mike
--
Mike Meyer <mw*@mired.org> http://www.mired.org/home/mwm/
Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information.

[Jeff Shannon]

Mike Meyer wrote:

Grumman <gr*****@example.com> writes:

Bill Turczyn wrote:

Does python have a module similiar to the perl Spreadsheet::WriteExcel

In a pinch, you can output an HTML table, give the file an .xls
extension, and Excel will read it just fine.

Welll, someone pointed out a third party package to do the job. I want
to point out the csv module included in the standard
distribution. That should work as well as an HTML table, with less
clutter in the file.

The difference being that when Excel opens up a *.CSV, it goes through
the import wizard. When you write an HTML table and save the file as
*.XLS, Excel will open it without the need for the import wizard (it
appears to act just as if the file were a true native-format Excel file)
.. Of course, this may also mean that you'll need to take extra care to
make sure that the cell formatting gets done correctly, since you won't
have the option of setting the formatting explicitly during import. (I
frequently deal with numbers that have significant leading zeros, and
Excel just loves to strip those off unless you set formatting to 'text'...)

Jeff Shannon
Technician/Programmer
Credit International

[Bill Turczyn]

Thanks to everyone for the prompt reply, I now have several options to
explore.

Thanks again,
Bill

[Jeff Shannon]

Simon Brunning wrote:

On Wed, 15 Dec 2004 18:10:40 -0800, Jeff Shannon <je**@ccvcorp.com> wrote:

The difference being that when Excel opens up a *.CSV, it goes through
the import wizard.

Are you sure that's true? When I open a *.csv file, Excel *appears* to
open it without running any kind of wizard. Certainly I don't see any
wizard dialogues.

You're right, my mistake -- I was thinking of tab-delimited *.txt files,
which I deal with far more often than I do *.csv ...

Jeff Shannon
Technician/Programmer
Credit International