How to write cell in each increasing column instead of row

Help
1

Hi,

I knew how to write cell in each increasing row by:
-Assign Count=Count+1
-Then write cell range = “A”+Count.ToString

But, if I want to write cell in each increasing columns from Column A2, B2,C2,D2…, how can I do?

Thanks.

1 Like
2

Instead of using “A” , “B” … Use ASCII of “A” , “B” and all and increase the value as usual. You will get the result.

3

hi
welcome to uipath community
here you go
hope this would help you resolve your query
xl.zip (14.9 KB)

Cheers @MrHeng

1 Like
4

Wow I get it! Many Thanks!

By the way, I changed the 65 to 64 since character A starting from 65 (as per ASCII code).
Convert.ToChar(64+Counter).ToString+“2”

1 Like
5

Fantastic
Cheers @MrHeng

6

Thank you

1 Like
7

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