Excel if element

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 if-element inside (or after) the element currently selected:

  NG2ExcelIF0001

 

2.You can also right-click on an element in the tree-structure to insert the if-element inside (or after) the currently selected element, select Insert and then If:

  NG2ExcelIF0002

 

When the if-element has been inserted you can setup a condition in the pop-up window

   

 

This works like the if-element of the normal template designer. To insert conditioned elements you just insert the element inside the folder inside the if-element.


    • Related Articles

    • 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 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 ...

    • 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 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 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 ...