Read Whole Excel Sheet but copy only specific Data into anothe Excel

Help Robot
,
1

I have data like this in first sheet

image

I want to copy only certain data into another excel how to do this ?

Final Output of Second Sheet

image

Edit : I tried using read range activity but somehow I want to read the whole first excel sheet and then from that datatable i want to copy certain data into another sheet

2

in general we would filter the data

From your sample there is currently no filter rule / requirement derivable. Can you elaborate more on this part?

3

To elaborate more. Suppose I have excel data like this

image

I want to copy the last three lines of this sheet and paste into some another sheet How to do this ?

4

Assign Activity

dtFiltered | DataType: DataTable =
YourOriginDataTableVar.AsEnumerable.Skip(YourOriginDataTableVar.Rows.Count - 3).Take(3).CopyToDataTable
5

Ok Thanks so Suppose I have the Same Excel Data And I want to copy all the rows after Row No 2 and paste into other excel then how to do this ?

6 
YourOriginDataTableVar.AsEnumerable.Skip(2).CopyToDataTable

We would recommend to check:
[HowTo] LINQ (VB.Net) Learning Catalogue - Help / Something Else - UiPath Community Forum

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

7

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