Read Excel in String Array Dynamically

Help Forum
, ,
1

Hi Everyone,

My requirement is i have excel with a single column, i need read that column and add it to array of strings

So i can retain only those column in datatable

datatablevar.default.toTable(False,arrVar)

where arrVar is array of names in the column

@ppr @Palaniyappan @Yoichi

thanks in advance

2

Some parts from description are unclear

arrVals = YourDtVar.AsEnumerable.Select(function (x) x(colnameorindex).ToString.trim).Distinct().toArray

3

@ppr thankyou it worked

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.