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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.