I want to exclude the blank cells

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

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

Hope it helps You!

1 Like

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.


1 Like

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