Need to get exact cell value from csv

[siddhi.kamble (Siddhi)]

I’m querying in sql and storing the output in output data table and then writing the same output in Write CSV. .Now i need to fetch the value which is present in C2 cell.

Help is much appreciated
Thanks & Regards

[kennbalobalo (Kenneth Balobalo)]

hi @siddhi.kamble ,

If you have a specific target cell, you may use the Read Cell activity

Read Cell

Hope this helps. Happy automation!

Kind regards,
Kenneth

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

@siddhi.kamble

I’m querying in sql and storing the output in output data table and then writing the same output in Write CSV. .Now i need to fetch the value which is present in C2 cell.

Hi @siddhi.kamble
You can fetch the value from the C2 cell of the output DataTable by using the following code:

outputDT.Rows(1)("C2").ToString()

This assumes that the output DataTable is stored in the variable outputDT. The Rows(1) method is used to access the second row of the DataTable (since row indexing starts from 0). The ("C2") part is used to specify the column name of the second column. Finally, the ToString() method is used to convert the cell value to a string.