Home Original page

Module question

Jeff Shannon jeff at ccvcorp.com
Wed Dec 15 21:10:40 EST 2004 
Mike Meyer wrote:

>Grumman <grumman at 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
More information about the Python-list mailing list