How to Read column from a csv file?

how to read column from a csv file an display the column values in dropdpwn list ?
i am getting an error as “ cannot be converted to string”
help me out with this

Use get row item activity

1 Like

Hi @suruchi120294,

  1. Use the Read Csv Activity and load the data into a datatable(dtCsv).
    2.Create the variable with type List. like “lstColValue”
    3.Use the assign activity

    lstColValue= internalSourceTable.Rows.Cast(Of DataRow)().Select(Function(a) a.Field(Of String)(“ColumnName”)).ToList()


1 Like