Excel对象常量和对应值.docx
- 文档编号:3852346
- 上传时间:2022-11-25
- 格式:DOCX
- 页数:33
- 大小:19.80KB
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
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Excel 对象 常量 对应