Tool sheet template definition
Before you generate your tool sheet, you need to define the tool sheet template in the Microsoft Excel application.
Defining the security settings
First, you need to define the security settings to manage executing of macros in the Excel environment.
Template creation
Template files must be located in the following folder:
<SolidCAM install directory>\SolidCAM\_XmlDoc\Files\
SolidCAM offers you by default the Default_XLS_Excel.xls or Default_XLSM_Excel.xls file. It is recommended to create new templates based on this file by copying the file and editing the required parameters. |
Template structure
A template consists of several worksheets. These worksheets are mandatory and have hard-coded names, which means that they cannot be deleted or renamed. Each worksheet contains special template data.
Final document
This worksheet contains the preview of the actual template design. This worksheet is updated and activated after every test call.
Design
This worksheet contains the design of the template. In this worksheet you can edit the content of the tool sheet to be generated, define its sections, images, parameters, etc.
Test
This worksheet serves for test process calling.
Options
This worksheet contains the general settings that affect the final document generating process.
DataXMLgeneral
This worksheet contains a list of general SolidCAM data parameters that can be used in the Design worksheet.
DataXMLtools
This worksheet contains a list of SolidCAM tool data parameters that can be used in the Design worksheet.
DataXMLoperations
This worksheet contains a list of SolidCAM operation data parameters that can be used in the Design worksheet.
DataXMLfixtures
This worksheet contains a list of SolidCAM fixture data parameters that can be used in the Design worksheet.
DataXMLpictures
This worksheet contains a list of image data parameters that can be used in the Design worksheet.
DataXMLHolders
This worksheet contains a list of SolidCAM Holder data parameters that can be used in the Design worksheet.
DataXMLsetups
This worksheet contains a list of SolidCAM Setup data parameters that can be used in the Design worksheet.
DataXMLuser
This worksheet contains a list of user-defined parameters that can be used in the Design worksheet. Here you can store your own parameters derived from SolidCAM data.
Conditional
This worksheet works in two ways:
1. You can type in a particular cell a list of aliases names separated by ; (semicolon). In this case the conditional section will be printed only once at start and then only in case if any of listed aliases will change its value from line to line.
2. You can type in the particular cell any formula where the result will be True or False. For True result that section will be printed and for False result that section will not be printed.
If you leave the cell blank, that section will not be printed.
|