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.

The row itself does not output any contents of the input file. For that you need to insert a cell in the row. 

These are the actions you can do related to Excel rows: 

Add a row in an Excel sheet.

You can add row to an Excel sheet in two manners:

1. You can click the click the row icon in the top after you have selected where to insert the row in the tree-structure: 
   
   
   
2. You can also insert a row, if you right-click on another row (or a sheet-element)
    

 

Delete a row

If you want to delete a row, then you need to right-click the row and here select Delete ROW:

 

  

 

Add a conditioned row

A prerequisite for adding a condition on a row on the input data is, that you have loaded a sample input file in the Excel designer.

(It is also possible to condition one or more cells.)

 

You first need to insert a condition by inserting an if element inside the sheet, and then you can insert the row inside the if-element:

  

 

Repeated rows

Normally the rows defined in the Excel designer will output the rows in the sequence in which the rows are defined. This can be referred to as relative row numbers. On the overview you can see the assumed row number, but the final row number might be different depending on the other rows.

 

If you want to assign a fixed row number to a defined row, then you need to double click on the row element in the element list. Then the properties of the row element is shown:

 

 

The Y-value is as default Auto (which means use the next row in the output Excel file), but you can set a specific row number here. The row number is shown in the tree-structure:

 

Any row, that is inserted after this row will be placed below this starting with the next row number, that is free.

 

Fixed positioned rows replace previous relatively positioned rows

If you already have a relatively positioned row, that has placed a value in the same cells (in the same output row), then all cells from the relatively positioned row will be overwritten by this fixed positioned row.

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

  In order to add data in the Excel output in the Excel designer, then you need to insert at least one cell. A cell can only be inserted within a row and a row can only be inserted within a sheet. This section contains these topics: 1.Create a cell. ...

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

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