Navigates and selects an option from the spreadsheet menu.
Object- xPath to the spreadsheet menu (See the Spreadsheet Menu section of Working with xPath) and xPath to the spreadsheet sub menu like Sheet, Edit, Display or Rows delimited by , symbol
Data- The path you want to take in the menu delimited by the character >
Example
‘Rows>Insert Multiple’ will open the insert multiple dialog so that multiple rows can be inserted.
The xPath in the repository would be as follows:
SSMenu = //table[contains(@id,'_bannerInnerTable')]/tbody/tr/td/table/tbody/tr/td/div
RowMenu = //div[contains(@id,'_rowsDropdown')]/div[2]/table/tbody/tr