Excel对象常量和对应值
Excel对象常量和对应值.txtゅ你不用一上线看见莪在线，就急着隐身，放心。莪不会去缠你。说好的不离不弃 现在反而自己却做不到╮ Excel对象操作的所有常量和对应值
XlFormatConditionOperator
常量 值
xlBetween 1
xlEqual 3
xlGreater 5
xlGreaterEqual 7
xlLess 6
xlLessEqual 8
xlNotBetween 2
xlNotEqual 4
XlFormatConditionType
常量 值
xlCellValue 1
xlExpression 2
XlFormControl
常量 值
xlButtonControl 0
xlCheckBox 1
xlDropDown 2
xlEditBox 3
xlGroupBox 4
xlLabel 5
xlListBox 6
xlOptionButton 7
xlScrollBar 8
xlSpinner 9
XlFormulaLabel
常量 值
xlColumnLabels 2
xlMixedLabels 3
xlNoLabels -4142
xlRowLabels 1
XlHAlign
常量 值
xlHAlignCenter -4108
xlHAlignCenterAcrossSelection 7
xlHAlignDistributed -4117
xlHAlignFill 5
xlHAlignGeneral 1
xlHAlignJustify -4130
xlHAlignLeft -4131
xlHAlignRight -4152
XlHebrewModes
常量 值
xlHebrewFullScript 0
xlHebrewMixedAuthorizedScript 3
xlHebrewMixedScript 2
xlHebrewPartialScript 1
XlHighlightChangesTime
常量 值
xlAllChanges 2
xlNotYetReviewed 3
xlSinceMyLastSave 1
XlHtmlType
常量 值
xlHtmlCalc 1
xlHtmlChart 3
xlHtmlList 2
xlHtmlStatic 0
XlIMEMode
常量 值
xlIMEModeAlpha 8
xlIMEModeAlphaFull 7
xlIMEModeDisable 3
xlIMEModeHangul 10
xlIMEModeHangulFull 9
xlIMEModeHiragana 4
xlIMEModeKatakana 5
xlIMEModeKatakanaHalf 6
xlIMEModeNoControl 0
xlIMEModeOff 2
xlIMEModeOn 1
XlImportDataAs
常量 值
xlPivotTableReport 1
xlQueryTable 0
XlInsertFormatOrigin
常量 值
xlFormatFromLeftOrAbove 0
xlFormatFromRightOrBelow 1
XlInsertShiftDirection
常量 值
xlShiftDown -4121
xlShiftToRight -4161
XlLayoutFormType
常量 值
xlOutline 1
xlTabular 0
XlLegendPosition
常量 值
xlLegendPositionBottom -4107
xlLegendPositionCorner 2
xlLegendPositionLeft -4131
xlLegendPositionRight -4152
xlLegendPositionTop -4160
XlLineStyle
常量 值
xlContinuous 1
xlDash -4115
xlDashDot 4
xlDashDotDot 5
xlDot -4118
xlDouble -4119
xlLineStyleNone -4142
xlSlantDashDot 13
XlLink
常量 值
xlExcelLinks 1
xlOLELinks 2
xlPublishers 5
xlSubscribers 6
XlLinkInfo
常量 值
xlEditionDate 2
xlLinkInfoStatus 3
xlUpdateState 1
XlLinkInfoType
常量 值
xlLinkInfoOLELinks 2
xlLinkInfoPublishers 5
xlLinkInfoSubscribers 6
XlLinkStatus
常量 值
xlLinkStatusCopiedValues 10
xlLinkStatusIndeterminate 5
xlLinkStatusInvalidName 7
xlLinkStatusMissingFile 1
xlLinkStatusMissingSheet 2
xlLinkStatusNotStarted 6
xlLinkStatusOK 0
xlLinkStatusOld 3
xlLinkStatusSourceNotCalculated 4
xlLinkStatusSourceNotOpen 8
xlLinkStatusSourceOpen 9
XlLinkType
常量 值
xlLinkTypeExcelLinks 1
xlLinkTypeOLELinks 2
XlListConflict
常量 值
xlListConflictDialog 0
xlListConflictDiscardAllConflicts 2
xlListConflictError 3
xlListConflictRetryAllConflicts 1
XlListDataType
常量 值
xlListDataTypeCheckbox 9
xlListDataTypeChoice 6
xlListDataTypeChoiceMulti 7
xlListDataTypeCounter 11
xlListDataTypeCurrency 4
xlListDataTypeDateTime 5
xlListDataTypeHyperLink 10
xlListDataTypeListLookup 8
xlListDataTypeMultiLineRichText 12
xlListDataTypeMultiLineText 2
xlListDataTypeNone 0
xlListDataTypeNumber 3
xlListDataTypeText 1
XlListObjectSourceType
常量 值
xlSrcExternal 0
xlSrcRange 1
xlSrcXml 2
XlLocationInTable
常量 值
xlColumnHeader -4110
xlColumnItem 5
xlDataHeader 3
xlDataItem 7
xlPageHeader 2
xlPageItem 6
xlRowHeader -4153
xlRowItem 4
xlTableBody 8
XlLookAt
常量 值
xlPart 2
xlWhole 1
XlMailSystem
常量 值
xlMAPI 1
xlNoMailSystem 0
xlPowerTalk 2
XlMarkerStyle
常量 值
xlMarkerStyleAutomatic -4105
xlMarkerStyleCircle 8
xlMarkerStyleDash -4115
xlMarkerStyleDiamond 2
xlMarkerStyleDot -4118
xlMarkerStyleNone -4142
xlMarkerStylePicture -4147
xlMarkerStylePlus 9
xlMarkerStyleSquare 1
xlMarkerStyleStar 5
xlMarkerStyleTriangle 3
xlMarkerStyleX -4168
XlMouseButton
常量 值
xlNoButton 0
xlPrimaryButton 1
xlSecondaryButton 2
XlMousePointer
常量 值
xlDefault -4143
xlIBeam 3
xlNorthwestArrow 1
xlWait 2
XlMSApplication
常量 值
xlMicrosoftAccess 4
xlMicrosoftFoxPro 5
xlMicrosoftMail 3
xlMicrosoftPowerPoint 2
xlMicrosoftProject 6
xlMicrosoftSchedulePlus 7
xlMicrosoftWord 1
XlObjectSize
常量 值
xlFitToPage 2
xlFullPage 3
xlScreenSize 1
XlOLEType
常量 值
xlOLEControl 2
xlOLEEmbed 1
xlOLELink 0
XlOLEVerb
常量 值
xlVerbOpen 2
xlVerbPrimary 1
XlOrder
常量 值
xlDownThenOver 1
xlOverThenDown 2
XlOrientation
常量 值
xlDownward -4170
xlHorizontal -4128
xlUpward -4171
xlVertical -4166
XlPageBreak
常量 值
xlPageBreakAutomatic -4105
xlPageBreakManual -4135
xlPageBreakNone -4142
XlPageBreakExtent
常量 值
xlPageBreakFull 1
xlPageBreakPartial 2
XlPageOrientation
常量 值
xlLandscape 2
xlPortrait 1
XlPaperSize
常量 值
xlPaper10x14 16
xlPaper11x17 17
xlPaperA3 8
xlPaperA4 9
xlPaperA4Small 10
xlPaperA5 11
xlPaperB4 12
xlPaperB5 13
xlPaperCsheet 24
xlPaperDsheet 25
xlPaperEnvelope10 20
xlPaperEnvelope11 21
xlPaperEnvelope12 22
xlPaperEnvelope14 23
xlPaperEnvelope9 19
xlPaperEnvelopeB4 33
xlPaperEnvelopeB5 34
xlPaperEnvelopeB6 35
xlPaperEnvelopeC3 29
xlPaperEnvelopeC4 30
xlPaperEnvelopeC5 28
xlPaperEnvelopeC6 31
xlPaperEnvelopeC65 32
xlPaperEnvelopeDL 27
xlPaperEnvelopeItaly 36
xlPaperEnvelopeMonarch 37
xlPaperEnvelopePersonal 38
xlPaperEsheet 26
xlPaperExecutive 7
xlPaperFanfoldLegalGerman 41
xlPaperFanfoldStdGerman 40
xlPaperFanfoldUS 39
xlPaperFolio 14
xlPaperLedger 4
xlPaperLegal 5
xlPaperLetter 1
xlPaperLetterSmall 2
xlPaperNote 18
xlPaperQuarto 15
xlPaperStatement 6
xlPaperTabloid 3
xlPaperUser 256
XlParameterDataType
常量 值
xlParamTypeBigInt -5
xlParamTypeBinary -2
xlParamTypeBit -7
xlParamTypeChar 1
xlParamTypeDate 9
xlParamTypeDecimal 3
xlParamTypeDouble 8
xlParamTypeFloat 6
xlParamTypeInteger 4
xlParamTypeLongVarBinary -4
xlParamTypeLongVarChar -1
xlParamTypeNumeric 2
xlParamTypeReal 7
xlParamTypeSmallInt 5
xlParamTypeTime 10
xlParamTypeTimestamp 11
xlParamTypeTinyInt -6
xlParamTypeUnknown 0
xlParamTypeVarBinary -3
xlParamTypeVarChar 12
xlParamTypeWChar -8
XlParameterType
常量 值
xlConstant 1
xlPrompt 0
xlRange 2
XlPasteSpecialOperation
常量 值
xlPasteSpecialOperationAdd 2
xlPasteSpecialOperationDivide 5
xlPasteSpecialOperationMultiply 4
xlPasteSpecialOperationNone -4142
xlPasteSpecialOperationSubtract 3
XlPasteType
常量 值
xlPasteAll -4104
xlPasteAllExceptBorders 7
xlPasteColumnWidths 8
xlPasteComments -4144
xlPasteFormats -4122
xlPasteFormulas -4123
xlPasteFormulasAndNumberFormats 11
xlPasteValidation 6
xlPasteValues -4163
xlPasteValuesAndNumberFormats 12
XlPattern
常量 值
xlPatternAutomatic -4105
xlPatternChecker 9
xlPatternCrissCross 16
xlPatternDown -4121
xlPatternGray16 17
xlPatternGray25 -4124
xlPatternGray50 -4125
xlPatternGray75 -4126
xlPatternGray8 18
xlPatternGrid 15
xlPatternHorizontal -4128
xlPatternLightDown 13
xlPatternLightHorizontal 11
xlPatternLightUp 14
xlPatternLightVertical 12
xlPatternNone -4142
xlPatternSemiGray75 10
xlPatternSolid 1
xlPatternUp -4162
xlPatternVertical -4166
XlPhoneticAlignment
常量 值
xlPhoneticAlignCenter 2
xlPhoneticAlignDistributed 3
xlPhoneticAlignLeft 1
xlPhoneticAlignNoControl 0
XlPhoneticCharacterType
常量 值
xlHiragana 2
xlKatakana 1
xlKatakanaHalf 0
xlNoConversion 3
XlPictureAppearance
常量 值
xlPrinter 2
xlScreen 1
XlPictureConvertorType
常量 值
xlBMP 1
xlCGM 7
xlDRW 4
xlDXF 5
xlEPS 8
xlHGL 6
xlPCT 13
xlPCX 10
xlPIC 11
xlPLT 12
xlTIF 9
xlWMF 2
xlWPG 3
XlPivotCellType
常量 值
xlPivotCellBlankCell 9
xlPivotCellCustomSubtotal 7
xlPivotCellDataField 4
xlPivotCellDataPivotField 8
xlPivotCellGrandTotal 3
xlPivotCellPageFieldItem 6
xlPivotCellPivotField 5
xlPivotCellPivotItem 1
xlPivotCellSubtotal 2
xlPivotCellValue 0
XlPivotFieldCalculation
常量 值
xlDifferenceFrom 2
xlIndex 9
xlNoAdditionalCalculation -4143
xlPercentDifferenceFrom 4
xlPercentOf 3
xlPercentOfColumn 7
xlPercentOfRow 6
xlPercentOfTotal 8
xlRunningTotal 5
XlPivotFieldDataType
常量 值
xlDate 2
xlNumber -4145
xlText -4158
XlPivotFieldOrientation
常量 值
xlColumnField 2
xlDataField 4
xlHidden 0
xlPageField 3
xlRowField 1
XlPivotFormatType
常量 值
xlPTClassic 20
xlPTNone 21
xlReport1 0
xlReport10 9
xlReport2 1
xlReport3 2
xlReport4 3
xlReport5 4
xlReport6 5
xlReport7 6
xlReport8 7
xlReport9 8
xlTable1 10
xlTable10 19
xlTable2 11
xlTable3 12
xlTable4 13
xlTable5 14
xlTable6 15
xlTable7 16
xlTa
ble8 17
xlTable9 18
XlPivotTableMissingItems
常量 值
xlMissingItemsDefault -1
xlMissingItemsMax 32500
xlMissingItemsNone 0
XlPivotTableSourceType
常量 值
xlConsolidation 3
xlDatabase 1
xlExternal 2
xlPivotTable -4148
xlScenario 4
XlPivotTableVersionList
常量 值
xlPivotTableVersion10 1
xlPivotTableVersion2000 0
xlPivotTableVersionCurrent -1
XlPlacement
常量 值
xlFreeFloating 3
xlMove 2
xlMoveAndSize 1
XlPlatform
常量 值
xlMacintosh 1
xlMSDOS 3
xlWindows 2
XlPrintErrors
常量 值
xlPrintErrorsBlank 1
xlPrintErrorsDash 2
xlPrintErrorsDisplayed 0
xlPrintErrorsNA 3
XlPrintLocation
常量 值
xlPrintInPlace 16
xlPrintNoComments -4142
xlPrintSheetEnd 1
XlPriority
常量 值
xlPriorityHigh -4127
xlPriorityLow -4134
xlPriorityNormal -4143
XlPTSelectionMode
常量 值
xlBlanks 4
xlButton 15
xlDataAndLabel 0
xlDataOnly 2
xlFirstRow 256
xlLabelOnly 1
xlOrigin 3
XlQueryType
常量 值
xlADORecordset 7
xlDAORecordset 2
xlODBCQuery 1
xlOLEDBQuery 5
xlTextImport 6
xlWebQuery 4
XlRangeAutoFormat
常量 值
xlRangeAutoFormat3DEffects1 13
xlRangeAutoFormat3DEffects2 14
xlRangeAutoFormatAccounting1 4
xlRangeAutoFormatAccounting2 5
xlRangeAutoFormatAccounting3 6
xlRangeAutoFormatAccounting4 17
xlRangeAutoFormatClassic1 1
xlRangeAutoFormatClassic2 2
xlRangeAutoFormatClassic3 3
xlRangeAutoFormatClassicPivotTable 31
xlRangeAutoFormatColor1 7
xlRangeAutoFormatColor2 8
xlRangeAutoFormatColor3 9
xlRangeAutoFormatList1 10
xlRangeAutoFormatList2 11
xlRangeAutoFormatList3 12
xlRangeAutoFormatLocalFormat1 15
xlRangeAutoFormatLocalFormat2 16
xlRangeAutoFormatLocalFormat3 19
xlRangeAutoFormatLocalFormat4 20
xlRangeAutoFormatNone -4142
xlRangeAutoFormatPTNone 42
xlRangeAutoFormatReport1 21
xlRangeAutoFormatReport10 30
xlRangeAutoFormatReport2 22
xlRangeAutoFormatReport3 23
xlRangeAutoFormatReport4 24
xlRangeAutoFormatReport5 25
xlRangeAutoFormatReport6 26
xlRangeAutoFormatReport7 27
xlRangeAutoFormatReport8 28
xlRangeAutoFormatReport9 29
xlRangeAutoFormatSimple -4154
xlRangeAutoFormatTable1 32
xlRangeAutoFormatTable10 41
xlRangeAutoFormatTable2 33
xlRangeAutoFormatTable3 34
xlRangeAutoFormatTable4 35
xlRangeAutoFormatTable5 36
xlRangeAutoFormatTable6 37
xlRangeAutoFormatTable7 38
xlRangeAutoFormatTable8 39
xlRangeAutoFormatTable9 40
XlRangeValueDataType
常量 值
xlRangeValueDefault 10
xlRangeValueMSPersistXML 12
xlRangeValueXMLSpreadsheet 11
XlReferenceStyle
常量 值
xlA1 1
xlR1C1 -4150
XlReferenceType
常量 值
xlAbsolute 1
xlAbsRowRelColumn 2
xlRelative 4
xlRelRowAbsColumn 3
XlRobustConnect
常量 值
xlAlways 1
xlAsRequired 0
xlNever 2
XlRoutingSlipDelivery
常量 值
xlAllAtOnce 2
xlOneAfterAnother 1
XlRoutingSlipStatus
常量 值
xlNotYetRouted 0
xlRoutingComplete 2
xlRoutingInProgress 1
XlRowCol
常量 值
xlCol
umns 2
xlRows 1
XlRunAutoMacro
常量 值
xlAutoActivate 3
xlAutoClose 2
xlAutoDeactivate 4
xlAutoOpen 1
XlSaveAction
常量 值
xlDoNotSaveChanges 2
xlSaveChanges 1
XlSaveAsAccessMode
常量 值
xlExclusive 3
xlNoChange 1
xlShared 2
XlSaveConflictResolution
常量 值
xlLocalSessionChanges 2
xlOtherSessionChanges 3
xlUserResolution 1
XlScaleType
常量 值
xlScaleLinear -4132
xlScaleLogarithmic -4133
XlSearchDirection
常量 值
xlNext 1
xlPrevious 2
XlSearchOrder
常量 值
xlByColumns 2
xlByRows 1
XlSearchWithin
常量 值
xlWithinSheet 1
xlWithinWorkbook 2
XlSheetType
常量 值
xlChart -4109
xlDialogSheet -4116
xlExcel4IntlMacroSheet 4
xlExcel4MacroSheet 3
xlWorksheet -4167
XlSheetVisibility
常量 值
xlSheetHidden 0
xlSheetVeryHidden 2
xlSheetVisible -1
XlSizeRepresents
常量 值
xlSizeIsArea 1
xlSizeIsWidth 2
XlSmartTagControlType
常量 值
xlSmartTagControlActiveX 13
xlSmartTagControlButton 6
xlSmartTagControlCheckbox 9
xlSmartTagControlCombo 12
xlSmartTagControlHelp 3
xlSmartTagControlHelpURL 4
xlSmartTagControlImage 8
xlSmartTagControlLabel 7
xlSmartTagControlLink 2
xlSmartTagControlListbox 11
xlSmartTagControlRadioGroup 14
xlSmartTagControlSeparator 5
xlSmartTagControlSmartTag 1
xlSmartTagControlTextbox 10
XlSmartTagDisplayMode
常量 值
xlButtonOnly 2
xlDisplayNone 1
xlIndicatorAndButton 0
XlSortDataOption
常量 值
xlSortNormal 0
xlSortTextAsNumbers 1
XlSortMethod
常量 值
xlPinYin 1
xlStroke 2
XlSortMethodOld
常量 值
xlCodePage 2
xlSyllabary 1
XlSortOrder
常量 值
xlAscending 1
xlDescending 2
XlSortOrientation
常量 值
xlSortColumns 1
xlSortRows 2
XlSortType
常量 值
xlSortLabels 2
xlSortValues 1
XlSourceType
常量 值
xlSourceAutoFilter 3
xlSourceChart 5
xlSourcePivotTable 6
xlSourcePrintArea 2
xlSourceQuery 7
xlSourceRange 4
xlSourceSheet 1
xlSourceWorkbook 0
XlSpeakDirection
常量 值
xlSpeakByColumns 1
xlSpeakByRows 0
XlSpecialCellsValue
常量 值
xlErrors 16
xlLogical 4
xlNumbers 1
xlTextValues 2
XlSubscribeToFormat
常量 值
xlSubscribeToPicture -4147
xlSubscribeToText -4158
XlSubtototalLocationType
常量 值
xlAtBottom 2
xlAtTop 1
XlSummaryColumn
常量 值
xlSummaryOnLeft -4131
xlSummaryOnRight -4152
XlSummaryReportType
常量 值
xlStandardSummary 1
xlSummaryPivotTable -4148
XlSummaryRow
常量 值
xlSummaryAbove 0
xlSummaryBelow 1
XlTabPosition
常量 值
xlTabPositionFirst 0
xlTabPositionLast 1
XlTextParsingType
常量 值
xlDelimited 1
xlFixedWidth 2
XlTextQualifier
常量 值
xlTextQualifierDoubleQuote 1
xlTextQualifierNone -4142
xlTextQualifierSingleQuote 2
XlTextVisualLayoutType
常量 值
xlTextVisualLTR 1
xlTextVisualRTL 2
XlTickLabelOrientation
常量
值
xlTickLabelOrientationAutomatic -4105
xlTickLabelOrientationDownward -4170
xlTickLabelOrientationHorizontal -4128
xlTickLabelOrientationUpward -4171
xlTickLabelOrientationVertical -4166
XlTickLabelPosition
常量 值
xlTickLabelPositionHigh -4127
xlTickLabelPositionLow -4134
xlTickLabelPositionNextToAxis 4
xlTickLabelPositionNone -4142
XlTickMark
常量 值
xlTickMarkCross 4
xlTickMarkInside 2
xlTickMarkNone -4142
xlTickMarkOutside 3
XlTimeUnit
常量 值
xlDays 0
xlMonths 1
xlYears 2
XlToolbarProtection
常量 值
xlNoButtonChanges 1
xlNoChanges 4
xlNoDockingChanges 3
xlNoShapeChanges 2
xlToolbarProtectionNone -4143
XlTotalsCalculation
常量 值
xlTotalsCalculationAverage 2
xlTotalsCalculationCount 3
xlTotalsCalculationCountNums 4
xlTotalsCalculationMax 6
xlTotalsCalculationMin 5
xlTotalsCalculationNone 0
xlTotalsCalculationStdDev 7
xlTotalsCalculationSum 1
xlTotalsCalculationVar 8
XlTrendlineType
常量 值
xlExponential 5
xlLinear -4132
xlLogarithmic -4133
xlMovingAvg 6
xlPolynomial 3
xlPower 4
XlUnderlineStyle
常量 值
xlUnderlineStyleDouble -4119
xlUnderlineStyleDoubleAccounting 5
xlUnderlineStyleNone -4142
xlUnderlineStyleSingle 2
xlUnderlineStyleSingleAccounting 4
XlUpdateLinks
常量 值
xlUpdateLinksAlways 3
xlUpdateLinksNever 2
xlUpdateLinksUserSetting 1
XlVAlign
常量 值
xlVAlignBottom -4107
xlVAlignCenter -4108
xlVAlignDistributed -4117
xlVAlignJustify -4130
xlVAlignTop -4160
XlWBATemplate
常量 值
xlWBATChart -4109
xlWBATExcel4IntlMacroSheet 4
xlWBATExcel4MacroSheet 3
xlWBATWorksheet -4167
XlWebFormatting
常量 值
xlWebFormattingAll 1
xlWebFormattingNone 3
xlWebFormattingRTF 2
XlWebSelectionType
常量 值
xlAllTables 2
xlEntirePage 1
xlSpecifiedTables 3
XlWindowState
常量 值
xlMaximized -4137
xlMinimized -4140
xlNormal -4143
XlWindowType
常量 值
xlChartAsWindow 5
xlChartInPlace 4
xlClipboard 3
xlInfo -4129
xlWorkbook 1
XlWindowView
常量 值
xlNormalView 1
xlPageBreakPreview 2
XlXLMMacroType
常量 值
xlCommand 2
xlFunction 1
xlNotXLM 3
XlXmlExportResult
常量 值
xlXmlExportSuccess 0
xlXmlExportValidationFailed 1
XlXmlImportResult
常量 值
xlXmlImportElementsTruncated 1
xlXmlImportSuccess 0
xlXmlImportValidationFailed 2
XlXmlLoadOption
常量 值
xlXmlLoadImportToList 2
xlXmlLoadMapXml 3
xlXmlLoadOpenXml 1
xlXmlLoadPromptUser 0
XlYesNoGuess
常量 值
xlGuess 0
xlNo 2
xlYes 1