一、使用Excel宏处理
转载:https://blog.csdn.net/bohu83/article/details/76273361/
二、批量修改文件后面名
批量修改后缀名.bat
ren *.xlsx *.csv
二、使用python pandas模块处理
import pandas as pd
# pd.read_excel(io, sheet_name=0, header=0, names=None, index_col=None,
# usecols=None, squeeze=False,dtype=None, engine=None,
# converters=None, true_values=None, false_values=None,
# skiprows=None, nrows=None, na_values=None, parse_dates=False,
# date_parser=None, thousands=None, comment=None, skipfooter=0,
# convert_float=True, **kwds)
from Tools.demo.beer import n
if __name__ == '__main__':
num = [60000,
60001 ,
48000 ,
12000 ,
7440 ,
6000
]
num1 = 0
for i in num:
df = pd.read_excel('LX.xlsx', sheet_name='jpDj706412-导入', header=num1, usecols=[0, 1, 2, 3, 4], nrows=i - 1)
num1 = num1 + i
df.to_excel(str(i) + '.xlsx')