By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,628 Members | 1,880 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,628 IT Pros & Developers. It's quick & easy.

Module question

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

Jul 18 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a

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.

Jul 18 '05 #2

P: n/a
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.

Jul 18 '05 #3

P: n/a
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.
Jul 18 '05 #4

P: n/a
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

Jul 18 '05 #5

P: n/a
Thanks to everyone for the prompt reply, I now have several options to
explore.

Thanks again,
Bill

Jul 18 '05 #6

P: n/a
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

Jul 18 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.