How to Read column from a csv file?

csv

#1

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


#2

Use get row item activity


#3

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()

Regards
Balamurugan.S