基于XLS模板的城市地下管线成果报表自动生成方法研究  

Automatic Generation Method of Urban Underground Pipeline Achievement Report Based on XLS Template

作　　者：蒋利 韩李涛[1,2] 刘建勋 

机构地区：[1]山东科技大学测绘科学与工程学院 [2]海岛(礁)测绘技术国家测绘局重点实验室,山东青岛266590

出　　处：《软件导刊》2017年第12期9-11,共3页Software Guide

基　　金：国家自然科学基金项目(41201381);公路地质灾变预警空间信息技术湖南省工程实验室开放基金项目(kfj150605)

摘　　要：城市地下管线探测成果上交时,探测管线成果数据需按照规定的格式生成报表。数据成果报表存在许多单元格合并、表格跨页、跨页保留表头等要求,对此,提出一种基于XLS模板的地下管线成果数据生成方法。先结合规范要求自定义报表模板,然后在管线成果数据与模板单元之间建立关联,最后基于NPOI组件库生成符合规范要求的城市地下管线数据成果Excel报表。实验结果表明,该方法能够生成符合规范要求的复杂Excel报表。When the results of urban underground pipeline detection are submitted,the achievements of detecting pipeline data to generate report forms in accordance with the prescribed format.For the productive report forms of urban underground pipeline data have complex demand such as merging cells、generating forms across the page and retaining headers across the page,this paper proposes a method based on the XLS template to generate report forms of urban underground pipeline data,firstly,designing custom report template,then establishing connections between the results of pipeline data and template units,finally,generating Excel reports of urban underground pipeline result data based on NPOI library normatively.The experimental results show that the method can generate complex Excel report forms which meet the specification requirements.

关 键 词：EXCEL报表 XLS模板 地下管线 NPOI 

分 类 号：TP301[自动化与计算机技术—计算机系统结构]