import pandas as pd
import numpy as np
import os
# buff = pd.read_excel(r'D:\program\test.xlsx')
# buff = pd.read_excel(r'D:\program\test.xlsx', index_col='Qty2') # index_col将指定列设置为索引列
# print(buff['Qty3']['语文'])
# buff = pd.read_excel(r'D:\program\test.xlsx', header=1, index_col='语文') # header的参数优先级比index_col高
# buff = pd.read_excel(r'D:\program\test.xlsx',header=None) # header=None则python从0开始自动生成列索引
# buff = pd.read_excel(r'D:\program\test.xlsx', usecols=['Qty1', 'Qty2', 'Qty3']) #用抬头指定读取哪些列
# buff = pd.read_excel(r'D:\program\test.xlsx', usecols=[0, 3]) # 用序列号指定读取哪些列
# buff = pd.read_excel(r'D:\program\test.xlsx', header=2, usecols='B, D:F') # 使用表格原始编号指定读取哪些列
# buff = pd.read_excel(r'D:\program\test.xlsx',header=None, names=['F1', 'F2', 'F3']) #从右至左重新命名列索引,不够则匹配为空
# buff = pd.read_excel(r'D:\program\test.xlsx', dtype={'Qty1':np.float64, 'Qty3':np.int32}) # dtype={'a':np.float64, 'b':np.int32}表示将名为'a'的一列设为64位浮点类型,将名为'b'的一列设为32位整数类型。
# buff = pd.read_excel(r'D:\program\test.xlsx', skiprows=2, skipfooter=1)# 截取表格从第3行到倒数第4行的数据
file_dir = "D:/program/"
file_list = os.listdir(file_dir)
print(file_list)
i = 1
for file in file_list:
if file.endswith('.xlsx'):
file_dataframe = pd.read_excel(os.path.join(file_dir,file))
print(i)
file_dataframe.to_excel(str(i)+'.xlsx', index = False)
i = i + 1
# print(buff)