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

You are viewing documentation for an older version of SIMA. Go to the latest documentation →