New Objects in 2013
| Application | |
| ChartDataPointTrack (Property) | True will cause all charts in newly created documents to use the cell reference tracking behavior.Boolean |
| EnableMacroAnimations (Property) | Controls whether macro animations are enabled. True if user interface animations or chart animations are enabled. Is set to False (no animation) by default. If it is set to True during the running of a macro, it will enable animation and then will reset to False after the macro runs. Read/write Boolean. |
| FlashFill (Property) | TRUE indicates that the Excel Flash Fill feature has been enabled and active. Boolean Read/Write |
| FlashFillMode (Property) | True if the Flash Fill feature is enabled. Boolean Read/Write |
| MergeInstances (Property) | True to merge multiple instances of the application into a single instance. Read/Write Boolean. |
| QuickAnalysis (Property) | Returns a QuickAnalysis object that represents the Quick Analysis options of the application. |
| ShowQuickAnalysis (Property) | Controls whether the Quick Analysis contextual user interface is displayed on selection. TRUE means the Quick Analysis button will show. Corresponds to the Show Quick Analysis options on selection checkbox located in the File menu, Options, Excel Options, and then General tab. Read/Write. Boolean. |
| CalculatedMember | |
| MeasureGroup (Property) | Returns the associated measure group. String Read-only |
| NumberFormat (Property) | Returns a XlCalcMemNumberFormatType value that represents the number format of the calculated member. The default value is xlNumberFormatTypeDefault. Read-only. |
| ParentHierarchy (Property) | Returns the name of the current parent hierarchy from the hierarchies that are available on the cube. String Read-only |
| ParentMember (Property) | Returns the name of the parent member for the parent hierarchy. String Read-only |
| CalculatedMembers | |
| AddCalculatedMember (Property) | Adds a calculated field or calculated item to a Pivot Table. |
| CategoryCollection (new) | Represents the collection of visible chart categories in the chart. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of objects in the CategoryCollection (returns the number of categories visible in the chart). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the CategoryCollection object. |
| Parent (Property) | Returns an Object that represents the parent object of the specified CategoryCollection Object (Excel) object. Read-only. |
| Chart | |
| CategoryLabelLevel (Property) | Returns a XlCategoryLabelLevel Enumeration (Excel) constant referring to the level of where the category labels are being sourced from. Integer Read/Write. |
| ChartColor (Property) | Returns or sets an Integer that represents the color scheme for the chart. Read-write. |
| ClearToMatchColorStyle (Property) | Clears all colors on the specified chart that do not follow the color style applied to the chart. |
| FullSeriesCollection (Property) | Enables retrieving the filtered out series specified by the Index argument. |
| SeriesNameLevel (Property) | Returns a XlSeriesNameLevel Enumeration (Excel) constant referring to the level of where the series names are being sourced from. Integer Read/Write. |
| ChartCategory (new) | Specifies a chart type's category. |
| Application (Property) | When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
| IsFiltered (Property) | Returns TRUE when the user filters out a series. Boolean Read-only |
| Name (Property) | Returns a String value that represents the name of the object. |
| Parent (Property) | Returns the parent object for the specified object. Read-only. |
| ChartFormat | |
| Adjustments (Property) | Returns an Adjustments Object (Excel) object. Read-only |
| AutoShapeType (Property) | Returns the type of the specified shape. MsoAutoShapeType Read-only |
| ChartGroup | |
| CategoryCollection (Property) | Returns an object that represents a collection of all of the visible categories (a CategoryCollection collection) in the chart group. |
| FullCategoryCollection (Property) | Returns an object that represents a collection of all of the visible and filtered categories (a CategoryCollection collection) in the chart group. |
| Charts | |
| Add2 (Property) | Inserts a chart directly onto the grid. |
| CubeFields | |
| GetMeasure (Property) | Given an attribute hierarchy, returns an implicit measure for the given function that corresponds to this attribute. If an implicit measure does not exist, a new implicit measure is created and added to the CubeFields Object (Excel) collection. |
| DataFeedConnection (new) | Contains the data and functionality needed to connect to data feeds. The same object is used for all Data Feed types. |
| AlwaysUseConnectionFile (Property) | True if the connection file is always used to establish connection to the data source. Boolean. Read/Write |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| CancelRefresh (Property) | Cancels a refresh operation on a data feed connection. |
| CommandText (Property) | Returns or sets the command string for the specified data source. Variant Read/Write |
| CommandType (Property) | Returns or sets the command string for the specified data source. Variant Read/Write |
| Connection (Property) | Returns or sets a string that contains Service Contract settings that enable Microsoft Excel to connect to a Data Feed data source. Variant Read/Write |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Long Read-only |
| EnableRefresh (Property) | True if the connection can be refreshed by the user. The default value is True. Boolean Read/Write |
| Parent (Property) | Returns an Object that represents the parent object of the specified DataFeedConnection Object (Excel) object. Read-only. |
| Refresh (Property) | Refreshes the data feed connection. |
| RefreshDate (Property) | Returns the date on which the OLE DB connection was last refreshed. Date. Read-only |
| Refreshing (Property) | True if an OLE DB query is in progress for the specified data source connection. Boolean Read/Write |
| RefreshOnFileOpen (Property) | True if the connection is automatically updated each time the workbook is opened. The default value is False. |
| RefreshPeriod (Property) | Returns or sets the number of minutes between refreshes. Long Read/Write |
| SaveAsODC (Property) | Saves the data feed connection as a Microsoft Office Data Connection file. |
| SavePassword (Property) | True if password information in a data feed connection string is saved in the connection string. False if the password is removed. |
| ServerCredentialsMethod (Property) | Returns or sets the type of credentials that should be used for server authentication. XlCredentialsMethod Enumeration (Excel) Read/Write |
| SourceConnectionFile (Property) | Returns or sets a String indicating the Microsoft Office Data Connection file or similar file that was used to create the connection. Read/Write |
| SourceDataFile (Property) | A path to the original file used to create the connection. In the case of an OData connection, this is the location of the *.atom or *.atomsvc file used to create the connection. String Read/Write |
| DataLabel | |
| ShowRange (Property) | Used to toggle the Range field if it exists on the data label range. Boolean Read/Write |
| DataLabels | |
| Propagate (Property) | Enables you to take the contents and formatting of a single data label and apply it to every other data label on the series. |
| ShowRange (Property) | Used to toggle the Range field if it exists on the data label range. Boolean Read/Write |
| FullSeriesCollection (new) | Represents the full set of Series Object (Excel) objects in a chart. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of Series Object (Excel) objects in the FullSeriesCollection Object (Excel) object. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the FullSeriesCollection Object (Excel) object. |
| Parent (Property) | Returns an Object that represents the parent object of the specified FullSeriesCollection object. Read-only. |
| ListObject | |
| ShowAutoFilterDropDown (Property) | True when the AutoFilter drop down for the ListObject object is displayed. Boolean Read/Write |
| Slicers (Property) | Returns a list of the table slicers associated with a ListObject. Read-only |
| TableObject (Property) | Returns a TableObject Object (Excel) object. Read-only |
| Model (new) | Stores references to workbook connections and information about the tables and relationships contained within the Data Model. |
| AddConnection (Property) | Adds a new Workbook Connection to the model with the same properties as the one supplied as an argument. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| CreateModelWorkbookConnection (Property) | Returns a WorkbookConnection Object (Excel) object of type ModelConnection Object (Excel). |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| DataModelConnection (Property) | Returns the model workbook connection object from the workbook connections collection which connects to the model. |
| Initialize (Property) | Initializes the Workbook's Data Model. This is called by default the first time the model is used. |
| ModelRelationships (Property) | Returns a collection of relationships between Data Model tables. Read-only |
| ModelTables (Property) | Returns a collection of tables inside the Data Model. Read-only |
| Name (Property) | Returns a String value representing the name of the Model object. Read-only |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelChanges object. Read-only. |
| Refresh (Property) | Refreshes all data sources associated with the model, fully reprocesses the model and updates all Excel data features associated with the Model. |
| ModelChanges (new) | Represents changes made to the data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| ColumnsAdded (Property) | Returns a ModelColumnNames Object (Excel) collection of ModelColumnName Object (Excel) objects which represent all columns added as part of a model operation. Read-only. |
| ColumnsChanged (Property) | Returns a ModelColumnChanges Object (Excel) collection of ModelColumnChange Object (Excel) objects which represent table names and column names of all table columns for which the data type was changed (might add more types of changes here in the future) as part of a model operation. Read-only. |
| ColumnsDeleted (Property) | Returns a ModelColumnNames Object (Excel) collection of ModelColumnName Object (Excel) objects which represent all columns which were deleted as part of a model operation. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| MeasuresAdded (Property) | Returns a ModelMeasureNames Object (Excel) collection of ModelMeasureName Object (Excel) objects which represent all measures which were added as part of a model operation. Read-only. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelChanges object. Read-only. |
| RelationshipChange (Property) | When True, one or more relationships in the model were changed (added, deleted or modified) as part of a model operation. When False, no relationships were changed during the operation. Boolean Read-only. |
| Source (Property) | Returns the source of the data model. Read-only. |
| TableNamesChanged (Property) | Returns a ModelTableNameChanges Object (Excel) collection of ModelTableNameChange Object (Excel) objects representing old and new names of all tables which were renamed in the model as part of a model operation. Read-only. |
| TablesAdded (Property) | Returns a ModelTableNames Object (Excel) collection of table names as strings representing all tables which were added to the model as part of a model operation. Read-only. |
| TablesDeleted (Property) | Returns a ModelTableNames Object (Excel) collection of table names as strings representing all tables which were deleted from the model as part of a model operation. Read-only. |
| TablesModified (Property) | Returns a ModelTableNames Object (Excel) collection of table names as strings representing all tables which were refreshed or recalculated as part of a model operation. Read-only. |
| UnknownChange (Property) | True when a non-specified change was made to the model as part of a model transaction. Boolean Read-only |
| ModelColumnChange (new) | An object representing a column in a table in the Excel data model for which the data type was changed. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| ColumnName (Property) | String representing the name of a column for which the data type was changed. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelColumnChange Object (Excel) object. Read-only. |
| TableName (Property) | String representing the name of a table in the Excel data model for which the data type of a column was changed. Read-only. |
| ModelColumnChanges (new) | A collection of ModelColumnChange Object (Excel) objects representing columns for which the data type was change in the Excel data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of ModelColumnChange Object (Excel) objects in a ModelColumnChanges Object (Excel) object. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the ModelColumnChanges Object (Excel) object. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelColumnChanges Object (Excel) object. Read-only. |
| ModelColumnName (new) | An object representing the name of a column in the data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| ColumnName (Property) | String representing the name of a column of the table identified by the ModelColumnName.TableName Property (Excel) property. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelColumnName Object (Excel) object. Read-only. |
| TableName (Property) | String representing a table name of a table in the data model. Read-only. |
| ModelColumnNames (new) | A collection of ModelColumnName Object (Excel) objects representing columns of tables in the data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of a ModelColumnName Object (Excel) objects in a ModelColumnNames Object (Excel) collection. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the ModelColumnNames Object (Excel) collection. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelColumnNames Object (Excel) object. Read-only. |
| ModelConnection (new) | Contain information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated data model. |
| ADOConnection (Property) | The ADO Connection Object is used to create an open connection to a data source. Enables addins, such as Powerview, to create a direct connection to the engine and hence the data model. ADOConnection object Read-only. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| CommandText (Property) | Returns or sets the command string for the specified data source. Variant Read/Write |
| CommandType (Property) | Returns or sets one of the XlCmdType Enumeration (Excel) constants. Read/Write |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelConnection object. Read-only. |
| ModelMeasureName (new) | An object representing a measure in the data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| MeasureName (Property) | String representing the new name a measure which was added to the ModelTable Object (Excel) identified by the ModelMeasureName.TableName Property (Excel) property. Read-only. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelMeasureName Object (Excel) object. Read-only. |
| TableName (Property) | String representing the name of a table in the model for which a measure was added. Read-only. |
| ModelMeasureNames (new) | A collection of ModelMeasureName Object (Excel) objects representing names of measures in the Excel data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of a ModelMeasureName Object (Excel) objects in a ModelMeasureNames Object (Excel) object. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the ModelMeasureNames Object (Excel) object. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelMeasureNames Object (Excel) object. Read-only. |
| ModelRelationship (new) | Represents a relationship, currently in the data model, between two tables. |
| Active (Property) | When True, the relationship is active. When False, this relationship is inactive. Boolean. Read/Write |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Delete (Method) | Deletes the relationship. |
| ForeignKeyColumn (Property) | Contains the ModelTableColumn Object (Excel) object (Excel) representing the foreign key column on the many side of the one-to-many relationship. Read-only |
| ForeignKeyTable (Property) | Contains the ModelTable Object (Excel) object (Excel) representing the table on the many side of the one-to-many relationship. Read-only |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelRelationship Object (Excel) object. Read-only. |
| PrimaryKeyColumn (Property) | Contains the ModelTableColumn Object (Excel) object (Excel) representing the primary key column in the table on the one side of the one-to-many relationship. |
| PrimaryKeyTable (Property) | Contains the ModelTable Object (Excel) object (Excel) representing the table on the one side of the one-to-many relationship. |
| ModelRelationships (new) | This collection contains all relationships currently between data tables in the data model. |
| Add (Method) | Adds a new relationship to the model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of a ModelRelationship Object (Excel) objects in a ModelRelationships Object (Excel) object. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the ModelRelationships Object (Excel) object. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelRelationships Object (Excel) object. Read-only. |
| ModelTable (new) | Represent a table in the Data Model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| ModelTableColumns (Property) | Collection of ModelTableColumns Object (Excel) that make up the ModelTable. Read-only |
| Name (Property) | Returns a String value that represents the name of the object. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelTable Object (Excel) object. Read-only. |
| RecordCount (Property) | Returns the total row count for the model table. Integer Read-only |
| Refresh (Property) | Refreshes the model table source connections. |
| SourceName (Property) | Name of the data source for the table. If the table has no data source, the call will generate a run-time error. String Read-only |
| SourceWorkbookConnection (Property) | Returns the Workbook Connection from which the model table originated. Read-only |
| ModelTableColumn (new) | Represent a single column inside a ModelTable Object (Excel) object. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| DataType (Property) | Returns the XlParameterDataType Enumeration (Excel) of the ModelTableColumn. Read-only |
| Name (Property) | Returns a String value that represents the name of the object. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelTableColumn Object (Excel) object. Read-only. |
| ModelTableColumns (new) | Represent a ModelTableColumn Object (Excel) collection of single columns inside a ModelTable Object (Excel) object. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of a ModelTableColumn Object (Excel) objects in a ModelTableColumns Object (Excel) object. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a ModelTableColumn Object (Excel) object (Excel) from the ModelTableColumns collection (Excel) |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelTableColumns Object (Excel) object. Read-only. |
| ModelTableNameChange (new) | An object representing the old and new name of a table which was renamed in the Excel data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelTableNameChange Object (Excel) object. Read-only. |
| TableNameNew (Property) | Returns the new name of the table. String Read-only |
| TableNameOld (Property) | Returns the previous name of the table. String Read-only |
| ModelTableNameChanges (new) | A collection of ModelTableNameChange Object (Excel) objects representing table names before and after a table name change in the Excel data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of a ModelTableNameChange Object (Excel) objects in a ModelTableNameChanges Object (Excel) collection. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the ModelTableNameChanges collection. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelTableNameChanges Object (Excel) object. Read-only. |
| ModelTableNames (new) | A collection of table names representing tables in the Excel data model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of objects in a ModelTableNames Object (Excel) collection. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the ModelTableNames collection. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelTableNames Object (Excel) object. Read-only. |
| ModelTables (new) | Collection of model tables inside the Data Model. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Count (Property) | Returns a Long value that represents the number of ModelTable Object (Excel) objects in a ModelTables Object (Excel) collection. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Item (Method) | Returns a single object from the ModelTables collection. |
| Parent (Property) | Returns an Object that represents the parent object of the specified ModelTables Object (Excel) object. Read-only. |
| PivotCache | |
| CreatePivotChart (Property) | Creates a standalone PivotChart from a PivotCache Object (Excel) object. A Shape Object (Excel) object is returned. |
| PivotCell | |
| ServerActions (Property) | Represents a collection of actions consisting of OLAP-defined actions which can be executed. The actions are specific to Pivot Tables existing at a worksheet-level. Read-only |
| PivotFilter | |
| WholeDayFilter (Property) | Sets or gets the filtering semantics for date filters. Boolean. Read/Write |
| PivotLine | |
| PivotLineCellsFull (Property) | Retrieves all of the PivotLine cells including those that are hidden in compact form. Read-only |
| PivotLineCells | |
| Full (Property) | When True, all of the PivotLineCells in the PivotLine (including those that are hidden in compact form) are retrieved. Boolean Read-only |
| PivotTable | |
| DrillDown (Property) | Enables you to drill down into the data within an OLAP or PowerPivot based cube hierarchy. |
| DrillTo (Property) | Enables you to drill to a location within an OLAP or PowerPivot based cube hierarchy. |
| DrillUp (Property) | Enables you to drill up into the data within an OLAP or PowerPivot based cube hierarchy. |
| Hidden (Property) | Checks whether the Pivot Table exists at the worksheet level. Boolean. Read-only |
| PivotChart (Property) | Returns a Shape Object (Excel) object that represents the standalone PivotChart for the specified hidden Pivot Table report. Read-only. |
| PivotValueCell (Property) | Retrieve the PivotValueCell Object (Excel) object for a given PivotTable provided certain row and column indices. |
| PivotValueCell (new) | Provides a way to expose values of cells in the case that actual cells (Range objects) are not available. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Parent (Property) | Returns an Object that represents the parent object of the specified PivotValueCell Object (Excel) object. Read-only. |
| PivotCell (Property) | Returns the PivotCell Object (Excel) that specifies the location of the PivotValueCell. Read-only |
| ServerActions (Property) | Returns a collection of OLAP Action name objects which will represent OLAP-defined actions which can be executed. Read-only |
| ShowDetail (Property) | Puts the individual rows of an OLAP data source which contribute to an aggregate onto their own Excel worksheet. |
| Value (Property) | Returns the value at the location. The value is the value after ShowAs and other calculations have been applied. Variant can be Empty, Number, Date, String, or Error value. |
| QuickAnalysis (new) | Object that enables single-click access to data analysis features such as formulas, conditional formatting, sparklines, tables, charts, and PivotTables. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Hide (Method) | Hides specific members of the Analysis Lens user interface. |
| Parent (Property) | Returns an Object that represents the parent object of the specified QuickAnalysis Object (Excel) object. Read-only. |
| Show (Property) | Displays specific members of the Analysis Lens user interface. |
| Range | |
| FlashFill (Property) | TRUE indicates that the Excel Flash Fill feature has been enabled and active. |
| Series | |
| IsFiltered (Property) | This setting controls whether the series has been filtered out from the chart. The default value is False. Boolean Read/Write. |
| Shapes | |
| AddChart2 (Property) | Adds a chart to the document. Returns a Shape object that represents a chart and adds it to the specified collection. |
| Sheets | |
| Add2 (Method) | This method is only implemented for the Charts collection object and will produce a run time error if used on the Sheets and Worksheets objects. |
| Slicer | |
| SlicerCacheType (Property) | Returns the type of the slicer cache - slicer or timeline. XlSlicerCacheType Read-only |
| TimelineViewState (Property) | The timeline-specific state of the Slicer. TimelineViewState Read-only |
| SlicerCache | |
| ClearAllFilters (Property) | Clears the filter for either slicer or timeline, depending on the slicer cache type. |
| ClearDateFilter (Property) | Clears the filter for a timeline (date filter). |
| FilterCleared (Property) | Returns whether the slicer or timeline filter state is cleared. Boolean. Read-only |
| List (Property) | True if the slicer cache is for a slicer on a table. False otherwise. Boolean Read-only |
| ListObject (Property) | Returns a ListObject object for the QueryTable Object (Excel) object. Read-only |
| RequireManualUpdate (Property) | True when manual updates of the slicer cache required. Boolean Read/Write |
| SlicerCacheType (Property) | Returns the type of the slicer cache - slicer or timeline. Read-only |
| TimelineState (Property) | The timeline-specific state of the SlicerCache object. Read-only |
| TableObject (new) | Represents a worksheet table built from data returned from a PowerPivot model. |
| AdjustColumnWidth (Property) | Specifies if the column widths are automatically adjusted for the best fit each time you refresh the specified query table. The default value is True. Boolean Read/Write |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Delete (Method) | Deletes the TableObject object. |
| Destination (Property) | Returns the cell in the upper-left corner of the query table destination range (the range where the resulting query table will be placed). The destination range must be on the worksheet that contains the TableObject object. Range. Read-only |
| EnableEditing (Property) | True if the user can edit the specified query table. False if the user can only refresh the query table. Boolean Read/Write |
| EnableRefresh (Property) | Specifies if the query table can be refreshed by the user. Boolean Read/Write |
| FetchedRowOverflow (Property) | Specifies if the number of rows returned by the last use of the Refresh method is greater than the number of rows available on the worksheet. Boolean Read-only |
| ListObject (Property) | Returns a ListObject Object (Excel) object for the TableObject Object (Excel) object. Read-only |
| Parent (Property) | Returns an Object that represents the parent object of the specified TableObject Object (Excel) object. Read-only. |
| PreserveColumnInfo (Property) | Specifies if column sorting, filtering, and layout information is preserved whenever a query table is refreshed. The default value is False. Boolean Read/Write |
| PreserveFormatting (Property) | True if any formatting common to the first five rows of data are applied to new rows of data in the query table. Unused cells aren't formatted. The property is False if the last AutoFormat applied to the query table is applied to new rows of data. The default value is True. Boolean Read/Write |
| Refresh (Method) | This method updates the TableObject object. |
| RefreshStyle (Property) | Returns or sets the way rows on the specified worksheet are added or deleted to accommodate the number of rows in a record set returned by a query. XlCellInsertionMode Enumeration (Excel) Read/Write |
| ResultRange (Property) | Returns a Range Object (Excel) object that represents the area of the worksheet occupied by the specified query table. Read-only |
| RowNumbers (Property) | Specifies if row numbers are added as the first column of the specified query table. Boolean Read/Write |
| WorkbookConnection (Property) | Returns the WorkbookConnection Object (Excel) used by the TableObject for connecting to the model. The WorkbookConnection.ModelConnection Property (Excel) property on the WorkbookConnection object can then be used to get to and edit DAX etc. Read-only |
| TableStyle | |
| ShowAsAvailableTimelineStyle | Returns or sets whether the specified table style is shown as available in the timeline styles gallery. Boolean. Read/write |
| TextConnection (new) | Contains Service Contract settings that enable Microsoft Excel to connect to a Data Feed data source. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Connection (Property) | Returns or sets a string that contains text file names that enable Microsoft Excel to connect to text data sources. Variant Read/Write |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Parent (Property) | Returns an Object that represents the parent object of the specified TextConnection Object (Excel) object. Read-only. |
| TextFileColumnDataTypes (Property) | Returns or sets an ordered array of constants that specify the data types applied to the corresponding columns in the text file that you're importing into a query table. The default constant for each column is xlGeneral. Variant. Read/Write |
| TextFileCommaDelimiter (Property) | True if the comma is the delimiter when you import a text file into a query table. False if you want to use some other character as the delimiter. The default value is False. Read/Write Boolean. |
| TextFileConsecutiveDelimiter (Property) | True if consecutive delimiters are treated as a single delimiter when you import a text file into a query table. The default value is False. Boolean Read/Write |
| TextFileDecimalSeparator (Property) | Returns or sets the decimal separator character that Microsoft Excel uses when you import a text file into a query table. The default is the system decimal separator character. Read/Write String. |
| TextFileFixedColumnWidths (Property) | Returns or sets an array of integers that correspond to the widths of the columns (in characters) in the text file that you're importing into a query table. Valid widths are from 1 through 32767 characters. Read/Write Variant. |
| TextFileHeaderRow (Property) | Returns or sets value that specifies whether or not the first row (from the starting row) should be treated as a header row. Boolean Read/Write |
| TextFileOtherDelimiter (Property) | Returns or sets the character used as the delimiter when you import a text file into a query table. The default value is null. Read/Write String. |
| TextFileParseType (Property) | Returns or sets the column format for the data in the text file that you're importing into a query table. Read/Write XlTextParsingType Enumeration (Excel) |
| TextFilePlatform (Property) | Returns or sets the origin of the text file you're importing into the query table. This property determines which code page is used during the data import. Read/write XlPlatform Enumeration (Excel) |
| TextFilePromptOnRefresh (Property) | True if you want to specify the name of the imported text file each time the query table is refreshed. The Import Text File dialog box allows you to specify the path and file name. The default value is False. Read/Write Boolean. |
| TextFileSemicolonDelimiter (Property) | True if the semicolon is the delimiter when you import a text file into a query table, and if the value of the TextConnection.TextFileParseType Property (Excel) property is xlDelimited. The default value is False. Read/Write Boolean. |
| TextFileSpaceDelimiter (Property) | True if the space character is the delimiter when you import a text file into a query table. The default value is False. Read/Write Boolean |
| TextFileStartRow (Property) | Returns or sets the row number at which text parsing will begin when you import a text file into a query table. Valid values are integers from 1 through 32767. The default value is 1. Read/Write Long. |
| TextFileTabDelimiter (Property) | True if the tab character is the delimiter when you import a text file into a query table. The default value is False. Read/Write Boolean |
| TextFileTextQualifier (Property) | Returns or sets the text qualifier when you import a text file into a query table. The text qualifier specifies that the enclosed data is in text format. Read/Write XlTextQualifier Enumeration (Excel) |
| TextFileThousandsSeparator (Property) | Returns or sets the thousands separator character that Microsoft Excel uses when you import a text file into a query table. The default is the system thousands separator character. Read/Write String |
| TextFileTrailingMinusNumbers (Property) | True for Microsoft Excel to treat numbers imported as text that begin with a "-" symbol as a negative symbol. False for Excel to treat numbers imported as text that begin with a "-" symbol as text. Read/Write Boolean |
| TextFileVisualLayout (Property) | Returns or sets a XlTextVisualLayoutType Enumeration (Excel) enumeration that indicates whether the visual layout of the text being imported is left-to-right or right-to-left. Read/Write |
| TimelineState (new) | The timeline-specific state of a SlicerCache Object (Excel) object. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| EndDate (Property) | Returns the end of the filtering date range (equals to TimelineState.StartDate Property (Excel) if range is a single day). Variant Read-only |
| FilterType (Property) | Returns the type of the date filter. XlPivotFilterType Enumeration (Excel) Read-only |
| FilterValue1 (Property) | Returns the 1st value associated with the date filter (semantics vary by filter type). Variant Read-only |
| FilterValue2 (Property) | Returns the 2nd value associated with the date filter (semantics vary by filter type). Variant Read-only |
| Parent (Property) | Returns an Object that represents the parent object of the specified TimelineState Object (Excel) object. Read-only. |
| SetFilterDateRange (Property) | Sets the Timeline's filter. |
| SingleRangeFilterState (Property) | True when the filtering state is a contiguous date range; False otherwise. Boolean Read-only |
| StartDate (Property) | Returns the start of the filtering date range. Variant Read-only |
| TimelineViewState (new) | Represents the Timeline-specific members of a Slicer view. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Level (Property) | Get or set the displayed level. XlTimelineLevel Enumeration (Excel) Read/Write |
| Parent (Property) | Returns an Object that represents the parent object of the specified TimelineViewState Object (Excel) object. Read-only. |
| ShowHeader (Property) | Get or set whether the control's header is displayed. Boolean Read/Write |
| ShowHorizontalScrollbar (Property) | Get or set whether the control's horizontal scrollbar is displayed. Boolean Read/Write |
| ShowSelectionLabel (Property) | Get or set whether the control's filter selection label is displayed. Boolean Read/Write |
| ShowTimeLevel (Property) | Get or set whether the control's time level drop-down is displayed. Boolean Read/Write |
| Window | |
| Hwnd (Property) | Returns a Long that indicates the window handle of the specified window. Read-only. |
| Workbook | |
| CaseSensitive (Property) | True if the workbook distinguishes between upper and lower case when comparing content. Read-only Boolean |
| ChartDataPointTrack (Property) | True will cause all charts in the current document to track the actual data point to which it's attached. False will revert back to tracking the index of the data point. Boolean Read/Write |
| DefaultTimelineStyle (Property) | The name of the default slicer style of the workbook. Variant. Read/Write |
| Model (Property) | Returns the top level Model object which is the one Data Model for the workbook. Read-only |
| PivotTables (Property) | Returns an object that represents a collection of all the PivotTable reports on a worksheet. Read-only. |
| UseWholeCellCriteria (Property) | True if the workbook uses search patterns that match the entire content of a cell. Read-only Boolean. |
| UseWildcards (Property) | True if the workbook enables wildcards for character string comparisons and searching. Read-only Boolean |
| WorkbookConnection | |
| DataFeedConnection (Property) | Returns a DataFeedConnection object that contains the data and functionality needed to connect to data feeds. Read-only |
| InModel (Property) | Specifies whether or not the WorkbookConnection Object (Excel) has been added to the model. Boolean Read-only |
| ModelConnection (Property) | Returns an object that contains information for the new Model Connection Type introduced in Excel 2013 to interact with the integrated Data Model. Read-only |
| ModelTables (Property) | Returns a ModelTables Object (Excel) object associated with the particular connection. Read-only |
| RefreshWithRefreshAll (Property) | Determines if the connection should be refreshed when refresh all is executed. Boolean. Read/Write |
| TextConnection (Property) | Returns a TextConnection Object (Excel) object that contains the information on a query to a text file. Read-only |
| WorksheetDataConnection (Property) | Returns an object that contains information for a connection from the PowerPivot Model to data within the workbook such as a range, named range, or table. Read-only |
| WorksheetDataConnection (new) | Used to import data into the Data Model from data on the worksheet such as ranges and tables. |
| Application (Property) | Returns an Application object that represents the Microsoft Excel application. Read-only. |
| CommandText (Property) | Returns or sets the command string for the specified data source. Variant Read/Write |
| CommandType (Property) | Returns or sets one of the XlCmdType Enumeration (Excel) constants. For a WorksheetDataConnection object, this type will be set to xlCmdExcel. |
| Connection (Property) | Returns the internal connection string to the object in Excel. Variant Read-only |
| Creator (Property) | Returns a 32-bit integer that indicates the application in which the specified object was created. Read-only Long. |
| Parent (Property) | Returns an Object that represents the parent object of the specified WorksheetDataConnection Object (Excel) object. Read-only. |
| WorksheetFunction | |
| Acot (Method) | Returns the arc-cotangent of a number, in radians in the range 0 to Pi. |
| Acoth (Method) | Returns the inverse hyperbolic cotangent of a number. |
| Arabic (Method) | Converts a Roman numeral to an Arabic numeral. |
| Base (Method) | Converts a number into a text representation with the given radix (base). |
| Binom_Dist_Range (Method) | Returns the probability of a trial result using a binomial distribution. |
| Bitand (Method) | Returns a Bitwise And of two numbers |
| Bitlshift (Method) | Returns a value number shifted left by shift_amount bits. |
| Bitor (Method) | Returns a bitwise OR of 2 numbers. |
| Bitrshift (Method) | Returns a value number shifted right by shift_amount bits. |
| Bitxor (Method) | Returns a bitwise 'Exclusive Or' of two numbers. |
| Ceiling_Math (Method) | Rounds a number up, to the nearest integer or to the nearest multiple of significance. |
| Combina (Method) | Returns the number of combinations with repetitions for a given number of items. |
| Cot (Method) | Returns the cotangent of an angle. |
| Coth (Method) | Returns the hyperbolic cotangent of a number |
| Csc (Method) | Returns the cosecant of an angle. |
| Csch (Method) | Returns the hyperbolic cosecant of an angle. |
| Days (Method) | Returns the number of days between the two dates. |
| Decimal (Method) | Converts a text representation of a number in a given base into a decimal number. |
| EncodeURL (Method) | URL encodes the argument. |
| FilterXML (Method) | Get specific data from the returned XML, typically from a WebService function call. |
| Floor_Math (Method) | Rounds a number down, to the nearest integer or to the nearest multiple of significance. |
| Gamma (Method) | Returns the Gamma function value. |
| Gauss (Method) | Returns 0.5 less than the standard normal cumulative distribution. |
| IfNa (Method) | Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression. |
| ImCosh (Method) | Returns the hyperbolic cosine of a complex number. |
| ImCot (Method) | Returns the cotangent of a complex number. |
| ImCsc (Method) | Returns the cosecant of a complex number. |
| ImCsch (Method) | Returns the hyperbolic cosecant of a complex number. |
| ImSec (Method) | Returns the secant of a complex number. |
| ImSech (Method) | Returns the hyperbolic secant of a complex number. |
| ImSinh (Method) | Returns the hyperbolic sine of a complex number. |
| ImTan (Method) | Returns the tangent of a complex number. |
| IsFormula (Method) | Added in 2013 |
| IsoWeekNum (Method) | Returns the ISO week number of the year for a given date. |
| Munit (Method) | Returns the unit matrix for the specified dimension. |
| NumberValue (Method) | Converts text to number in a locale-independent manner. |
| PDuration (Method) | Returns the number of periods required by an investment to reach a specified value. |
| Permutationa (Method) | Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects. |
| Phi (Method) | Returns the value of the density function for a standard normal distribution. |
| Rri (Method) | Returns an equivalent interest rate for the growth of an investment. |
| Sec (Method) | Returns the secant of an angle. |
| Sech (Method) | Returns the hyperbolic secant of an angle. |
| Skew_p (Method) | Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean. |
| Unichar (Method) | Returns the Unicode character referenced by the given numeric value. |
| Unicode (Method) | Returns the number (code point) corresponding to the first character of the text. |
| WebService (Method) | Underlying function that calls the web service asynchronously, using an HTTP GET request, and returns the response. |
| Xor (Method) | Returns a logical exclusive OR of all arguments. |
| Worksheets | |
| Add2 (Property) | This method is only implemented for the Charts collection object and will produce a run time error if used on the Sheets and Worksheets objects. |
Events
To see a list of all the events, please refer to the Events page.
| Application | |
| SheetBeforeDelete | Occurs before any sheet is deleted. |
| SheetLensGalleryRenderComplete | Occurs after a callout gallery?s icons (dynamic & static) have finished rendering. |
| SheetTableUpdate | Occurs after the sheet of the PivotTable report has been updated. |
| WorkbookModelChange | Occurs when the data model is updated. |
| Workbook | |
| ModelChange | Occurs after the Excel data model is changed. |
| SheetBeforeDelete | Occurs when any sheet is deleted. |
| SheetLensGalleryRenderComplete | Occurs when a callout gallery's icons (dynamic & static) have completed rendering for a worksheet. |
| SheetTableUpdate | Occurs after the sheet table has been updated. |
| Worksheet | |
| BeforeDelete | Occurs before the worksheet is deleted. |
| LensGalleryRenderComplete | Occurs when a callout gallery's icons (dynamic & static) have completed rendering. |
| TableUpdate | Occurs after a Query table connected to the Data Model is updated on a worksheet. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext