import pandas as pd # 读取excel文件内容 def read(file_path): data_from = pd.read_excel(io=file_path, header=0, sheet_name='Sheet2', keep_default_na=False, dtype=str, engine='openpyxl') print(data_from) # 输出的是一个DataFrom表单 file_path = r'C:\Users\1\Desktop\date_raw.xlsx' # r对路径进行转义,windows需要 read(file_path)