Xlwings - unable to insert values for a range of rows

Question

I am trying to insert a value n into a specific H column from position H10:H20

So, I tried the below

start_index = int(10)
for n in range(20):
    print(type(n))  # this returns int
    range('H' + str(start_index)).value = n
    start_index = start_index + 1

However, the above code results in the below error

      2 for n in range(20):
      3     print(type(n))
----> 4     range('H' + str(start_index)).value = n
      5     start_index = start_index + 1

TypeError: 'str' object cannot be interpreted as an integer

But my n is an integer.

The built-in range function (that you are calling at line number 4) takes integer as input. — Echchama Nayak, Mar 19 '22 at 09:31
But the script doesn't know that. It is treating the range as a built-in function — Echchama Nayak, Mar 19 '22 at 10:02
Try `from xlwings import range as xlrange`. and rename the code at line 4 as `xlrange`. Or use `import xlwings` and at line 4 say `xlwings.range`. Try to avoid asterisk in your import statements in order to avoid polluting the namespace — Echchama Nayak, Mar 19 '22 at 10:05
Sure, thanks for your help. I just realised that if I prefix sheet.range, the error went away — The Great, Mar 19 '22 at 10:07
Sure me or someone else will help but please do post reproducible code along with import statements in order to avoid mistakes — Echchama Nayak, Mar 19 '22 at 10:11

score 1 · Accepted Answer · answered Mar 19 '22 at 10:10

Try the following from xlwings import range as xlrange and rename the code at line 4 as xlrange.

Or use import xlwings and at line 4 use xlwings.range.

Try to avoid asterisk in your import statements in order to avoid polluting the namespace. For more info check this post

Xlwings - unable to insert values for a range of rows

1 Answers1