Excel variables

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 click the variable icon in the top of the designer:

 

NG2ExcelVariable0001

 

2.You can also insert a variable element, if you right-click on an existing element and here click Insert and Variable:

 

NG2ExcelVariable0002

 

You can refer to a variable in the following XPath expressions, where the variable name is to be preceded with a $-sign like in any other Xpath function in InterFormNG2.


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

        In InterFormNG2 there are 4 kind of variables: 1.User defined variables, that you define in the designer. 2.Workflow variables. They can be defined in the workflow either by setting a single variable or multiple variables at a time. 3.Predefined ...
      • Excel to XML component

        The advanced, converter workflow component, Excel to XML converts an input excel file in the .xlsx format into the special XML format. The converter handles rows, columns and the most important styles. A related workflow component can create an ...
      • EXCEL

        EXCEL is one of the file types, that can be handled as input in the workflow. Only input excel files in the format, .xlsx is supported. The excel files can e.g. be converted into xml with the component, Excel to XML.
      • Predefined variables

        InterFormNG2 is delivered with a lot of predefined variables, that you can refer to as any of the user defined variables. It is highly recommended not to create user defined variables with the same name as the predefined variables, but you can use ...