Rapise Visual Language Editor
How to Open
Use the RVL button on the main toolbar to open an RVL (
.rvl.xlsx) file. The file will be opened by the RVL Editor in the Content View.
Editor has support for all RVL statements including
RVL is a recordable language. Rapise recorder is translates captured actions to objects stored in the object repository and a set of actions. Each recorded chunk may be inserted into desired place in the selected sheet:
In addition to recording one may use RVL editor for authoring scripts. You may drag&drop actions from the Object Tree into the RVL. Also RVL editor is both keyboard and mouse friendly. You may either type whole or parts of commands and rely on auto-completion OR simply select a dropdown in each cell of the row.
When writing or modifying a script it is recommended to go left-to-right for script creation.
RVL Editor supports Auto completions. For example, if you type
I in the flow column:
Tab key the whole If statement is created:
Tabis a trigger for auto-completion. If you use cursor keys or mouse to leave the cell then auto completion will not be executed.
If you go to last line and change End with ElseIf
then alternative branch is appended:
Similar logic works for Params, Conditions, Maps, Loops, Assertions and so on.
Disabling Cell Auto Correction
Sometimes autocompletion prevents one from entering a desired value. For example, you have a global object
navigator and typing it into the Object columns automatically changes it to
The solution is to enter the cell for editing text and pressing
F2. It will disable all autocompletion for this cell and then you may type any value.
When you select an action from the list RVL Edtior automatically fills default action params. For example, if we choose:
DoLaunch RVL Editor fills default param:
DoLaunch has one required parameter
cmdLine. Also it has a number of optional parameters. They are not added by default to make script more concise. However, you may need all or some of them. So you may add them by pressing
Params button on RVL Toolbar:
It is also possible to add params one-by-one using the dropdown in the ParamName column:
Password Param Value
Once column ParamType set to
password, ParamValue should be an encrypted string. Setting encrypted value is simple:
Change ParamType to
Type plain value to be encrypted into ParamValue.
Switch ParamType to
password- plain value becomes encrypted.
Full Line Comments
Anything typed into the Type cell of the commented line is expanded to as many cells as needed to show the text. This is similar to the way Excel extends cell text across sibling empty cells:
<object>' in Object Tree - this menu item is only available when you click on the cell from the Object column.
<object>'... - rename object in the object repository and fix all references in the current sheet.
Play This Sheet - execute actions from the active sheet.
Play Selection - execute selected range of actions only. Useful for tweaking tricky actions and checking the result immediately.
Play from Here - start execution at selected line and proceed until the end. Useful to continue script from the point where it stopped.
Cut, Copy, Paste - standard clipboard operations.
Copy Selection as Text - put selected range as tab-separated text to the clipboard.
Ins Row - insert new row before the active one.
Del Row - delete all selected rows.
Select All Rows - select full sheet.
Insert Selected Rows Here - clone rows at the current location.
MOve Selected Rows Here - move rows to the current location.
Wrap Selection Info If - enclose selected range into branch.
Wrap Selection Into Loop - enclose selected range into loop.
Extract Selection as new Sheet - make new sheet and move selected range into it.
Sheet Tab Context Menu
Play this Sheet - execute given sheet.
Rename... - change sheet tab name.
Remove Sheet '
<sheet name>' - delete sheet form the workbook.
Copy RVL DoPlaySheet - copy call statement for the selected sheet for inserting into the other RVL sheet in the same workbook.
Copy RVL DoPlaySheet - copy call statement for the selected sheet for inserting into the other RVL workbook.
Suppose we have some functions defined in the
Functions Object. It is not available in the object repository and is only shown in RVL Objects dropdown:
Once selected it shows all user defined functions from the
RVL has following file extensions:
RVL is designed to be a simple grid language and it may be edited in any spreadsheet editor supporting
.xlsx files (i.e. Microsoft Excel)