How to write a excel cell using row and column index using WriteCell Activity?

Help
,
1

How to write a excel cell using row and column index using WriteCell Activity?
Like in Excel VBA itself, we can write using (1,1) (2,3) etc.

2

Hi @abskulkarni,

Use “Write Cell” activity and specify the range to write in particular cell.
Provide the value in “Value field”, include the activity in Excel application scope.
Hope this will help.

Thanks,
Girish

3

Hi Girish
No. The range should be in the form of numbers like 1,1 or 4,5 etc; and not like “A1”, “B3” etc. Range parameter of WriteCell activity does not take “number, number” format.

4

Hi @abskulkarni,

Write cell doesn’t take number as parameter, since it is excel cell, it will take only “A1:A5”. If you want range to be decided at run time then you can use counter to change range at runtime.

Thanks,
Girish

5

Hi @Girish
You may use this solution to first convert the Column numbers to Alphabets,
then use write cell

Excel_Column_Name_Mapping

7 Likes
6

Hi, @aksh1yadav, thanks for your Column_Name_Mapping. It workable to convert the column numbers to Alphabets.

Would you please tell me how to convert alphabets to column number?
eg. Convert Column"A" to “1”, Column “B” to “2”, … Column “AA” to “27” etc.

Thanks,
Karen

7

Hey @karen_li

Super Busy … but i have already this workflow :slight_smile:
please find attached one and let me know :slight_smile:

Convert Excel Col name to Col Number.xaml (9.7 KB)

Regards…!!
Aksh

4 Likes
8

Thanks a lot! Very kind of you~

Karen

9

Can you please tell me how to convert column number to alphabets?

10

Hey @arunshiva

Follow existing Link - Get last column of Excel sheet in Alphanumeric form - #7 by aksh1yadav

Regards…!!
Aksh

11

Thanks @aksh1yadav
It works.