Issue in Set range with down key (Spreadsheet)

excel-loop
keystrokes

#1

I need to print data in excel through “Loop” and “set range”(Excel) .
After every loop execution, data has printed through set range (Table variable),i want to press down key with each iteration of loop to print table data form next row .

can you please suggest, how can i do it


#2

Hi Ankit,
You cannot use keystrokes (Down key) in Excel actions.
Instead, you can define the start of the cell range through a recorder variable, and use Constant value action to add the number of the rows in the table to the start cell at the end of each loop as shown below.


How to dynamically add data to excel