Copy data of particular range in Excel


i dont have copy data activity in Enterprise version…

i want to copy data of particular range in Excel G100:AB100…where my data formula is present…i should copy the formula for below lines of G101:AB101 to G200:AB200—

for all lines of G101:AB101

Thanks in advance

Hi @venkateshtangudu
Use write value activity based on formula


We can use excel application scope and pass the excel file path as input
—use a read range activity with range mentioned as “G101:AB200” and mention the sheetname that we want to read
—the output would a variable of type datatable and name dt1

That’s all you are done
Hope this would help you
Kindly try this and let know for any queries or clarification
Cheers @venkateshtangudu


there are 10 to 15 columns…can we use write value