CADWorx Spec Editor Project: Home Tab > Export/Import Data > Import Update From Excel
Imports data from an Excel file to a specification.
File Path
Specifies the location of the Excel file.
Select the components for import
Displays the information details for the import.
Import
Enables you to select the items to import.
Type
Displays the type of import if the import contains a type.
Description
Displays a description of the import. For example, if you made a change to the Pipe component, the Description displays the long description of the piping. However, if you changed the Component ID or the Program Code of Pipe in the Excel file, the description displays the Table Field types that display in Long in the New and Edit Component pane.
Property
Displays the property that you changed in the Excel file.
Action
Displays the action taken for the import. For example, if you change the Weight factor in the Excel file, the Action reads Update, because the action taken updates the specification. In addition, if you changed the Component ID or the Program Code of Pipe in the Excel file, the Action reads Addition, because this action adds a new component to the specification.
Existing Spec
Displays the value of the property from the existing specification.
Excel Spec
Displays the value of the property from the Excel file. The value displayed here comes from the changes made to the Excel file.
Result
Displays success or failure of the imported property.
-
Success =
-
Failure = Import data displays in red before import. After import you receive the following:
Saves backup project
Saves a backup of the original project.
View Log
Enables you to view a log of the import.