How to read excel Column from Input dialog

Help Studio
1

Hi,

I want to read excel column from input dialog in multiple-choice option.Whatever the Data in Column it come in Multiple-Choice option and we have to select one value from it.
Stations.xlsx (18.7 KB)
Attached file has sample .

Thanks in Advance.

2

give a try on following:
arrOptions | DataType: String () =
dtData.AsEnumerable.Select(Function (x) x(ColNameOrIndex).toString).Dinstinct().toArray

it will return a string array of the distinct col values.This array can be used within the input dialog
grafik