python怎么读取excel文件中的数据

import pandas as pd# 读取 Excel 文件df = pd.read_excel('my_excel_file.xlsx', sheet_name='Sheet1')# 查看数据print(df)

import xlrd# 打开 Excel 文件workbook = xlrd.open_workbook('my_excel_file.xlsx')# 获取工作表sheet = workbook.sheet_by_index(0)  # 第一个工作表# 遍历行和列for row in range(sheet.nrows):    for col in range(sheet.ncols):        value = sheet.cell_value(row, col)        print(value)