python操作excel

一、读取

from openpyxl import load_workbook

# 读取 Excel 文件
file_path = 'your_excel_file.xlsx'
workbook = load_workbook(file_path)
sheet = workbook.active

# 读取具体的单元格
cell_a1 = sheet['A1']
cell_b2 = sheet['B2']

# 读取特定列（假设是第1列）
column_data = []
for row in sheet.iter_rows(min_col=1, max_col=1, values_only=True):
    column_data.append(row[0])

# 输出列的数据
print(column_data)

二、写入

from openpyxl import load_workbook

# 读取 Excel 文件
file_path = 'your_excel_file.xlsx'
workbook = load_workbook(file_path)
sheet = workbook.active

# 修改特定列的值（假设是第1列）
for row in sheet.iter_rows(min_col=1, max_col=1, min_row=2, values_only=False):  # 跳过标题行
    cell = row[0]
    if cell.value:  # 检查是否有值
        cell.value = str(cell.value) + ' - modified'  # 修改值

# 保存修改后的 Excel 文件
workbook.save(file_path)

# 输出列的数据以验证修改
column_data = []
for row in sheet.iter_rows(min_col=1, max_col=1, values_only=True):
    column_data.append(row[0])
print(column_data)