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.
_______________________________________________
python-win32 mailing list
python-win32@python.org
http://mail.python.org/mailman/listinfo/python-win32

Reply via email to