Match columns names of excel by storing them in config file

How to store column names of an excel sheet in config file and match the stored values with that of same excel sheet column names? @Palaniyappan any idea how to do this? Thanks in advance

1 Like

Fine
—use a read range activity and get the datatable as output
—now use a while loop with condition like
counter < dt.Columns.Count
Where counter is a variable of type int32 with default value as 0
—then use a ADD TO COLLECTIONS activity with item property as dt.Columns(counter).ColumnName.ToString
And in collections property mention as list_columnName

Where list_columnName is a variable of type System.Collections.Generic.List(of string) with default value as New List(of String)

—next to this add to collections use a assign activity like this
counter = counter + 1

Cheers @vamsikrish28

1 Like

Thanks and cheers @Palaniyappan

1 Like

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