Add Rows to excel from two variables where the values in the column end and begin

Help Studio
, ,
1

Hello Good people,
I urgently need help with how to add rows to an excel the values are coming from two different variables where, after the first variable records has been added to excel, then add the records of the second variable to the same column, where the values of first variable ended

Thanks

2

Hi @phionamartinez
Either you find out the insertion point from GetTableRange or you use AppendRange

3

Hi @phionamartinez ,
I am attaching a sample workflow for your reference I hope it helps you.
Sequence2.xaml (12.2 KB)

Just add the variable of 1 and 2 respectively in add datarow activity and I have mentioned it in the names as well of the activities.

Thanks & Regards,
Shubham Dutta

4

The values are coming from 2 variables, in add data two, how do I pass the two variable, to add data to one column?
I have tried to use array row{} but can only add one variable

5

It has worked, thank you so much

1 Like
6

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