Points (by click selection) Coordinates to Excel with Automatic Numbering...

[Yasir.Aman]

Hi,

I am looking for a lisp to export point coordinates to excel. The points are selected by clicking one-by-one. I found a lisp named "Click2Xls" by CADSTUDIO.cz, and it works perfectly except it does not add point numbers (neither to the drawing nor to the excel sheet).

So basically, I need the exact same functionality as "click2xls", but with every click I need to add an incremental point number (both in the drawing and excel sheet). Moreover, it will be great if I have the option to choose the start and increment of the numbering, as well as the ability to UNDO a point without leaving the ongoing command.

Hope I explained myself properly.

Thank you all!

P.S. I have already tried to thoroughly search this forum, as well as, world wide web, but couldn't find something more similar other than the "click2xls". Forgive me if I missed something out there, and kindly point me to it.

[Sea-Haven]

Bedit, change attribute text size, do a attsync on block and hundreds are updated instantly.

[Sea-Haven]

If you bedit the point block changing its attribute text size, bsave, then do a attsync on a point block, hundreds will be changed instantly. Not very hard to do about 30 seconds.

[Yasir.Aman]

While there are various methods to manage multiple blocks at once, not everyone is proficient with AutoCAD to utilize these techniques.

We often have to share files with individuals who possess only basic AutoCAD knowledge. If they need to make adjustments to the blocks, they just explode them, resulting in the loss of data.

I hope this clarifies my concern.

[komondormrex · Accepted solution]

understood. 

this one goes especially for you and draws point entity with every click and at every click. 

[Yasir.Aman]

This is absolutely magic.

I am completely amazed by your level of expertise. You have truly exceeded my expectations.

Thank you so much for dedicating your time and effort.

Really grateful,

/Yasir

[komondormrex]

your welcome)  be advised also that you can change starting number and increment value on the fly before you choose to write down a csv file.