from pandas import ExcelFile
import pandas as pd
xls = ExcelFile('test.xlsx')
df = pd.read_excel(xls, 'sheet_name1')
json_obj = df.to_dict()
转载于:https://www.cnblogs.com/jessicaDuan/p/9897635.html