|Home | Demo | Display 1 | Display 2 | Display 3 | Display 4 | Display 5 | About | Contact / Support|
|Advanced options||Available soon.|
One can use a Microsoft Excel template as input with graphs,
introduction texts and other advanced objects. These graphs can be
located in "graph_sheets" and these make use of "data_sheets".
During the export the "data_sheets" are populated.
When the Excel sheet opens, the "graph_sheets" are instantly refreshed.
If a SQL statement consists of a column named "department",
one can name the worksheet "worksheet_[department]",
Runtime this populates sheets dynamically like "worksheet_SALES",
"worksheet_HR" etc. Data is automatically filtered,
so the "worksheet_SALES" only contains SALES data.
If all SQL statement consists of a column named "department",
one can name the workbook "workbook_[department].xlsx",
Runtime this populates sheets dynamically like "workbook_SALES.xlsx",
Data is automatically filtered so the "workbook_SALES.xlsx" only contains SALES data.
Command line generation of Excel files without User Interface:
There is only 1 parameter: the location of the xml configuration file e.g.:
duke$ java -jar Database2excel-37-jar-with-dependencies.jar /Users/duke/Configuration_file.xml
|© Database2excel.com - Design Style 1998.|