Fetch only last 3 rows from an excel

Help Studio
, ,
1

In UiPath how to get only last 3 rows from an excel.
Can anyone help me on this? Your solution would really helps me

2

@Steven_ds_55
filteredDT = yourDT.AsEnumerable().Skip(Math.Max(0, dtData.Rows.Count - 3)).CopyToDataTable()

hope it helps!!

3 Likes
Forum Engagement Daily Reports
3

Hey @Steven_ds_55 replace build data table with read range activity use assign activity and the variable which hold the last row is of Datatable. so it will store last 3 row data

This image shows a screenshot of UiPath Studio with an open workflow Sequence, where an expression in an "Assign" activity is being edited to set a variable to the last three rows of a data table. (Captioned by AI)
This image shows a screenshot of UiPath Studio with an open workflow Sequence, where an expression in an "Assign" activity is being edited to set a variable to the last three rows of a data table. (Captioned by AI)941×566 30 KB

4

@Steven_ds_55

If using model excel activities

Then excel.sheet("Sheetname").rowcount will give you the count

Which can be used in reqd range to read only last 3 rows

Cheers

5

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