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
neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
Solved! Go to Solution.
Solved by Jeff_M. Go to 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.
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...!!!
neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
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
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
neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
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
Attached is the most recent version of the file. Hope this helps.
This lisp doesn't work for me neither does another one I have.
Does anyone have any others?
neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
http://cadtips.cadalyst.com/content/alspsol0308-convert-old-table-new-table-format
I was using this one and it stopped working on this table
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
neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
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
neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
This is the one I use - similar to the v1.6a routine posted above - which worked earlier
neilyj (No connection with Autodesk other than using the products in the real world)
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.