【摘要】 研究目的:运用Excel VBA自动完成地籍测量中宗地图的绘制及进行界址点成果表的显示输出。研究方法:运用Excel电子表格作为开发平台,以附置其中的VBA语言作为编程工具进行程序编制。研究结果:VBA可完成宗地图的图面绘制及相应的界址点号、界址边长等信息的标注,并可生成包含界址边长、方位角及宗地面积的界址点成果表。研究结论:编写的程序摆脱了现有宗地图绘制程序中需要安装相应软件并熟悉软件操作的不便之处,本程序在测试中使用方便,运行效果良好。更多还原

【Abstract】 The purposes of this paper are to draw cadastral parcel map automatically and to show the tables of boundary marks in a cadastral survey based on Excel VBA tool.Method employed is to conduct programming using Excel spreadsheet as development platform and the attached VBA as programming language.The results indicate that through Excel VBA the plotting of cadastral parcel map,corresponding numbers of boundary marks and the labeling of side lengths of boundary sites can be achieved.Furthermore a result table containing side lengths of boundary sites,azimuths and area of land parcel can also be generated.It is concluded that the compiled programs in this paper are easy to be applied to draw a cadastral parcel map,while avoiding the inconveniences of installing a third-party software which requires the users to get familiar with the software in advance.更多还原