How to read the excel cell then regards the same result to be one?

dear all,

i have an excel file, i use the read range to find the result of each cell, then print the result .

for example, the results of output are 001 001 001 001 003 004 , how could I regards these same

output to one, like print 001 003 004

anybody could help me ? thanks a lot in advance

If you want to get the distinct values from the excel, you can add those values to the collection and then you can print the distinct values

could you give me a demo code ?

Can u share your xaml ?

no xaml … sorry

sample input excel ?

excel sample.xlsx (8.7 KB)

like this excel file, i read the excel, then read for each row
output the row b, the output is 1 1 1 1 1 2 2 3 , i need get the result 1 2 3 ,
delete the same

Check this out Distinct Column.xaml (6.2 KB)

1 Like