Print sum value of a range with Python

Question

I am trying to print the value in the cell B26. So far all my print out is '=SUM(B2:B25)' for each iteration. How can I print the sum value in the range of B2:B25?

import glob
import openpyxl

path = 'C:/ExcelFolder/*.xlsx'
files = glob.glob(path)
for file in files:
  wb = openpyxl.load_workbook(file)
  sheet2 = wb.get_sheet_by_name('TOTAL')
  Totals = sheet2.cell(row=26, column=2).value
  print(Totals)

Output is:

=SUM(B2:B25)
=SUM(B2:B25)
=SUM(B2:B25)
=SUM(B2:B25)
=SUM(B2:B25)

This is covered by the documentation. – Charlie Clark Jun 28 '16 at 19:18 — Charlie Clark, Jun 28 '16 at 19:18

galaxyan · Answer 1 · 2016-06-28T19:09:34.087

1

try this one

sheet2.cell(row=26, column=2).internal_value

update

import glob
import openpyxl

path = 'C:/ExcelFolder/*.xlsx'
files = glob.glob(path)
for file in files:
  wb = openpyxl.load_workbook(file,data_only=True)
  sheet2 = wb.get_sheet_by_name('TOTAL')
  Totals = sheet2.cell(row=26, column=2).value
  print(Totals)

edited Jun 28 '16 at 19:09

answered Jun 28 '16 at 18:57

galaxyan

5,944
2
19
43

I still get the same output of '=SUM(B2:B25)' – wisenhiemer Jun 28 '16 at 19:03
@wisenhiemer updated. – galaxyan Jun 28 '16 at 19:09

score 1 · Answer 2 · answered Jun 28 '16 at 19:00

1

Based on this documentation, it seems like instead of

Totals = sheet2.cell(row=26, column=2).value

You'd want something like

Totals = sheet2['B26'].value

if you just want to read at that cell in an existing workbook.

answered Jun 28 '16 at 19:00

Ryan

387
3
13

I had tried this before and still got the same output. – wisenhiemer Jun 28 '16 at 19:04
Have you taken a look at this question: http://stackoverflow.com/questions/22613272/how-to-access-the-real-value-of-a-cell-using-the-openpyxl-module-for-python – Ryan Jun 28 '16 at 19:06
That worked! adding the 'data_only=True)'. Thank you! – wisenhiemer Jun 28 '16 at 19:12

Print sum value of a range with Python

2 Answers2