Python loop excel sheet printing cell values

Question

I'm trying to loop through an excel sheet printing the values in each column. Then go down to the next row, print the values of the column, until the end of the file.

My data looks like

Name           email                desc           date
name1          email1               desc1          date1
name2          email2               desc2          date2
name3          email3               desc3          date3



wb = load_workbook('example.xlsx')
sheet = wb.get_sheet_by_name('Sheet1')
row_count = sheet.max_row -1
column_count = sheet.max_column
i = 1
while (i <= row_count):
 for item in sheet.iter_cols():
    #for row in sheet.iter_cols():
    first_value = item[i]
    print (first_value.value)
    i+=1

I get of error or tuple index out of range, and it also isn't printing the correct data.

 first_value = item[i]
 IndexError: tuple index out of range

with the code above before the out of range error i get name1, email2, desc3 as output which is clearly wrong because the data isn't in the same row

Possible duplicate of [Read Excel File in Python](https://stackoverflow.com/questions/22169325/read-excel-file-in-python) — ayrusme, Nov 28 '17 at 16:37
Please give your **complete** code and the complete error message. — monamona, Nov 28 '17 at 16:37

Vityata · Accepted Answer · 2017-11-28T16:44:09.370

The fact that you are printing values like name1, email2, desc3 tells that you are incrementing on both column and row. This is because you are increasing the i in the nested for-loop and not in the outer one.

Try to increase it in the while loop. E.g., something like this:

while (i <= row_count):
 for item in sheet.iter_cols():
   #for row in sheet.iter_cols():
   first_value = item[i]
   print (first_value.value)
 i+=1

score 1 · Answer 2 · answered Nov 28 '17 at 16:39

The easiest way to solve this is to save your file as .csv

Then run:

import csv
with open(<YOUR_CSV_FILE_NAME>) as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        print(row)

From here you can play around with the "row" variable as you wish

Python loop excel sheet printing cell values

2 Answers2