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.


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