파이썬 엑셀 프로그래밍 (Working with Excel Files in Python)

파이썬에서 엑셀 다루기

파이썬 (Python)에서 엑셀(Excel) 다루기

https://www.datacamp.com/community/tutorials/python-excel-tutorial

win32com library 설치

http://sourceforge.net/projects/pywin32/files/pywin32/

엑셀 다루기

http://pythonexcels.com/python-excel-mini-cookbook/

http://pythonexcels.com/basic-excel-driving-with-python/

sql 연결

https://wikidocs.net/1307

# Add a workbook and save (Excel 2007)
# For older versions of excel, use the .xls file extension

import win32com.client as win32
excel = win32.gencache.EnsureDispatch('Excel.Application')
wb = excel.Workbooks.Add()
wb.SaveAs('add_a_workbook.xlsx')
excel.Application.Quit()