from genericpath import exists
import pandas as pd
import os
file_dir = 'D:/program/write/'
# data = pd.read_excel("D:/program/test.xlsx", header=None)
data = pd.read_excel("D:/program/test.xlsx", index_col='Qty2')
exists = os.path.exists(file_dir)
if not exists:
os.makedirs(file_dir)
# to_excel不返回值
# data.to_excel(os.path.join(file_dir,"result.xlsx"), sheet_name="数量") # sheet name 指定表格名
# data.to_excel(os.path.join(file_dir, "result.xlsx"), na_rep="缺失") # na_rep补充无数据的单元格数据,默认补充位空
# data.to_excel(os.path.join(file_dir, "result.xlsx"), columns=['Qty1'])
# data.to_excel(os.path.join(file_dir, "result.xlsx"), columns=[1, 3]) # 当获取dataframe对象时,指定了header=None,则可