The invention relates to a method for drawing an exploratory point
planar graph on the basis of the Excel. The method comprises the following steps of: 1, setting an Excel template file, i.e. setting a corresponding worksheet, wherein the worksheet at least comprises a header, a column number acquisition region, a CAD (
Computer Aided Design) batch command generating region for expressing graph blocks and characters of different exploration holes, a hole coordinate input regions of the exploration holes and an element input region; 2, setting a CAD template file, including steps of setting corresponding drawing
layers and defining the graph blocks and graph block names as per the elements, and
programming a small program of '
numbering and coordinate extracting.dvb'; and 3, by loading the small program of '
numbering and coordinate extracting. dvb', generating a corresponding Excel table, acquiring the coordinates of exploratory points so as to obtain the worksheet, starting a CAD batch command and drawing the exploratory point
planar graph. The method has the advantages that the method is simple, is easy to operate, is flexible and changeful, has strong adaptability, is convenient to carry out batch regulation and modification and has large
data capacity; the time of generating the exploratory point
layout plan in the investigation project is greatly shortened; and the working efficiency is improved.