for my Project I am exporting an Excel File to a DataTable (using the ExportToTable function of the excel connector). The Excel File has many columns and rows and can change sometimes. The Bot is iterating through each row and is performing some steps with the data. Instead of assigning each column a variable, I would like to get the cell value from the datatable by the Column Name. I was not able to find any methods for that, how can I build that function?
@DennisM37 This is much easier to do in a script. You can't really supply the easiest notation in an automation. I would create a script like in my attached example that takes in the following; your DataTable, the row index, and the column name. The notation is;
In an automation, this would be much more complex than necessary.