AutoCAD Civil 3D
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Export Pipe Network Structure Table to Excel
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
The PLS I work under inquired if the pipe and structure tables provided in our construction plans are able to be exported to excel. The only way I know how is to use the reports manage. The problem is, the provided Pipes reports don't contain all the data we are looking for. How do I modify, or create a new, Pipe report? It seems like it should be really easy to export the data to excel......I've gotta be missing something.
Thanks
Re: Export Pipe Network Structure Table to Excel
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hrmm. What data do you want to show exactly? I know you can copy all the pipe structure or pipe data from toolspace. Would that get you what you need?
Civil 3D 2013 64 bit SP1
Windows 7 Pro 64
Intel Xeon 2.93GHz
24GB RAM
NVIDIA Quadro FX 580
explodetheblock.wordpress.com
Re: Export Pipe Network Structure Table to Excel
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
I would like to export all of the data represented in my structure table, as shown in the construction plans. Ideally, I could generate a Sturcture Report that would match my structure table (Number, Location, Structure, Frame & Cover, Grate Elev, Sump Elev, and depth) Once in excel, I would add a few additional columns and formulas to facilitate construction staking (i.e. - hub elevation, cuts/fills, etc..).
If it's not relatively easy to customize a report, I will just cob it all together via copy/paste and call er' good enough.
Thanks
Re: Export Pipe Network Structure Table to Excel
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Check out the thread above. Might be worth doing some digging. I assume once you get the exploded civil 3d table into the autocad table format or a CSV then you could do whatever you need in excel.
Civil 3D 2013 64 bit SP1
Windows 7 Pro 64
Intel Xeon 2.93GHz
24GB RAM
NVIDIA Quadro FX 580
explodetheblock.wordpress.com
Re: Export Pipe Network Structure Table to Excel
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
This might be too easy, but you can manipulate the columns you want in the Panorama; higlight the pipes or structures you want to see in the report; right-click and copy to clipboard; then paste into Excel. It's not dynamically linked or anything, but it'll make for a pretty easy solution.
