CSDNxiaozhi的博客

book = load_workbook(filename)writer = pd.ExcelWriter(filename,engine='openpyxl')writer.book = book其实就是这几段代码，主要的是engine=‘openpyxl’下载openpyxl库之后可以进行使用引入from openpyxl import load_workbook伺候在进行数据...

两种操作都是对所选文件的遍历循环的出的结果，这种结果无法进行更改，那么执行的效率其实就是对表格的准备工作，在这时候就会出现时间上的落差xlex = pd.ExcelFile(filename)print(xlex.sheet_names)sheet = input('请选择想要操作的表格：') # 查询出文件中所有的表格名df = pd.read_excel(filename, shee...

import pandas as pdimport numpy as npimport timeimport refrom pandas.core.frame import DataFrameimport copydef new_sheet(filename): xlex = pd.ExcelFile(filename) writer = pd.ExcelWrite...