Excel Issue in UIpath Pls assist

Help
1

I have one excel file with me i want to append the another excel.

2

@Kamesh
Use Read Range to read the the Excel file that you want to append. Then use Append Range to add it to the other file.

3

Hi Kamesh

You need to read the second excel file in using a read range activity. then use an append range activity to add it to the end of the first excel file

4

I want to append only particular columns(2 cloumns) from excel

5

image

read range and filter data table

1 Like
6

Fine
So to append columns
— use excel application scope and pass the file path as input
—use read range activity and get the output with a variable of type datatable named outdt
—use another excel application scope and read the another excel file
—same use a read range and the get the output with a variable of type datatable named finaldt
— use a assign activity like
Out_col1 = outdt.Columns(“yourcolumnname”)
Another assign activity like
Out_col2 = ousts.Columns(“yourcolumnname”)
Where both Out_col1 and Out_col2 are a variable of type system.Data.Datacolumn
—use add datacolumn activity and mention the datacolumn as Out_col1 and datatable as Finaldt
And another add datacolumn activity and mention the datacolumn as Out_col2 and datatable as Finaldt

Hope this would help you
Cheers @Kamesh