python pandas操作Excel使csv和xlsx互相转换的方法

python pandas操作Excel使csv和xlsx互相转换的方法

1. xlsx to csv:

import pandas as pd

def xlsx_to_csv_pd():
	data_xls = pd.read_excel('1.xlsx', index_col=0)
	data_xls.to_csv('1.csv',encoding='utf-8')
	
if __name__ =="__main__":
	xlsx_to_csv_pd()

2.csv to xlsx:

import pandas as pd

def csv_to_xlsx_pd():
	csv = pd.read_csv(1.csv', encoding='utf-8')
	csv.to_excel('1.xlsx', sheet_name='data')
	
if __name__ =="__main__":
	csv_to_xlsx_pd()