[python-win32] Reading .py or .pyc from an excel sheet
Tony Cappellini
cappy2112 at gmail.com
Thu Jan 31 19:21:15 CET 2008
Why not just format the entire column as string data, before calling Python?
That's just requires a few menu clicks, then pass that column to Python.
Another option is to use a Python library called xlrd, which reads
Excel (.XLS) files from Python.
This way you can avoid using COM and the need to have Excel on the
machine where you are reading the file.
There are some limits to what you can do with the library, but for
just pulling in data, it should be ok.
Your Python script can check the data type of each cell as you are
iterating over the cells.
More information about the python-win32
mailing list