Not at this time. We support interaction with Excel via the connector and do not support interrogating the application itself. You might be able to access these objects through the Microsoft.Office.Excel.Interop as we do expose those objects via the connector. You'd likely want to code that in C# as there may be examples on the web available on how to read those objects.
Posted: 5 years ago
Posted: 26 May 2017 10:50 EDT
Jeff Badger (jeffbadger)
Principal Product Manager, Robotics
Managed to analyse the objects in the ActiveSheet through the following automation. Setting the correct one is just a matter of comparing the text, name or type then setting the text property for the one which matches.