Mike Meyer wrote:
Grumman <[EMAIL PROTECTED]> writes:
Bill Turczyn wrote:
Does python have a module similiar to the perl Spreadsheet::WriteExcelIn 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
-- http://mail.python.org/mailman/listinfo/python-list