使用 Python 中的 openpyxl 在 excel 文件中执行算术运算

pythonserver side programmingprogramming更新于 2025/9/4 17:48:17

Python 可以帮助我们直接从 Python 环境中使用 excel 文件。我们可以引用 excel 中的每个单元格或单元格范围,并对这些单元格应用算术运算符。这些操作的结果也可以存储在某些单元格中,这些单元格的位置可以由 Python 程序指定。

在下面的例子中,我们使用 excel 的内置函数执行各种算术运算。例如单元格内数字的总和或平均值。结果也存储在特定位置。我们使用 openpyxl 模块打开一个工作簿并将其标记为活动状态。然后,我们将某些值存储在预定义的单元格中,然后将函数应用于将结果存储在其他单元格中的单元格。

示例

import openpyxl

excel = openpyxl.Workbook()

excel_file = excel.active

excel_file['A1'] = 50
excel_file['B1'] = 100
excel_file['C1'] = 150
excel_file['D1'] = 200
excel_file['E1'] = 250

excel_file['A3'] = 20
excel_file['B3'] = 40
excel_file['C3'] = 60
excel_file['D3'] = 80
excel_file['E3'] = 100

excel_file['A5'] = 2
excel_file['B5'] = 4
excel_file['C5'] = 6
excel_file['D5'] = 9
excel_file['E5'] = 15

excel_file['A7'] = 4
excel_file['B7'] = 11
excel_file['C7'] = 27
excel_file['D7'] = 40
excel_file['E7'] = 75

excel_file['F1'] = 'Sum(A1 to E1)'
excel_file['G1'] = '= SUM(A1:E1)'
excel_file['F3'] = 'Sum(A3 to E3)'
excel_file['G3'] = '= AVERAGE(A3:E3)'
excel_file['F5'] = 'Product(A5 to E5)'
excel_file['G5'] = '= PRODUCT(A5:E5)'
excel_file['F7'] = 'Count(A7 to E7)'
excel_file['G7'] = '= COUNT(A7:E7)'

excel.save("D:\Arithmetic_operations.xlsx")

输出

运行上述代码得到以下结果 −


相关文章


有用资源