weixin_43664085的博客

抛砖引玉系列- 将多sheet的excel拆分成单个的excelpython2最好的实现, 还是看源码import pandas as pddata_xls = pd.read_excel(file_path, None, dtype=object) # sheet_name为None时, 获取全部for sheet_name in data_xls.keys(): # index=False 默认为True False 表示不将行号写入文件 data_xls[sheet_name

from openpyxl import load_workbookfrom openpyxl import Workbookdef replace_xls(file_path, file_name): try: wb = load_workbook(file_path, data_only=True) except: wb = load_workbook(file_path, read_only=True) ws_name = wb.