To Copy only selected data and paste it to new sheet in the same excel

Help Studio
, ,
1

Hello all,

Could anyone to help me out for the requirement- copy only certain data from one sheet and paste to another sheet in the same excel.

Having the condition is to copy data after subtotal as shown in the below excel,

image
image997×476 36.1 KB

Paste to sheet1 as shown below ,

image
image1096×230 13 KB

Thanks in advance.

2

Hi @sushmitha.e

  1. you can use lookup range activity to get the subtotal range(where its start)
  2. you can use read range activity to read the range.
  3. you can use filter data table activity to remove the unwanted rows.
    4.finally you can write or append the data table to sheet1.

hope it helps!!!

3

@sushmitha.e welcome to you UiPath Forum for your first post, I hope it help you solve your issue

Option 1

  1. Read the hole excel
  2. Get the data in datatable
  3. apply the filter on the index column “C”
    Apply filter on keyword Sub-Total

image

Option 2
you can use the LINQ Query for to filter the row

Then you remove the first two columns and past to new excel and the append option should enable.

Regard
Mukesh S