Python 3实现把各个Sheet另存为单独的Excel

• Z时代
• 2024-01-10
• 分类：综合

python"># -*- coding: utf-8 -*-
# @Time       : 2019/1/16 12:55
# @Author     : Philly
# @File       : sdsd.py
# @Description: 把各个Sheet另存为单独的Excel
from openpyxl import load_workbook,Workbook
wb = load_workbook("Sheet.xlsx")
sheetnames = wb.sheetnames
for name in sheetnames:
    ws = wb.get_sheet_by_name(name)
    print(ws)
    # 创建新的Excel
    wb2 = Workbook()
    # 获取当前sheet
    ws2 = wb2.active
    #两个for循环遍历整个excel的单元格内容
    for i,row in enumerate(ws.iter_rows()):
        for j,cell in enumerate(row):
            # 写入新Excel
            ws2.cell(row=i+1, column=j+1, value=cell.value)
            # 设置新Sheet的名称
            ws2.title = name
    wb2.save(name + ".xlsx")

以上是 Python 3实现把各个Sheet另存为单独的Excel 的全部内容， 来源链接： utcz.com/z/386558.html