CN110472297A - A kind of CAD cross-section diagram profile data rapid extracting method - Google Patents
A kind of CAD cross-section diagram profile data rapid extracting method Download PDFInfo
- Publication number
- CN110472297A CN110472297A CN201910665182.7A CN201910665182A CN110472297A CN 110472297 A CN110472297 A CN 110472297A CN 201910665182 A CN201910665182 A CN 201910665182A CN 110472297 A CN110472297 A CN 110472297A
- Authority
- CN
- China
- Prior art keywords
- data
- section
- profile data
- cad
- extraction
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000010586 diagram Methods 0.000 title claims abstract description 30
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000000605 extraction Methods 0.000 claims abstract description 16
- 238000013500 data storage Methods 0.000 claims abstract description 13
- 239000000284 extract Substances 0.000 claims abstract description 13
- 238000013075 data extraction Methods 0.000 claims abstract description 12
- 230000008676 import Effects 0.000 claims abstract description 4
- 238000012216 screening Methods 0.000 claims abstract description 4
- 241001269238 Data Species 0.000 claims description 2
- 238000011161 development Methods 0.000 claims description 2
- 238000004321 preservation Methods 0.000 abstract description 3
- 238000012790 confirmation Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Abstract
The invention discloses a kind of CAD cross-section diagram profile data rapid extracting methods, comprising the following steps: determines the format that CAD section exports in Excel table style, and edits fixed data format template；Specified data file class, file name, document location；Determine data import format, quantity；Define the parameter of required input before profile data extracts；It determines the type for extracting section line, generates profile data；Judge whether to complete the extraction of this section total data, does not complete data extraction and then continue to extract up to completing, such as complete all data of the section and extract, then enter the data storage stage；Judge to continue to store under the data with existing rear direction come out with automatic screening with the presence or absence of data in data storage object table；Next CAD cross-section diagram profile data is carried out to extract until terminating.The method of the present invention improves working efficiency convenient for data preservation, reduces mistake caused by influencing because of human factor.
Description
Technical field
The present invention relates to CAD cross-section diagrams to extract section coordinate point methods field, specifically a kind of CAD cross-section diagram profile data
Rapid extracting method.
Background technique
In engineering construction process, mobility of people is larger, data hand-over be likely to occur transfer it is not comprehensive etc.
Problem.It is how that existing cross-section diagram profile data is quick for only having CAD cross-section diagram there is no the case where profile data to happen occasionally
It extracts, improves working efficiency, human factor is avoided to cause mistake extremely important.
Summary of the invention
Technical problem to be solved by the invention is to provide a kind of CAD cross-section diagram profile data rapid extracting methods, to normal
The CAD cross-section diagram seen is drawn and profile data Extraction specification carries out procedure treatment, improves data extraction rate and accuracy.
In order to solve the above technical problems, the technical solution adopted by the present invention is that:
A kind of CAD cross-section diagram profile data rapid extracting method, comprising the following steps:
Step 1: based on Excel2007 version and combining AutoCAD2007 or less version, be that exploitation is flat with AutoCADVBA
Platform；It determines the format that CAD section exports in Excel table style, and edits fixed data format template；
Step 2: specified data file class, file name, document location；Determine data import format, quantity；
Step 3: defining the parameter of required input before profile data extracts；
Step 4: determining the type for extracting section line, generate profile data；
Step 5: judging whether to complete the extraction of this section total data, do not complete data extraction and then continue to extract until complete
At such as completing all data of the section and extract, then enter the data storage stage；
Step 6: judging with the presence or absence of data in data storage object table, the data with existing rear come out with automatic screening
Continue to store downwards；
Step 7: carrying out next CAD cross-section diagram profile data and extract until terminating.
Further, in step 3, the parameter includes: section serial number, section pile No., specified profile extraction basic point, base
Point offset distance and basic point elevation.
Further, in step 4, the type for extracting section line is that multi-section-line first judges selection during the extraction process
Whether it is linearly multi-section-line, if the section line extracted is non-multi-section-line, needs to modify to section line type.
Further, during the extraction process, the case where there are a plurality of multi-section-lines for same section then carries out before extraction
Multi-section-line merges.
Further, the step 6 further include: after data storage, judge whether all CAD cross-section diagram profile datas all
It extracts and completes, completed if all extracting, terminate extraction task, otherwise carry out in next step.
Compared with prior art, the beneficial effects of the present invention are: it is quick to existing cross-section diagram section coordinate by this method
Extract and be converted into fixed excel formatted data table, in order to data preservation, while improving working efficiency, reduce because it is artificial because
Mistake caused by element influences.
Detailed description of the invention
Fig. 1 is data format in extracting method of the present invention；
Fig. 2 is to extract frame schematic diagram with profile data in invention extracting method；
Fig. 3 is that section serial number inputs schematic diagram in extracting method of the present invention；
Fig. 4 is that section pile No. inputs schematic diagram in extracting method of the present invention；
Fig. 5 is that offset distance inputs schematic diagram in extracting method of the present invention；
Fig. 6 is that elevation inputs schematic diagram in extracting method of the present invention；
Whether Fig. 7 is to extract to finish confirmation block diagram in extracting method of the present invention；
Fig. 8 is the completion confirmation block diagram that whether works in extracting method of the present invention；
Fig. 9 is that preservation block diagram is checked in extracting method of the present invention；
Figure 10 is that data save block diagram in extracting method of the present invention.
Specific embodiment
The present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments.
It determines that CAD section exports to the format in Excel table style under common state, and edits fixed data format sample
Plate, selection AutoCAD VBA are development platform.In order to which data export mode is simple as far as possible, understandable, it is convenient for operation, program
Interface keeps succinct and adds clear remarks.
In AutoCAD VBA program editing:
1, (statement) data file class, file name, document location are specified；Determine data import format, quantity (Dim
It is statement variable inside program).
2, the parameter of required input before profile data extracts is defined, such as: must include in specific input profile data be interior
Hold, section serial number, section pile No., specifies profile extraction basic point, basic point offset distance, basic point elevation.
3, it determines the type for extracting section line, is such as determined as extracting object type being common multi-section-line, in extraction process
In, whether the line style selected is first judged for multi-section-line, if the section line extracted is non-multi-section-line, pop-up window is prompted,
It modifies at this time, it may be necessary to exit the program to section line type, runs program again；When selecting section line as multi-section-line, generate
Profile data；Data extraction is finished to be prompted in the form of pop-up window, if the extraction of this section total data is completed, it is such as same disconnected
There is a multi-section-line in face, do not complete data extraction and then continues selection until completing, such as complete all data of the section and extract, then into
Enter data storage stage (for same section there are when a plurality of multi-section-line, merging processing in advance).
4, judge that data storage is not with the presence or absence of data in data storage object table to cover the data in former tables of data
To require, continue to store under the data with existing rear direction that data storage is come out with automatic screening.After data storage is complete, pop-up window
Prompt, whether profile data extraction is completed, if not completing, continues to come back for next profile data extraction, if completion, is popped up
Data are extracted, and prompt to save, end of run.
Specific implementation program code according to the above technical scheme is as follows:
According to above procedure the specific operation is as follows:
1, operation cad tools column is clicked, this program is loaded and run, pop-up window (Fig. 2) is clicked " profile data extraction "
Operation；
2, pop-up window " input section serial number ", inputs section serial number, such as: 1,2,3 ... (Fig. 3), point in input frame
It hits and determines into next step；
3, pop-up window " input section pile No. ", inputs section pile No. in input frame, such as: 10,20,30 ... (Fig. 4),
It clicks and determines into next step；
4, it is operated according to the prompt of CAD command cue column, " arbitrary point A on specified section line ", best specified point section
Elevational point is fixed on center line；
5, after specified point A selection, distinguish pop-up window " input A point offset distance ", " input A point height ", note: offset distance is
Away from center line distance (Fig. 5, Fig. 6)；
6, it is operated according to the prompt of CAD command cue column, " choosing multi-section-line " chooses section line multi-section-line；
7, pop-up window " this profile extraction finishes " it clicks "Yes" (Fig. 7)；
8, pop-up window " work finishes ", continue to extract profile data click "No" if necessary and 2~6 steps need to be repeated
Suddenly, data extraction finishes click "Yes", operates (Fig. 8) into next step；
9, data extraction finishes, and clicks "Yes" and determines, pop-up window " checking that excel chooses whether to save " (Fig. 9)；
10, the extracted profile data of reality in excel file " mileage file " table, and bullet at the same time as needed are popped up
Whether prompt out is saved (Figure 10) to excel data form；
11, all operations are completed.
Claims (5)
1. a kind of CAD cross-section diagram profile data rapid extracting method, which comprises the following steps:
Step 1: based on Excel2007 version and AutoCAD2007 or less version is combined, using AutoCAD VBA as development platform；
It determines the format that CAD section exports in Excel table style, and edits fixed data format template；
Step 2: specified data file class, file name, document location；Determine data import format, quantity；
Step 3: defining the parameter of required input before profile data extracts；
Step 4: determining the type for extracting section line, generate profile data；
Step 5: judging whether to complete the extraction of this section total data, do not complete data extraction and then continue to extract until completing, such as
It completes all data of the section to extract, then enters the data storage stage；
Step 6: judging with the presence or absence of data in data storage object table, under the data with existing rear direction come out with automatic screening
Continue to store；
Step 7: carrying out next CAD cross-section diagram profile data and extract until terminating.
2. a kind of CAD cross-section diagram profile data rapid extracting method according to claim 1, which is characterized in that in step 3
In, the parameter includes: section serial number, section pile No., specified profile extraction basic point, basic point offset distance and basic point elevation.
3. a kind of CAD cross-section diagram profile data rapid extracting method according to claim 1, which is characterized in that in step 4
In, the type for extracting section line is multi-section-line, and during the extraction process, whether first judge to select is linear for multi-section-line, if extracting
Section line be non-multi-section-line, need to modify to section line type.
4. a kind of CAD cross-section diagram profile data rapid extracting method according to claim 3, which is characterized in that extracting
In the process, the case where there are a plurality of multi-section-lines for same section then carries out multi-section-line merging before extraction.
5. a kind of CAD cross-section diagram profile data rapid extracting method according to claim 1, which is characterized in that the step
Rapid 6 further include: after data storage, judge whether that all CAD cross-section diagram profile datas all extract completion, if all having extracted
At, then terminate extraction task, otherwise carry out in next step.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910665182.7A CN110472297A (en) | 2019-07-23 | 2019-07-23 | A kind of CAD cross-section diagram profile data rapid extracting method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910665182.7A CN110472297A (en) | 2019-07-23 | 2019-07-23 | A kind of CAD cross-section diagram profile data rapid extracting method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110472297A true CN110472297A (en) | 2019-11-19 |
Family
ID=68509765
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910665182.7A Pending CN110472297A (en) | 2019-07-23 | 2019-07-23 | A kind of CAD cross-section diagram profile data rapid extracting method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110472297A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2003019523A1 (en) * | 2001-08-23 | 2003-03-06 | Fei Company | Graphical automated machine control and metrology |
| CN104008252A (en) * | 2014-06-12 | 2014-08-27 | 福建省电力勘测设计院 | Method for automatically generating plane-section drawing of underground cable duct lines |
| CN106503154A (en) * | 2016-10-21 | 2017-03-15 | 长江勘测规划设计研究有限责任公司 | The automation extracting method of batch river cross-section morphological data |
| CN109271697A (en) * | 2018-09-10 | 2019-01-25 | 云南省红河州水利水电勘察设计研究院 | Based on profile data processing system and method, computer program in VBA processing AutoCAD |
| CN109918824A (en) * | 2019-03-18 | 2019-06-21 | 中国水利水电第四工程局有限公司 | One kind being based on AutoCAD secondary development underground chamber Section chart drawing method |
-
2019
- 2019-07-23 CN CN201910665182.7A patent/CN110472297A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2003019523A1 (en) * | 2001-08-23 | 2003-03-06 | Fei Company | Graphical automated machine control and metrology |
| CN104008252A (en) * | 2014-06-12 | 2014-08-27 | 福建省电力勘测设计院 | Method for automatically generating plane-section drawing of underground cable duct lines |
| CN106503154A (en) * | 2016-10-21 | 2017-03-15 | 长江勘测规划设计研究有限责任公司 | The automation extracting method of batch river cross-section morphological data |
| CN109271697A (en) * | 2018-09-10 | 2019-01-25 | 云南省红河州水利水电勘察设计研究院 | Based on profile data processing system and method, computer program in VBA processing AutoCAD |
| CN109918824A (en) * | 2019-03-18 | 2019-06-21 | 中国水利水电第四工程局有限公司 | One kind being based on AutoCAD secondary development underground chamber Section chart drawing method |
Non-Patent Citations (1)
| Title |
|---|
| 吴立军: "基于VBA实现断面数据自动提取", 《中国农村水利水电》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107239595B (en) | Tire three-dimensional modeling system based on NX software PTS module and modeling method thereof | |
| CN104317589B (en) | A kind of code automatic generation method and device for being used to load dynamic link library | |
| CN101718977B (en) | CAM system for automobile longeron punching processing and control method and construction method thereof | |
| CN102707669B (en) | Method for constructing CAM (computer-aided manufacturing) system for punching for automobile girders | |
| CN113112222B (en) | Automatic signature method and system for OFD format file based on big data analysis | |
| CN103454972A (en) | Tool five-axis numerical control grinding automatic programming method based on UG NX API | |
| CN105677970A (en) | Copper-deficiency automatic supplementing method with no need of repeatedly avoiding copper | |
| CN109271697B (en) | System and method for processing interrupt data in AutoCAD based on VBA, and computer program | |
| CN112818460A (en) | Intelligent building rollover method from two-dimensional drawing to three-dimensional model | |
| CN102968539A (en) | Method for massively and quickly generating format drawing | |
| CN109145359B (en) | Steel structure material preparation method based on BIM system and CAD software | |
| CN105630514A (en) | Form designing method based on modularization | |
| CN107480118A (en) | Method for editing text and device | |
| CN111291025B (en) | Method for supporting multi-physical model conversion by logic model and storage device | |
| CN102541282A (en) | Method, device and system for reediting completed words and phrases through icon moving | |
| CN102254076B (en) | Tool for analyzing manufacturability of three-dimensional model design | |
| CN110472297A (en) | A kind of CAD cross-section diagram profile data rapid extracting method | |
| CN108038255A (en) | A kind of automatic method for making pcb board set jigsaw | |
| CN102609564A (en) | Fast positioning and corresponding method for machining features and machining operations | |
| CN106446133A (en) | Method and device for simultaneous butt joint of two databases | |
| CN112015728A (en) | Method for automatically checking acquired data | |
| CN108153931A (en) | VBA combinations APDL carries out the method that nuclear power station pipeline suspension and support mechanical property calculates analysis | |
| CN101776993B (en) | System and method automatically generating software interactive interface | |
| CN105573972A (en) | Report check formula generation method and apparatus | |
| CN115115787B (en) | DirectVR-based two-dimensional drawing to 3D model method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20191119 |