Kneeling to the master: How to use excel

王林
Release: 2024-01-12 15:27:22
forward
964 people have browsed it

Kneeling Master: How to export excel CAD data to each other

CAD can realize these two functions, as follows:

Import CAD coordinate data into excel:

Use a polyline in CAD to trace the points you want to output one by one, then select the polyline, enter "li" in the dialog box and press Enter, the coordinates of the points will appear. Copy and paste them in a In notepad, save. Now you open excel, use excel to open the notepad you just saved, select fixed width, adjust the column width, and you are done. Finally, use the edit and replace function in excel to replace the useless x= y=. Enough.

Import the coordinate data in excel into CAD:

First copy the coordinate data in excel to a notepad. The data format in the notepad is:

y,x

y,x

...

For example: 36071283.00,3248453.00

(Note that it is y first, then x because the coordinates in CAD are opposite to the x and y coordinates printed out by GPS)

After adjusting the format, open CAD, first select the polyline function, then copy the data in Notepad to the dialog box in CAD, press Enter, and you will see that CAD draws it according to your coordinates A broken line.

Go and try it!

Kneel down, excel master!

Please format the first and second rows as text (select rows 1 and 2, right-click - "Format Cells" - "Number" - "Text" - "OK" )

Suppose the data is as shown:

Kneeling to the master: How to use excel

Change the formula =IF(A1="","",IF(A2="","",LEFT(A1,(FIND("/",A1)-1)) LEFT(A2,(FIND( "/",A2)-1))&"/"&MID(A1,FIND("/",A1) 1,LEN(A1)) MID(A2,FIND("/",A2) 1,LEN(A2 )))) Copy and paste into the "A3" cell, aim the cursor at the lower right corner, hold down the left button and drag to the right, the effect is as shown below:

Kneeling to the master: How to use excel

If it doesn’t look good, the formula can be simplified to:

=LEFT(H1,(FIND("/",H1)-1)) LEFT(H2,(FIND("/",H2)-1))&"/"&MID(H1,FIND("/ ",H1) 1,LEN(H1)) MID(H2,FIND("/",H2) 1,LEN(H2))

The above is the detailed content of Kneeling to the master: How to use excel. For more information, please follow other related articles on the PHP Chinese website!

source:docexcel.net
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template