CN108763382A - A method of the chart content in CAD program is imported into Excel programs - Google Patents
A method of the chart content in CAD program is imported into Excel programs Download PDFInfo
- Publication number
- CN108763382A CN108763382A CN201810482852.7A CN201810482852A CN108763382A CN 108763382 A CN108763382 A CN 108763382A CN 201810482852 A CN201810482852 A CN 201810482852A CN 108763382 A CN108763382 A CN 108763382A
- Authority
- CN
- China
- Prior art keywords
- excel
- programs
- cad program
- chart
- imported
- 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
Landscapes
- Processing Or Creating Images (AREA)
Abstract
The invention discloses a kind of chart contents by CAD program to imported into the method in Excel programs, and this method includes carrying out secondary development to CAD program so that CAD program executes following processing：It determines targeted content area pending in target interface, acquisition recognition result is identified to the content shown in the targeted content area, the recognition result includes the coordinate information at lines, text data and respective place that the chart includes；According to the recognition result, the cell included by the chart content, the text data in each unit lattice and the relative position relation between each unit lattice are determined, and can be by the logical structure data of Excel procedure identifications according to above- mentioned information generation.Method provided by the present application is simple and efficient to the Secondary of CAD program, CAD program after secondary development can be by the text data in the table and table in CAD diagram table both quick and accurate true export, to make the working efficiency of staff greatly promote.
Description
Technical field
The present invention relates to data leading-in technique fields, are imported into more particularly to a kind of chart content by CAD program
Method in Excel programs.
Background technology
ACAD is widely used in each field as universal mapping software.Have in bridge construction detail drawing conversion aspect
Big advantage, the material table in detail drawing includes a large amount of text datas, and ACAD itself lacks the energy handled mass data
Power.Factory will merge the mass data in construction drawing when manufacturing steel construction, classification and ordination operates, and use EXCEL at present
Carry out these work.ACAD and EXCEL can be solved by secondary development and carries out data interchange, use manually input data efficiency
It is extremely low, also result in various mistakes.
Invention content
A kind of method being imported into the present invention provides chart content by CAD program in Excel programs.It is suitable for
CAD program steel bridge construction drawing material table data are output in Excel programs.
The present invention provides following schemes：
A method of the chart content in CAD program is imported into Excel programs, including：
Secondary development is carried out to CAD program by VISUAL LISP so that CAD program executes following processing：
Determine that targeted content area pending in target interface, the targeted content area are the region where chart content；
Acquisition recognition result is identified to the content shown in the targeted content area, the recognition result includes described
The coordinate information at lines, text data and respective place that chart includes；
According to the recognition result, determine the cell included by the chart content, the text data in each unit lattice and
Relative position relation between each unit lattice, and can be by the logical structure data of Excel procedure identifications according to above- mentioned information generation；
Start the Excel programs, and the logical structure data is imported into the Excel programs, so as to the Excel
Program creates corresponding list data according to the logical structure data.
Preferably：Pending targeted content area in the determining target interface, the targeted content area are chart
Region where content；Including：
The coordinate information for obtaining two points in the target interface that user selectes encloses shape when by described two points as diagonal 2
At rectangular area as targeted content area.
Preferably：Coordinate information where the text data is ranked up and the coordinate information phase where the lines
It is opposite between text data in cell, each unit lattice and each unit lattice in conjunction with included by the determination chart content
Position relationship.
Preferably：Start the Excel programs by the Active X functions in VISUAL LISP.
Preferably：By the logical structure data carry out full line and or permutation batch change after imported into the Excel journeys
In sequence.
Preferably：The batch change includes carrying out automatic point of row to certain column data, certain row being multiplied by with a number automatically, right
Certain arranges any one or the combination of several of them in being summed.
Preferably：When in the logical structure data comprising multigroup different logical structure data, start the Excel journeys
Sequence, and multigroup different logical structure data is imported into order in the Excel programs, so as to the Excel journeys
Sequence creates corresponding multigroup different list data according to multigroup different logical structure data, and in multigroup difference
List data between addition distinguish symbol.
Preferably：The differentiation symbol is blank line.
Preferably：Secondary development is carried out to the Excel programs so that the Excel programs execute following processing：
The list data of establishment is ranked up, Classifying Sum according to scheduled format, and generates target inventory.
Preferably：Secondary development is carried out to the Excel programs by C# programs or Visual Basic programs.
According to specific embodiment provided by the invention, the invention discloses following technique effects：
By the invention it is possible to realize that a kind of chart content by CAD program imported into the method in Excel programs, one
Under kind realization method, this method may include carrying out secondary development to CAD program by VISUAL LISP so that CAD program is held
The following processing of row：Determine that targeted content area pending in target interface, the targeted content area are chart content place
Region；Acquisition recognition result is identified to the content shown in the targeted content area, the recognition result includes
The coordinate information at lines, text data and respective place that the chart includes；According to the recognition result, determine described in
Cell included by chart content, the text data in each unit lattice and the relative position relation between each unit lattice, and
It can be by the logical structure data of Excel procedure identifications according to above- mentioned information generation；Start the Excel programs, and is patrolled described
It collects structured data to imported into the Excel programs, be corresponded to so that the Excel programs are created according to the logical structure data
List data.Method provided by the present application, the integrated visual development environment VISUAL that CAD can be utilized to carry
LISP carries out secondary development so that it can which the information such as lines, text data in CAD diagram table are identified, to raw to CAD
At list data being exported eventually by Excel programs by the logical structure data of Excel procedure identifications.This method is to CAD
The Secondary of program is simple and efficient, and the CAD program after secondary development can be by the table and table in CAD diagram table
Text data both quick and accurate true export in lattice, to make the working efficiency of staff greatly promote.
Certainly, it implements any of the products of the present invention and does not necessarily require achieving all the advantages described above at the same time.
Description of the drawings
It in order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, below will be to institute in embodiment
Attached drawing to be used is needed to be briefly described, it should be apparent that, the accompanying drawings in the following description is only some implementations of the present invention
Example, for those of ordinary skill in the art, without creative efforts, can also obtain according to these attached drawings
Obtain other attached drawings.
Fig. 1 is the side that a kind of chart content by CAD program provided in an embodiment of the present invention is imported into Excel programs
The flow chart of method.
Specific implementation mode
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation describes, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.It is based on
Embodiment in the present invention, the every other embodiment that those of ordinary skill in the art are obtained belong to what the present invention protected
Range.
Embodiment
Referring to Fig. 1, Excel programs are imported into for a kind of chart content by CAD program provided in an embodiment of the present invention
In method, as shown in Figure 1, this method includes：
Secondary development is carried out to CAD program by VISUAL LISP so that CAD program executes following processing：
S101：Determine targeted content area pending in target interface, the targeted content area is where chart content
Region；Specifically, obtaining the coordinate information of two points in the target interface that user selectes, it regard described two points as at diagonal 2 points
When the rectangular area that is enclosed as targeted content area.
S102：Acquisition recognition result, the recognition result are identified to the content shown in the targeted content area
It include the coordinate information at lines, text data and respective place that the chart includes；
S103：According to the recognition result, the cell included by the chart content, the text data in each unit lattice are determined
And the relative position relation between each unit lattice, and can be by the logical construction of Excel procedure identifications according to above- mentioned information generation
Data；In specific implementation, the coordinate information where the text data is ranked up and is believed with the coordinate where the lines
Cell included by the manner of breathing combination determination chart content, the text data in each unit lattice and between each unit lattice
Relative position relation.
S104：Start the Excel programs, and the logical structure data is imported into the Excel programs, so as to
The Excel programs create corresponding list data according to the logical structure data.In specific implementation, can pass through
Active X functions in VISUAL LISP start the Excel programs.When needing to be modified original list data,
By the logical structure data carry out full line and or permutation batch change after imported into the Excel programs.The batch changes
Dynamic includes to certain column data automatically divide arranging, being multiplied by certain row automatically one number, arranging certain any one in summing
Or several combination.
When in the logical structure data comprising multigroup different logical structure data, start the Excel programs, and will
Multigroup different logical structure data is imported into order in the Excel programs, so that the Excel programs are according to institute
It states multigroup different logical structure data and creates corresponding multigroup different list data, and in multigroup different table number
Symbol is distinguished in addition between.The differentiation symbol is blank line.
In order to allow Excel programs further to generate various inventories, the embodiment of the present application can also be provided to described
Excel programs carry out secondary development so that the Excel programs execute following processing：
The list data of establishment is ranked up, Classifying Sum according to scheduled format, and generates target inventory.Specifically
, secondary development is carried out to the Excel programs by C# programs or Visual Basic programs.
Method provided by the present application can be applied to steel bridge construction drawing material table data and be output in Excel, specific side
Method is：
Secondary development is carried out to ACAD with VISUAL LISP, reaches and is output to steel bridge construction drawing material table data according to format
In EXCEL softwares.It is as follows：
1）Secondary development is carried out to ACAD using VISUAL LISP.
2）According to the word and table in ACAD steel bridge construction drawing material tables, according to the sequence of word coordinate and rectilinear coordinates phase
In conjunction with mode, the procedural model of table and lteral data is calculated using topological method.
3）EXCEL is opened in a visible manner using the function of VISUAL LISP, according to the logical relation of mathematical model by material
Expect in table data and list data write-in EXCEL, in ACAD tables lteral data and EXCEL table lteral data be consistent or
Person carries out automatic point of row for such as No. X according to separator to certain column data to data, and also can certain row be multiplied by with a number or right automatically
Certain row is summed.Data are not changed requirement can by with logical relation former table and data be written to EXCEL
And it deposits.There is change to require data, EXCEL is written to simultaneously after just being changed in batches to former list data full line or permutation
Deposit.Specifically, the Active X functions using VISUAL LISP are linked to EXCEL.
4）Material table data different in ACAD are output in order in same EXCEL file, in different list datas
Between plus blank line distinguish.Specifically, can merge to work in same EXCEL automatically to the data that different materials table exports
Bao Zhong, and add null to be separated processing between different list datas.
5）List data in EXCEL file check it is errorless after, program secondary development EXCEL using VB, program can be right
The automatic Classifying Sum of output data, and according to fixed format automatically generate various inventories.
In short, method provided by the present application, the integrated visual development environment VISUAL that CAD can be utilized to carry
LISP carries out secondary development so that it can which the information such as lines, text data in CAD diagram table are identified, to raw to CAD
At list data being exported eventually by Excel programs by the logical structure data of Excel procedure identifications.Pass through this method
It can be by the text data in the table and table in CAD diagram table both quick and accurate true export, to make the work of staff
It is greatly promoted as efficiency.
As seen through the above description of the embodiments, those skilled in the art can be understood that the application can
It is realized by the mode of software plus required general hardware platform.Based on this understanding, the technical solution essence of the application
On in other words the part that contributes to existing technology can be expressed in the form of software products, the computer software product
It can be stored in a storage medium, such as ROM/RAM, magnetic disc, CD, including some instructions are used so that a computer equipment
（Can be personal computer, server or the network equipment etc.）Execute the certain of each embodiment of the application or embodiment
Method described in part.
Each embodiment in this specification is described in a progressive manner, identical similar portion between each embodiment
Point just to refer each other, and each embodiment focuses on the differences from other embodiments.Especially for system or
For system embodiment, since it is substantially similar to the method embodiment, so describing fairly simple, related place is referring to method
The part of embodiment illustrates.System and system embodiment described above is only schematical, wherein the conduct
The unit that separating component illustrates may or may not be physically separated, the component shown as unit can be or
Person may not be physical unit, you can be located at a place, or may be distributed over multiple network units.It can root
According to actual need that some or all of module therein is selected to achieve the purpose of the solution of this embodiment.Ordinary skill
Personnel are without creative efforts, you can to understand and implement.
The method in Excel programs is imported into a kind of chart content by CAD program provided herein above,
It is described in detail, specific examples are used herein to illustrate the principle and implementation manner of the present application, the above reality
The explanation for applying example is merely used to help understand the present processes and its core concept；Meanwhile for the general technology of this field
Personnel, according to the thought of the application, there will be changes in the specific implementation manner and application range.In conclusion this theory
Bright book content should not be construed as the limitation to the application.
Claims (10)
1. a kind of chart content by CAD program imported into the method in Excel programs, which is characterized in that including passing through
VISUAL LISP carry out secondary development to CAD program so that CAD program executes following processing：It determines pending in target interface
Targeted content area, the targeted content area be chart content where region；To being shown in the targeted content area
Content be identified acquisition recognition result, the recognition result include the chart include lines, text data with
And the coordinate information at respective place；According to the recognition result, cell, each unit lattice included by the chart content are determined
Relative position relation between interior text data and each unit lattice, and can be known by Excel programs according to above- mentioned information generation
Other logical structure data；Start the Excel programs, and the logical structure data imported into the Excel programs,
So that the Excel programs create corresponding list data according to the logical structure data.
2. the chart content according to claim 1 by CAD program imported into the method in Excel programs, feature
It is, pending targeted content area in the determining target interface, the targeted content area is where chart content
Region；Including：The coordinate information for obtaining two points in the target interface that user selectes, when by described two points as diagonal 2
The rectangular area being enclosed is as targeted content area.
3. the chart content according to claim 1 by CAD program imported into the method in Excel programs, feature
It is, the coordinate information where the text data is ranked up and is combined determining institute with the coordinate information where the lines
State the cell included by chart content, the text data in each unit lattice and the relative position relation between each unit lattice.
4. the chart content according to claim 1 by CAD program imported into the method in Excel programs, feature
It is, the Excel programs is started by the Active X functions in VISUAL LISP.
5. the chart content according to claim 1 by CAD program imported into the method in Excel programs, feature
Be, by the logical structure data carry out full line and or permutation batch change after imported into the Excel programs.
6. the chart content according to claim 5 by CAD program imported into the method in Excel programs, feature
It is, the batch change includes to certain column data automatically divide arranging, a number being multiplied by automatically to certain row, seeking certain row
Any one or the combination of several of them in.
7. the chart content according to claim 1 by CAD program imported into the method in Excel programs, feature
It is, when in the logical structure data comprising multigroup different logical structure data, starts the Excel programs, and by institute
It states multigroup different logical structure data to imported into order in the Excel programs, so that the Excel programs are according to
Multigroup different logical structure data creates corresponding multigroup different list data, and in multigroup different list data
Between addition distinguish symbol.
8. the chart content according to claim 7 by CAD program imported into the method in Excel programs, feature
It is, the differentiation symbol is blank line.
9. the chart content according to claim 1 by CAD program imported into the method in Excel programs, feature
It is, secondary development is carried out to the Excel programs so that the Excel programs executes following processing：
The list data of establishment is ranked up, Classifying Sum according to scheduled format, and generates target inventory.
10. the chart content according to claim 9 by CAD program imported into the method in Excel programs, special
Sign is, secondary development is carried out to the Excel programs by C# programs or Visual Basic programs.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810482852.7A CN108763382A (en) | 2018-05-18 | 2018-05-18 | A method of the chart content in CAD program is imported into Excel programs |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810482852.7A CN108763382A (en) | 2018-05-18 | 2018-05-18 | A method of the chart content in CAD program is imported into Excel programs |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108763382A true CN108763382A (en) | 2018-11-06 |
Family
ID=64008417
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810482852.7A Pending CN108763382A (en) | 2018-05-18 | 2018-05-18 | A method of the chart content in CAD program is imported into Excel programs |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108763382A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109933765A (en) * | 2019-03-12 | 2019-06-25 | 中冶焦耐(大连)工程技术有限公司 | A method of Excel table content is extracted to CAD table |
| CN111985195A (en) * | 2020-08-18 | 2020-11-24 | 上海外高桥造船有限公司 | Text-based AUTOCAD table data reading method |
| CN112307725A (en) * | 2020-10-30 | 2021-02-02 | 天津光电通信技术有限公司 | Method for adding table information on two-dimensional drawing interface |
| CN112329407A (en) * | 2019-08-05 | 2021-02-05 | 珠海金山办公软件有限公司 | Method and device for adding data in table and electronic equipment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002230052A (en) * | 2001-01-29 | 2002-08-16 | Sanei Plot:Kk | Method for preparing cad data file and method for distributing the same |
| CN102830979A (en) * | 2012-08-30 | 2012-12-19 | 江苏省交通科学研究院股份有限公司 | CAD (computer-aided design) drawing information batch processing method based on ObjectArx |
| CN105159685A (en) * | 2015-09-28 | 2015-12-16 | 武汉中冶易新科技有限公司 | Method for extracting detail content of computer aided design (CAD) drawing to Excel form |
| CN105912516A (en) * | 2016-04-01 | 2016-08-31 | 南京朗坤软件有限公司 | Method for one-lick extraction of table data from AutoCAD file |
| CN106599324A (en) * | 2017-01-20 | 2017-04-26 | 深圳市晋铭航空技术有限公司 | Method for capturing CAD data |
-
2018
- 2018-05-18 CN CN201810482852.7A patent/CN108763382A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP2002230052A (en) * | 2001-01-29 | 2002-08-16 | Sanei Plot:Kk | Method for preparing cad data file and method for distributing the same |
| CN102830979A (en) * | 2012-08-30 | 2012-12-19 | 江苏省交通科学研究院股份有限公司 | CAD (computer-aided design) drawing information batch processing method based on ObjectArx |
| CN105159685A (en) * | 2015-09-28 | 2015-12-16 | 武汉中冶易新科技有限公司 | Method for extracting detail content of computer aided design (CAD) drawing to Excel form |
| CN105912516A (en) * | 2016-04-01 | 2016-08-31 | 南京朗坤软件有限公司 | Method for one-lick extraction of table data from AutoCAD file |
| CN106599324A (en) * | 2017-01-20 | 2017-04-26 | 深圳市晋铭航空技术有限公司 | Method for capturing CAD data |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109933765A (en) * | 2019-03-12 | 2019-06-25 | 中冶焦耐(大连)工程技术有限公司 | A method of Excel table content is extracted to CAD table |
| CN109933765B (en) * | 2019-03-12 | 2023-05-23 | 中冶焦耐(大连)工程技术有限公司 | Method for extracting Excel table content to CAD table |
| CN112329407A (en) * | 2019-08-05 | 2021-02-05 | 珠海金山办公软件有限公司 | Method and device for adding data in table and electronic equipment |
| CN111985195A (en) * | 2020-08-18 | 2020-11-24 | 上海外高桥造船有限公司 | Text-based AUTOCAD table data reading method |
| CN112307725A (en) * | 2020-10-30 | 2021-02-02 | 天津光电通信技术有限公司 | Method for adding table information on two-dimensional drawing interface |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108763382A (en) | A method of the chart content in CAD program is imported into Excel programs | |
| Liyanage | Breeding innovation clusters through collaborative research networks | |
| Baicun et al. | Human-centered intelligent manufacturing: overview and perspectives | |
| CN101794270B (en) | Selection method and system of a redundant controller based on resource view | |
| Williams et al. | PERA and GERAM—enterprise reference architectures in enterprise integration | |
| Lee et al. | UAS mission path planning system (MPPS) using hybrid-game coupled to multi-objective optimizer | |
| Kang et al. | Energy management method of hybrid AC/DC microgrid using artificial neural network | |
| Yoon et al. | Utilization of energy storage system for frequency regulation in large-scale transmission system | |
| Ishraque et al. | Optimal sizing and assessment of a renewable rich standalone hybrid microgrid considering conventional dispatch methodologies | |
| Wiendahl et al. | Agent-based control of self-organized production systems | |
| CN108009012A (en) | A kind of multiple agent dynamic task allocation method of task based access control model | |
| Zhang et al. | Solving the spatial scheduling problem: a two-stage approach | |
| Mahdavi et al. | Reconfiguration of distribution networks with simultaneous allocation of distributed generation using the whale optimization algorithm | |
| Kim et al. | Hybrid AC/DC Microgrid Energy Management Strategy Based on Two-Step ANN | |
| Wang et al. | Multi-UAV unbalanced targets coordinated dynamic task allocation in phases | |
| Inaba et al. | Robotics Research: The 16th International Symposium ISRR | |
| Phatak et al. | Simulation based optimization using PSO in manufacturing flow problems: a case study | |
| CN110045959A (en) | A kind of page layout method and device | |
| CN110011971A (en) | A kind of manual configuration method of network security policy | |
| McNeese et al. | Using the living laboratory framework as a basis for understanding next-generation analyst work | |
| Shah et al. | New modeling and performance evaluation of tool sharing control in FMS using colored Petri nets | |
| Quaddus et al. | IMOLP: an interactive method for multiple objective linear programs | |
| Chen et al. | Block workshop spatial scheduling based on cellular automata modelling and optimization | |
| Hamdan et al. | A two-stage decomposition approach for the traveling salesman problem | |
| Skuza et al. | Power System Division—Certain Issues Associated with Shaping Commutation Strategies in Power Substations |
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 |
Application publication date: 20181106 |
|
| RJ01 | Rejection of invention patent application after publication |