I have a spreadsheet with two columns, A and B.
I'm iterating through it like this:
wb = load_workbook(filename = 'Counties.xlsx', use_iterators=True) ws = wb.get_sheet_by_name(name = 'COUNTIES') for row in ws.iter_rows(range_string='A2:C3'): print row
If I use a range_string value of 'A2:B3', the object returned only includes column A. I have to expand the range to include C if I want to get the B column returned. Even though column C has no data.