Why UI Explorer is unable to find selector on cell level for Excel 2013?
Issue Description:
UI Explorer cannot find a selector on the cell level for Excel 2013. When hovering over a cell, the entire worksheet is highlighted:
Resolution:
This is an Excel issue/limitation. Excel 2013 creates an actual cell when the text editor is open within the cell, or when the cell contains text. It can be checked by taking the below steps:
- Write some text into a cell (even a space).
- Hover over that cell and notice that the cell is accessible/visible.
- Use the inspect.exe tool, with the UIA framework, to inspect the worksheet and notice that only the visible cells are the ones that contain text. Inspect.exe tool can be downloaded from Windows 10 SDK and it is located under \bin\<version>\<platform> folder.
The changes can still be made within an Excel 2013 sheet though, by using the Excel Activities.
Note: Getting selectors for the Excel cells is available in Office 2016 and above.