Filter paricular row of entire Excel data

[nirmalad123 (Nirmala.d)]

Is there 100Excel Data i need to filter 10Rows only …What is the Expression in UiPath Using Vb Expression

[mkankatala (Mahesh Kankatala)]

Hi @nirmalad123

Provide the condition to filter the rows in the datatable…

[nirmalad123 (Nirmala.d)]

ok i will try to get.

[Palaniyappan (Forum Leader)]

Hi

Welcome to UiPath forum

If you would like to get the first 10 rows then

In assign activity

dt = dt.AsEnumerable().Take(10).CopyToDataTable()

To know more about datatable activity have a view on this

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

cheers @nirmalad123

[sasi_poosarla (sasi p)]

HI,
@nirmalad123

Dt=ExcelDt.AsEnumerable.Take(10).CopyToDataTable

[nirmalad123 (Nirmala.d)]

Hi,

Thanks For your Reply

[nirmalad123 (Nirmala.d)]

Hi,
Thanks for your reply

[Palaniyappan (Forum Leader)]

If the question is clarified, topic can be closed @nirmalad123

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…