ParameterTable Object


Description

The ParameterTable object represents the connection to a spreadsheet. From the ParameterTable object you can access the spreadsheet and the properties that define how the spreadsheet is read. In addition, the ParameterTable object provides access to the parameters that were created as a result of reading in the spreadsheet.

Methods

Name Description
Delete Method that deletes the ParameterTable object.
Export Exports the ParameterTable to an external file.
GetReferenceKey Method that generates and returns the reference key for this entity.

Properties

Name Description
AttributeSets Property that returns the AttributeSets collection object associated with this object.
FileName Gets/Sets the File Name of this linked table. Fails if this table is embedded. Setting a new File Name may add new parameters, update existing ones, and may turn some to DriverLost.
Linked Property that specifies if the Excel document is linked or embedded to the Autodesk Inventor document.
Parent Property that returns the parent object of this ParameterTable. This property will return different types of objects depending on the document type the ParameterTable is contained in. If the ParameterTable is in a part document then the parent is a PartComponentDefinition object. If the ParameterTable is in an assembly document then the parent is an AssemblyComponentDefinition. If the document is a drawing document then the parent is a DraftDocument.
ReferencedFileDescriptor Gets the description of the linked file.
StartCell Gets the starting cell in the WorkSheet from which the table is derived.
TableParameters Property that returns the TableParameters collection object.
Type Returns an ObjectTypeEnum indicating this object's type.
WorkSheet Property that returns the Excel WorkSheet object. Using the Excel Automation interface you can query and modify the contents of the sheet.

Accessed From

ParameterTables.AddExcelTable, ParameterTables.Item

Samples

Name Description
Table Parameters This sample demonstrates how to access the Parameters object, and from it in turn the TableParameters collection that represents the collection of parameters that have been linked/embedded from an external spreadsheet.

Version

Introduced in version 4