I have created a config.xlsx file to add the configuration url and other datas.How can I get the data? Example if i want to get the url from config and in 'open url 'activity.
So, for that, you would use Read Excel file or Read Excel Cell and save that text to a variable. Then, in Open URL, you would use “Calculate a value” and enter that variable name.
If you wish to get more detailed assistance with this, please pop an email over to firstname.lastname@example.org
Thank you for the reply…
I had tried a similar way and got the result with read excel using
conf[‘Sheet’][rownumber]['Value ']. But my question is, is there any we can get the data from excel as a key -value pair or dictionary ? Because if someone changes the fieldname to another row, we need to make changes in code to the corresponding row number right?