Export Excel format

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