Configuration Table

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

import

Imports the specified Java package so that its objects and methods can be used in tables.

include

Includes another Excel or Word file so that its tables and data can be referenced in tables of the current file.

language

Language import functionality.

extension

External set of rules for expanding OpenL Tablets capabilities. After adding, external rules are complied with OpenL Tablets rules and work jointly.

vocabulary

Ability to use user created dynamic classes in OpenL Tablets.

dependency

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 30: Configuration table