使用VBA编程制作MapGIS格式地球化学直方图的方法研究

Research on the Method of Making MapgGIS Format Geochemical Histogram by Using VBA Programming

摘要:

Excel和MapGIS是地球化学数据处理和制图的常用软件，根据数据表手工计算和制作MapGIS格式图件的过程通常比较繁琐，而MapGIS明码格式为数据表和图件的直接交互提供了可能。使用VBA编程可以迅速、批量地实现基于Excel数据表的地球化学专题图件的生成，该文以地球化学数据直方图的制作为例，在Excel中通过VBA编程完成多元素地球化学数据直方图的制作。该方法首先在Excel中使用VBA编程完成制图所需的关键统计值和参数的计算，之后根据MapGIS明码格式的规则编程实现了点、线、区文件的批量生成，实现了数据表和图件的直接交互，并且各种参数均可在代码层修改，代码完善后生成的图件可不进行任何后期人工修改，制图效率较高，制图自由度高，操作简便。VBA编程制图具有灵活、易用和直观的优点，可以大幅减少数据处理和制图过程中的繁琐操作，配合专业软件使用，在数据预处理、统计、分析等过程中均具有较高的应用价值。

Abstract:

Excel and MapGIS are two commonly used softwares in geochemical data processing and mapping. The manual process of data calculation and the MapGIS format map making are usually tedious. However, the MapGIS clear file format makes it possible for the direct interaction between geochemical data tables and geochemical maps. With VBA programming, geochemical maps based on data tables can be generated quickly and massively. Taking the making of geochemical histograms as an example, geochemical histogram of multielements are completed by using VBA programming in the Excel. Firstly, calculate the key statistics and parameters which should be needed in the mapping process by useing VBA program in the Excel, then generates the points, lines and area files according to the rules of MapGIS clear format by using a VBA program. This method can realize the direct interaction between the data tables and maps, and all parameters used in the histogram maps can be modified in the code layer. These maps can be used without any manual modification with optimized codes, the drawing efficiency and the degree of freedom are rather high, and the operation is very simple. VBA programming drawing is flexible, intuitive and easy to use, which can greatly reduce the tedious operation of data processing and drawing process. It has high application value in data preprocessing and statistical analysis when cooperating with other professional softwares.