Statements

Last updated on 2025-12-11

Overview

Using statements in a tilde formula, you can dynamically insert or name rows and columns in an Excel report with Lucanet.Excel-Reporting. 

Tilde Formula Structure

For statements, the tilde formula must be structured as follows:

~statement:"Parameter_1";"Parameter_2"

 

Rules for Statements in Tilde Formulas

The following rules apply for statements in tilde formulas:

  • Statements always end with a colon ( : ) followed by the parameters of the statement.
  • The parameters for a statement must be within inverted commas ( " ).
  • Several parameters are separated using semicolons ( ; ).
Available Statements

The following statements can be used in a tilde formula:

You can use the Row and Column statements to name the corresponding row or column so that they can be accessed in functions using the name, as well as the row or column number.

The advantage of accessing by name is that functions will retain the correct cell link even after rows and columns are inserted (which can change the numbering of existing rows and columns).

Tilde Formula Structure

The tilde formula must be structured as follows:

~Row/Column:"Name"

Note: The name of the row or column cannot match a placeholder name.

 

Example

In the following reporting template, row 5 is named Period. In the Value function, the name Period is used to access the row with the period headings:

Statement for naming a row
Statement for naming a row

The generated report appears as follows:

Result of the ‘row’ statement Result of the ‘row’ statement

The Fill rows and Fill columns statements can be used to insert further rows or columns dynamically, based on the respective row in an Excel report.

Structure of the tilde formula

The tilde formula must be structured as follows:

~Fill rows/Fill columns:Keyword=Item/Organization element/Partner/Transaction type/Adjustment level/Data level;[Abbreviation];[Name/OID];[No zero values];[Level]

The Abbreviation, Name/OID, No zero values, and Level parameters can be used optionally depending on the parameter.

Example

The Excel worksheet contains a tilde formula with the Fill rows statement. The formula uses the URL of the item Other operating expenses:

'Fill rows' statement 'Fill rows' statement

The report created displays all the items contained in Other operating expenses. Row 19 displays the overall total of all items:

Result of a 'Fill rows' statement Result of a 'Fill rows' statement
Contact Us