使用Python读取Excel表格“.xlsx”和“.xls”方法大全：一文教会你如何使用Python处理Excel表格数据

pip install pandas openpyxl

import pandas as pd

# 读取Excel文件
file_path = "example.xlsx"
data = pd.read_excel(file_path)

# 显示前5行
print(data.head())

pip install xlrd

pip install openpyxl

from openpyxl import load_workbook

# 打开Excel文件
file_path = "example.xlsx"
workbook = load_workbook(file_path)

# 获取所有Sheet名称
print(workbook.sheetnames)

# 读取Sheet数据
sheet = workbook.active
for row in sheet.iter_rows(values_only=True):
    print(row)

pip install xlrd

import xlrd

# 打开Excel文件
file_path = "example.xls"
workbook = xlrd.open_workbook(file_path)

# 获取第一个Sheet
sheet = workbook.sheet_by_index(0)

# 遍历Sheet中的行
for row_idx in range(sheet.nrows):
    print(sheet.row_values(row_idx))

pip install xlrd==1.2.0

pip install pyxlsb

from pyxlsb import open_workbook

file_path = "example.xlsb"
with open_workbook(file_path) as workbook:
    with workbook.get_sheet(1) as sheet:
        for row in sheet.rows():
            print([item.v for item in row])

pip install msoffcrypto-tool

import msoffcrypto
import io

# 解密文件
file = open("encrypted.xlsx", "rb")
decrypted = io.BytesIO()
office_file = msoffcrypto.OfficeFile(file)
office_file.load_key(password="your_password")
office_file.decrypt(decrypted)

# 使用pandas读取
import pandas as pd
data = pd.read_excel(decrypted)
print(data.head())

pip install dask

import dask.dataframe as dd

data = dd.read_excel("large_file.xlsx")
print(data.head())