Storing data from excel to list

Reeba_Raju · August 22, 2023, 6:39am

I have to read Data from Excel sheets and store into List.

Please help,

Thanks in advance,
Regards…

Shiva_Nikhil · August 22, 2023, 6:49am

outptdt.AsEnumerable.Select(Function(x) x).ToList

use this syntax to make to list

or

can you explain more your requirement

Cheers

Reeba_Raju · August 22, 2023, 6:53am

I have to store names into list from excel sheet if it matches a if condition in workflow

Regards.

B_H_Akshatha_Pai · August 22, 2023, 6:53am

Hey you can do this way , make sure that your variable is of type list < datarow >

Regards

Nguyen_Van_Luong1 · August 22, 2023, 6:54am

Hi @Reeba_Raju ,
You can read as dtData
dtData.AsEnumerable().Select(Function(g) g ).ToList
regards,
LNV

Shiva_Nikhil · August 22, 2023, 7:01am

listvar=outptdt.AsEnumerable.Select(Function(x) x(“ColumnName”).ToString).ToList

x(“ColumnName”) is replaced by x("YourcolumnName)

The below synatx gives you true or false

outptdt.AsEnumerable.Any(Function(r) listvar.Contains(r(“ColumnName”).ToString))

system · August 25, 2023, 7:01am

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