Hi all
update: I’m not able to attach the xaml as being a new member I believe
In the context of my job, I’m currently writing down a few sequences using Excel toolset.
More specifically, I get an error when I try to specify the range of a write cell activity. The error window is as follow:
I looked around in the forum but unfortunately couldnt find an appropriate answer to my problem
To give a bit of context here (and I’ll attach the xaml as well), I need to retrieve a row index (I created a column “index” in the excel) based on a 1-1 match I do using ctrl + f. Once it is done, the number is stored in a variable called index and reused to update cells in predefined columns using Write cell activities.
Afterwards, I created a variable (range1) that is defined as “column” + index.toString. For instance, if I have to update a specific cell (based on the match) in column F, I’d assign “F” + index.toString to range1, then put range1 as the Range in the Write Cell activity.
Nonetheless, the error message pops up when the robot reaches the write cell activity. I tried using & instead of + but it doesnt work better.
I dont know if any of you have encountered this type of issues, or would think of what might be wrong here ?
Thanks a lot in advance
kr,
Victor