Open MS Excel Spreadsheet with Python

Bob Gailer bgailer at alum.rpi.edu
Fri Sep 12 17:51:21 CEST 2003


At 08:16 AM 9/12/2003, Ajith Prasad wrote:

>Would appreciate any advice on how to get started with the script.
>Created an empty spreadsheet "test.xls" on drive F. Then at the
>PythonWin prompt tried and obtained:
> >>> xlapp=UseExcel("f:\test.xls")

What precedes this code> Where does UseExcel() come from?

Try "f:\\test.xls" (\t is the tab character and must be escaped)

>Traceback (most recent call last):
>   File "<interactive input>", line 1, in ?
>   File "UseExcel.py", line 16, in __init__
>   File "<COMObject <unknown>>", line 2, in Open
>com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft Excel',
>"'f:\test.xls' could not be found. Check the spelling of the file
>name, and verify that the file location is correct.\n\nIf you are
>trying to open the file from your list of most recently used files on
>the File menu, make sure that the file has not been renamed, moved, or
>deleted.", 'C:\\Program Files\\Microsoft
>Office\\Office10\\1033\\xlmain10.chm', 0, -2146827284), None)

[snip]

Bob Gailer
bgailer at alum.rpi.edu
303 442 2625
-------------- next part --------------

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.506 / Virus Database: 303 - Release Date: 8/1/2003


More information about the Python-list mailing list