Hmm…it should work even when passed directly from a config file with the variable obtained
I hope you have used this process
—use a FLOWCHART activity
—use EXCEL APPLICATION SCOPE Activity and pass the file path of excel as input
—inside the scope use READ RANGE activity and get the output with a variable of type datatable named dt
—now use a FOR EACH ROW activity and mention the variable dt as input
—inside the loop use a assign activity like this
dic_variable(row(“yourcolumnname”).ToString) = row(“your value columnname”).ToString
Where dic_variable is a variable of type System.Collections.Generic.Dictionary(of string)(string) with default value as New Dictionary(of string, string) defined in the variable panel
—next inside the loop use a START PROCESS activity where pass the file path of exe file of your application as input to a Filepath Property or start process activity
—then use TYPE INTO activity, select that input field as element and mention the input as dic_variable(“keyname”).ToString and enable the simulate type property in the property panel of type into activity
And same for remaining columns
If we are not using dictionary we can directly mention the input row(“yourcolumnname”).ToString
Or if not inside the for each row loop Then use the dt.Rows(rowindex)(columnindex).ToString
Where both rowindex and columnindex both starts from 0 for the first row and first column
Cheers @vijaybrijmohan14