Anuncios

The Autodesk Community Forums has a new look. Read more about what's changed on the Community Announcements board.

Anonymous
1210 Vistas, 4 Respuestas

When click point and transfer it to Excel.

I have been work that i get point of coordinate XYZ value and then transfer it to Excel by using Click2XLS(lisp command).

I click points about 1,000 everyday.

However, i think that the way take a long time to finish work also i often mistake such as missing points, forgetting point number.

Therefrore, is there more fast way that point of coordinate XYZ value to Excel?.

Patchy
en respuesta a: Anonymous

After have all points in the drawing, export them using this:

 

http://www.lee-mac.com/ptmanager.html

 

points.JPG

john.vellek
en respuesta a: Anonymous

Hi @Anonymous, Are the points contained in blocks? If so, you can easily add an attribute field to capture the location and then use a data extraction to get the information into Excel.

 

Let me know if this sounds like it can work for you. I would be happy to provide additional information and resources to you.


John Vellek


Join the Autodesk Customer Council - Interact with developers, provide feedback on current and future software releases, and beta test the latest software!

Autodesk Knowledge Network | Autodesk Account | Product Feedback
Pointdump
en respuesta a: Anonymous

S,

 

I like John's method with data extraction.

 

Dave S

Dave Stoll
Las Vegas, Nevada

EESignature

64GB DDR4 2400MHz ECC SoDIMM / 1TB SSD
NVIDIA Quadro P5000 16GB
Windows 10 Pro 64 / Civil 3D 2024
Anonymous
en respuesta a: Patchy

Im very interested in your answer.

When i use the lisp command(pt manager) that you recommanded, i can get very easliy point of XYZ value at Excel.

However, my worked point is numbered sequentially along line.

The point of coordinate XYZ value randomly sorted at Excel.

All i need is that the numbered point will sorted sequentially at Excel.

Thanks you answer.