Excel处理

一、使用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')