Differences
This shows you the differences between two versions of the page.
|
en:mervis-db:excel-exporter [2017/08/16 17:50] m.chlupac [Example] |
en:mervis-db:excel-exporter [2020/02/03 15:35] |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== 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 | ||
| - | |||
| - | ===== Example ===== | ||
| - | |||
| - | In this example we demonstrate how to export single variable into Excel file. | ||
| - | |||
| - | You can see the raw data from database in: [[https:// | ||
| - | |||
| - | {{ : | ||
| - | |||
| - | First you have to create a simple XML file where you define mapping between a set of keys describing individual Mervis DB variable and some Variable Name that will be used later in Excel template. | ||
| - | |||
| - | <code xml ExcelDemo.xml><? | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | </ | ||
| - | </ | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | < | ||
| - | </ | ||
| - | </ | ||
| - | </ | ||
| - | </ | ||