How to loop through excel sheets in python file to calculate the values spread across the sheets?

Question

I have one excel file with 3 sheets, each sheet has a set of values within cell A1. How would I loop through the sheets and calculate the values?

I'm new to python and have been struggling to find a solution to this problem. Thanks

This question has been already answered. See these: stackoverflow.com/questions/44549110/… stackoverflow.com/questions/43544514/… — Aditya Abhas
– Aditya Abhas, Commented Sep 1, 2021 at 21:25
Please provide enough code so others can better understand or reproduce the problem. — Community
– Community Bot, Commented Sep 5, 2021 at 5:33

Shweta Khera · Accepted Answer · 2021-09-01 21:23:23Z

0

Checkout this Code #3 where you can update sheet by looping sheet = wb.sheet_by_index(x) and retrieve the cell value sheet.cell_value(0, 0).

answered Sep 1, 2021 at 21:23

Shweta Khera

1265 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1