Chapter 1 Introduction

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.

Excel Report Generator 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. XLReportGen creates a blank report using the report template file, executes SQL statements in the XRF file, and puts the data from database into the report.

Features

XLReportGen includes the following features: