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

excel
activities

#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


#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


How to Get Excel Column Index From Alphanumeric?
#8

Thanks a lot! Very kind of you~

Karen