Convert Excel Spreadsheet Reports to Native Text Box Format Custom Command - Intergraph Smart 3D - Help - Hexagon

SmartSketch Drawing Editor Help

Language
English
Product
Intergraph Smart 3D
Subproduct
SmartSketch Drawing Editor
Search by Category
Help
Smart 3D Version
13
SmartSketch Version
11

The SP3DConvertExcelEmbedded.dll is a delivered custom command that allows you to convert an Excel spreadsheet report to the native text box format for use in 3D Drawings. The DLL to execute this command is located on the client machine in the [Product Folder]\Drawings\Client\Bin folder. To run this custom command, select Tools > Custom Commands in an open drawing in SmartSketch Drawing Editor, and browse to the DLL location on the computer.

To convert an embedded report, you must set the properties correctly on the associated views. For a 3D composed drawing, set the Report Output property for a report view as needed. See Report Properties Dialog. For a 3D volume drawing, select the Convert report output to text boxes (no Excel) property for the drawing view associated to the report view. See View Tab (Drawing View Properties Dialog).

When you run this command, the Convert dialog appears so you can specify the appropriate options for the convert operation:

Convert embedded Excel spreadsheet

Indicates that the specified report will be converted to native text box format.

Convert and embed an Excel spreadsheet

Indicates that the specified report will be converted to native text box format and then embedded in the current drawing document.

Replace converted spreadsheet with a new converted version from Excel

Specifies that a converted spreadsheet report will be replaced with a new version of the same report.

File

Indicates the report file to convert. Click the ellipsis button to browse to the appropriate file.

See Also

Region Properties Dialog