AutoCAD Civil 3D General Discussion

AutoCAD Civil 3D General Discussion

Reply
Contributor
13 Posts
0 Kudos
Registered: ‎10-09-2009
Post 1 of 7

export alignment table to excel/csv

3720 Views, 6 Replies
11-15-2009 08:07 AM
Hello

I have created an alignment elements table with lines, radius, lengths etc (Alignments > Add tables > Add segments). Now I need a way to export that information to csv / Excel for further work. Does anyone know a way to do this?

I am using c3d 2009.

-Bjørn Amund
*Harold Alberto
Post 2 of 7

Re: export alignment table to excel/csv

11-15-2009 09:19 AM in reply to: baenebo
Hi,

I don't think there's a way to export the segment table out to csv.

All info in the table however can also be viewed in grid view in the
Alignment Layout Tools. Select the alignment>Edit geometry>click the
third button from the left. This will open the panorama window with all
elements of the alignment. Right click any of the table headers and
check the elements you need to show. Then go down the bottom of the
list and click Copy all. This can then be pasted onto Excel. Please
see attached.

Hope that helps.

Harold
*Harold Alberto
Post 3 of 7

Re: export alignment table to excel/csv

11-15-2009 09:21 AM in reply to: baenebo
Sorry, I meant third button from the right.

Harold Alberto wrote:
> Hi,
>
> I don't think there's a way to export the segment table out to csv.
>
> All info in the table however can also be viewed in grid view in the
> Alignment Layout Tools. Select the alignment>Edit geometry>click the
> third button from the left. This will open the panorama window with all
> elements of the alignment. Right click any of the table headers and
> check the elements you need to show. Then go down the bottom of the
> list and click Copy all. This can then be pasted onto Excel. Please
> see attached.
>
> Hope that helps.
>
> Harold
>
>
> ------------------------------------------------------------------------
>
Contributor
13 Posts
0 Kudos
Registered: ‎10-09-2009
Post 4 of 7

Re: export alignment table to excel/csv

11-15-2009 10:41 AM in reply to: baenebo
Harold,

Thanks for your quick reply, and good explanation. Your method does the trick, with one (for me) important limitation. From what I can see, I get all the information except the element tag. The tag is the only link between the table and the drawing, and I need it to be able to communicate what elements I am referring to (se attachment for illustration).

If anyone knows a way to extract this data, I would be very happy. (The task involves 4.5km of alignments, so any manual operation is not wanted)

-BA

Edit: Also, for some reason the panorama does not include detached parts of the alignment... but the alignment table does. Which I need. Edited by: EneboBj%C3%B8rnAmund4192 on Nov 15, 2009 9:50 PM
Active Contributor
38 Posts
0 Kudos
Registered: ‎06-01-2006
Post 5 of 7

Re: export alignment table to excel/csv

11-16-2009 03:01 AM in reply to: baenebo
Hello,
Here in Brazil, we are developing in VB and. Net a report to extract data
We could not find another way,

Good luck
Contributor
13 Posts
0 Kudos
Registered: ‎10-09-2009
Post 6 of 7

Re: export alignment table to excel/csv

11-16-2009 11:09 AM in reply to: baenebo
Hi,

You have a script that extracts the data in the elements table? Is this something you'd be interrested in sharing? I would break my neck trying to do this in vb myself, so the alternative is to contact my software company and have them make something.

- BA
New Member
1 Posts
0 Kudos
Registered: ‎01-05-2012
Post 7 of 7

Re: export alignment table to excel/csv

01-05-2012 11:08 AM in reply to: baenebo

Got it to work with Civil3D 2011, not sure if this is even still an issue.

 

Select your alignment that you wish to export.  Under the toolbar select Geometry Editor a new toolbar will open select Alignment Grid View.  Right click on the top line, copy all.  Then just paste this into your excel spreadsheet.  Hope this is helpful for anyone who is still looking for a solution to this problem.

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post