How to output report to Microsoft Excel

XLReportGen is simple and easy to use. It does not require programming to create reports. It is enough if you know how to use Microsoft ® Excel ® and write SQL statements. To output report to Excel using XLReportGen, it requires only three steps:

Step 1

Create a report template file using Microsoft Excel, define the layouts, styles, formats of reports.

For example, to create a Customer List report, you make a report template as follows.

Step 2

Create an XRF file with an .xrf extension using XLReportGen. The XRF file tell XLReportGen how to extract data from database, and where and how to put data.

For example, you create an XRF file, and write a report function and SQL as follows.

/* Customer List */
@F1=Report(sheet="Customer List" type=var cell=A6 reserve=2)
SELECT CompanyName
,CityName
,CountryName
,ContactName
FROM Customers, Cities, Countries
WHERE Customers.CityCode = Cities.CityCode
AND Customers.CountryCode = Cities.CountryCode
AND Customers.CountryCode = Countries.CountryCode
ORDER BY CompanyName,CityName,CountryName
;

Step 3

Run XLReportGen to generate a report file in Microsoft Excel spreadsheet.

The report Customer List is generated as follows.

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