John Machin <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] Providenza & Boekelheide, Inc. -- http://mail.python.org/mailman/listinfo/python-list
