Specific Examples - EcoSys - Help

EcoSys Functional Automation Framework

Language
English
Product
EcoSys
Search by Category
Help
EcoSys Version
8.7

Spreadsheet with no freeze columns

  1. Using Dev tools, highlight the entire spreadsheet and get the xPath.

    The xPath appears as follows:

    //*[@id="wks1227-2849_spreadDiv"]/div[2]

  2. Take the ID Number between the – and the _. Use the following xPath replacing the # symbol with the number.

    //*[contains(@id,'-#_spreadDiv')]/div[2]/table/tbody

  3. Add /table/tbody to the end of the string

    //*[contains(@id,'-#_spreadDiv')]/div[2]/table/tbody

Spreadsheet with freeze columns

When a spreadsheet has frozen columns, it appears like a split spreadsheet. For many keywords that work with spreadsheets, you must provide both the left and right spreadsheet xPath to the keyword.

To get the proper xPath, repeat the following steps for the left and right hand side generating two sets of xPath.

  1. Start with the left hand side of the spreadsheet and use the selector to click on the spreadsheet so it highlights the column header as below and has the div.hdrcell popup.

    The DOM XML in Chrome dev tools looks as follows.

    The div class (which is highlighted by a black arrow) is originally selected. In Dev tools, click on the div with class="dhx_cell_cont_layout" and get the xPath for that (red arrow).

  2. Copy the xPath for this element, it should appear as follows:

    //*[@id="wks11103-16748_spreadDiv"]/div/div[1]/div[2]

  3. Replace id equals (id=) to use the contains pattern as described above.

  4. Add div/div[2]/table/tbody to the end of the xPath.

    For example ://*[contains(@id,"16748_spreadDiv")]/div/div[1]/div[2]/div/div[2]/table/tbody

  5. Repeat the same process for the right-hand side of the spreadsheet.

Spreadsheet Menu

  1. Using Dev tools, highlight the entire Spreadsheet menu and get the xPath.

    The xPath looks as follows:

    //*[@id="wks1227-2849_bannerInnerTable"]/tbody/tr/td[1]

  2. Take the ID Number between the – and the _.

  3. Use the following xPath replacing the # symbol with the number

    //table[contains(@id,'-#_bannerInnerTable')]/tbody/tr/td/table/tbody/tr/td/div