CN109933765B - A Method of Extracting Excel Table Contents to CAD Table - Google Patents

Abstract

The invention relates to a method for extracting Excel table content to a CAD table, which comprises the following steps of utilizing a Visual LISP module to carry out secondary development on a CAD program, so that the CAD program carries out the following processing: judging the correctness of Excel table data and format of the data to be read, carrying out batch reading and specific operation processing on cells with the data in the Excel, and writing a program result into a table of the CAD template file according to a specific text format and specific coordinates. The method for extracting the Excel table content to the CAD table is simple and quick in a secondary development method of the CAD program, the CAD program subjected to secondary development carries out quick operation processing on Excel table data, one or more tables of the required CAD are formed at one time, and the working efficiency and the accuracy of the tables are improved.

Description

A Method of Extracting Excel Table Contents to CAD Table

technical field

The invention relates to the field of secondary development of AutoCAD, in particular to a method for extracting the content of an Excel form to a CAD form.

Background technique

AutoCAD (Autodesk Computer Aided Design) is a computer-aided drawing software developed by Autodesk (Autodesk) in 1982. It is used for two-dimensional drawing, detailed drawing, design documentation and basic three-dimensional design. It has become widely popular internationally. drawing tools. AutoCAD has a good user interface, and various operations can be performed through interactive menus or commands.

In engineering, due to the diversity of drawings, it is often necessary to copy the contents of the Excel table to the AutoCAD table. Manually copying data is not only inefficient, but also prone to errors. Therefore, how to efficiently and accurately extract the contents of the Excel table Data into CAD drawings is extremely important.

In view of this, this patent provides a method for extracting the content of an Excel table to a CAD table to solve the above problems.

Contents of the invention

The purpose of the present invention is to provide a method for selectively extracting the contents of an Excel table to a CAD table in order to overcome the defects of the prior art. The secondary development method of the CAD program is simple and fast. After the secondary development of the CAD program, the Excel table data is quickly processed and processed, and one or more CAD tables are formed at one time, which improves the work efficiency and the accuracy of the table.

In order to achieve the above object, the present invention adopts the following technical solutions to realize:

A method for selectively extracting the content of an Excel table to a CAD table, the method uses the Visual LISP module to carry out secondary development of the CAD program, so that the CAD program performs the following processing: judging the correctness of the data and format of the Excel table that needs to be read It can batch read the cells with data stored in Excel and perform specific calculation processing, and write the program results into the table of the CAD template file in a specific text format and specific coordinates.

A method for selectively extracting the content of an Excel table to a CAD table, the prerequisite is that the CAD software has installed the Visual LISP module, and the specific steps of the method are:

1) Prepare an Excel file that needs to extract data, which is characterized in that the contents of the Excel header are fixed, and the cell content and format meet the program requirements;

2) Draw the target form template in the CAD program, define the lower left point of the form as coordinates (0, 0), and name the template file "Extract Excel content.dwg";

3) Open the CAD software, write the program in the Visual LISP editor, insert the form, the function of the form process is to display the form, and input appropriate data and information in the form; the program then reads the Excel table The data and the data and information in the form are automatically processed. After the program is completed, compile and save it as *.vlx, and then copy it to the support path of the CAD program;

4) Add a command button "extracting an Excel table" in the CAD software, and point this command to the program process in step 3);

5) Click the button "Extract Excel Table" in the CAD window, and the form in step 3) will pop up, and enter appropriate data and information in the form, and the program will automatically process the data and information after reading Excel in the background, And form the required form in CAD according to the coordinate points set by the program.

The method for extracting the content of the Excel form to the CAD form as described above is characterized in that the specific cells of the Excel form are read, the data is calculated and processed according to the required method through the program, and the result is written into the designated position of the CAD form .

The beneficial effects of the present invention are:

Due to the adoption of the above-mentioned technical scheme, the method for extracting the content of the Excel form to the CAD form in the present invention has a positive effect. Compared with the manual extraction method, the program automatically reads the content of the Excel form, and forms one or more forms of CAD required at one time, which improves the efficiency of the CAD form. Productivity and accuracy of forms.

Description of drawings

Fig. 1 is a kind of flow chart of the method for extracting Excel form content to CAD form of the present invention;

Fig. 2 is a function and data example diagram of inserting a form in a method for extracting the content of an Excel form to a CAD form according to the present invention.

Detailed ways

The following is a clear and complete description of the technical solutions in the method of the present invention in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described method is only a part of the technical solutions of the present invention, not all technical solutions. Anyone familiar with the technical field within the technical scope disclosed in the present invention, according to the technical scheme of the present invention and its inventive concepts to make equivalent replacements or changes shall be covered within the scope of protection of the present invention.

As shown in Figure 1, the present invention extracts the method for Excel form content to CAD form, under the premise that Visual LISP module has been installed, the concrete steps of this method are:

1) Prepare an Excel file that needs to extract data, which is characterized in that the contents of the Excel header are fixed, and the cell content and format meet the program requirements;

2) Draw the target table template in the CAD program, define the lower left point of the table as coordinates (0, 0), and name the template file "Extract Excel content.dwg". For the same type of drawings, it is not necessary to create this template file every time ;

3) Open the CAD software, write the program in the Visual LISP editor, and the program is inserted into the form, as shown in Figure 2, the function of the form process is to display the form, and input appropriate data and information in the form; Perform automatic calculation and processing on the data read from the Excel table and the data and information in the form. And perform coordinate positioning according to the table in the CAD template file in step 2), and write the Excel original data and the result after processing operation into specific coordinates; after the program is completed, compile and save it as *.vlx (for example: acre.vlx, acre is set by the user), and then copied to the support path of the CAD program;

4) Add a command button "extract Excel table" in the CAD software, and point the command to the program process in step 3); after the command button is created, it can be reused later;

5) Click the button "Extract Excel Table" in the CAD window, and the form in step 3) will pop up, and enter appropriate data and information in the form, and the program will automatically process the data and information after reading Excel in the background, If the content and format of the Excel table do not meet the program requirements, a program error description will pop up, and return to step 1) to modify the Excel table; if the content and format of the Excel table are correct, the program will automatically write the original data of Excel and the result after processing and calculation The specific coordinates in the CAD template file created in step 2) form the required table in CAD.

Claims (2)

1. A method for extracting Excel form content to CAD form, provided that CAD software has installed Visual LISP module, characterized by that, the specific steps of the method are:

1) Preparing an Excel file of which the data needs to be extracted, wherein each item of content of an Excel table head is fixed, and the content and format of cells meet the program requirements;

2) Drawing a target table template in a CAD program, defining the lower left point of the table as coordinates (0, 0), and naming the table as 'extract Excel content. Dwg';

3) Opening CAD software, writing a program in a visual LISP editor, inserting a window, displaying the window in the window process, and inputting data and information required by a user in the window; then the program automatically calculates the data read by the Excel table and the data and information in the window; after the program is completed, compiling and storing the program as vlx, and copying the program to a support path of the CAD program;

4) Adding a command button "extract Excel form" in the CAD software and directing the command to the program process in step 3);

5) Clicking a button in a CAD window to extract an Excel form, popping up the window in the step 3), inputting proper data and information in the window, automatically carrying out background operation processing on the data and information after Excel reading by a program, and forming a required form in the CAD according to coordinate points set by the program;

according to engineering requirements, a programming program carries out data operation on each cell of an Excel table, writes the data into specific coordinates of a CAD template file, and sets font style, word height, word width and alignment modes on the words.

2. The method of claim 1, wherein the cells of the Excel in which the data is stored are read in batch and processed by specific operations, and if the content or data format of a cell is not required by the program, the program gives error information to adjust the modification.

Images