I have read lot of thread here with the similar question but none has helped me.
I am trying to change the default column names( column1, column2 etc)
I have made an array(columnHeadersArray) of string with all possible default column names.
I read the data table in dtFInal.
Use for Each
column in dtFinal.Columns
Assign:
dtFinal.Columns(column.ToString).ColumnName = “Week Ending”
I am getting error: Assign: Exception has been thrown by the target of an invocation.