How to export coordinates in CAD, how to import coordinates in CAD

There are many programs for exporting coordinates in CAD, and it is necessary to explain clearly which one it is. Search the web AutoCAD Engineering Application Development There are many programs in this network disk that export coordinates.

Some coordinates need to be imported into CAD from the outside, so do you know how to import coordinates in CAD? The following is the method of how to import coordinates in CAD that I have organized, I hope to give you an answer.

How to import coordinates in CAD:

1.Lituan quietly uses Excel to enter the point coordinates.

First, enter the coordinate values in Excel (note to enter absolute coordinates). We put the X coordinate value into column A, the Y coordinate value into column B, and then merge column A and column B into column C, because the two-dimensional coordinate points in CAD are separated by commas, so we enter =A2&" in cell C2, B2, C2 will appear in a pair of coordinate values.

We can copy the formula of c2 by dragging the mouse, and we can get a set of coordinate values. As shown in the figure below:

Secondly, select the coordinate value of the point you want to draw the line, such as the data in column C in the above example, and press Ctrl+C to copy it to the clipboard.

Above. Open CAD on the command line.

Enter the command to draw a line, such as L (straight line), PL (polyline), SPL (spline), and when the press return prompts the first point to locate, paste the copied coordinates into the command line with Ctrl+V to quickly complete the drawing of these points. Then follow the command line prompt to select the closure or right-click to finish drawing the curve.

2.Save the CAD script file, and Excel will save the point coordinates in txt format.

Open the excel file - file - save pin mask as - save type - select "text file (tab.

delimited)" - save - i.e. txt text format.

Suffix the file.

Replace with "*".lsp”

3.Use Notepad for a small LISP program.

Open Notepad, copy the content of excl** and paste it into Notepad, after the copy is completed, you need to replace it again, a good lisp language is as follows:

In particular, it is important to note that all characters and symbols in the LISP language must be entered in English half-width, and there can only be one space between command and "point", and only one space between "point" and "a, b", and no spaces elsewhere.

Save the notepad file, close the file and change its suffix to. lsp。

3.To change the CAD midpoint style, select "Point Style" in the "Format" field to change the point shape.

In order to see these points, you need to select: Point Style in the menu and set a style that can be seen, as shown in the following figure

Note: There are two ways to set the dot size, one is a percentage relative to the screen size, and the other is the absolute size, which form to use and how big it is, depending on whether you want to print these dots or not, the dot display effect is shown in the following figure:

Load Script Drawing: In the Collapse Bucket Rack "Tools", select "Load Application, Run Script"*lsp”

Batch import coordinates into CAD.

Open CAD, find "Load Referencer" in the "Tools" menu, load this file, and a miracle happens, all the dots are drawn automatically. The drawn coordinate points are shown below:

Open Excel** with measurement coordinates and cut the X coordinate to the back of the Y coordinate. Then select the coordinates and copy them. Then create a new text document.

Right-click New Text Document. Open the newly created text document and paste in the coordinates of the previously copied friend. Then select the Copy of the Gaps between the coordinates and click on the Replace function under Options.

Demo model: Huawei MateBook X System version: Win10 APP version: Excel2019&&&CAD2007 1. Open Excel** with measurement coordinates and cut the X coordinates to the back of the Y coordinates.

2. Then copy the selected coordinates.

3. Then create a new text document. Right-click New Text Document.

4. Open the newly created text document and paste the coordinates you copied earlier.

5. Then select the space between the coordinates to copy, and then click the replacement function under the item of Mu Regret.

6. In the replacement window, copy the previously copied spaces and replace them with "Note: This comma must be a comma in the English input state.

7. Finally, close the replacement window, and you can see that all the coordinates are converted into CAD, so that the measurement can be imported into CAD.

CAD coordinates can actually be imported from the outside and can also be used for drawing. So do you know how to import Excel coordinates into CAD? The following is how to import Excel coordinates into CAD by me, I hope to give you an answer.

Excel coordinates are imported into CAD in Figure 1In the latter column, enter =c2&", b2 to get the CAD line coordinates.

Excel coordinates are imported into CAD step 2

Excel coordinates are imported into CAD in Figure 3In the latter column, enter the formula to get the coordinate point and point number of the CAD annotation.

Here is a brief explanation of the first if statement is to determine whether the coordinates are empty, the second half is the cad command, and finally will explain to you why?

Excel coordinates are imported into CAD in Figure 4The drop-down populates all coordinates.

Excel coordinates are imported into CAD in Figure 5Important: Open the CAD and enter the multi-line command "pl".

Excel coordinates are imported into CAD in Figure 6Focus: Switch to Excel, select all the data in the yellow column, Ctrl+C command.

Excel coordinates are imported into CAD in Figure 7Important: Switch to CAD, click on the command line, Ctrl+V paste, and get the coordinate line diagram.

Excel coordinates are imported into CAD in Figure 8Focus: Repeat the above steps to get the coordinate annotation and point number annotation, as shown in the following figure, and you're done.

Excel coordinates are imported into CAD step 9

Excel coordinates are imported into CAD in Figure 10

There is a special exhibition point Cheng Li San's judgment digging Zhaoxuan, which will be changed to see it.

The specific operation steps to export the point coordinates from CAD drawings to Excel** are as follows:

1. First of all, we open the CAD software in the computer, and there is a [Data Extraction] function under the [Tools] option, which can extract a lot of data information, including but not limited to the XYZ coordinates of the extraction point.

2. After executing [Data Extraction], it will ask whether it is a new data extraction file or a previous one, and you can also use a similar template from before.

3. Then let's save the file storage path.

4. Then go ahead and click Next.

5. At this time, all the components in the CAD will be displayed, and I created a new empty file, which only has a few points and a few lines, because if you want to export the point coordinates, only check the points.

6. Then we select [Position X] and Y,Z.

7. Continue to click Next, and the xyz of all points will be listed in the form of **.

8. Proceed to the next step, you can insert the ** into the current CAD file, or you can generate an Excel file and save it.

9. The next step is to set up the ** in the future.

10. Finally, click Finish to export the point coordinates in the CAD drawings to Excel**.

"I don't know if the "Data Extraction" function under the "Tools" menu can meet your needs, you can follow the prompts to try it.

You can use the "Data Extraction" in the tool menu to extract the x, y, and z coordinates of various objects in the graph (of course, you can also extract other attribute values) and output them as xls files. There is no need to copy and paste.

Command: eattext

In the dialog box that pops up, just follow the prompts step by step. You need to extract the coordinates of which class or scum objects, just select which objects you want to extract coordinates. Finally, the output is an XLS file (or an earlier version of CVS) file.

The CVS file extracted in the earlier version is saved as an XLS file after opening in Excel.

1. The premise is that you need to open the coordinates extracted by the spine, and then carry out the following good operations.

2. Then you need to click the first empty cell of the x,y column, and enter =A2& in the top FX formula bar",b2。

3. Now drag the right corner of the C2 cell down to the bottom row, and then perform the operation like a trembling lead.

<>5. Then you need to switch back to Excel, select all cells of the x and y coordinates of column C, copy, switch to import to CAD.