Extract only one row from csv

Help Activities
,
1

Hello,
I have a CSV file in which I need to extract the data in the 12th row completly and add that data in mail body how can I achieve this…

Thank you

2

Hi @sanjay_gowda

You can read the csv file it will give you a datatable then you can get the values from 12th row like below

DT.Rows(11)("ColumnName").tostring

Thanks,
Prankur

3

Hi @sanjay_gowda,

You can take the 12th row like -

dt_TransactionData.AsEnumerable().Skip(10).Take(1).CopyToDataTable
For the email part can you explain a bit more on the requirement part

Thanks

4

Hai @Shikhar_Tandon
I have a CSV file in that file I have 2 columns and 13 rows I need to take the 12th row value completly i.e value of 1st column and value of 2nd column from 12th row and add those values in mail body …

5

To Take the 12th row you can refer my above solution and for mail part refer the below link

Thanks!