利用XML和Excel设计动态通用报表系统的新方法

A New Way to Design General-purpose Reporting Systems Using XML and Excel

提出一种利用XML和Excel设计动态通用报表系统的新方法。首先对Excel报表模板进行分解,生成报表模板的报表信息、架构信息和映射信息,再根据统计模板生成统计分析信息,这些信息均以XML文档的形式存入数据库。在系统运行时,将用户上报的Excel文件中的报表数据提取出来,以XML文档的形式存入数据库。然后结合XPath和XQuery对报表数据进行统计分析,得到统计报表数据。最后将统计报表数据组装为Excel文件输出给用户。采用这种方法设计的报表系统动态灵活、通用性强。

This paper discusses a new way to design dynamic and generalpurpose reporting systems,which utilizes XML and Excel. Excel templates is deconstructed and reporting information,structure information and mapping information of tem- plates are built,and statistics by a statistic template is generated,and all these information are stored in database in XML format. After that,data is extracted from user uploaded Excel files and it is saved to database in XML format. Using Xpath and XQuery,reporting data and statistic data which is further composed into an Excel file to users. This kind of design makes reporting system more flexible and custornizable.