Spreadsheet Editor

spreadsheet editor

Purpose

The Spreadsheet editor lets you view and edit Microsoft Excel spreadsheet files (.xls or .xlsx). This very convenient when you are doing data-driven testing and need to create or edit the test data directly inside Rapise.

How to Open

Use the Test Files View to open an excel file.  The excel file will be opened in a Spreadsheet Viewer, in the Content View.  The Spreadsheet tab of the Ribbon will also open.

Forumula Bar

The formular bar lets you see/edit the contents of the currently selected cell as well as enter more complex Excel calculations/formulas:

spreadsheet-editor-formula

Spreadsheet Grid

The main spreadsheet grid lets you see the cells in the spreadsheet, select a range and use the Speadsheet ribbon to change the format:

spreadsheet-editor-cells