How to add excel column row data to Array of string variable?

[MitheshBolla (Mithesh Reddy Bolla)]

I am having columns name "Approved " and "Denials ". i need get row data into arraylist… c#, and avoid blanks

I had read excel sheet and stored in DT. i had kept for each and able to read all data indivudally.

[VIDHATHA_THADURI]

How to put data from a column of datatable to list of string

Hi everyone, I am finding solution to put data from a column in a datatable into list of string. At the moment, I loop row by row in datatable and add each item value into list of string. I want to find a better solution for that. Please help me if you have any idea. Many thanks, AnhTH15.

[Unknown_User]

Hi!

Share us the input and expected output!

Regards,

[supermanPunch (Arpan)]

Hi @MitheshBolla ,

The Below Expression should provide you the Output as Array of String, which would have values present in the Column “Approvals”.

DT.AsEnumerable().Where(a=>!String.IsNullOrWhiteSpace(a["Approvals"].ToString())).ToArray()

[MitheshBolla (Mithesh Reddy Bolla)]

If i assign to variable of data type arry of string its showing error.

[supermanPunch (Arpan)]

@MitheshBolla ,

Apologies, Do find the Updated Expression below :

DT.AsEnumerable().Where(a=>!String.IsNullOrWhiteSpace(a["Approvals"].ToString())).Select(a=>a["Approvals"].ToString()).ToArray()

[Aleem_Khan (crazy bot)]

What is here a>=! String