Excel designer
Spooled file into Excel
This section shows how a spooled file can be converted into Excel. The example relates to a spooled file, that has a format like below: The spooled file is a multi-page spooled file with a header, some details lines (in the middle blue frame), which ...
Excel designer
Excel Support It is possible to generate Excel output in InterFormNG2, and it is also possible to convert Excel files into XML. You need however to have a license for InterFormNG2, that includes the Excel functionality, which can be support for ...
CSV file into Excel
InterFormNG2 is able to convert generic CSV files into Excel. This section describes how that can be done. As an example we consider a CSV file with this content: Seq,Product No,Description 1,4234,aaaaa 2,23423,bbbbbb 3,3423,ccccccc 4,345,dddd ...
Excel template file
In the Excel designer you can choose to design the complete excel file from scratch, but you can also choose to combine the Excel output from InterFormNG2 with a predefined Excel file (.xlsx). This can be e.g. used, if you want to use advanced ...
Excel variables
You can use variables in the Excel designer exactly like the variable element in the normal template designer. These variables can be used in any Xpath expression. You can create a new variable or update the value of a variable in two ways: You can ...
Excel templates
Excel templates contains the setup of the Excel output based on an input file. The Excel templates are saved with other templates in the templates section of the Library. Templates can be organized by placing them in sub-directories in the Template ...
Excel styles
Excel styles can be referred in a cell in the Excel designer. The styles are not global and are only saved within the current Excel template. A style can be used for setting up a lot of attributes for a cell. That includes: The font settings and ...
Excel sheets
This section describes how to work with the sheets of an output Excel file in the Excel designer. The sheets are shown as tabs in the bottom of the final Excel file: This section covers these areas: Set the name of the excel sheet in the Excel ...
Excel rows
This section explains how to work with rows in the Excel designer. In order to add data into an Excel sheet you first need to add at least one row within a sheet and then at least one cell in a row. The row itself does not output any contents of the ...
Excel repeat
You can insert a repeat element in the excel designer. The Excel repeat element works exactly like the repeat-element of the normal template designer. You can insert the repeat element in two ways: 1.You can click the repeat-element on the top to ...
Excel if element
It is possible to insert a condition in the Excel designer. You can insert a condition via the if-element. The if-element can be inserted in two ways in the tree-structure on the left: 1.You can click the if-element on the top to insert the ...
Excel cells
In order to add data in the Excel output in the Excel designer, then you need to insert at least one cell. A cell can only be inserted within a row and a row can only be inserted within a sheet. This section contains these topics: 1.Create a cell. ...
Popular Articles
REST webservice basic example
Below a simple setup is done to illustrate how the REST webservice basic can be setup. The example below can be run without any programming at all. First a simple template to prove, that the workflow has worked and returned a PDF: The template is ...
High Availability setup
For multi-server installations with high availability, we support an active-active setup with multiple active application server instances, supported by a shared relational database. A load balancer should be in front, to distribute HTTPS requests ...
XPath
In InterFormNG2, you use the language XPath for referencing data from the XML file. There are many sources of information if you want to learn more about XPath, but you can also simply read the few examples below to get a good idea of how it can be ...
Release log
This is the list of the InterFormNG2 releases and the major new features in each release: Important: InterFormNG2 now runs on Java 17. So you need to install Java 17 on Linux and the IBM i platform, if you want to InterFormNG2 on either of these ...
Aligment options for fixed positioned elements
There are several ways to align fixed positioned elements in the designer: (This lists alignment options for fixed positioned elements only. All alignment options are covered here.) 1.You can enable a grid, resize the lines of the grid and the fixed ...