Handling dynamic columns in excel


#1

dynamic column means - column may or may not present. for e.g. some times a spreadsheet may come with ‘Middle Name’ column between ‘First Name’ and ‘Last Name’ columns and sometimes not. Get row item should get middle name if it is present if not ignore it or assign black space to the respective variable.

i’m using column Name in get row item. whenever the column changes it is still reading.
Getting error when column doesn’t exist. I have to continue without errors.

Please do the needful


#2

Hello @Venkatp try If activity with condition - datatable.Columns.Contains(“ColumnToSearch”) = True