Python in Excel iteration of sheets

peiyezhu 

Thank you for a response.

I would agree with you if it weren't for the fact that it works after another direct loading of those specific cells line pointing to the sheet.

for i in range(2,4):
    value = f"Sheet{i}!A1:A2"
    print(xl(value))

Does not work for Sheet2, however,

xl("Sheet2!A1:A2")
for i in range(2,4):
    value = f"Sheet{i}!A1:A2"
    print(xl(value))

For Sheet2 does work

xl("Sheet2!A1:A3")
for i in range(2,4):
    value = f"Sheet{i}!A1:A2"
    print(xl(value))

Does not work for Sheet2

Very strange.