# -*- coding: utf-8 -*-
import pandas as pd
path = 'd:/file/线上流量包产品用户订购明细表.xls'
tdir = "D:/file/liuliangbao/"
xl = pd.ExcelFile(path)
header = ["地市","订购状态","订购渠道","用户号码","订购号码套餐","订购时间","包ID","包名称","资费ID","资费名称"]
for name in xl.sheet_names:
df = xl.parse(name)
df.to_csv(tdir+name+".csv",header=True,index=False,encoding="gb18030")