Export coordinate from DWG to Excel

Export coordinate from DWG to Excel

Anonymous
Not applicable
3,473 Views
10 Replies
Message 1 of 11

Export coordinate from DWG to Excel

Anonymous
Not applicable

Hey guys. Is it somehow possible to export dwg coordinate into excel file?

Thanks in advance.

 

 

0 Likes
Accepted solutions (1)
3,474 Views
10 Replies
Replies (10)
Message 2 of 11

Patchy
Mentor
Mentor

Have you tried DATAEXTRACTION command?

data.JPG

 

0 Likes
Message 3 of 11

Anonymous
Not applicable

Thank you Very Much what About the lenghts?

0 Likes
Message 4 of 11

Anonymous
Not applicable

Is it possible to combine the information for name, length and coordinate so I can export them out together?

 

For instance Vx.21 has length 2236 and coordinates x=35 and y=5975

 

 

0 Likes
Message 5 of 11

Patchy
Mentor
Mentor

what About the lenghts?

Try the command yet?
length.JPG

 
0 Likes
Message 6 of 11

Anonymous
Not applicable

Thanks i have tried it but now i have another problem :(.

 

How can i make a system the coordinates, length and name work together?

 

for instance i want a table that says:

 

x=6248 y=9174 L=1128 and name vx.1 

x=11288 y=9174 L=1068 and name Vx.2 

etc...

etc..

 

Is that possible and if it is can you show it in a video? Gratitude.

 

 

Udklip1.PNG

Udklip2.PNG

  

0 Likes
Message 7 of 11

Patchy
Mentor
Mentor

Use FIELD for length, then Dataextraction can show both.

Coord-length.JPG

0 Likes
Message 8 of 11

Anonymous
Not applicable

Can you show it in a video? I dont really understasnd.

0 Likes
Message 9 of 11

Patchy
Mentor
Mentor
Accepted solution

Use FIELD and label Length on the lines and edit the text with your segment name.

then use Dataextraction to get the names.

Here is an example:

Add Field Length.JPG

Extraction settings.JPG

Result.JPG

Message 10 of 11

Anonymous
Not applicable

i dont understsnd can you please take my dwg and show it in a video from scratch

0 Likes
Message 11 of 11

TerryDotson
Mentor
Mentor

Preparing videos takes a lot of time and remember that all the help you get here are FREE.  It looks like you've been given some good starting information.  Actually trying it and reading about the topics discussed should get you farther along.