CN109933765A - A method of Excel table content is extracted to CAD table - Google Patents
A method of Excel table content is extracted to CAD table Download PDFInfo
- Publication number
- CN109933765A CN109933765A CN201910186498.8A CN201910186498A CN109933765A CN 109933765 A CN109933765 A CN 109933765A CN 201910186498 A CN201910186498 A CN 201910186498A CN 109933765 A CN109933765 A CN 109933765A
- Authority
- CN
- China
- Prior art keywords
- cad
- excel
- data
- program
- content
- 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.)
- Granted
Links
Landscapes
- Stored Programmes (AREA)
Abstract
The present invention relates to a kind of methods of extraction Excel table content to CAD table, this method carries out secondary development to CAD program including the use of Visual LISP module, so that CAD program executes following processing: judgement needs to read the Excel list data of data and the correctness of format, the Excel cell for having data read in batches and certain operations are processed, procedure result is written in the table of CAD template file by particular text format, preferred coordinates.A kind of method for extracting Excel table content to CAD table provided by the invention is simple and fast to the Secondary of CAD program, CAD program by secondary development carries out quick operation processing to Excel table data, it is disposable to form one or more table of required CAD, improve work efficiency the accuracy with table.
Description
Technical field
The present invention relates to AutoCAD secondary development field more particularly to a kind of extraction Excel table contents to CAD table
Method.
Background technique
AutoCAD (Autodesk Computer Aided Design) is Autodesk (Ou Teke) company in nineteen eighty-two
The computer-assisted mapping software of exploitation, for X-Y scheme drafting, in detail drafting, design documentation and basic three dimensional design,
As drawing tool popular in the world.AutoCAD has good user interface, passes through interactive menu or command mode
It can carry out various operations.
In engineering, due to the diversity of drawing, it is often necessary to which the content in Excel table is copied to AutoCAD table
In, it therefore how efficiently, is accurately extracted with the mode not only low efficiency, but also error-prone of manual replicate data
Data in Excel table seem particularly important into CAD diagram paper.
In consideration of it, this patent provides a kind of method for extracting Excel table content to CAD table, to solve the above problems.
Summary of the invention
The purpose of the invention is to overcome prior art defect, and provide a kind of selectable from Excel table content
It extracts to the method for CAD table.It is simple and fast to the Secondary of CAD program, by the CAD program pair of secondary development
Excel table data carry out quick operation processing, disposable to form one or more table of required CAD, improve work
The accuracy of efficiency and table.
In order to achieve the above object, the present invention is implemented with the following technical solutions:
A method of it selectively extracts from Excel table content to CAD table, this method utilizes Visual LISP
Module carries out secondary development to CAD program, so that CAD program executes following processing: judgement needs to read the Excel table of data
The correctness of data and format carries out batch to the Excel cell for having data and reads simultaneously certain operations processing, by program knot
Fruit is written in the table of CAD template file by particular text format, preferred coordinates.
A method of selectively extract from Excel table content to CAD table, precondition be CAD software
Visual LISP module is installed, this method comprises the concrete steps that:
1) preparation needs to extract the Excel file of data, it is characterised in that Excel gauge outfit items content is fixed, cell
Content and format are in order requirement；
2) target table template is drawn out in CAD program, the lower-left point of table is defined as coordinate (0,0), by template text
Part is named as " extracting Excel content .dwg "；
3) CAD software is opened, program is write in Visual LISP editing machine, is inserted into forms, the function of forms process is
It shows forms, and inputs data and information appropriate in forms；Program again to Excel table read after data and forms in
Data and information carry out automatic operation processing.After the completion of program, compiles and save as * .vlx, be then copied into CAD journey
Under the support path of sequence；
4) order button " extracting Excel table " is added in CAD software, and the program in step 3) is directed toward in the order
Process；
5) button " extract Excel table ", Eject step 3 are clicked in CAD window) in forms, inputted in forms suitable
When data and information, program will read the data after Excel automatically and information carries out the automatic operation processing in backstage, and presses program
The coordinate points of setting form required table in CAD.
The method as described above for extracting Excel table content to CAD table, which is characterized in that read Excel table
Particular cell carries out operation processing to data in a desired fashion through program, and writes the result into the specific bit of CAD table
It sets.
The beneficial effects of the present invention are:
Due to the adoption of the above technical scheme, the method that the present invention extracts Excel table content to CAD table has actively effect
Fruit, manually extracting mode, program read Excel table content automatically for comparison, it is disposable formed required for CAD mono- or
Multiple tables improve work efficiency the accuracy with table.
Detailed description of the invention
Fig. 1 is a kind of method flow diagram for extracting Excel table content to CAD table of the present invention；
Fig. 2 is a kind of function and data extracted Excel table content and be inserted into forms into the method for CAD table of the present invention
Exemplary diagram.
Specific embodiment
With reference to the attached drawing in the embodiment of the present invention, the technical solution in the method for the present invention is carried out clear, complete
Description, it is clear that described method is only a part of technical solution of the present invention, rather than whole technical solutions.It is any ripe
Know those skilled in the art in the technical scope disclosed by the present invention, according to the technique and scheme of the present invention and its invention structure
Think of is subject to equivalent substitution or change, should be covered by the protection scope of the present invention.
As shown in Figure 1, the present invention extracts Excel table content to the method for CAD table, Visual LISP is being installed
Under the premise of module, this method is comprised the concrete steps that:
1) preparation needs to extract the Excel file of data, it is characterised in that Excel gauge outfit items content is fixed, cell
Content and format are in order requirement；
2) target table template is drawn out in CAD program, the lower-left point of table is defined as coordinate (0,0), by template text
Part is named as " extracting Excel content .dwg ", for same type drawing, without creating this template file every time；
3) CAD software is opened, program is write in Visual LISP editing machine, program is inserted into forms, as shown in Fig. 2, window
The function of body process is display forms, and data and information appropriate are inputted in forms；After program again reads Excel table
Data and information in data and forms carry out automatic operation processing.And by step 2) CAD template file in table into
Preferred coordinates are written in Excel original data and the result after processing operation by row coordinate setting；After the completion of program, compiling is simultaneously
* .vlx (such as: acre.vlx, acre are user's self-setting) is saved as, the support path of CAD program is then copied into
Under；
4) order button " extracting Excel table " is added in CAD software, and the program in step 3) is directed toward in the order
Process；After order button creates, it may be reused later；
5) button " extract Excel table ", Eject step 3 are clicked in CAD window) in forms, inputted in forms suitable
When data and information, program will read the data after Excel automatically and information carries out the automatic operation processing in backstage, if
The content and format of Excel table do not meet program requirement, pop-up program explanation of error, and return step 1) modification Excel table
Lattice；If the content and format of Excel table are correct, program is automatically by Excel original data and the result after processing operation
Write step 2) in create CAD template file in preferred coordinates, in CAD formed required for table.
Claims (3)
1. a kind of extraction Excel table content is to the method for CAD table, precondition is that CAD software has been installed
VisualLISP module, which is characterized in that this method comprises the concrete steps that:
1) preparation needs to extract the Excel file of data, and Excel gauge outfit items content is fixed, and cell content and format meet
Program requirement；
2) target table template is drawn out in CAD program, the lower-left point of table is defined as coordinate (0,0), table is named as
" extracting Excel content .dwg "；
3) CAD software is opened, program is write in Visual LISP editing machine, is inserted into forms, the function of forms process is display
Forms, and data and information needed for input user in forms；Then program will be to the data and window after the reading of Excel table
Data and information in body carry out automatic operation；After the completion of program, compiles and save as * .vlx, be then copied into CAD journey
Under the support path of sequence；
4) order button " extracting Excel table " is added in CAD software, and the program mistake in step 3) is directed toward in the order
Journey；
5) button " extract Excel table ", Eject step 3 are clicked in CAD window) in forms, inputted in forms appropriate
Data and information, program press the seat of program setting automatically by the data and information progress backstage operation processing after reading Excel
Punctuate forms required table in CAD.
2. a kind of method for extracting Excel table content to CAD table according to claim 1, which is characterized in that according to
Requirement of engineering writes program and carries out data operation to Excel table each unit lattice, and it is specific to carry out write-in CAD template file to data
In coordinate, and carry out that font style, word are high, word is wide, alignment thereof is arranged to text.
3. a kind of method for extracting Excel table content to CAD table according to claim 1, which is characterized in that right
Batch is carried out in the cell that Excel has data and reads simultaneously certain operations processing, if the interior perhaps data lattice of certain cell
Formula is not by program requirement, and program provides error message, so as to redjustment and modification.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910186498.8A CN109933765B (en) | 2019-03-12 | 2019-03-12 | Method for extracting Excel table content to CAD table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910186498.8A CN109933765B (en) | 2019-03-12 | 2019-03-12 | Method for extracting Excel table content to CAD table |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109933765A true CN109933765A (en) | 2019-06-25 |
| CN109933765B CN109933765B (en) | 2023-05-23 |
Family
ID=66986902
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910186498.8A Active CN109933765B (en) | 2019-03-12 | 2019-03-12 | Method for extracting Excel table content to CAD table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109933765B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110569626A (en) * | 2019-10-28 | 2019-12-13 | 云南瀚哲科技有限公司 | CAD house type graph batch plotting method based on data sheet |
| CN111796868A (en) * | 2020-07-07 | 2020-10-20 | 无锡中粮工程科技有限公司 | Method for realizing interaction between CAD (computer-aided design) enhanced attribute block and Excel data |
| CN111813849A (en) * | 2020-09-14 | 2020-10-23 | 杭州数梦工场科技有限公司 | Data extraction method, device and equipment and storage medium |
| CN112307725A (en) * | 2020-10-30 | 2021-02-02 | 天津光电通信技术有限公司 | Method for adding table information on two-dimensional drawing interface |
| CN115329730A (en) * | 2022-07-11 | 2022-11-11 | 中国建筑西南设计研究院有限公司 | Spreadsheet operation management method suitable for graphic platform |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101404041A (en) * | 2008-09-24 | 2009-04-08 | 上海纳杰电气成套有限公司 | System diagram generation system |
| US20090282324A1 (en) * | 2006-10-04 | 2009-11-12 | Dilip Patel | Method and system for automatically generating template based excel pivots from web analytics |
| 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 |
| CN108763382A (en) * | 2018-05-18 | 2018-11-06 | 中铁山桥集团有限公司 | A method of the chart content in CAD program is imported into Excel programs |
-
2019
- 2019-03-12 CN CN201910186498.8A patent/CN109933765B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090282324A1 (en) * | 2006-10-04 | 2009-11-12 | Dilip Patel | Method and system for automatically generating template based excel pivots from web analytics |
| CN101404041A (en) * | 2008-09-24 | 2009-04-08 | 上海纳杰电气成套有限公司 | System diagram generation system |
| 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 |
| CN108763382A (en) * | 2018-05-18 | 2018-11-06 | 中铁山桥集团有限公司 | A method of the chart content in CAD program is imported into Excel programs |
Non-Patent Citations (3)
| Title |
|---|
| 冯若谦等: "Excel表格到AutoCAD表格的转换", 《宁夏工程技术》 * |
| 胡建平: "AutoCAD二次开发在土工试验中的应用", 《水运工程》 * |
| 马晓明等: "基于AutoLISP的AutoCAD与Excel数据交换的二次开发程序设计", 《现代制造技术与装备》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110569626A (en) * | 2019-10-28 | 2019-12-13 | 云南瀚哲科技有限公司 | CAD house type graph batch plotting method based on data sheet |
| CN110569626B (en) * | 2019-10-28 | 2023-04-07 | 云南瀚哲科技有限公司 | CAD house type graph batch plotting method based on data sheet |
| CN111796868A (en) * | 2020-07-07 | 2020-10-20 | 无锡中粮工程科技有限公司 | Method for realizing interaction between CAD (computer-aided design) enhanced attribute block and Excel data |
| CN111796868B (en) * | 2020-07-07 | 2023-10-27 | 无锡中粮工程科技有限公司 | Method for realizing interaction of CAD enhanced attribute block and Excel data |
| CN111813849A (en) * | 2020-09-14 | 2020-10-23 | 杭州数梦工场科技有限公司 | Data extraction method, device and equipment and storage medium |
| CN112307725A (en) * | 2020-10-30 | 2021-02-02 | 天津光电通信技术有限公司 | Method for adding table information on two-dimensional drawing interface |
| CN115329730A (en) * | 2022-07-11 | 2022-11-11 | 中国建筑西南设计研究院有限公司 | Spreadsheet operation management method suitable for graphic platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109933765B (en) | 2023-05-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109933765A (en) | A method of Excel table content is extracted to CAD table | |
| US4635208A (en) | Computer-aided design of systems | |
| EP3451206B1 (en) | Method, apparatus, and device for generating a visual model layout of a space | |
| CN101763067A (en) | Quick generation method of numerical control machining scheme of complex parts of airplane | |
| CN101196963B (en) | Indexing system and method of generic chemical structure | |
| JPH0785137A (en) | Generating device for cad library model | |
| CN101211166A (en) | Simulation data creation supporting device | |
| CN109145359B (en) | Steel structure material preparation method based on BIM system and CAD software | |
| WO2021135091A1 (en) | Deep learning-based target advertorial generating method and apparatus | |
| CN105573972A (en) | Report check formula generation method and apparatus | |
| CN104408267A (en) | Finite element modeling method for special-shaped spatial structure | |
| CN109634215B (en) | Nuclear power plant operation procedure design method based on planar graph coding technology | |
| CN109656151A (en) | Shield machine intelligence tool changing analogue system and implementation method based on UNITY | |
| CN114090611A (en) | Method and device for generating cable inventory by terminal wiring table and electronic equipment | |
| CN112269355B (en) | Graphical interactive auxiliary numerical control programming method and software system | |
| CN107240150A (en) | A kind of three-dimensional tube numeral dissolves drawing method | |
| CN106844883A (en) | It is a kind of that the method that interface is tested automatically is carried out by script | |
| CN109582304A (en) | A kind of UI control generation method and device based on man-machine interactive system | |
| CN106599499A (en) | Method for automatically generating XilinxFPGA constraint file | |
| CN111985255A (en) | Translation method, translation device, electronic device and storage medium | |
| JPH08263130A (en) | Simulation system | |
| CN107908821A (en) | Structural strain energy entropy characterization calculates and result treatment system | |
| CN117708911A (en) | Building axis network coordinate rapid labeling method based on CAD | |
| Yang et al. | Design and implementation of virtual experiment on character encoding | |
| CN108984166A (en) | A kind of quick tool System for interactive software |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |