topic Re: Make AutoCAD table from lines and text in AutoCAD Forum

Make AutoCAD table from lines and text

neilyj666 — Thu, 27 Jan 2011 08:58:07 GMT

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

Re: Make AutoCAD table from lines and text

Jeff_M — Thu, 27 Jan 2011 15:11:00 GMT

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.

Re: Make AutoCAD table from lines and text

neilyj666 — Thu, 27 Jan 2011 15:26:01 GMT

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

Re: Make AutoCAD table from lines and text

markus.logdal — Fri, 18 Mar 2011 15:08:23 GMT

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

Re: Make AutoCAD table from lines and text

neilyj666 — Fri, 18 Mar 2011 16:03:13 GMT

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

Re: Make AutoCAD table from lines and text

Anonymous — Thu, 29 Nov 2012 10:37:14 GMT

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

Re: Make AutoCAD table from lines and text

olsonwinston — Wed, 05 Jul 2017 13:33:02 GMT

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

Re: Make AutoCAD table from lines and text

najowa — Fri, 16 Nov 2018 14:35:46 GMT

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

Does anyone have any others?

Re: Make AutoCAD table from lines and text

neilyj666 — Fri, 16 Nov 2018 14:38:18 GMT

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

Re: Make AutoCAD table from lines and text

najowa — Fri, 16 Nov 2018 14:50:48 GMT

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

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

Re: Make AutoCAD table from lines and text

neilyj666 — Fri, 16 Nov 2018 15:06:49 GMT

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

Re: Make AutoCAD table from lines and text

najowa — Fri, 16 Nov 2018 17:21:07 GMT

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

Re: Make AutoCAD table from lines and text

neilyj666 — Fri, 16 Nov 2018 20:24:02 GMT

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

Re: Make AutoCAD table from lines and text

neilyj666 — Fri, 16 Nov 2018 20:42:52 GMT

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