Copying an Excel spreadsheet into a sheet model


 Product(s):OpenBuildings Designer 
 Version(s):CONNECT Edition
Area:Platform Tools

Problem Description

How can I copy an Excel spreadsheet into an OpenBuildings Designer sheet model?

Steps to Accomplish

Please follow the below steps to insert your Excel spreadsheet into a sheet model.

  1. First, from the Key-in dialog box type “mdl load olecntr” and press Enter.

   

  1. Next, go to your sheet model and change the workflow to Drawing. From the Utilities tab choose Utilities > OLE > Insert Object, click on Create from File, browse to the the desired Excel spreadsheet and click OK.

 

  1. Next, choose the desired options in the Insert OLE Object dialog, and paste the data from Excel into the sheet model.

  2. Finally, you can see that the data from the Excel spreadsheet has been successfully inserted in your sheet model.