How to check all column headers

Help Studio
, ,
1

Hello guys
How can I design a process that checks all column headers in an excel sheet and output the missing columns names and how I can choose the names the bot will search for in sheet header

thanks

2

example
I need the following columns to be available in sheet (Name,number,location)
it will check if name is there the output should be number and location
if name and location is there the output is Number
and like that

3

@khaled_emad
Hello

Here is a starting point for some of what you want>

Regards

4

Hi @khaled_emad ,
Could you Check with the below Expression :

RequiredColumnNamesArray.Except(DT.Columns.Cast(Of DataColumn).Select(Function(x)x.ColumnName).ToArray)

Here, RequireColumNamesArray is an Array of String variable type which contains the Column Names that you need to Check in the Datatable columns, DT is the Input Datatable.

The above Expression will return an Array of values which is not present in the DT columns. If all columns are present according the Required Column names then it will return an empty array.

5

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