Expand|Select|Wrap|Line Numbers
- import win32com.client
- xlApp = win32com.client.Dispatch("Excel.Application")
- xlApp.Visible=1
- xlWb = xlApp.Workbooks.Open(r"C:\Template_Rev_3.2.xls")
- print xlApp.Worksheets("sheet1").Name
Expand|Select|Wrap|Line Numbers
- for x in cell2.Range("B8","B78"):
- print str(x)
rng=cell2.Range("C8")
rng.Interior.ColorIndex = 6
#BUT HOW DO I COMPARE TWO COLUMNS B8 and C8, B9 and C9, B10 and C10...and color them if they are different easily?