CODEWITHSUNDEEP
pythonexcelopenpyxl
zakparks31191
zakparks31191

Reputation: 937

Getting values from a column in excel using openpyxl

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?

Upvotes: 2

Views: 4558

Answers (1)

zakparks31191
zakparks31191

Reputation: 937

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 :)

Upvotes: 5

Related Questions