Community
Civil 3D Forum
Welcome to Autodesk’s Civil 3D Forums. Share your knowledge, ask questions, and explore popular AutoCAD Civil 3D topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Get data from AC3D (tables) to Excel // Get tables of Cant Tabular Editor

4 REPLIES 4
SOLVED
Reply
Message 1 of 5
ascensojimer
687 Views, 4 Replies

Get data from AC3D (tables) to Excel // Get tables of Cant Tabular Editor

Good evening,

 

I want to export data from AC3D to Excel; I've tried to do it with copying directly the tables I made, but it isn't text or number format.

For example, I want to get the data from this table:

 

Tabla1.jpg

Do you know about some macros or procedures that can help me?

I know that with previous versions of autocad it could be done.

 

In addition, I also want to get value table of the calculated cant of the "Cant Tabular Editor":


Tabla2.jpg

 

How can I get a table of this data? I need it because I have a lot of curves and I want to do some verifications of the standars of my country.

 

Any help would be highly valued

Thank you in advance,

 

 

4 REPLIES 4
Message 2 of 5
Jay_B
in reply to: ascensojimer

For the "Cant Tabular Editor".

 

Right click on the Cant Tabular Editor as shown in caption (anywhere one cell/line is fine)_copy to clipboard_open excel_paste.

 

C3D 2018.1
C3D 2016 SP4

Win 7 Professional 64 Bit
Message 3 of 5
troma
in reply to: ascensojimer

For the C3D table, I think I've seen discussions on this before.  If I remember rightly, the only solution was to explode to lines & text, then use a lisp to export it as a .csv.  Not very pretty, I know.


Mark Green

Working on Civil 3D in Canada

Message 4 of 5
MikeEvansUK
in reply to: ascensojimer

Or create the table to form a CSV file format.

 

So..

Easting,Northing,Elevation,Definition,Values,Values,Values;;

 

Use the ;; at the line end to indentify it later.

 

Explode to text then use TxT2Mtxt command and select the text objects.

Edit add hard returns where ;; are, copy and paste to notepad and save as a csv file. Open and edit in excel.

 

Lot of work but does work.

 

Mike Evans

Civil3D 2022 English
Windows 7 Professional 64-bit
Intel(R) Core(TM) i7-3820 CPU @ 3.60GHz (8 CPUs), ~4.0GHz With 32768MB RAM, AMD FirePro V4900, Dedicated Memory: 984 MB, Shared Memory: 814 MB

Message 5 of 5
ascensojimer
in reply to: Jay_B

Thank you very much!! I hadn't expected that it would be so easy!

With the table I can do the same as the cant tabular editor (because there already exist a table editor as well as cant editor).

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Rail Community


Autodesk Design & Make Report