Save as Excel - Intergraph Smart Instrumentation - Help

Intergraph Smart Instrumentation Help

Language
English
Product
Intergraph Smart Instrumentation
Search by Category
Help
Smart Instrumentation Version
13.1

You can use Smart Instrumentation Save as Excel options to save specifications in Microsoft Excel format. You can then use any of the Excel functionalities to edit the exported specifications. The software allows you to save all specs that share a common spec form to a single Excel file. For example, you can save specifications based on form 11 in file T_Form11_0.xlsx. If needed, you can set the Save as Excel preferences so that you can create an individual Excel file for each specification. The default target folder is the SPI_SaveAsExcel folder under the user's base folder.

  • Save as Excel functionality is dependent on the correct Microsoft Windows ODBC drivers being installed on your machine. See the Prerequisites section of the topic Create an Import Link for an ODBC Source.

  • Installing Windows updates sometimes causes problems with the Windows ODBC drivers. If Save as Excel fails to work correctly you should re-install the ODBC drivers.

  • Saving as an .xls Excel formated file is limited to 65,536 rows (256 columns). Use the .xlsx Excel format, to save more than 65,536 rows (256 columns).

  • The Save-as Excel functionality only works with the 32-bit version of Microsoft Excel. You must also have installed from the Microsoft Download center the following file: Microsoft Access 2013 Runtime.exe.

To locate the user's base folder, select the Windows Start > Run > %userprofile%.

You can specify a different path and folder by changing the Save as Excel preferences.

The Excel workbook opens displaying the specification with the lowest tag number. If the file that you opened contains multi-page specs, each page is displayed on a separate Excel worksheet. If you exported multi-tag specifications, the multi-tag list is displayed on the Excel See List worksheet. The notes are displayed on the Excel Notes worksheet.

  • In Excel 2003, you need to set macro security to Medium.

  • In Excel 2007, to turn pages, select the Add-Ins tab and then select the appropriate arrow.

Supported Spec Types

You can only use Save as Excel options with specs whose item type is Instrument (single-tag or multi-tag specs). Smart Instrumentation does not support Save as Excel options for specs whose item type is other than instrument, or whose form contains page sections.

  • If you previously saved multi-tag specifications in Excel format and then made changes to the format upon which these specifications are based, you should rename the previous result files or move them from the target folder before exporting further specifications based on that format.

Font Style

Regardless of the font of the original specification, the text font style in the target Excel file is Arial.

Graphics and Other Embedded Objects

Graphic elements, for example, the logo image, or other .bmp graphics are not shown in the target Excel file. Smart Instrumentation does not support export of embedded objects to Excel, for example, equations.