How to taking all the column name as array


I need to take all the column name as an array in linq expression

Here is the sample excel file :
Sample.xlsx (5.3 MB)

Hi @Marian_B

Try the below expression

Use Assign activity

RHS - Create an Variable
LHS - (from P in PeakE.Columns.Cast(of DataColumn)Select P.ColumnName).ToArray

Refer to the thread for more Information about LINQ

Hope it will help you


1 Like

Hi @Marian_B

Have a view on this: How to get column names of data table to an array?


1 Like

Thanks a lot its working @Gokul001 & @THIRU_NANI

1 Like

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