Retrieve all Excel column data into an array

[grape_guy22]

Hi I am trying to retrieve Excel column headers so I can store them in an array, how do I go about doing that?

[Gokul001 (Gokul Balaji)]

Hi @grape_guy22

Welcome to UiPath community

How about this expression

(from P in PeakE.Columns.Cast(of DataColumn)Select P.ColumnName).ToArray 

Regards
Gokul

[grape_guy22]

Hi thanks for the reply, could you explain what is ‘P in PeakE’ ?

[Gokul001 (Gokul Balaji)]

Hi @grape_guy22

Here P -> variable that assign in the expression and PeakE is the DataTable

Check out the XAML file

GetHeader.xaml (8.6 KB)

Regards
Gokul

[Shubham_Dutta]

Hi @grape_guy22 ,
I am sending you a sample workflow with a sample excel file for your reference.
ColumnHeaders.zip (8.2 KB)

This will help you to get your output with less complexity and higher accuracy.

Thanks & Regards,
Shubham Dutta

[Gokul001 (Gokul Balaji)]

Do get your Output as you expected @grape_guy22

Let us know do you have any issue?

If not Kindly mark it as solved. It will help for other too

Regards
Gokul

[grape_guy22]

Yes, thank you!