自动化Excel文件处理

[python]代码库

import openpyxl

workbook = openpyxl.load_workbook("/path/to/workbook.xlsx")
worksheet = workbook.active

for row in worksheet.iter_rows(min_row=2, min_col=1, max_col=3):
    value1 = row[0].value
    value2 = row[1].value
    value3 = row[2].value

    # Process values

workbook.save("/path/to/workbook.xlsx")