Excel templates

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

 

The Excel templates contains the setup of the output Excel file, which enables you to map input data from either a spooled file or an XML file into the output Excel file.

 

Here are the things you can do with an Excel template:

 

1.Create a new Excel template.

2.Open and edit an existing template.

3.Search a template.

5.Other template actions.

6.Design the contents of an Excel template.

 

 

 

Create a new Excel template

You can create a new Excel template, if you start the Excel designer. The designer will then start with a new, empty Excel template. You can also start with a new, empty Excel template, if you are currently editing a template if you click the New icon on the top right:

 

NG2ExcelTemplate0001

 

 

Open and edit an existing template

You can open and edit an existing template in two ways:

 

1.You can click on the template in the templates Library - all Excel templates has the extension .iet. When you do that InterFormNG2 will jump to the Excel designer, where the selected Excel template has been opened for edit.

2.You can start the Excel designer, click the open icon on the upper right (marked below) and click on the Excel template, that you want to edit.

NG2ExcelTemplate0002

 

Now you can e.g. start to add sheets or rows in the Excel template.


Search a template

In the top of the template there is a search field. If you type in a text here, then all design elements are highlighted where this text is found. To the right you see the number of 'hits' and you can use the arrow key icons to jump between the places where the search text is found:

 


On the screen shot above we have searched for 'in' and this is found twice.

 

Save an Excel template

You can click the Save or Save as icon on the upper right in the Excel designer in order to save template, that you are currently editing. If the template has never been saved, then only the Save as option is available. You can of course also choose the Save as option to save the Excel template with a new name or in a different folder in the templates library.

 

The save/save as icon looks like this:

 

NG2ExcelTemplate0003


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

    • Templates library

      The templates library contains the forms, that you want to merge your input data files (xml or spooled files) with. The forms can be both: 1.InterFormNG2 templates. These are files with the extension .ift. These templates can be edited with the ...

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

    • Mail templates library

      You probably want to configure the contents, when you send an email with InterFormNG2. In InterFormNG2 this can be defined as either an html file (which is recommended) or as an Apache Velocity Template (.vm), which is described below. Email template ...