This project has moved and is read-only. For the latest updates, please go here.

This table shows you all new excel 2013 properties and methods for existing types(means the types already exists in excel 2012 and further). Please scroll down for enum info. A list with all the completely new 2013 types and enums is available in my blog.

Name

Method

Properties

Excel._Chart
FullSeriesCollection CategoryLabelLevel
DeleteHiddenContent SeriesNameLevel
ClearToMatchColorStyle HasHiddenContent
ChartColor
Excel.Sheets
Add2
Excel.CubeFields
GetMeasure
Excel.AppEvents / Excel.IAppEvents
SheetLensGalleryRenderComplete
SheetTableUpdate
WorkbookModelChange
SheetBeforeDelete
Excel.WorksheetFunction / Excel:IWorksheetFunction
Acot
Acoth
Cot
Coth
Csc
Csch
Sec
Sech
ImCot
ImTan
ImCsc
ImCsch
ImSec
ImSech
Bitand
Bitor
Bitxor
Bitlshift
Bitrshift
Xor
Combina
Permutationa
PDuration
Base
Decimal
Days
Binom_Dist_Range
Gamma
Gauss
Phi
Skew_p
Rri
Unichar
Unicode
Munit
Arabic
IsoWeekNum
NumberValue
IsFormula
IfNa
Ceiling_Math
Floor_Math
ImSinh
ImCosh
FilterXML
WebService
EncodeURL
Excel.Range / Excel.IRange
FlashFill
Excel.DocEvents / Excel.IDocEvents
LensGalleryRenderComplete
TableUpdate
BeforeDelete
Excel.WorkbookEvents / Excel.IWorkbookEvents
SheetLensGalleryRenderComplete
SheetTableUpdate
ModelChange
SheetBeforeDelete
Excel.Charts / IExcel.Charts
Add2
Excel.PivotCache
CreatePivotChart
Excel.PivotTable / Excel.IPivotTable
PivotValueCell Hidden
DrillDown PivotChart
DrillUp
DrillTo
Dummy2
Excel.Modules / IExcel.Modules
Add2
Excel.DialogSheets / Excel.IDialogSheets
Add2
Excel.Worksheets / Excel.IWorksheets
Add2
Excel.ChartGroup / Excel.IChartGroup
FullCategoryCollection
CategoryCollection
Excel.DataLabels / Excel.IDataLabels
Propagate ShowRange
Excel.Shapes / Excel.IShapes
AddChart2
Excel.CalculatedMembers / Excel.ICalculatedMembers
AddCalculatedMember
Excel.PivotFilters / Excel.IPivotFilters
_Add WholeDayFilter
MovingPeriod
Excel.Connections / Excel.IConnections
_AddFromFile
_Add
Excel.SlicerCaches / Excel.ISlicerCaches
_Add TimelineState
ClearAllFilters SlicerCacheType
ClearDateFilter FilterCleared
List
RequireManualUpdate
ListObject
TimelineViewState
SlicerCacheType
Excel._Application
ShowQuickAnalysis
QuickAnalysis
FlashFill
EnableMacroAnimations
ChartDataPointTrack
FlashFillMode
MergeInstances
Excel._Workbook
CaseSensitive
UseWholeCellCriteria
UseWildcards
PivotTables
Model
ChartDataPointTrack
DefaultTimelineStyle
Excel.Window / IExcel.Window
Hwnd
Excel.Series
IsFiltered
Excel.DataLabel / Excel.IDataLabel
_Height
_Width
ShowRange
Excel.CalculatedMember / IExcel.CalculatedMember
MeasureGroup
ParentHierarchy
ParentMember
NumberFormat
Excel.PivotCell / Excel.IPivotCell
ServerActions
Excel.ListObject / Excel.IListObject
TableObject
Slicers
ShowAutoFilterDropDown
Excel.PivotLineCells / Excel.IPivotLineCells
Full
Excel.PivotLine / Excel.IPivotLine
PivotLineCellsFull
Excel.WorkbookConnection/ Excel.IWorkbookConnection
ModelConnection
WorksheetDataConnection
RefreshWithRefreshAll
TextConnection
DataFeedConnection
InModel
ModelTables
Excel.TableStyle / Excel.ITableStyle
ShowAsAvailableTimelineStyle
Excel.ChartFormat / Excel.IChartFormat
Adjustments
AutoShapeType


Enum Table

Enum

Member

Excel.XlConsolidationFunction
xlDistinctCount
Excel.XlAutoFillType
xlFlashFill
Excel.XlFileFormat
xlOpenXMLStrictWorkbook
Excel.XlBuiltInDialog
xlDialogManageRelationships
xlDialogCreateRelationship
xlDialogRecommendedPivotTables
Excel.XlCmdType
xlCmdTableCollection
xlCmdExcel
xlCmdDAX
Excel.XlPivotTableVersionList
xlPivotTableVersion15
Excel.XlCalculatedMemberType
xlCalculatedMeasure
Excel.XlListObjectSourceType
xlSrcModel
Excel.XlRemoveDocInfoType
xlRDIInlineWebExtensions
xlRDITaskpaneWebExtensions
xlRDIExcelDataModel
Excel.XlConnectionType
xlConnectionTypeDATAFEED
xlConnectionTypeMODEL
xlConnectionTypeWORKSHEET
xlConnectionTypeNOSOURCE
Excel.XlCubeFieldSubType
xlCubeImplicitMeasure
Excel.XlTableStyleElementType
xlTimelineSelectionLabel
xlTimelineTimeLevel
xlTimelinePeriodLabels1
xlTimelinePeriodLabels2
xlTimelineSelectedTimeBlock
xlTimelineUnselectedTimeBlock
xlTimelineSelectedTimeBlockSpace
Excel.XlSlicerCrossFilterType
xlSlicerCrossFilterHideButtonsWithNoData

Last edited Jul 21, 2012 at 5:29 PM by SebastianDotNet, version 7

Comments

No comments yet.