Read single cell value from DataTable

Help Studio
, ,
1

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!

image

2

Hi @elliot.barling
Use Read cell Workbook activity
image

1 Like
3

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.
image

Hope it helps!!

4

@elliot.barling
How about the below

dt_Input.Columns(0).ToString

image
image705×510 40.2 KB

Regards,

1 Like
5

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

image

6

Found it!

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

For anybody who might be struggling :slight_smile:

image

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.