OpenL Tablets allows externalizing business logic into Excel or Word files. However, these files can still use objects and methods defined in the Java environment. To enable use of Java objects and methods in Excel or Word tables, the file must have a configuration table. A configuration table provides information to the OpenL Tablets engine about available Java packages. Another purpose of a configuration file is to point to other Excel and Word files that can be referenced in tables.
A configuration table is identified by the keyword 'Environment' in the first row. No additional parameters are required. Starting with the second row, a configuration table must have two columns. The first column contains commands and the second column contains input strings for commands.
The following commands are supported in configuration tables:
|
Configuration table commands |
|
|---|---|
|
Command |
Description |
|
|
Imports the specified Java package so that its objects and methods can be used in tables. |
|
|
Includes another Excel or Word file so that its tables and data can be referenced in tables of the current file. |
|
|
Language import functionality. |
|
|
External set of rules for expanding OpenL Tablets capabilities. After adding, external rules are complied with OpenL Tablets rules and work jointly. |
|
|
Ability to use user created dynamic classes in OpenL Tablets. |
|
|
Adds the dependency module by its name. All data from this module will be accessible in current one. |
The following is an example of a configuration table:
Figure 31: Configuration table