How can i read a value of a specific cell in column A dynamically corresponding to the cell in column A

excel
faq

#1

Column A contains several file name and column B has their path, i want to read path for the corresponding file without hardcoding the cell number.

Thanks


#2

You can always place variable in cell.
like “B”+ number


#3

@Aishwarya_Thakur Read excel file and store output in datatable variable. Then use following command.

UrdatatableVariable.Select("[Column A]=‘filename’"),CopyToDataTable()(0)(1).toString

It will give u desired value.


#4

Create variable for cell…

Excel

And define that variable as you want…

Cheers,
Radomir


#5

Read range --> get DataTable–> for each datarow activity like item(“B”)+item(“A”)
or row(0)(“B”)+row(0)(“A”)


#6

hi @bala_subramanyam i tried read range and fetched the data using two separate get row item activity for column A and column B and store it in a variable, but now the issue is that whole data of column A is in the variable and when i am trying to print it is giving filenames in entire column A while i want a file name(which can be at any row number) from the collection.How can i do that?


#7

use read range activity with range specified as “” i mean blank collect datatable,
use for each data row activity on datatable, you can get individual row.