Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
  • Welcome
  • Products
  • Support
  • About
  • More
  • Cancel
AutoPIPE
  • Product Communities
  • More
AutoPIPE
AutoPIPE Wiki 01. Ability to export data to MS Excel or MS Access from AutoPIPE
    • Sign in
    • -Pipe and Vessel Stress Analysis - Wiki
      • +ADL PIPE
      • -Bentley AutoPIPE
        • ++Table Of Contents - AutoPIPE Wiki page
        • +- General Information about AutoPIPE
        • +-NEW User Guide - TIPs - FAQ - RSS Newsfeed - AutoPIPE
        • +ATS and Batch Processing - AutoPIPE
        • AutoPIPE QA&R program
        • +Download - Install - Release Notes - AutoPIPE
        • +File / Model Management using AutoPIPE
        • +General - AutoPIPE
        • +Graphics - AutoPIPE
        • -Grids (Input & Results) - AutoPIPE
          • -01. Input grids - AutoPIPE
            • 01. Ability to export data to MS Excel or MS Access from AutoPIPE
            • 02. Navigating The Input Grids In Bentley AutoPIPE 2004 [CS]
            • 03. Input / Results grid are missing, reset location
            • 04. Power User Tips & Techniques When Using The Input Grids
            • +06. (01) "Press/Temp/PipeID" - Input grid tab in AutoPIPE
            • +06. (02) "Pipe Properties" - Input grid tab in AutoPIPE
            • +06. (03) "Segment" - Input grid tab in AutoPIPE
            • +06. (04) "Point" - Input grid tab in AutoPIPE
            • 06. (09) "Bend" - Input grid tab in AutoPIPE
            • 06. (15) "Section ID" tab on the Input Grids In AutoPIPE
            • 06. (22) "Soil ID" Tab On Input Grids In AutoPIPE
            • +06. (30) "Rigid Options" Tab On Input Grids In AutoPIPE
            • +07. "Support" - Input grid tab in AutoPIPE
          • +02. Results (Output) Grids - AutoPIPE
          • a. Input / Results grids only shows 0 - 3 decimal places, how to see more digits after the decimal in AutoPIPE?
        • +Import and Export - AutoPIPE
        • +Known Issues in AutoPIPE (Enhancements, defects, etc..)
        • +Libraries - AutoPIPE
        • +License AutoPIPE -
        • +Loads and Load Sets - AutoPIPE
        • +Localization (Non-English Language) - AutoPIPE
        • +Modeling Approaches in AutoPIPE
        • +Modules (i.e. Flange Analysis, Spring Hanger Selection, Rotating Equip, TTA) in AutoPIPE
        • +Piping codes - AutoPIPE
        • +Post Processing - AutoPIPE
        • +Printing - AutoPIPE
        • +Reports - AutoPIPE
        • +Settings - AutoPIPE
        • +Stress Isometrics - AutoPIPE
        • +Technology Productivity Capabilities
        • +Warnings, Errors, Crashed, Confirm, etc.. messages in AutoPIPE
        • +~ Technical Support - AutoPIPE
      • +Bentley AutoPIPE Nozzle (WinNOZL)
      • +Bentley AutoPIPE Vessel (powered by Microprotol)
      • +Bentley PlantFLOW
      • +Bentley PULS
    • Multi-lingual announcement from BENTLEY TECHNICAL SUPPORT.
    • +Training - Webinar - Help
    • Working at Home with AutoPIPE
    • +~ Attend a live meeting with an AutoPIPE Analyst

     
     Questions about this article, topic, or product? Click here. 

    01. Ability to export data to MS Excel or MS Access from AutoPIPE

    Applies To
    Product(s): AutoPIPE,
    Version(s): ALL
    Area: Export
    Original Author: Bentley Technical Support Group

    Problem:

    How to copy/export data to MS Excel or MS Access

    Solution:

     How to copy / export AutoPIPE's input or results grid data to MS Excel:


    1. Open model

    2. Open Input grids by pressing on the Icon in the top toolbar or by using the menu Edit> Grids.

    3. Select a tab on the grids (example, Input grid> Press/Temp/PipeID)

    4. Select the square in the top most left corner

    5. The entire gride should now be highlighted black.


    6. Press Cntl+C (copy clip to clipboard)

    7. Open MS Excel, blank sheet

    8. In cell A1, press Cntl + V (paste from clipboard)


    9. Done

    How to copy / export AutoPIPE's input or results grid data to MS Access:


    1. Open model in AutoPIPE

    2. Please see the following AutoPIPE help section:

      Help > Contents> Contents Tab> Command Reference> File Commands> Export> Exporting a Model

      • Input Database (*.mdb)

      • Results Database (*.mdb)

    Note: Sometimes there are problems associated with copy / pasting to / from the input grids. Sometimes the following is displayed: "Selection type different"

    Even if the data looks same as those copied from input grids. The following has been logged, TFS-D170633, Input Grid: Cannot copy data from MS Excel to input grid. Until this has been added, use the following workaround: 

      • Copy a cell of input grid column (where data will be pasted from excel)
      • Copy data from Excel
      • Paste in the cell(s) of input grid

    Please see the video for workaround. Keyboard shortcuts (Ctrl + C & Ctrl + V) works as well.

    See Also

    Bentley AutoPIPE

    • Excel
    • Export
    • AutoPIPE
    • Microsoft
    • Access
    • Share
    • History
    • More
    • Cancel
    • Mike Dattilio Created by Bentley Colleague Mike Dattilio
    • When: Tue, Sep 17 2013 4:45 AM
    • Mike Dattilio Last revision by Bentley Colleague Mike Dattilio
    • When: Fri, Apr 27 2018 11:58 AM
    • Revisions: 7
    • Comments: 2
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2021 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies