XLReportGen Overview

XLReportGen is a report generator for Microsoft ® Excel ® that outputs reports in Microsoft Excel spreadsheet format. If you know how to use Microsoft Excel and write SQL statements, you can use XLReportGen to create all kinds of reports as you need.

To create a report, XLReportGen need to read a report template file and an XRF file. The report template file is a Microsoft Excel workbook that defines the layouts and formats of a report. The XRF file contains SQL statements and some information, and tells XLReportGen how to get data from database and how to put data into a report. First XLReportGen creates a blank report using the report template file, and then executes SQL statements in the XRF file to get data from database, and fills data into the report to generate the desired report in Microsoft Excel spreadsheet format.

Software Requirement:

• Microsoft Windows 95, Windows 98, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista or later.
• Microsoft Office 97/98, Office 2000, Office XP, Office 2003 or later.

Download XLReportGen Introduction PDF (88KB)

• XLReportGen Home
• XLReportGen Overview
• XLReportGen Benefits
• XLReportGen Features
• How to output report to Microsoft Excel
• How to format reports using Microsoft Excel
• How to export data from database to Microsoft Excel
• How to create Microsoft Excel reports with pictures
• XLReportCom Introduction