少楊

from openpyxl import load_workbook
from openpyxl import Workbook
 
# 加載現(xiàn)有的工作簿
wb = load_workbook('product_item.xlsx')
 
# 獲取所有的工作表名稱
sheet_names = wb.sheetnames

new_wb = Workbook()
new_ws = new_wb.active
new_ws.title = "Sheet1"
# new_ws['A1']="haha"

# new_wb.save("new.xlsx")

# exit()
# print("over")

# 遍歷每個工作表并保存為單獨的文件
for sheet_name in sheet_names:
    ws = wb[sheet_name]
    print(wb,sheet_name)
    # ws2 = wb.get_sheet_by_name(sheet_name)
    print(ws.max_row,ws.max_column)
    columns = ws.max_column
    rows = ws.max_row
    # print(ws.cell(1,1).value)
    # print(ws.cell(1,2).value)
    for j in range(1,rows+1):
        for i in range(1,columns+1):
            # print(i,ws.cell(j,i).value)
            new_ws.cell(j,i).value = ws.cell(j,i).value
    
    # print(ws['A1'].value)
    # print(ws['B1'].value)

    new_wb.save("new.xlsx")
    break
    # new_wb = wb.copy()  # 創(chuàng)建一個工作簿的副本（因為我們正在修改它）
    # new_wb.remove(new_wb[sheet_name])  # 移除除了當前工作表之外的所有工作表
    # new_wb.save(f'{sheet_name}.xlsx')