How to pass variable in write cell range

Help Something Else
1

how to pass a variable to write cell range which has a value like B:B10

1 Like
2

Hello @sathish_Kumar6
There is a property “Text” for the activity which you can pass the value
image

Thanks,
Mousa

3

“B”+var1.tostring+“:”+“B”+var2.tostring
you can do like that

4

Hi @sathish_Kumar6
Please go through the below xaml file. It will help you
Thanks and Regards
Sreejith
WriteRange.xaml (5.6 KB)

5

Hey!

We can do like this…

Create a int variable

Assign IntCounter = 2

The above assign should outside the for each loop

Now take any loop (Foe Each, While, Do-While, For Each Row in DataTable)

inside the for each row do like this

Take one write cell activity perform like this

"B2:B"+(intCounter+1).ToString

In the end of the loop increment the counter like this

Assign intCountrer = intCounter+1

This will increment the counter value

Try this and let me know

Regards,
NaNi

6

thanks bro it worked

1 Like
7

thanks for the reply

8

thanks for the reply thiru

1 Like
9

thanks for the workflow file sreejith

10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.