For the Spreadsheet tool bar icons that have additional drop-down icons, the following two xPaths are required:
-
Top menu
-
Menu that is displayed when clicking on an item on the top menu.
Top Menu
-
Using Dev tools, highlight the entire Spreadsheet menu icon that you want to use so that you see the i.fa.epc-layers::before and get the xPath.
-
The line with :: before will be selected and highlighted in blue in the DOM
-
Look up the hierarchy and find the parent div with id that starts with wks. Take the value from data-qa-locator and replace it in this template
-
The xPath looks as follows:
//*[@data-qa-locator='data-qa-locator value']/div/div/div/i
Drop down menu
Take the same value and use it in the below template:
//*[@data-qa-locator='data-qa-locator value']/div/table/tbody