Reads assembly hierarchy data from a Microsoft Excel spreadsheet to create, delete, or assign parts to the existing assembly hierarchy.
Visual Basic Project: [Reference Data Folder]\SharedContent\Src\Planning\Rules\ImportFromXLS
Compiled Visual Basic Rule: [Reference Data Folder]\SharedContent\Planning\Rules\PlanningAssemblyRules\ImportRule.dll
.Net Project: [Reference Data Folder]\SharedContent\Src\Planning\Rules\PlanningAssemblyRules\PlanningAssemblyRules.sln
Compiled .Net Rule: [Reference Data Folder]\SharedContent\Bin\Planning\Rules\Release\PlanningAssemblyRules.dll
Example Spreadsheet: [Reference Data Folder]\SharedContent\Import\Planning\S3D_ImportAssemblyData.xlsx
The Process sheet in this example workbook contains actions, the rule progID, and arguments for the rule. The software reads this sheet when you specify an action, and calls the related rule with information for that action. For more information, see Import Assembly Data from Excel in the Planning User's Guide.
The following class modules are included in the Visual Basic project:
-
ImportAssembly - Imports assembly data from an xls file.
-
AssignParts - Assigns parts to the existing assembly hierarchy.
-
DeleteAssembly - Deletes the assembly hierarchy.