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