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:

 

NG2ExcelIF0003

 

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.


    Notice: Help Center Transition Update

    As of January 13, 2025, we are excited to announce that our new Help Center is in the final stages of development. While the Knowledge Base is already accessible, our current JIRA system will continue to manage support tickets during this transition period. For assistance with InterForm Output Management Software, please refer to the Support for InterForm Output Management Software.

    We appreciate your patience and understanding as we work to enhance your support experience. If you have any questions or encounter any issues, please do not hesitate to reach out via the existing support channels.

    Best regards,
    The InterForm Support Team


      • 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: 1.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. These are the actions you can do related to Excel ...