How to read row data of paticular column

[rajthyaga53]

i have a table data , containing server names and dates , i need to read only dates , and store each date in one variable

[Gokul001 (Gokul Balaji)]

Hi @rajthyaga53

How about this expression?

Arrstring = dt.AsEnumerable.Select(function(x) x("Schedule").Tostring).ToArray()

This will give the array value. You can use Arrstring(0) -> It will get the first row value in the Schedule column

Regards
Gokul

[rajthyaga53]

@Gokul001

function(x) x("Schedule").Tostring).ToArray()

Hi , thanks for reachingout,
its showing error while writing it in output

[Sudharsan_Ka]

Check whether you have space in the column name in your excel @rajthyaga53

[Gokul001 (Gokul Balaji)]

Can you share the sample input? @rajthyaga53

Check out the XAML file

GetOnlyOneColumn.xaml (7.3 KB)

Regards
Gokul

[rajthyaga53]

no, i checked it, there is no space

[Peter_Groft]

Read the Excel File.
Add For Each row.
Inside For Each row add row(“column name you want to read”) to the Write line to print the values. E.g: row(“Column x”).tostring. row(“Column y”).tostring.

Hope This Helps,
Peter