Make AutoCAD table from lines and text

[neilyj666]

I have a Civil 3D AECC table that I want to use in Excel but these entities can't be copied and pasted. I have exploded it a few time to get simple lines and text and want to convert these into an AutoCAD table for export to Excel.

I have searched forums and have found a few lisp routines (e.g. maketable.lsp at http://cadtips.cadalyst.com/content/alspsol0308-convert-old-table-new-table-format) but they don't work - has anyone got a lisp routine that will work for this??

Thanks

[Jeff_M · Accepted solution]

I have not tried it, but this has been recently posted and modified:

http://www.theswamp.org/index.php?topic=35884.0

You will need to be a member of the Swamp (free registration) to view/download.

[neilyj666]

Thanks for the link Jeff - I have just downloaded the lisp, run it and it works fine

A bit bizarre that the functionality (i.e. export AECC table to csv) isn't built into C3D - one for the wish list...!!!

[markus.logdal]

Since im a total beginner when it comes to handling .lsp files, can you guide me in how to use this .lsp?

Thanks in advance

// Markus

[neilyj666]

Download the lsp routine, unzip to a suitable folder (mine is in C:\AutoLISP)

Type APPLOAD at command line

Browse to lisp routine and LOAD, then close dialog

Type COT to run and follow prompts

[Anonymous]

hi,

that theswamp site does not allow registration, it says 'Sorry, registration is currently disabled.'

Could you pleease share their lisp with us here.

Thanks in advance

[olsonwinston]

Attached is the most recent version of the file. Hope this helps.

[najowa]

This lisp doesn't work for me neither does another one I have.

Does anyone have any others?

[neilyj666]

WBLOCK the text and lines you are using to a new dwg and post it

[najowa]

http://cadtips.cadalyst.com/content/alspsol0308-convert-old-table-new-table-format

I was using this one and it stopped working on this table

[neilyj666]

Original data above and my converted table below

Make sure all polylines are exploded to lines and that there are no duplicate line objects - there is one above the DESCRIPTION.

I then ran COT.lisp, deleted some rows then centred the text

[najowa]

When I explode and delete the line and run COT.lisp it only makes an empty table for me.

[neilyj666]

Can you post both the drawing with the empty table and the lsp to check - won't be able to look until Monday but someone else may be able to give some advice

[neilyj666]

This is the one I use - similar to the v1.6a routine posted above - which worked earlier