Python / COM

COM ( Component Object Model )

- 마이크로소프트에서 개발한 기술

 

- explorer open

# explorer open
explore = win32com.client.Dispatch("InternetExplorer.Application")
explore.Visible = True

 

- word open

# word open
word = win32com.client.Dispatch("Word.Application")
word.Visible = True

 

- excel open write

# excel open write
excel = win32com.client.Dispatch("Excel.Application")
excel.Visible = True
wb = excel.Workbooks.Add()
ws = wb.Worksheets("Sheet1")
ws.Cells(1,1).Value = "hello world"
wb.SaveAs("C:\\Users\\User\\Desktop\\test.xlsx")
excel.Quit()

 

- excel open read

# excel open read
excel = win32com.client.Dispatch("Excel.Application")
excel.Visible = True
wb = excel.Workbooks.Open("C:\\Users\\User\\Desktop\\test.xlsx")
ws = wb.ActiveSheet
print( ws.Cells(1,1).Value )
excel.Quit()

 

- excel open read write color

- ColorIndex 는 0 ~ 56 범위를 가지며, 마이크로소프트에서 제공하는 MSDN 참고 또는 구글링

# excel open read write color 
excel = win32com.client.Dispatch("Excel.Application")
excel.Visible = True
wb = excel.Workbooks.Open("C:\\Users\\User\\Desktop\\test.xlsx")
ws = wb.ActiveSheet
ws.Cells(1,2).Value = "hello"
ws.Range("C1").value = "world"
ws.Range("C1").Interior.ColorIndex = 20 # 0 ~ 56 마이크로소프트에서 제공하는 MSDN 참고
ws.Range("A2:C4").Interior.ColorIndex = 30