Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
en:mervis-db:excel-exporter [2017/08/15 10:56] m.chlupac [Example] |
en:mervis-db:excel-exporter [2020/02/03 15:35] (current) |
||
---|---|---|---|
Line 4: | Line 4: | ||
It's based on custom template XLSX files where you can place data from Mervis DB using special syntax. | It's based on custom template XLSX files where you can place data from Mervis DB using special syntax. | ||
- | |||
- | {{ : | ||
For more info contact | For more info contact | ||
Line 13: | Line 11: | ||
In this example we demonstrate how to export single variable into Excel file. | In this example we demonstrate how to export single variable into Excel file. | ||
- | You can see the raw data from database in this: [[https:// | + | You can see the raw data from database in: [[https:// |
{{ : | {{ : | ||
- | First you have to create | + | ==== Configuration File ==== |
+ | |||
+ | |||
+ | First you have to create | ||
+ | |||
+ | 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 the output 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 look like this: | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | ==== Download Full Example ==== | ||
+ | |||
+ | Download: {{ : | ||
+ | |||
+ | |||
+ | |||
+ | |||
- | <code xml></ |