I want to exclude the blank cells

[Girid (Rodcole)]

Hello i want to exclude the blank cells and ultimately i want only filled cell
How do i do it in studio

[Vikas_M]

Hey @Girid ,

Use a Filter Datatable activity and keep the condition as

Or you can write linq query as

(From row In YourDT.AsEnumerable
Where Not row.ItemArray.Any(Function (x) If(isNothing(x), True, String.IsNullOrWhiteSpace(x.toString.trim)))
Select row
).CopyToDataTable

Hope it helps You!

[Nitya1 (Nitya Tomar)]

Hi @Girid

In UiPath Studio, you can exclude blank cells and retrieve only the filled cells from an Excel spreadsheet using the following steps:

1. Read Range: Use the “Read Range” activity to read the Excel file into a DataTable.

2. Filter DataTable: Use the “Filter Data Table” activity to filter out the blank rows. Here’s how to set up the activity:

   • Input: DataTable from the previous step.
   • Filter Wizard: Configure the filter to exclude rows where the desired column(s) are empty. For example, if you want to exclude rows where the “Column1” is empty, you can use a condition like [Column1] <> "".

3. Output: Save the filtered DataTable as a new Excel file or use it for further processing as needed.

By using the “Filter Data Table” activity with appropriate conditions, you can exclude rows with blank cells and work only with rows that contain data in your UiPath workflow.

Thanks!!