Excel对象常量和对应值.docx

Excel对象常量和对应值.docx

《Excel对象常量和对应值.docx》由会员分享，可在线阅读，更多相关《Excel对象常量和对应值.docx（33页珍藏版）》请在冰豆网上搜索。

Excel对象常量和对应值

Excel¶ÔÏó²Ù×÷µÄËùÓг£Á¿ºÍ¶ÔÓ¦Öµ

XlFormatConditionOperator

³£Á¿Öµ

xlBetween1

xlEqual3

xlGreater5

xlGreaterEqual7

xlLess6

xlLessEqual8

xlNotBetween2

xlNotEqual4

XlFormatConditionType

³£Á¿Öµ

xlCellValue1

xlExpression2

XlFormControl

³£Á¿Öµ

xlButtonControl0

xlCheckBox1

xlDropDown2

xlEditBox3

xlGroupBox4

xlLabel5

xlListBox6

xlOptionButton7

xlScrollBar8

xlSpinner9

XlFormulaLabel

³£Á¿Öµ

xlColumnLabels2

xlMixedLabels3

xlNoLabels-4142

xlRowLabels1

XlHAlign

³£Á¿Öµ

xlHAlignCenter-4108

xlHAlignCenterAcrossSelection7

xlHAlignDistributed-4117

xlHAlignFill5

xlHAlignGeneral1

xlHAlignJustify-4130

xlHAlignLeft-4131

xlHAlignRight-4152

XlHebrewModes

³£Á¿Öµ

xlHebrewFullScript0

xlHebrewMixedAuthorizedScript3

xlHebrewMixedScript2

xlHebrewPartialScript1

XlHighlightChangesTime

³£Á¿Öµ

xlAllChanges2

xlNotYetReviewed3

xlSinceMyLastSave1

XlHtmlType

³£Á¿Öµ

xlHtmlCalc1

xlHtmlChart3

xlHtmlList2

xlHtmlStatic0

XlIMEMode

³£Á¿Öµ

xlIMEModeAlpha8

xlIMEModeAlphaFull7

xlIMEModeDisable3

xlIMEModeHangul10

xlIMEModeHangulFull9

xlIMEModeHiragana4

xlIMEModeKatakana5

xlIMEModeKatakanaHalf6

xlIMEModeNoControl0

xlIMEModeOff2

xlIMEModeOn1

XlImportDataAs

³£Á¿Öµ

xlPivotTableReport1

xlQueryTable0

XlInsertFormatOrigin

³£Á¿Öµ

xlFormatFromLeftOrAbove0

xlFormatFromRightOrBelow1

XlInsertShiftDirection

³£Á¿Öµ

xlShiftDown-4121

xlShiftToRight-4161

XlLayoutFormType

³£Á¿Öµ

xlOutline1

xlTabular0

XlLegendPosition

³£Á¿Öµ

xlLegendPositionBottom-4107

xlLegendPositionCorner2

xlLegendPositionLeft-4131

xlLegendPositionRight-4152

xlLegendPositionTop-4160

XlLineStyle

³£Á¿Öµ

xlContinuous1

xlDash-4115

xlDashDot4

xlDashDotDot5

xlDot-4118

xlDouble-4119

xlLineStyleNone-4142

xlSlantDashDot13

XlLink

³£Á¿Öµ

xlExcelLinks1

xlOLELinks2

xlPublishers5

xlSubscribers6

XlLinkInfo

³£Á¿Öµ

xlEditionDate2

xlLinkInfoStatus3

xlUpdateState1

XlLinkInfoType

³£Á¿Öµ

xlLinkInfoOLELinks2

xlLinkInfoPublishers5

xlLinkInfoSubscribers6

XlLinkStatus

³£Á¿Öµ

xlLinkStatusCopiedValues10

xlLinkStatusIndeterminate5

xlLinkStatusInvalidName7

xlLinkStatusMissingFile1

xlLinkStatusMissingSheet2

xlLinkStatusNotStarted6

xlLinkStatusOK0

xlLinkStatusOld3

xlLinkStatusSourceNotCalculated4

xlLinkStatusSourceNotOpen8

xlLinkStatusSourceOpen9

XlLinkType

³£Á¿Öµ

xlLinkTypeExcelLinks1

xlLinkTypeOLELinks2

XlListConflict

³£Á¿Öµ

xlListConflictDialog0

xlListConflictDiscardAllConflicts2

xlListConflictError3

xlListConflictRetryAllConflicts1

XlListDataType

³£Á¿Öµ

xlListDataTypeCheckbox9

xlListDataTypeChoice6

xlListDataTypeChoiceMulti7

xlListDataTypeCounter11

xlListDataTypeCurrency4

xlListDataTypeDateTime5

xlListDataTypeHyperLink10

xlListDataTypeListLookup8

xlListDataTypeMultiLineRichText12

xlListDataTypeMultiLineText2

xlListDataTypeNone0

xlListDataTypeNumber3

xlListDataTypeText1

XlListObjectSourceType

³£Á¿Öµ

xlSrcExternal0

xlSrcRange1

xlSrcXml2

XlLocationInTable

³£Á¿Öµ

xlColumnHeader-4110

xlColumnItem5

xlDataHeader3

xlDataItem7

xlPageHeader2

xlPageItem6

xlRowHeader-4153

xlRowItem4

xlTableBody8

XlLookAt

³£Á¿Öµ

xlPart2

xlWhole1

XlMailSystem

³£Á¿Öµ

xlMAPI1

xlNoMailSystem0

xlPowerTalk2

XlMarkerStyle

³£Á¿Öµ

xlMarkerStyleAutomatic-4105

xlMarkerStyleCircle8

xlMarkerStyleDash-4115

xlMarkerStyleDiamond2

xlMarkerStyleDot-4118

xlMarkerStyleNone-4142

xlMarkerStylePicture-4147

xlMarkerStylePlus9

xlMarkerStyleSquare1

xlMarkerStyleStar5

xlMarkerStyleTriangle3

xlMarkerStyleX-4168

XlMouseButton

³£Á¿Öµ

xlNoButton0

xlPrimaryButton1

xlSecondaryButton2

XlMousePointer

³£Á¿Öµ

xlDefault-4143

xlIBeam3

xlNorthwestArrow1

xlWait2

XlMSApplication

³£Á¿Öµ

xlMicrosoftAccess4

xlMicrosoftFoxPro5

xlMicrosoftMail3

xlMicrosoftPowerPoint2

xlMicrosoftProject6

xlMicrosoftSchedulePlus7

xlMicrosoftWord1

XlObjectSize

³£Á¿Öµ

xlFitToPage2

xlFullPage3

xlScreenSize1

XlOLEType

³£Á¿Öµ

xlOLEControl2

xlOLEEmbed1

xlOLELink0

XlOLEVerb

³£Á¿Öµ

xlVerbOpen2

xlVerbPrimary1

XlOrder

³£Á¿Öµ

xlDownThenOver1

xlOverThenDown2

XlOrientation

³£Á¿Öµ

xlDownward-4170

xlHorizontal-4128

xlUpward-4171

xlVertical-4166

XlPageBreak

³£Á¿Öµ

xlPageBreakAutomatic-4105

xlPageBreakManual-4135

xlPageBreakNone-4142

XlPageBreakExtent

³£Á¿Öµ

xlPageBreakFull1

xlPageBreakPartial2

XlPageOrientation

³£Á¿Öµ

xlLandscape2

xlPortrait1

XlPaperSize

³£Á¿Öµ

xlPaper10x1416

xlPaper11x1717

xlPaperA38

xlPaperA49

xlPaperA4Small10

xlPaperA511

xlPaperB412

xlPaperB513

xlPaperCsheet24

xlPaperDsheet25

xlPaperEnvelope1020

xlPaperEnvelope1121

xlPaperEnvelope1222

xlPaperEnvelope1423

xlPaperEnvelope919

xlPaperEnvelopeB433

xlPaperEnvelopeB534

xlPaperEnvelopeB635

xlPaperEnvelopeC329

xlPaperEnvelopeC430

xlPaperEnvelopeC528

xlPaperEnvelopeC631

xlPaperEnvelopeC6532

xlPaperEnvelopeDL27

xlPaperEnvelopeItaly36

xlPaperEnvelopeMonarch37

xlPaperEnvelopePersonal38

xlPaperEsheet26

xlPaperExecutive7

xlPaperFanfoldLegalGerman41

xlPaperFanfoldStdGerman40

xlPaperFanfoldUS39

xlPaperFolio14

xlPaperLedger4

xlPaperLegal5

xlPaperLetter1

xlPaperLetterSmall2

xlPaperNote18

xlPaperQuarto15

xlPaperStatement6

xlPaperTabloid3

xlPaperUser256

XlParameterDataType

³£Á¿Öµ

xlParamTypeBigInt-5

xlParamTypeBinary-2

xlParamTypeBit-7

xlParamTypeChar1

xlParamTypeDate9

xlParamTypeDecimal3

xlParamTypeDouble8

xlParamTypeFloat6

xlParamTypeInteger4

xlParamTypeLongVarBinary-4

xlParamTypeLongVarChar-1

xlParamTypeNumeric2

xlParamTypeReal7

xlParamTypeSmallInt5

xlParamTypeTime10

xlParamTypeTimestamp11

xlParamTypeTinyInt-6

xlParamTypeUnknown0

xlParamTypeVarBinary-3

xlParamTypeVarChar12

xlParamTypeWChar-8

XlParameterType

³£Á¿Öµ

xlConstant1

xlPrompt0

xlRange2

XlPasteSpecialOperation

³£Á¿Öµ

xlPasteSpecialOperationAdd2

xlPasteSpecialOperationDivide5

xlPasteSpecialOperationMultiply4

xlPasteSpecialOperationNone-4142

xlPasteSpecialOperationSubtract3

XlPasteType

³£Á¿Öµ

xlPasteAll-4104

xlPasteAllExceptBorders7

xlPasteColumnWidths8

xlPasteComments-4144

xlPasteFormats-4122

xlPasteFormulas-4123

xlPasteFormulasAndNumberFormats11

xlPasteValidation6

xlPasteValues-4163

xlPasteValuesAndNumberFormats12

XlPattern

³£Á¿Öµ

xlPatternAutomatic-4105

xlPatternChecker9

xlPatternCrissCross16

xlPatternDown-4121

xlPatternGray1617

xlPatternGray25-4124

xlPatternGray50-4125

xlPatternGray75-4126

xlPatternGray818

xlPatternGrid15

xlPatternHorizontal-4128

xlPatternLightDown13

xlPatternLightHorizontal11

xlPatternLightUp14

xlPatternLightVertical12

xlPatternNone-4142

xlPatternSemiGray7510

xlPatternSolid1

xlPatternUp-4162

xlPatternVertical-4166

XlPhoneticAlignment

³£Á¿Öµ

xlPhoneticAlignCenter2

xlPhoneticAlignDistributed3

xlPhoneticAlignLeft1

xlPhoneticAlignNoControl0

XlPhoneticCharacterType

³£Á¿Öµ

xlHiragana2

xlKatakana1

xlKatakanaHalf0

xlNoConversion3

XlPictureAppearance

³£Á¿Öµ

xlPrinter2

xlScreen1

XlPictureConvertorType

³£Á¿Öµ

xlBMP1

xlCGM7

xlDRW4

xlDXF5

xlEPS8

xlHGL6

xlPCT13

xlPCX10

xlPIC11

xlPLT12

xlTIF9

xlWMF2

xlWPG3

XlPivotCellType

³£Á¿Öµ

xlPivotCellBlankCell9

xlPivotCellCustomSubtotal7

xlPivotCellDataField4

xlPivotCellDataPivotField8

xlPivotCellGrandTotal3

xlPivotCellPageFieldItem6

xlPivotCellPivotField5

xlPivotCellPivotItem1

xlPivotCellSubtotal2

xlPivotCellValue0

XlPivotFieldCalculation

³£Á¿Öµ

xlDifferenceFrom2

xlIndex9

xlNoAdditionalCalculation-4143

xlPercentDifferenceFrom4

xlPercentOf3

xlPercentOfColumn7

xlPercentOfRow6

xlPercentOfTotal8

xlRunningTotal5

XlPivotFieldDataType

³£Á¿Öµ

xlDate2

xlNumber-4145

xlText-4158

XlPivotFieldOrientation

³£Á¿Öµ

xlColumnField2

xlDataField4

xlHidden0

xlPageField3

xlRowField1

XlPivotFormatType

³£Á¿Öµ

xlPTClassic20

xlPTNone21

xlReport10

xlReport109

xlReport21

xlReport32

xlReport43

xlReport54

xlReport65

xlReport76

xlReport87

xlReport98

xlTable110

xlTable1019

xlTable211

xlTable312

xlTable413

xlTable514

xlTable615

xlTable716

xlTable817

xlTable918

XlPivotTableMissingItems

³£Á¿Öµ

xlMissingItemsDefault-1

xlMissingItemsMax32500

xlMissingItemsNone0

XlPivotTableSourceType

³£Á¿Öµ

xlConsolidation3

xlDatabase1

xlExternal2

xlPivotTable-4148

xlScenario4

XlPivotTableVersionList

³£Á¿Öµ

xlPivotTableVersion101

xlPivotTableVersion20000

xlPivotTableVersionCurrent-1

XlPlacement

³£Á¿Öµ

xlFreeFloating3

xlMove2

xlMoveAndSize1

XlPlatform

³£Á¿Öµ

xlMacintosh1

xlMSDOS3

xlWindows2

XlPrintErrors

³£Á¿Öµ

xlPrintErrorsBlank1

xlPrintErrorsDash2

xlPrintErrorsDisplayed0

xlPrintErrorsNA3

XlPrintLocation

³£Á¿Öµ

xlPrintInPlace16

xlPrintNoComments-4142

xlPrintSheetEnd1

XlPriority

³£Á¿Öµ

xlPriorityHigh-4127

xlPriorityLow-4134

xlPriorityNormal-4143

XlPTSelectionMode

³£Á¿Öµ

xlBlanks4

xlButton15

xlDataAndLabel0

xlDataOnly2

xlFirstRow256

xlLabelOnly1

xlOrigin3

XlQueryType

³£Á¿Öµ

xlADORecordset7

xlDAORecordset2

xlODBCQuery1

xlOLEDBQuery5

xlTextImport6

xlWebQuery4

XlRangeAutoFormat

³£Á¿Öµ

xlRangeAutoFormat3DEffects113

xlRangeAutoFormat3DEffects214

xlRangeAutoFormatAccounting14

xlRangeAutoFormatAccounting25

xlRangeAutoFormatAccounting36

xlRangeAutoFormatAccounting417

xlRangeAutoFormatClassic11

xlRangeAutoFormatClassic22

xlRangeAutoFormatClassic33

xlRangeAutoFormatClassicPivotTable31

xlRangeAutoFormatColor17

xlRangeAutoFormatColor28

xlRangeAutoFormatColor39

xlRangeAutoFo