Design and Implementation of Template Web Data Export

doi:10.3969/j.issn.1674-0696.2011.03.38

Journal of Chongqing Jiaotong University(Natural Science) ›› 2011, Vol. 30 ›› Issue (3): 507-510.DOI: 10.3969/j.issn.1674-0696.2011.03.38

Previous Articles Next Articles

Design and Implementation of Template Web Data Export

WANG Jia??wei, HUANG Kun, WANG Ren??hong

School of Information Sciences and Eng inee ring, Chongqing Jiaotong University, Chongqing 400074, China

Received:2011-01-24 Revised:2011-03-09 Online:2011-06-15 Published:2015-03-12

一种模版化的Web数据导出方法的设计与实现

王家伟, 黄?? 坤, 罗?? 宪, 汪仁红

重庆交通大学信息科学与工程学院, 重庆400074

作者简介:王家伟(1971—),男,四川达川人,副教授,主要从事数据库研究方面的工作。E-mai:l495826001@163.com。
基金资助:
重庆市攻关项目(2010AC2077)

Abstract

Abstract: In B/SMode, exporting data to excel is usually realized by some common data controls in C#, however, the exporting format of data and the style of report are hard to control.Implementing process of exporting data to excel based on WebDataWindowControl of DataWindow.NET was in troduced.In this way, data including some complicate style of report could be exported to exc l exactly without data container like DataSet to store data.

Key words: Data Window. NET, data exporting, template, reportforms

摘要： B/S模式下,C#中通常是利用一般数据控件实现数据导出到Excel中,但数据导出格式以及报表样式不易控制。介绍了以DataWindow.NET中的WebDataWindowControl为基础实现数据导出到Excel的过程和方法。该方法可以准确无误地导出页面数据,包括复杂的表格样式,且无需类似于DataSet的数据容器来暂存即将导出的数据。

关键词: DataWindow.NET, 数据导出, 模版, 报表

CLC Number:

TP39

WANG Jia??wei, HUANG Kun, WANG Ren hong. Design and Implementation of Template Web Data Export[J]. Journal of Chongqing Jiaotong University(Natural Science), 2011, 30(3): 507-510.

王家伟, 黄?? 坤, 罗?? 宪, 汪仁红. 一种模版化的Web数据导出方法的设计与实现[J]. 重庆交通大学学报（自然科学版）, 2011, 30(3): 507-510.

References

[1]SYBASE C o., L td..Programm ers Guide DataW indow: NET(tm ) 2.0[Z].Dub lin: Syb ase, In c, 2006.
[2] 史雪梅.基于Javascrip t的JSP页面数据导出Excel[J].现代计算机, 2010(3): 123-125.
SH I Xue- m e.i Export JSP page data that is based on JavaS crip t to Excel[J] .Modern Com puter, 2010(3 ): 123-125.
[3]罗乐霞, 郑志娴.ASP.NET 导出Excel数据方法总结[J] .科技资讯, 2007(3): 77.
LUO Le- xia, ZH ENG Zhi-xian.M ethods of data export in Execel based on ASP.NET [J ].Science & Techno logy In formation, 2007(3 ): 77.
[4] SYBASE 软件(中国)有限公司.DataW indow.NET 扩展Power Builder的使用空间[J] .铁路计算机应用, 2006, 15(1 ): 59 - 60.
SYBASE S oftw are(China)Co., Ltd..DataW indow.NET expand the use of space for pow erbu ilder[J] .Railw ay Computer Appl ication, 2006, 15(1): 59-60.
[5] 张文博, 余文芳.ASP.NET编程中对Excel文档操作的探讨及应用[J] .计算机系统应用, 2010, 19(3): 187-189.
ZHANG Wen-b o, YU Wen-fang.Discuss ion and application of Excel docum ents in ASP.NET programm ing[J] .Computer System s& Applications, 2010, 19(3): 187-189.
[6] 刘振声.海量数据导出E xcel的方法与实现[J] .计算机与现代化, 2010(2): 130-132.
LIU Zhen-sh eng.M ethod and im p lem en tat ion ofm assive data export in Excel form at[J] .Computer and Modernization, 2010(2 ): 130-132.
[7] 邓世建, 耿丙成, 张超, 等.基于软件集成的数据报表设计技术及实现[J] .计算机工程与应用, 2005(20): 98-101. DENG Sh i- jian, GENG B ing- cheng, ZHANG Chao, et a.l Technology and implementation of designing data report form based on software integration [J ].Computer Engineering and App lications, 2005(20): 98-101.
[8] 方伟, 左春, 孙玉芳.基于XML的数据模型在报表模块上的应用[J] .计算机工程与应用, 2003(30): 197- 200. FANG Wei, ZUO Chun, SUN Yu- fang.The application of data model to report module based on XML[J] .Computer Engineering and Applications, 2003(30 ): 197- 200.
[9] 关萍萍, 翟正军, 姜红梅.基于LabW indow s /CV I测控系统通用报表的设计与实现[J ] .计算机工程与设计, 2010(1 ): 203 - 205.
GUAN Ping-ping, ZHAI Zheng- jun, JIANG H ong- me.i Design and implementation of universal control system report based on Lab Windows /CV I[J ] .Computer Engineering and Design, 2010 (1 ): 203- 205.
[10] 王东, 孙彬.基于A jax的DataW indow 框架分析[J] .计算机工程, 2008, 34(7 ): 79- 80.
WANG Dong, SUN Bin.Analys is of Data Window frame based on A jax[J] .C omputer Engineering, 2008, 34(7): 79-80.
[11] 王丽芳, 李少春, 蒋泽军.基于.N et和XML模版的打印控件的设计与实现: 分层与复用思想的应用[J] .微计算机应用, 2006, 27(3): 339- 342.
WANG Li-fang, LI Shao- chun, JIANG Ze- jun.Design and implementation of the XML Template print control on .Net [J ]. Micro computer Application, 2006, 27(3): 339- 342.

Design and Implementation of Template Web Data Export

一种模版化的Web数据导出方法的设计与实现

PDF

Knowledge

Abstract

Cite this article

share this article

References

Related Articles 3

Recommended Articles

Metrics

[1]	LING Xiang, LAI Kun, WANG Xipeng. Uneven Illumination License Plate Image Recognition Base on Template Matching Method [J]. Journal of Chongqing Jiaotong University(Natural Science), 2018, 37(08): 102-106.
[2]	WANG Jiawei, HUANG Kun, WANG Renhong. Design and Implementation of Template Web Data Export [J]. Journal of Chongqing Jiaotong University(Natural Science), 2011, 30(2): 349-352.
[3]	LI BO , CHENG Qing—jun， GU An—bang. Using generic programming in bridge finite analysis software development [J]. Journal of Chongqing Jiaotong University(Natural Science), 2005, 24(3): 20-22.