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. In this section I will describe 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 ...
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: 1.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: 1.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: 1.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. These are the actions you can do related to Excel ...
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. ...