在python中解析POSTed Excel文件

from openpyxl import load_workbook

# 加载Excel文件
workbook = load_workbook('path_to_file.xlsx')

# 获取工作表
sheet = workbook.active

# 读取单元格数据
cell_value = sheet['A1'].value

# 遍历工作表中的所有行和列
for row in sheet.iter_rows():
    for cell in row:
        print(cell.value)

import xlrd

# 打开Excel文件
workbook = xlrd.open_workbook('path_to_file.xls')

# 获取工作表
sheet = workbook.sheet_by_index(0)

# 读取单元格数据
cell_value = sheet.cell_value(0, 0)

# 遍历工作表中的所有行和列
for row in range(sheet.nrows):
    for col in range(sheet.ncols):
        print(sheet.cell_value(row, col))

import pandas as pd

# 读取Excel文件
dataframe = pd.read_excel('path_to_file.xlsx')

# 访问工作表数据
cell_value = dataframe.iloc[0, 0]

# 遍历工作表中的所有行和列
for index, row in dataframe.iterrows():
    for column, value in row.iteritems():
        print(value)