直接上代码,python小白请大师们指点。感谢感谢。。。
import pandas as pd
import os
import sys
import xlwt
def csv_to_xlsx_pd(file_name):
path = os.getcwd()
#print(path)
if(os.path.exists(path + '\\'+ file_name +'.csv')):
csv = pd.read_csv(path + '\\'+ file_name +'.csv', encoding='gbk',low_memory=False)
#csv.to_excel(path + '\\'+ file_name +'.xls', sheet_name='data')
csv.to_excel(path + '\\'+ file_name +'.xlsx', sheet_name='data')
else:
exit()
if __name__ == '__main__':
file_name = sys.argv[1]
csv_to_xlsx_pd(file_name)