I would like to read a specific cell, from an Excel based template, that uses data validation list.
So I used read cell activity, but UiPath gives an exception: "There isn’t a worksheet named ‘Sheet1’.
The sheet’s name, I want to read is ‘Template’. I think this activity wants to get the data, not from the template, but the data validation list behind it.
How can I solve this issue? I cannot read the background database, only the template.