how to operate the excel by python?

[Tim Roberts]

John Machin <sjmachin at lexicon.net> wrote:

>Rune Strand wrote:
>> The key is Python for Windows :
>> http://starship.python.net/crew/mhammond/win32/
>> 
>> See here for an Excel dispatch example:
>> http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/325735
>> 
>> When doing such operations, I generally save all the Excel files to CSV
>> files and do the operations on them using the csv module.
>> 
>
>Problems with that approach:
>
>1. Unfortunately, "save as CSV" is very much a WYSIWYG operation. If the 
>"number formats" are not sensible, loss of information can result.

This is a real problem.  US postal codes are a particular nasty issue.  The
value "01234", for example, will be imported into Excel as "1234".
-- 
- Tim Roberts, timr at probo.com
  Providenza & Boekelheide, Inc.