[python-win32] Reading .py or .pyc from an excel sheet (original) (raw)
Tony Cappellini cappy2112 at gmail.com
Thu Jan 31 19:21:15 CET 2008
- Previous message: [python-win32] python-win32 Digest, Vol 58, Issue 53
- Next message: [python-win32] parameters got changed after passing to a function through COM
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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.
- Previous message: [python-win32] python-win32 Digest, Vol 58, Issue 53
- Next message: [python-win32] parameters got changed after passing to a function through COM
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]