python openpyxlライブラリの簡単な使用

from openpyxl import Workbook
from openpyxl import load_workbook
# from openpyxl.writer.excel import ExcelWriter

'''
   sheet
'''
#    output.xlsx
wb = load_workbook(u"output.xlsx")
#       sheet
source = wb.active
#    sheet
target = wb.copy_worksheet(source)
#   sheet    
target.title = 'copy'
#   
wb.save(u"output.xlsx")


'''
   
'''
wb = load_workbook(u"output.xlsx")
#      sheet   
sheetnames =wb.sheetnames
#       sheet
sheet = wb[sheetnames[0]]
# A    ，     D1
sheet["D1"] = "=SUM(A:A)"
#    A2   
print(sheet['A2'].value)
#      6 ， 3   
print(sheet.cell(row=6,column=3).value)
#     A1
sheet['A1'] = '47'
#   
wb.save("update.xlsx")


'''
   excel
'''
#      excel
wb = Workbook()
#       sheet
sheet = wb.active
#    A1   4
sheet['A1'] = 4
#   
wb.save("create.xlsx")


'''
    
'''
#    output.xlsx
wb = load_workbook('output.xlsx')
sheet = wb.copy_worksheet(wb.active)
sheet.title = 'copy'
#     (idx)      (amount)  
sheet.insert_rows(idx=2, amount=2)
#   
wb.save('insert.xlsx')