Python integrated with activeX

import win32com.client

xlApp = win32com.client.Dispatch("Excel.Application")
xlApp.Visible=1

workBook = xlApp.Workbooks.Open(r"C:\MyTest.xls")
print str(workBook.ActiveSheet.Cells(i,1))
workBook.ActiveSheet.Cells(1, 1).Value = "hello"                
workBook.Close(SaveChanges=0) 
xlApp.Quit()

Source: stackoverflow.com

Similar codes

0 vote126 views1 answer
Numpy convert 1d to 2d
Python
0 vote115 views1 answer
Accessing python dictionary values with dot
Python
0 vote113 views1 answer
Micropython free space esp32 esp2866
Python
0 vote122 views1 answer
Python if string is null or whitespace
Python
1 vote113 views1 answer
Colab save figure
Python
3 votes107 views1 answer
Python iterate letters
Python
1 vote69 views1 answer
Plus months onto python date
Python
18 votes122 views2 answers
Import local module python
Python
0 vote71 views1 answer
Pandas summary
Python
0 vote122 views1 answer
Change date format python code
Python