• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Civil 3D

    Reply
    Contributor
    Posts: 11
    Registered: ‎05-03-2012

    Export Pipe Network Structure Table to Excel

    319 Views, 4 Replies
    02-05-2013 06:43 AM

    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 

    Please use plain text.
    Mentor
    Posts: 173
    Registered: ‎12-02-2009

    Re: Export Pipe Network Structure Table to Excel

    02-05-2013 07:08 AM in reply to: n8ch

    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?

    -Dustin
    Civil 3D 2013 64 bit SP1
    Windows 7 Pro 64
    Intel Xeon 2.93GHz
    24GB RAM
    NVIDIA Quadro FX 580
    explodetheblock.wordpress.com
    Please use plain text.
    Contributor
    Posts: 11
    Registered: ‎05-03-2012

    Re: Export Pipe Network Structure Table to Excel

    02-05-2013 08:28 AM in reply to: dasindog

    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

    Please use plain text.
    Mentor
    Posts: 173
    Registered: ‎12-02-2009

    Re: Export Pipe Network Structure Table to Excel

    02-05-2013 09:02 AM in reply to: n8ch

    http://forums.autodesk.com/t5/Visual-LISP-AutoLISP-and-General/Go-from-TEXT-and-LINES-to-an-AutoCAD-...

     

    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.

    -Dustin
    Civil 3D 2013 64 bit SP1
    Windows 7 Pro 64
    Intel Xeon 2.93GHz
    24GB RAM
    NVIDIA Quadro FX 580
    explodetheblock.wordpress.com
    Please use plain text.
    Contributor
    Posts: 12
    Registered: ‎10-23-2012

    Re: Export Pipe Network Structure Table to Excel

    02-05-2013 11:34 AM in reply to: n8ch

    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.

    -John J. Rauch, P.E.
    Please use plain text.