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.