Read single cell value from DataTable

[elliot.barling]

Hey All!
I am building out several datatables which I am using the load into the queue.
I would like to loop through the individual datatables and read the ‘A1’ cell and save it into a Variable to then name the queue item.

Is there a way to do this so I don’t have to have 12 individual stages to hardcode the string into the queue item name.

Hope that makes sense!

[lrtetala (Lakshman Reddy)]

Hi @elliot.barling
Use Read cell Workbook activity

[mkankatala (Mahesh Kankatala)]

Hi @elliot.barling

Use the read cell activity to read the specific cell value from the excel or datatable and store the output of the activity in a string variable. Then pass the variable where you want.

Hope it helps!!

[lrtetala (Lakshman Reddy)]

@elliot.barling
How about the below

dt_Input.Columns(0).ToString

Regards,

[elliot.barling]

Almost there!
This seems to return the Column Header rather than the First Row
I currently have the following:

[elliot.barling]

Found it!

DT.Rows(0).Item(0).ToString

For anybody who might be struggling