Find the cell value

I know to column name in the excel
But I want to know in which cell range it exists?
Can anyone help me in finding it?

u can use the below code:

DT1.Rows.count+1

Dt1 is Your datatableName

assign this to one string variable.

Thanks and Regards,
Parvati

I don’t understand your requirement @Sweety_Girl… Can you explain :slight_smile:

example
I have 5 column
Aaa,bbb,ccc,ddd,eee
Aaa will be in A cell range
bbb will be in B cell range

if the column order changes, I need the cell range
How to get it

@Sweety_Girl
use Lookup Range activity

Refer- https://docs.uipath.com/activities/docs/excel-look-up-range

1 Like

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