Product(s):	MicroStation
	Version(s):	10.11.00.36
	Environment:	N\A
	Area:	Tables
	Subarea:	N\A

The following article describes the steps to import an Excel Spreadsheet as a Table into a Design file using MicroStation CONNECT Edition.

Steps to Accomplish

Option 1 Using the Place Table tool

1.         Select the Place Table tool (Drawing > Annotate > Table).

   
   

   2.      In the Place Table tool settings window, select From file.

   
   

   3.      Select the Browse icon next to the File Name setting.

    

    The File Open dialog opens.

   4.      In the File Open dialog, navigate to the folder where your excel file is located, select the file and click Open.

    

   The Select Cells dialog opens.

    

   5.      (Optional) In the Worksheet drop-down list, select the desired worksheet.

     The range of cells defined for the selected worksheet are displayed in the From and To fields.

   6.      (Optional) By default, the Range drop-down list is set to Automatic, which means, the range of cells are selected automatically. If you want to change the range of cells, select Manual from the Range drop-    down list and then enter the cell range in the From and To fields.

   7.      Click OK.

   8.      (Optional) To preserve the formatting from the Excel file, select From Excel in the Seed drop-down list.

   9.      (Optional) To add a title row and/or header row to the Table, turn on the Contains Title Row and Contains Header Row check boxes respectively.

   10.    (Optional) To retain association with the source Excel file, turn on the Retain Association check box.

   11.  Enter a data point to place the Table

Option 2 Using a Key-in

1. Open the Key-in dialog (Drawing > Home > Key-In)
2. Enter the Key-in

·         File: Is the path and name of the Excel file to be opened

·         Worksheet: The name of the Excel Worksheet in the file to be opened

·         Range: The cells in the Worksheet to be opened

See Also