Getting values from a column in excel using openpyxl

Question

I had intended to do this using the code in the answer here, in the last block of code. However i get an error in the line for cell in ws.iter_rows(range_string=range_expr): saying that "Worksheet object has no attribute iter_rows". Any idea what I'm doing wrong here?

did you check to see that you had the most updated version of openpyxl? — Jeff Tratner
– Jeff Tratner, Commented Jun 20, 2012 at 23:09

zakparks31191 · Accepted Answer · 2012-06-21 15:05:15Z

5

all i needed was to change the workbook declaration to the following: wb = load_workbook('path/doc.xls', use_iterators=True), adding in the use_iterators paramater. Simple issue, simple solution :)

answered Jun 21, 2012 at 15:05

zakparks31191

9472 gold badges22 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Getting values from a column in excel using openpyxl

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related