环境:python 3.7
pandas 1.4.3
import os
import pandas as pd
import tkinter.filedialog
def spilt_excel(path):
data = pd.read_excel(path, header=None, sheet_name="Sheet1").values.tolist()
data2 = pd.read_excel(path, header=None, sheet_name="Sheet2").values.tolist()
start = 0
end = 90
n = len(data)//90
file_name = path.split("/")[-1]
print(file_name)
for i in range(n):
info = data[start:end]
info2 = data2[start: end]
new_excel_path = path.replace(file_name, file_name.replace(".xlsx", "") + str(i + 1) + ".xlsx")
os.makedirs(os.path.dirname(new_excel_path), exist_ok=True)
with pd.ExcelWriter(new_excel_path) as writer:
dat = pd.DataFrame(info)
dat.to_excel(writer, header=None,index=None, sheet_name="Sheet1")
dat2 = pd.DataFrame(info2)
dat2.to_excel(writer,header=None,index=None, sheet_name="Sheet2")
start = end
end = start + 90
file_path = tkinter.filedialog.askopenfilename(title="输入文件")
spilt_excel(file_path)