RepeatNumberOfTimes integer-string issue: Option Strict On disallows implicit conversions from Integer to String

[atreides]

Hello!

I’m extracting data using from a website using the data extraction tool. I have used a “Repeat number of times” activity as there are multiple pages (and “next link” functionality doesn’t work in this case).

My iteration successfully goes through each page, but it overwrites the data in the excel. So I thought I’d duplicate each iteration result in a new sheet that will be named whatever the CurrentItem is, but I can’t figure out how to get past the error below.

[lakshman (Ganta lakshman)]

@atreides

Hope currentItem variable is of type Integer here. If yes then write currentItem.ToString in Duplicate sheet activity.

[atreides]

Thanks, but I have already tried that. I get the same error:

[Yoichi]

Hi,

Can you try to modify expression to CurrentItem.ToString at NewVariable in variable panel, too?

Regards,

[atreides]

Thank you, Yoichi! That solved my problem. Looks like I forgot to delete that variable. Much appreciated!