Differences
This shows you the differences between two versions of the page.
en:mervis-db:excel-exporter [2017/08/16 18:38] m.chlupac [Excel Template] |
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:// | ||
- | |||
- | {{ : | ||
- | |||
- | ==== Configuration File ==== | ||
- | |||
- | |||
- | First you have to create a configuration 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. | ||
- | |||
- | You can also define the name of output file and whether the file should be just updated or overwritten. | ||
- | |||
- | <code xml ExcelDemo.xml><? | ||
- | < | ||
- | < | ||
- | < | ||
- | < | ||
- | < | ||
- | < | ||
- | < | ||
- | < | ||
- | < | ||
- | </ | ||
- | </ | ||
- | < | ||
- | < | ||
- | < | ||
- | < | ||
- | </ | ||
- | </ | ||
- | </ | ||
- | </ | ||
- | |||
- | ==== Excel Template ==== | ||
- | |||
- | You can use a simple templating language to define which values from Mervis DB should go where in th Excel file. | ||
- | |||
- | < | ||
- | |||
- | Any of the time-defining values can be omitted and will be replace by current date, time or values passed via command line parameters. | ||
- | |||
- | {{ : | ||
- | |||
- | ==== Run the Exporter | ||
- | |||
- | <code bat runExcelDemo.bat> | ||
- | |||
- | For more info options see < | ||
- | |||
- | ==== Output ==== | ||
- | |||
- | The output file is defined in configuration XML file and the example output should like this: | ||
- | |||
- | {{ : | ||
- | |||
- | ==== Download Full Example ==== | ||
- | |||
- | Download: {{ : | ||
- | |||
- | |||
- | |||
- | |||
- | |||