Win32com and Excel
michael.pearmain at tangozebra.com
Thu Jan 10 10:21:01 CET 2008
I currently have an excel table (1 table each time) that has differing
number of rows and differing number of columns each time, for another
program i use (SPSS) to import the data i need to know the cell range
of this data table.
I.e what the last row of data is and the last column that has data in
Does anyone have any code that does something similar? My guess is i
have to do something like thefollowing to enable python to read xl?
working_dir = '//c:/temp/'
xl = win32com.client.Dispatch("Excel.Application")
xl.Visible = 1 #open MS Excel
xl.Workbooks.Open('%s/working_output.xls' % (working_dir))
then code to find the cell ranges
Any help here is much appreciated
More information about the Python-list