Check each column of each row in excel whether it is null or have data

Help Studio
,
1

Hi , I need to check where i have to check all the columns of each row whether null or have data. i know for one column we have the linq but to check all the columns and to find which column dont have data in the row what is the query?

2

Hie @Madhups after read the data use a for each row and use inside this use assign activity and store the column data after that use if condition and pass
String.isnullorEmpty this will check all the rows have value or null
The image depicts an Excel processing workflow in a robotic process automation (RPA) tool, consisting of steps to read data from a specified Excel file and iterate through each row to assign a value from the "Number" column to a variable. (Captioned by AI)

The image shows a workflow in a process automation tool with actions to iterate over rows in a data table, assigning a value from a column, and logging an error message if the value is null or empty. (Captioned by AI)

The image shows a split screen with a debugging tool displaying variable values on the left and an Excel spreadsheet listing dates and corresponding text entries on the right. (Captioned by AI)

so it will check like this
cheers

3

Thank you sumit, is there any other simple way because i have so many columns to check

4

you need to count the blank columns or write value where the columns = blank ?

5

@Madhups

If you just need to find…then you can use the linq below

dt.AsEnumerable.Select(function(x,i) newdt.LoadDataRow({String.Join(",",dt.Columns.Cast(Of DataColumn).Where(function(y) x(y.ColumnName).ToString.Trim.Equals("")).Select(function(y) i.ToString + "_" + y.ColumnName).ToArray)},False)).CopyToDataTable

Newdt is s datatable with single column which you can build where you will get all data

The image shows a comparison of two data tables, "dt" and "newdt", with differing formats and entries within specific columns. (Captioned by AI)

cheers

6

Hi have to check each row if any column is not filled i have to update the status report saying that the column value is not provided in the column name so that we cannot proceed with the creation. so i need for each row which column is not updated.

7

@Madhups

If you see the output it is giving row number and column name for each row

cheers