This is an old revision of the document!
Excel Exporter
There is a command line tool called Excel Exporter available that can help you create fully customizable Microsoft Excel reports from your Mervis DB data.
It's based on custom template XLSX files where you can place data from Mervis DB using special syntax.
For more info contact sales department.
Example
In this example we demonstrate how to export single variable into Excel file.
You can see the raw data from database in: Mervis DB Viewer.
First you have to create simple XML file where you define mapping between set of keys describing individual Mervis DB variable and some Variable Name that will be used later in the Excel template.
- ExcelDemo.xml
<?xml version="1.0" encoding="utf-8"?> <RcWareDbExporterVariableTemplateFile> <exportTemplate>ExcelDemo.xlsx</exportTemplate> <exportOutput>ExcelDemoOutput_[yyyy-MM-dd_HH-mm].xlsx</exportOutput> <fillIncrementaly>false</fillIncrementaly> <variables> <variable name="OutsideTemperature"> <keyValuePairs> <keyValuePair key="DPGuid" value="338E2882-D72B-4D17-A241-73E8BC30F458" isId="true" /> <keyValuePair key="StationName" value="ENERGO" isId="true" /> </keyValuePairs> </variable> <variable name="HereCouldBeSomeOtherVariable"> <keyValuePairs> <keyValuePair key="DPGuid" value="338E2882-D72B-4D17-A241-73E8BC30F458" isId="true" /> <keyValuePair key="StationName" value="ENERGO" isId="true" /> </keyValuePairs> </variable> </variables> </RcWareDbExporterVariableTemplateFile>