Activate cell

[Bala Shunmugam]

I have an excel. i have opened it and inserted a new row on the top.. How do i activate cell A1 and enter valur in it, then a2 then a3 and soo on.... I tried "Go to Cell" action and gave cell reference as "A1". Its not working

 

[sivagelli]

Try 'Set Cell Value' action from Excel VBO to set value of a cell.

 

[Bala Shunmugam]

what if i have to enter column name for some 10columns?

 

[sivagelli]

Two options-

#1. Create a collection with 10 fields and use 'Write collection' action from Excel VBO to write directly into excel worksheet

#2. Create a collection with two fields, one to hold cell reference and other field for the value you want to set. Now, using loop stage write the values into cell using 'Set Cell Value' action

Post back how it goes.