The Excel format produces an .xlsx Excel file, with the data either stored in a single worksheet or each series in a separate sheet.
The following flags can be used in the extra1-field.
Name |
Meaning |
<type> |
Specifies how the data should be exported, either into a single worksheet or each series getting a single worksheet. Valid values are ‘separate’ or ’combined’, default is ‘separate’. |
<dateformat1> |
The dateformat for the first date-column in the file. |
<dateformat2> |
The dateformat for the second date-column in the file. |
<wind> |
Indicates whatever the data is windata or not. Make sure this setting is set as true when exporting data for windseries. Default value is false. |
<resolution> |
Resolution of output file |
<factor> |
Factor to multiply the load or production values with |
<time> |
Sets time reference for the export. This setting will be over written by the setting in Export name station |
Example 1)
Type:combined@wind:true@dateformat1:yyyy-MM-dd HH:mm@resolution:15@factor:1@time:wallstart
Example 2)
Type:separate@wind:true@dateformat1:yyyy-MM-dd@dateformat2:HH:mm@resolution:60@factor:1000@time:wallstart