pip install openpyxl

from openpyxl import Workbook

# 創(chuàng)建工作簿
wb = Workbook()
ws = wb.active

# 寫(xiě)入數(shù)據(jù)
ws['A1'] = "姓名"
ws['B1'] = "年齡"
ws['A2'] = "張三"
ws['B2'] = 25

# 保存文件
wb.save("example.xlsx")

from openpyxl import load_workbook

# 加載工作簿
wb = load_workbook("example.xlsx")
ws = wb.active

# 讀取數(shù)據(jù)
for row in ws.iter_rows(values_only=True):
    print(row)

pip install pandas openpyxl

import pandas as pd

# 創(chuàng)建DataFrame
data = {'姓名': ['張三', '李四'], '年齡': [25, 30]}
df = pd.DataFrame(data)

# 寫(xiě)入文件
df.to_excel("example.xlsx", index=False)

import pandas as pd

# 讀取文件
df = pd.read_excel("example.xlsx")
print(df)

from openpyxl import load_workbook

# 以只讀模式加載
wb = load_workbook("large_file.xlsx", read_only=True)
ws = wb.active

# 逐行讀取
for row in ws.iter_rows(values_only=True):
    print(row)

import pandas as pd

# 分塊讀取
chunk_size = 1000
for chunk in pd.read_excel("large_file.xlsx", chunksize=chunk_size):
    print(chunk)

from openpyxl.styles import Font, Alignment

wb = Workbook()
ws = wb.active

# 設(shè)置字體和對(duì)齊
ws['A1'].font = Font(bold=True)
ws['A1'].alignment = Alignment(horizontal="center")

wb.save("formatted.xlsx")

from openpyxl import Workbook

wb = Workbook()

# 創(chuàng)建工作表
ws1 = wb.create_sheet("Sheet1")
ws2 = wb.create_sheet("Sheet2")

# 寫(xiě)入不同工作表
ws1['A1'] = "Sheet1數(shù)據(jù)"
ws2['A1'] = "Sheet2數(shù)據(jù)"

wb.save("multi_sheet.xlsx")

from openpyxl import load_workbook

wb = load_workbook("multi_sheet.xlsx")
ws = wb["Sheet2"]  # 獲取指定工作表
print(ws['A1'].value)