-
In the main window of the Specifications module, select Actions > Save as Excel.
-
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.
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. -
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.
-
-
In the dialog that opens, find specs that you want to save in Excel format.
-
In the Search results data window, select the instrument tags whose specs you want to save in Excel format.
-
After you install a new Smart Instrumentation version or service pack, if you previously saved specifications in Excel format, rename the previous result files or move them from the target folder. You can change the default settings for the target folder, on the Preferences > Specifications > Save as Excel tab.
-
If you previously saved specs in Excel format, and do not want to overwrite existing result files, you should rename the previous files or move them from the target folder.
-
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.
-
-
Select OK to start exporting the spec data to Excel.
-
In the generated Excel files, graphic elements within title blocks display as designed. Smart Instrumentation does not support export of other graphic elements to Excel format.
-
Specifications sharing a common form are saved in a common Excel file. For example, specs based on form 11 might be saved in file T_Form11_0.xlsx. To set the preferences to create an individual Excel file for each spec, on the Preferences > Specifications > Save as Excel tab, under Saving method, select Separate file for each tag.
-
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).