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
).CopyToDataTable
Hope it helps You!
Hi @Girid
In UiPath Studio, you can exclude blank cells and retrieve only the filled cells from an Excel spreadsheet using the following steps:
-
Read Range: Use the “Read Range” activity to read the Excel file into a DataTable.
-
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] <> ""
.
-
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!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.