XLReportGen 是 Microsoft Excel 的报告生成器，它以 Microsoft Excel 电子表格格式输出报告。如果您知道如何使用 Microsoft Excel 和编写 SQL 语句，可以使用 XLReportGen 创建所需的各种报表。 若要创建报表，XLReportGen 需要读取报表模板文件和 XRF 文件。报表模板文件是 Microsoft Excel 工作簿，用于定义报表的布局和格式。XRF 文件包含 SQL 语句和一些信息，并告诉 XLReportGen 如何从数据库获取数据以及如何将数据放入报表中。XLReportGen 使用报表模板文件创建空白报表，在 XRF 文件中执行 SQL 语句，并将数据来自数据库的数据放入报表中。 效益： * 使用微软Excel作为您的报告工具。 * 易于使用。只是微软的Excel和SQL。 * 强大而灵活。微软 Excel 功能强大且灵活。 * 省钱。无需购买额外昂贵的报告工具。 * 节省时间。减少开发时间和培训时间。 * 提高工作效率。报表采用熟悉的格式。 * 适合各种用户：IT用户、业务用户和开发人员。 特征： * 使用微软Excel作为您的报告工具 * 直接使用微软 Excel 制作报表模板 * 使用 OpenXML SDK 操作 Excel 报告 * 使用 SQL 访问数据 * 创建没有编程经验的报告 * 使用计算机连接到所有ADO.Net * 在一份报告中支持多数据库 * 生成具有参数的报告 * 支持 Windows 模式和命令行模式 * 创建复杂报告 * 使用图表创建报表 * 使用图片创建报表 * 一个微软 Excel 工作簿中的许多报表 * 自动生成报告 * 一次配置 * 灵活部署
版本历史记录
- 版本 5.2.0.0 发布于 2014-04-28
升级到 OpenXML SDK 2.5 和微软 .NET 框架 4。 - 版本 3.6.2 发布于 2008-12-24
修复了 UNC 路径的一些错误。
软件信息
终端用户许可协议
XLReportGen Version 5 License Agreement Copyright (C) 2014 LJZsoft All rights reserved. Your Agreement to This License ------------------------------ You should carefully read the following terms and conditions before using, installing, copying, or distributing this software. Your use, installation, copying, or distribution of XLReportGen indicates your acceptance of this agreement ("License"). NO WARRANTY ----------- XLREPORTGEN IS DISTRIBUTED "AS IS". NO WARRANTY OF ANY KIND IS EXPRESSED OR IMPLIED. THE AUTHOR WILL NOT BE LIABLE FOR DATA LOSS, DAMAGES, LOSS OF PROFITS OR ANY OTHER KIND OF LOSS WHILE USING OR MISUSING THIS SOFTWARE. Evaluation ---------- XLReportGen is not free software. You may use this software for evaluation purposes without charge for a period of 30 days. If you use this software after the 30 day evaluation period, you must purchase it. Use --- Each Licensed Copy of this Software may either be used by a user who uses the software personally on one or more computers, or installed on a single computer used nonsimultaneously by multiple people, but not both. This is not a concurrent use license. If you install the Software onto a multi-user platform, server or network, each and every individual user of the Software must be licensed separately. Distribution ------------ You may copy the evaluation version of this software and documentation as you wish, and give exact copies of the original evaluation version to anyone, and distribute the evaluation version of the software and documentation in its unmodified form via electronic means. You are specifically prohibited from charging, or requesting donations without permission from the author. You may not modify, copy, share, distribute, re-sell, transfer or sub-license the full version of this software except that you may make copies for archive purposes only. Any such unauthorized use shall result in immediate and automatic termination of this license. Edition ------- There are 2 types of editions issued for XLReportGen. 1) XLReportGen Standard Edition User can execute no more than 50 SQL statements in one report processing. 2) XLReportGen Professional Edition User can execute SQL statements unlimitedly in one report processing.