Hi guys, I want to make my Lookup DT dynamic - meaning - I want the Target columnindex to dynamic loop through all the columns and gradually enter data into my excel file. I tried to use the following: cint(DTSelEq.Rows.IndexOf(row)+3) - but it throws an error. Kindly guide how to work it out. […

cint(DTSelEq.Rows.IndexOf(row)+3) This is your first code. How about revert your code to This. You said row is member of DTSelEq. So this code will make sense. What you need to check is that DTSelEq.Rows.IndexOf(row)+3 is within the size of columns of DTCrisil as I said before.

How to create a dynamic Lookup Datatable?

Help

yuji.katayose (Yuji Katayose) September 14, 2020, 3:50am 3

BTW, Write Rante activity is much faster than writing into cells one by one.

Topic		Replies	Views
How to use write cell excel activity dynamic in For each row(Data table) Help datatable , excel , activities	9	16025	February 1, 2020
Lookup Data Table on Multiple Columns Help datatable , activities , question	4	8567	December 19, 2019
Write in specific column based on a row Academy Feedback datatable , excel , uiautomation , activities , string , question	34	8919	April 30, 2020
All about Datatable - UiPath Tutorials datatable , data_manipulation	28	18604	January 30, 2023
Dynamic Variables to reference active cell in excel while using for each loop Help excel , activities	4	3044	October 29, 2018

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

How to create a dynamic Lookup Datatable?

Related Topics