loop excel sheets and rows in Python

Question

I have a simple code:

import xlrd  
book = xlrd.open_workbook('import.xls')  
for sheet in book.sheets():  
    for row in range(sheet.nrows):    
        print sheet.row(row)

but it's printing:

sheet1: row1  
sheet1: row2  
sheet1: row3  

sheet2: row1  
sheet2: row2   
sheet2: row3  
and etc

I need to change this code to print this:

sheet1: row1  
sheet2: row1  
sheet3: row1  

sheet1: row2  
sheet2: row2  
sheet3: row2  
and etc.

Any help would be highly appreciated. Thanks

Jyhess · Accepted Answer · 2013-09-05 08:03:53Z

7

import xlrd
book = xlrd.open_workbook('import.xls')

max_nb_row = 0
for sheet in book.sheets():
  max_nb_row = max(max_nb_row, sheet.nrows)

for row in range(max_nb_row) :
  for sheet in book.sheets() :
    if row < sheet.nrows :
      print sheet.row(row)

answered Sep 5, 2013 at 8:03

Jyhess

1531 silver badge6 bronze badges

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

Collectives™ on Stack Overflow

loop excel sheets and rows in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related