Hi,
I am trying to copy a cell from an excel sheet from different files. I want to copy the value if there is a colum name with “DIS”. It would be better to get the value in variable because I’ ll make a calculation with the value later.
Thanks in advance.
Hi @anil.candan ,
Data table can change name by index, form 0
you can get index
datatable.colunns.indexof(“DIS”).Tostring
regards,
LNV
datatablevar.rows(0).item(“DIS”).tostring
Gives the Output value as 1456
If you want get the column index
Datatable.columns.indexof(“DIS”).tostring