파이썬 - 엑셀 다루기

pip install openpyxl

"""

excel 제어

openexcelparse

openpyxl tutorial

excel win32com

mini cookbook

"""

import openpyxl

import webbrowser

wb = openpyxl.load_workbook('testfile.xlsx')

print(wb.get_sheet_names())

sheet = wb.get_sheet_by_name('Sheet1')

sheet.cell(row=2,column=1).value ="자바";

sheet.cell(row=3,column=1).value ="파이썬";

sheet.cell(row=4,column=1).value ="C#";

sheet.cell(row=5,column=1).value ="닷넷";

sheet.cell(row=6,column=1).value ="C";

wb.save("testfile.xlsx")

webbrowser.open("testfile.xlsx")