How to taking all the column name as array

Help Activities
, ,
1

Hello

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)

2

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

Regards
Gokul

1 Like
3

Hi @Marian_B

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

Regards,
NaNi

1 Like
4

Thanks a lot its working @Gokul001 & @THIRU_NANI

1 Like
5

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