Database2excel exports your database to Excel.

Database2Excel provides Developers and Business Analysts a simple means of exporting Oracle, MSSQL Server, MySQL, PostgreSQL, Sybase, HSQL, DB2 and SQLite data to Microsoft Excel. It supports exporting data (using 1 select statement) to multiple Excel worksheets or multiple Excel workbooks, and exports as much data (using many select statements) as you would like in one go. While making use from Microsoft Excel Templates makes Database2excel cost effective reporting, with superb performance and support for millions of rows. An existing Microsoft Excel workbook (xlsx) may be used as a template. To export data to multiple worksheets from a SQL statement with<br>column name [DEPARTMENT] use "worksheet_[DEPARTMENT]" as worksheet name To export data to multiple workbooks from a SQL statement with colum name [DEPARTMENT] use "workbook_[DEPARTMENT].xlsx" as Excel file name.


Templating

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.


Dynamic worksheet

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.


Dynamic workbook

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","workbook_HR.xlsx" etc. 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-<....>.jar /Users/duke/Configuration_file.xml


Mail output

If one opens the xml one sees the following xml elements that may be modified to mail the output

    <mail>

        <mailOutput>false</mailOutput>

        <mailTo>john@gmail.com,jack@gmail.com</mailTo>

        <mailFrom>john@gmail.com</mailFrom>

        <mailHost>smtp.gmail.com</mailHost>

        <mailSubject>The Excelsheet from Database2excel.com</mailSubject>

        <mailBody>Hi, here is the Excelsheet exported with Database2excel.com. Duke</mailBody>

        <mailPort>587</mailPort>

        <mailEnableTTLS>true</mailEnableTTLS>

        <mailEnableSSL>false</mailEnableSSL>

        <mailUserName>john@gmail.com</mailUserName>

        <mailPassword></mailPassword>

    </mail>