待读取文件预览:
读取excel代码:
import pandas as pd
file_path = r'C:\Users\123\Desktop\pandastest\example.xlsx'
df = pd.read_excel(file_path, sheet_name=0, header=0, skipfooter=0)
print(df)
输出结果:
导出excel代码:
import pandas as pd
file_path = r'C:\Users\123\Desktop\pandastest\example.xlsx'
df = pd.read_excel(file_path, sheet_name=0, header=0, skipfooter=0)
print(df)
df.to_excel(r'C:\Users\123\Desktop\pandastest\output.xlsx', engine='openpyxl', index=False)
导出结果: