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

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

城市地下管线探测成果上交时,探测管线成果数据需按照规定的格式生成报表。数据成果报表存在许多单元格合并、表格跨页、跨页保留表头等要求,对此,提出一种基于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.