Copy a cell from dynamic coumn in excel

[anil.candan (Anil C.)]

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.

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @anil.candan ,
Data table can change name by index, form 0
you can get index

datatable.colunns.indexof(“DIS”).Tostring

regards,
LNV

[Shiva_Nikhil]

@anil.candan

datatablevar.rows(0).item(“DIS”).tostring

Gives the Output value as 1456

If you want get the column index

Datatable.columns.indexof(“DIS”).tostring