Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenUtilities
  • Product Communities
OpenUtilities
OpenUtilities Wiki Inserting Tables
    • Sign In
    • +OpenUtilities
    • Access Service Request Manager
    • +Bentley sisHYD Multi Utility
    • Design Features - promis.e Functionality - Promis.e Standard
    • +OpenUtilities sisNET - English
    • +OpenUtilities Substation
    • Promis.e Paths
    • -Promis.e Wiki
      • +CONNECT Edition - Promis.e
      • About Promis.e
      • +Administration Features - Promis.e
      • +APIs_VBA - Promis.e
      • +Automation Features - Promis.e
      • +Component Features - Promis.e
      • +Component Management - Promis.e
      • +CONNECT Services - Promis.e
      • +Data Manager - Promis.e
      • +Database Platform Support - Promis.e
      • +Display - Promis.e
      • +Drawing Management - Promis.e
      • +Engineering Design Considerations - Promis.e
      • Error - Object reference...General
      • +Find_Replace - Promis.e
      • Finding the Tutorial
      • +Installation_Configuration - Promis.e
      • +Interoperability - Promis.e
      • +Licensing - Promis.e
      • +Maintenance Features - Promis.e
      • +Migration - Promis.e
      • +OS Support - Promis.e
      • +Panel Layout - Promis.e
      • +Performance - Promis.e
      • -PowerPlatform Support - Promis.e
        • Area inside the sheet border is filled white
        • Assign actions to function keys
        • Attaching References (Auxiliary Views)
        • Blank, gray project pages
        • Customizing the Interface - CONNECT Edition
        • Customizing the Interface - V8i
        • Elements missing from published or plotted output
        • Empty box is stuck on the screen
        • Error - Format version not supported, not recognized file format
        • Error - Unable load/create dialog item of type 'HTML', id=41510001
        • Inserting Drawings
        • Inserting Elements By Coordinates
        • Inserting Raster Images
        • Inserting Tables
        • Make custom styles available for all pages, symbols
        • +Manipulate Tools - PowerPlatform Support - Promis.e
        • Masking Elements
        • MicroStation Help file
        • Off-grid wires and symbols
        • Pasted elements rotated or scaled
        • Platform Fundamentals for Promis.e Standalone Users
        • promis.e is read-only
        • Restore Platform Defaults - Promis.e
        • Run key-ins when a page is opened
        • Set DGN files to update fields automatically
        • Symbols jump when moved or placed
        • Tools Are Missing From Tasks Menu
        • Turn the Task Bar Menu Back On
        • Unreadable or disappearing elements upon selection
        • View is rotated
      • +Print_Publish Features - Promis.e
      • +ProjectWise Integration - Promis.e
      • Promis.e Help file
      • +Reports_Output Features - Promis.e
      • +Template Management - Promis.e
      • +Text Tools - Promis.e
      • Training FAQs
      • +Wire Numbering - Promis.e
      • +Wiring Features - Promis.e
      • +Project Management - Promis.e
      • Promis.e Title
      • Working from home with Promise.e
    • Replace Family - Find_Replace - Promis.e
    • SQL Server Login

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

    Inserting Tables

      Product(s): Promis.e, Bentley Substation
      Version(s): through 08.11.12.140
      Environment: N/A
      Area: PowerPlatform Support
      Subarea: N/A

    Background

    It is sometimes necessary to display data from a spreadsheet on a project page in Promis.e or Bentley Substation.

    Another situation is that the simple report templates required for the Text On Drawing feature of Run Reports are not adequate.  In this case, a report based on a complex template can be exported to an .xls file by setting the check box next to the name of the desired template on Run Reports, setting the Output To File and XLS check boxes, then clicking Run.

    Use the following procedure to get the data, including formatting, from a spreadsheet onto the page drawing.

    Steps to Accomplish

    1. Open the spreadsheet in Excel. Other spreadsheet software may also work for this procedure. 

    2. Use the mouse or the SHIFT and arrow keys to select only the cells containing data to be displayed on the drawing.

    3. Press CTRL+C to copy the cells to the clipboard.

    4. Switch to the Bentley software and open the destination page using Project Manager.

    5. Press CTRL+V to paste the cells into the drawing. 

    6. A Paste OLE Object box should appear.  Set Paste As to "Picture" if the data is to be static. To be able to change the data in the cells at a later time, set Paste As to "Embedded". 
      Note: if the “Embedded” option is grayed out, the spreadsheet may have opened in Protected View in Excel. Protected View would need to be disabled and the cells copied and pasted once again for “Embedded” to be available.

      With the "By Corners" method, the size and position of the table is specified by clicking on the drawing. 

      With the "By Size" method, a scale factor is specified on the dialog and position is selected by clicking on the drawing.  The Paste OLE Object dialog must be expanded to see the Scale field.

    7. Click on the drawing to size and/or place the table.

    If the cells were pasted as "Embedded", the data can be changed by double clicking the outer border of the pasted table and it will open in Excel.  Make the desired changes and close Excel.  The data on the drawing will update accordingly.

      Original Author: Matt_P
    • PowerPlatform Support
    • promis.e
    • Reports_Output Features
    • how to
    • Bentley Substation
    • en
    • Reporting
    • Share
    • History
    • More
    • Cancel
    • Matt_P Created by Communities MVP Matt_P
    • When: Tue, Nov 13 2012 12:42 PM
    • Satish Saptasagar Last revision by Bentley Colleague Satish Saptasagar
    • When: Mon, Apr 13 2020 9:37 AM
    • Revisions: 10
    • Comments: 0
    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

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