Excel sheets

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:

 

NG2ExcelSheets0001

 

This section covers these areas:

 

1.Set the name of the excel sheet in the Excel designer.

2.Create a new excel sheet in the Excel designer.

3.Delete an excel sheet in the Excel designer.

4.Select a sheet in the result view.

 

 

Set the name of the excel sheet in the Excel designer.

As default the output sheet will be named Sheet, but you can rename it, if you double-click on the sheet in the element list to see the properties and here type a new name:

 

NG2ExcelSheets0002

 

If you intend to match the excel template on the workflow component, Create Excel document, so that the output will be inserted into an existing excel file, then you need to match the sheet names of the existing excel file and the name of the sheet in the excel template.

 

 

Create a new excel sheet in the Excel designer.

You create a new Excel sheet by clicking on the Excel document element and the Sheet element in the top of the designer:

 

 

NG2ExcelSheets0003

 

 

 

The new sheet is created with the name undefined, which means, that the name will be generated automatically, but you can rename the sheet.

 

 

Delete an excel sheet

To delete a sheet in an excel definition, you need to right-click the sheet and then select Delete SHEET like shown below:

NG2ExcelSheets0005

 

Select a sheet in the result view

If you want to verify the output as you enter new cells/values, then you can select a specific sheet by clicking the sheet name in the bottom of the result view:

 

NG2ExcelSheet0003

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

    • 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 template file

      In the Excel designer you can choose to design the complete excel file from scratch, but you can also choose to combine the Excel output from InterFormNG2 with a predefined Excel file (.xlsx). This can be e.g. used, if you want to use advanced ...

    • Create Excel document

      InterFormNG2 can generate an output excel file in the format .xlsx based on a special formatted XML file. Such an XML file can be generated by the related workflow component, Excel to XML. The advanced, Create Excel document component has these ...

    • Internal Excel format

      InterFormNG2 can convert input Excel files (.xlsx) into XML with the workflow component, Excel to XML. The input files are converted into the XML format as described below. XML files with the format below can be converted back into Excel files with ...