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, Jun 20 '12 at 23:09

score 5 · Accepted Answer · answered Jun 21 '12 at 15:05

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 '12 at 15:05

zakparks31191

919
2
21
42

Getting values from a column in excel using openpyxl

1 Answers1