系统:Windows 7 语言版本:Anaconda3-4.3.0.1-Windows-x86_64 编辑器:pycharm-community-2016.3.2 openpyxl:2.6.2
Part 1:示例
Part 2:代码
from openpyxl import Workbook
wb = Workbook()
excel_address = r"E:\Coding\E_PythonWriting\Excel\openpyxl示例_5.xlsx"
sht = wb.worksheets[0]
sht["A1"] = 1
sht.title = "首页"
sht_2 = wb.create_sheet("新建表1")
sht_3 = wb.create_sheet("新建表2", 0)
sht_copy = wb.copy_worksheet(sht)
wb.save(excel_address)
代码
执行结果
Part 3:部分代码解读
wb = Workbook()
新建工作簿sht = wb.worksheets[0]
获取第1个工作表sht_3 = wb.create_sheet("新建表2", 0)
,在首位创建工作表新建表2,从0开始计数sht_copy = wb.copy_worksheet(sht)
,复制工作表