win32com pycharm에서 설정하기/엑셀 저장하기

pycharm 에서 pywin32 있으면 삭제하고(업그레이드하라고 나오는데 업그레이드 에러나니까)

다시 pywin32 설치

import win32com.client

# explore=win32com.client.Dispatch("InternetExplorer.Application")
# explore.Navigate ( "http://www.google.com")
# explore.Visible=True

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

Excel = win32com.client.Dispatch("Excel.Application")
Excel.Visible = True

wb = Excel.Workbooks.Add()
ws = wb.Worksheets("Sheet1")
ws.Cells(1,1).Value = "Hello"
ws.Cells(1,2).Value = "World!"
ws.Cells(1,2).Interior.ColorIndex = 45;

wb.SaveAs("d:\git\python\win32com\ex.xlsx")
Excel.Application.Quit()