Anuncios

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

When click point and transfer it to Excel.

Anonymous

When click point and transfer it to Excel.

Anonymous
No aplicable

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?.

0 Me gusta
Responder
Soluciones aceptadas (1)
1.211 Vistas
4 Respuestas
Respuestas (4)

Patchy
Mentor
Mentor
Solución aceptada

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

 

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

 

points.JPG

0 Me gusta

john.vellek
Alumni
Alumni

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
Mentor
Mentor

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
0 Me gusta

Anonymous
No aplicable

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.

0 Me gusta