AutoCAD Civil 3D General Discussion

AutoCAD Civil 3D General Discussion

Reply
Distinguished Contributor
pocketmerlin
Posts: 112
Registered: ‎08-24-2013
Message 1 of 4 (321 Views)

How to copy a Point Table from Excel?

321 Views, 3 Replies
10-22-2013 03:32 PM

This seems like it should be the most stupidly easy thing...but AutoCAD doesn't seem to have a way to do this.

 

I made a point table from a point group. Quick and sweet.

 

But now I want to change it a little bit, and it's not something I can just do from the table style. So I want to copy it into Excel...and when I try to, hitting paste in Excel ends up just giving me this block image version of the table in Excel. I tried doing TABLEEXPORT but that's only for regular tables.

 

Any help here? Thanks!

*Expert Elite*
mikeevans
Posts: 764
Registered: ‎09-29-2008
Message 2 of 4 (293 Views)

Re: How to copy a Point Table from Excel?

10-23-2013 01:29 AM in reply to: pocketmerlin
This can not be done in this way. Civil tables are not the same as excel tables or autocad tables so the data cannot be passed in this way.

You can export the points and achieve the same thing so long as you select the right columns. After export open in excel and edit away but this will be detached from the points in the file.
Mike Evans

Civil3D 2013 / 2014 British UK
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

*Expert Elite*
Joe-Bouza
Posts: 4,884
Registered: ‎12-15-2008
Message 3 of 4 (274 Views)

Re: How to copy a Point Table from Excel?

10-23-2013 04:50 AM in reply to: pocketmerlin
I concur with Mike

export the point group from the points menu, edit save a csv, reimport and the civil table will import
Thank you

Joseph D. Bouza, P.E. (one of 'THOSE' People) Civil 3D 2012 & 2013
HP Z210 Workstation
Intel Xeon CPU E31240 @ 3.30 Hz
12 GB Ram


Note: Its all Resistentialism, so keep calm and carry on

64 Bit Win7 OS
Distinguished Contributor
pocketmerlin
Posts: 112
Registered: ‎08-24-2013
Message 4 of 4 (261 Views)

Re: How to copy a Point Table from Excel?

10-23-2013 06:34 AM in reply to: Joe-Bouza

OK, I had been thinking that the export points command gave you some strange file format that I didn't know how to work with, because in the menu it gave formats such as ENZ, NEZ, etc, but then I realized that those meant "Easting, Northing, Elevation" and "Northing, Easting, Elevation," etc. and it gave it to you in a text file format, which I do know how to bring into Excel.

 

So...I'm good now. Thanks for your help.

Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.