Saving excel contents to an array variable

Help
3

Hi @suwalruchan365,

1.Read excel data into a datatable by using of ReadRange Activity.The table called dtExcel.
2.Declare a Array Variable arrColumns.
3.Using assign activity , arrColumns = dtExcel.Columns.Cast(Of DataColumn)().Select(Function(x) x.ColumnName).ToArray()

Below the sample.
File :ColumnsARRAY.zip (9.2 KB)

Regards
Balamurugan

2 Likes