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	31998	October 29, 2018
Converting Data Table to an Array of String Help datatable , activities , string	8	14539	April 1, 2020
List values in a column into one variable Learn datatable , excel , activities	5	2541	July 27, 2020
Read Excel in String Array Dynamically Forum datatable , excel , question	3	657	July 21, 2022
Convert Column in Data Table to Array Help	10	33627	April 5, 2020

Most Active Users - Yesterday
ashokkarale
Yoichi
AkshaySandhu
Anil_G
sudster
heidi.michelsson1
Z15
Rahul_Rajendran
rpamailer
SorenB
More details...

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

Related topics