Restrictions on Web adapter (for IE), and Windows adapters (for Excel and Access forms)
One of our prospects is asking us on how far we can recognize/operate objects when we use Web adapter (for IE in general), and Windows adapter for Excel and Access forms. Do we have any existing documents elaborating these kind of things?
- Windows adapter for Excel and Access forms ... We can recognize/operate some "layers" of the form, but not individual input fields, radio buttons, or dropdown menus. As for the individual parts, we need to operate it with SendKeys methods, PerformClick methods with coordinates, Control Regions, etc. We can also take the way to execute Excel Macro directly with Excel Connectors, and OleDbQuery for Access.
This question was put by the customer after the PoC. We need to clarify the spec in detail quite a bit.
When you have these types of questions, refer to the application support matrix. It will be the most up to date listing of support. Flash/Flex and Silverlight are not supported at this time. The forms in Excel and Access are not support either. You may use ClickChildByText and ClickChildByName which use UI Automation to click inside a form that you cannot interrogate, however. There are new methods coming soon that will extend the UI Automation functionality. Check upcoming releases for this functionality.