将Excel文档导入Python

import pandas as pd

# 读取Excel文件
data = pd.read_excel('path/to/file.xlsx')

# 对数据进行操作和分析
# ...

# 打印数据
print(data)

import xlrd

# 打开Excel文件
workbook = xlrd.open_workbook('path/to/file.xlsx')

# 选择工作表
sheet = workbook.sheet_by_index(0)  # 通过索引选择工作表
# 或者
# sheet = workbook.sheet_by_name('Sheet1')  # 通过名称选择工作表

# 读取数据
data = []
for row in range(sheet.nrows):
    row_data = []
    for col in range(sheet.ncols):
        cell_value = sheet.cell_value(row, col)
        row_data.append(cell_value)
    data.append(row_data)

# 打印数据
for row_data in data:
    print(row_data)

from openpyxl import load_workbook

# 加载Excel文件
workbook = load_workbook('path/to/file.xlsx')

# 选择工作表
sheet = workbook.active

# 读取数据
data = []
for row in sheet.iter_rows(values_only=True):
    data.append(row)

# 打印数据
for row_data in data:
    print(row_data)