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
Subhadharan
(Subhadharan Palanivel)
September 29, 2020, 7:01am
2
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 ?
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
Subhadharan
(Subhadharan Palanivel)
September 29, 2020, 8:13am
8
Check this out Distinct Column.xaml (6.2 KB)
1 Like