How to extract polyline coordinates from CAD and enter Excel and its processing

For the majority of colleagues doing measurement work, it is a common method to extract polyline coordinates from CAD drawings. At the same time, it is also a more accurate approach. Here I will put forward my own point of view on how to extract the polyline coordinates from the CAD drawing and do the corresponding data processing. Xiaobian recommended "AutoCAD 2016 (with registered machine) official simplified Chinese version download" method /step first step: open CAD. Enter "Li" on the CAD command line. ” Select the object “, click on the polyline to extract the coordinates. Enter. Step 2: Copy the data in the CAD text box to Excel. Check the valid data in the text box & rdquo; Ctrl + C & ldquo;, in the open Excel & quoquo; Ctrl + V & ldquo;. Step 3: Replace the unnecessary text and spaces with the Excel” Check the cell where the text is located. Click ”Start“On the right side of "Replace" (or "Edit “——”Replace“). Select all parts before the first grid X coordinate. Copy and paste into ” find content “. “ Replace with ” nothing to fill. Click “ Replace All (A)”. I found that the format was a bit awkward at this time. So there are a few more steps to do this, deleting the extra spaces in the formatted text like the second line. The fourth step: data breakdown. Check the column where the text is located. Select “data”——“column”———“next”——check “comma”——“next”&mdash ;—“Complete”. Step 5: Exchange x, y coordinates. Step 6: Format adjustment. “ Ctrl +1 & rdquo; or right click to select “ set the cell format & rdquo;, adjust the format in the note. Be sure to pay attention to replace the space when replacing. The above is how to extract the polyline coordinates from CAD and input Excel and its processing methods, I hope to help everyone! This article comes from [System Home] www.xp85.com