Excel Append Range activity

Help Studio
, ,
1

Hello,

I want to use excel Append Range activity to append data table variable to the excel file. it seems not work. the source has to be the same, excel range. is it right?

2

Uipath - Append range activity tutorial | Excel append range in uipath | append range in uipath (youtube.com)

3

@haiyan.he

Yes,the path of the excel,sheetname should be same and datatable need to append in the excel.

image
check the thread for more info

4

thank you. My question is related to Append Range activity under Excel. base on the hint “excel range expression”, I think it’s to be used to append data from one sheet to another sheet and both sheets are from the same excel file.
image

image
image663×765 46.2 KB

5

Hi @haiyan.he

Check the below docs:

I think above documentation will give an basic idea of how to use Append Range.

Hope it helps!!

6

Hi @haiyan.he

We can do for same excel and different excel also

image
image900×936 40.2 KB

From one sheet to another sheet are from different excels

image
image900×1356 57.1 KB

Regards,

7

thanks for clarification. it’s really helpful for me to understand these activities.

8

@haiyan.he

Hope you got the solution for your question. If yes please mark it as solution to close the loop else happy to help.

9

thank you. I check documentations but sometimes I cannot apply to the use case. the forum is helpful and gives me a lot of insights.

10

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