Python, COM and Excel

charliehubbard76 at charliehubbard76 at
Mon Nov 15 21:57:41 CET 1999


I'm trying to write a python script to take an excel
workbook and turn it into html pages.  I'm trying to
automate this process, but I can't seem to get the
bounds of the selection through com.  I can get the
contents of a selection with

app = Dispatch(Excel.Application)

But this just gives me the data contained with the cells.
I want to be able to check fonts, bold, and format
information of each cell to get it as close to the excel
formatting as possible.  In order to do this I need to
either get the bounds of the selection, or retrieve all
the cells references' being used.  Preferrably a bounding
selection of all the cells being used.  For example,
"A3:AN32" or "1,3,36,32".  Any ideas?


Sent via
Before you buy.

More information about the Python-list mailing list