Enabling Custom XLSM Templates for Export of Importable Spreadsheets or Redline Importable Spreadsheets
Custom XLSM template files can be enabled through configuration with the following activities:
• Creating the custom XLSM template files
• Including the customer XLSM template files on the Windchill server
• Configuring properties specifying the custom XLSM template files for specific export options
 |
We recommend consulting your system administration policy on the use of XLSM. We do not recommend using the Enable VBA macros (not recommended; potentially dangerous code can run) macro settings.
|
Each custom XLSM template file requires the workbook to include a worksheet for the selected export option, where a Microsoft VB project must be defined to support the appropriate business logic available.
Once the custom XLSM template is fully defined, it should be included on the Windchill server. The file system location may be configured using properties or may be included in the default template directory location.
When using a custom directory location, the optional property wt.ixb.customMacroEnabledSpreadsheetTemplateDirectory may be used to specify the directory location.
Each XLSM template file is unique to the set of export options selected by the user, as the set of export options drives the worksheets included in the workbook. The combination of export options, identified by the SHEETTYPE, must be included in the property specifying the XLSM template file to be used for that combination. For example, the following configuration would allow the custom XLSM template file to be used when the user selects the export options of BOM, Part and BOM, or BOM and Replacements, but would not allow custom XLSM for any other combinations:
• wt.ixb.customMacroEnabledSpreadsheetTemplate.BOM=CustomBOMSpreadsheet.xlsm
• wt.ixb.customMacroEnabledSpreadsheetTemplate.PART_BOM=CustomPartBOMSpreadsheet.xlsm
• wt.ixb.customMacroEnabledSpreadsheetTemplate.BOM_REPLACEMENTS=CustomBOMReplacementsSpreadsheet.xlsm
For more information on exporting redline product data, see About Exporting Product Data to Excel and How to Export Product Data to Excel.