I am having columns name "Approved " and "Denials ". i need get row data into arraylist… c#, and avoid blanks [image] I had read excel sheet and stored in DT. i had kept for each and able to read all data indivudally.

@MitheshBolla , Apologies, Do find the Updated Expression below : DT.AsEnumerable().Where(a=>!String.IsNullOrWhiteSpace(a["Approvals"].ToString())).Select(a=>a["Approvals"].ToString()).ToArray()

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

Help Activities

VIDHATHA_THADURI (VIDHATHA THADURI) June 1, 2022, 9:11am 2

1 Like

Topic		Replies	Views
How to put data from a column of datatable to list of string Help datatable , excel , activities	11	32588	October 29, 2018
How to extract string from excel column into array of string? Activities uiautomation	4	890	May 13, 2022
Converting Data Table to an Array of String Help datatable , activities , string	8	14901	April 1, 2020
List values in a column into one variable Learning Hub datatable , excel , activities	5	2602	July 27, 2020
Read Excel in String Array Dynamically Forum datatable , excel , question	3	657	July 21, 2022

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

Related topics