How to make a table & export to excel

1. Make a table

  • A table is build up arrays

  • One array is one column

  • Attributes sets the name on the coluns in the table

2. Table attributes

  • header

  • label

    • produce: labelTxt

    • Label is ranked higher than ylabel

  • ylabel

    • produce: ylabelTxt [<unit>]

  • format

    • Will be used in reports only

  • font-size

968057453 image13

  • Label is ranked higher than ylabel if both attributes are set

1800205373 image14

3. How to set the attributes

  • Use specify properties in the Post processor operation

1641720980 image16
908488343 image17
1416286679 image18

  • Click on the green circle with the cross

  • Add header and label attributes with values

  • When path is set to *, all signals coming in the input slot will be given these two attributes and their values

4. Format & font

  • Format and font is also set using the Specify Properties operator

870943013 image20

5. Example:

  • The array Stats is given the attribute label and the label value <labelTxt>

  • In addition the attributes header and ylabel is set

  • See result in page Attributes

23805900 image21
77234872 image22

6. Export to Excel

  • Make a table

    • Add all arrays with their attributes to the table input slot

    • In the table

      • Select the data

      • Click Fix Table

683867631 image23

  • Connect the table output slot to the file output

467080347 image24

  • Give name to the results file

  • Choose file format (here: Excel)

162972819 image25

7. Info about table attributes

  • After the table is fixed, you can click on Configure

  • You can find information about the attributes by pointing on the cells

2147382358 image26
2097532039 image27

8. Example files