Excel对象常量和对应值

更新时间:2023-07-20 20:22:25 阅读: 评论:0

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
XlInrtFormatOrigin
常量 值
xlFormatFromLeftOrAbove 0
xlFormatFromRightOrBelow 1
XlInrtShiftDirection
常量 值
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
xlListDataTyp
eListLookup 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
XlMouButton
常量 值
xlNoButton 0
xlPrimaryButton 1
xlSecondaryButton 2
XlMouPointer
常量 值
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
xlPaperUr 256
XlParameterDataType
常量 值
xlParamTypeBigInt -5
xlParamTypeBinary -2
xlParamTypeBit -7
xlParamTypeChar 1
xlParamTypeDate 9
xlParamTypeDecimal 3
xlParamTypeDouble 8
xlParamTypeFloat 6
xlParamTypeInteger 4
xlParamTypeLongVarBinary -4
xlParamTypeLon
gVarChar -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
人教版pep
xlTable4 13
xlTable5 14
xlTable6 15
xlTable7 16
xlTable8 17
xlTable9 18
XlPivotTableMissingItems
常量 值
xlMissingItemsDefault -1
xlMissingItemsMax 32500
xlMissingItemsNone 0
XlPivotTableSourceType
常量 值
xlConsolidation 3
xlDataba 1
xlExternal 2
x
lPivotTable -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
常量 值
关于月亮的手抄报xlADORecordt 7
xlDAORecordt 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
常量 值
xlColumns 2
xlRows 1
XlRunAutoMacro
常量 值
xlAutoActivate 3
xlAutoClo 2
xlAutoDeactivate 4
xlAutoOpen 1
XlSaveAction
平菇肉片汤的做法常量 值
xlDoNotSaveChanges 2
xlSaveChanges 1
XlSaveAsAccessMode
常量 值
x
lExclusive 3
xlNoChange 1
xlShared 2
XlSaveConflictResolution
常量 值
xlLocalSessionChanges 2
xlOtherSessionChanges 3
xlUrResolution 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
XlSizeReprents
常量 值
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
常量

本文发布于:2023-07-20 20:22:25,感谢您对本站的认可!

本文链接:https://www.wtabcd.cn/fanwen/fan/82/1107580.html

版权声明:本站内容均来自互联网,仅供演示用,请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系,我们将在24小时内删除。

标签:做法   月亮   电影
相关文章
留言与评论(共有 0 条评论)
   
验证码:
推荐文章
排行榜
Copyright ©2019-2022 Comsenz Inc.Powered by © 专利检索| 网站地图