1、Excel对象常量和对应值ExcelXlFormatConditionOperator xlBetween 1xlEqual 3xlGreater 5xlGreaterEqual 7xlLess 6xlLessEqual 8xlNotBetween 2xlNotEqual 4XlFormatConditionType xlCellValue 1xlExpression 2XlFormControl xlButtonControl 0xlCheckBox 1xlDropDown 2xlEditBox 3xlGroupBox 4xlLabel 5xlListBox 6xlOptionButton
2、7xlScrollBar 8xlSpinner 9XlFormulaLabel xlColumnLabels 2xlMixedLabels 3xlNoLabels -4142xlRowLabels 1XlHAlign xlHAlignCenter -4108xlHAlignCenterAcrossSelection 7xlHAlignDistributed -4117xlHAlignFill 5xlHAlignGeneral 1xlHAlignJustify -4130xlHAlignLeft -4131xlHAlignRight -4152XlHebrewModes xlHebrewFull
3、Script 0xlHebrewMixedAuthorizedScript 3xlHebrewMixedScript 2xlHebrewPartialScript 1XlHighlightChangesTime xlAllChanges 2xlNotYetReviewed 3xlSinceMyLastSave 1XlHtmlType xlHtmlCalc 1xlHtmlChart 3xlHtmlList 2xlHtmlStatic 0XlIMEMode xlIMEModeAlpha 8xlIMEModeAlphaFull 7xlIMEModeDisable 3xlIMEModeHangul 1
4、0xlIMEModeHangulFull 9xlIMEModeHiragana 4xlIMEModeKatakana 5xlIMEModeKatakanaHalf 6xlIMEModeNoControl 0xlIMEModeOff 2xlIMEModeOn 1XlImportDataAs xlPivotTableReport 1xlQueryTable 0XlInsertFormatOrigin xlFormatFromLeftOrAbove 0xlFormatFromRightOrBelow 1XlInsertShiftDirection xlShiftDown -4121xlShiftTo
5、Right -4161XlLayoutFormType xlOutline 1xlTabular 0XlLegendPosition xlLegendPositionBottom -4107xlLegendPositionCorner 2xlLegendPositionLeft -4131xlLegendPositionRight -4152xlLegendPositionTop -4160XlLineStyle xlContinuous 1xlDash -4115xlDashDot 4xlDashDotDot 5xlDot -4118xlDouble -4119xlLineStyleNone
6、 -4142xlSlantDashDot 13XlLink xlExcelLinks 1xlOLELinks 2xlPublishers 5xlSubscribers 6XlLinkInfo xlEditionDate 2xlLinkInfoStatus 3xlUpdateState 1XlLinkInfoType xlLinkInfoOLELinks 2xlLinkInfoPublishers 5xlLinkInfoSubscribers 6XlLinkStatus xlLinkStatusCopiedValues 10xlLinkStatusIndeterminate 5xlLinkSta
7、tusInvalidName 7xlLinkStatusMissingFile 1xlLinkStatusMissingSheet 2xlLinkStatusNotStarted 6xlLinkStatusOK 0xlLinkStatusOld 3xlLinkStatusSourceNotCalculated 4xlLinkStatusSourceNotOpen 8xlLinkStatusSourceOpen 9XlLinkType xlLinkTypeExcelLinks 1xlLinkTypeOLELinks 2XlListConflict xlListConflictDialog 0xl
8、ListConflictDiscardAllConflicts 2xlListConflictError 3xlListConflictRetryAllConflicts 1XlListDataType xlListDataTypeCheckbox 9xlListDataTypeChoice 6xlListDataTypeChoiceMulti 7xlListDataTypeCounter 11xlListDataTypeCurrency 4xlListDataTypeDateTime 5xlListDataTypeHyperLink 10xlListDataTypeListLookup 8x
9、lListDataTypeMultiLineRichText 12xlListDataTypeMultiLineText 2xlListDataTypeNone 0xlListDataTypeNumber 3xlListDataTypeText 1XlListObjectSourceType xlSrcExternal 0xlSrcRange 1xlSrcXml 2XlLocationInTable xlColumnHeader -4110xlColumnItem 5xlDataHeader 3xlDataItem 7xlPageHeader 2xlPageItem 6xlRowHeader
10、-4153xlRowItem 4xlTableBody 8XlLookAt xlPart 2xlWhole 1XlMailSystem xlMAPI 1xlNoMailSystem 0xlPowerTalk 2XlMarkerStyle xlMarkerStyleAutomatic -4105xlMarkerStyleCircle 8xlMarkerStyleDash -4115xlMarkerStyleDiamond 2xlMarkerStyleDot -4118xlMarkerStyleNone -4142xlMarkerStylePicture -4147xlMarkerStylePlu
11、s 9xlMarkerStyleSquare 1xlMarkerStyleStar 5xlMarkerStyleTriangle 3xlMarkerStyleX -4168XlMouseButton xlNoButton 0xlPrimaryButton 1xlSecondaryButton 2XlMousePointer xlDefault -4143xlIBeam 3xlNorthwestArrow 1xlWait 2XlMSApplication xlMicrosoftAccess 4xlMicrosoftFoxPro 5xlMicrosoftMail 3xlMicrosoftPower
12、Point 2xlMicrosoftProject 6xlMicrosoftSchedulePlus 7xlMicrosoftWord 1XlObjectSize xlFitToPage 2xlFullPage 3xlScreenSize 1XlOLEType xlOLEControl 2xlOLEEmbed 1xlOLELink 0XlOLEVerb xlVerbOpen 2xlVerbPrimary 1XlOrder xlDownThenOver 1xlOverThenDown 2XlOrientation xlDownward -4170xlHorizontal -4128xlUpwar
13、d -4171xlVertical -4166XlPageBreak xlPageBreakAutomatic -4105xlPageBreakManual -4135xlPageBreakNone -4142XlPageBreakExtent xlPageBreakFull 1xlPageBreakPartial 2XlPageOrientation xlLandscape 2xlPortrait 1XlPaperSize xlPaper10x14 16xlPaper11x17 17xlPaperA3 8xlPaperA4 9xlPaperA4Small 10xlPaperA5 11xlPa
14、perB4 12xlPaperB5 13xlPaperCsheet 24xlPaperDsheet 25xlPaperEnvelope10 20xlPaperEnvelope11 21xlPaperEnvelope12 22xlPaperEnvelope14 23xlPaperEnvelope9 19xlPaperEnvelopeB4 33xlPaperEnvelopeB5 34xlPaperEnvelopeB6 35xlPaperEnvelopeC3 29xlPaperEnvelopeC4 30xlPaperEnvelopeC5 28xlPaperEnvelopeC6 31xlPaperEn
15、velopeC65 32xlPaperEnvelopeDL 27xlPaperEnvelopeItaly 36xlPaperEnvelopeMonarch 37xlPaperEnvelopePersonal 38xlPaperEsheet 26xlPaperExecutive 7xlPaperFanfoldLegalGerman 41xlPaperFanfoldStdGerman 40xlPaperFanfoldUS 39xlPaperFolio 14xlPaperLedger 4xlPaperLegal 5xlPaperLetter 1xlPaperLetterSmall 2xlPaperN
16、ote 18xlPaperQuarto 15xlPaperStatement 6xlPaperTabloid 3xlPaperUser 256XlParameterDataType xlParamTypeBigInt -5xlParamTypeBinary -2xlParamTypeBit -7xlParamTypeChar 1xlParamTypeDate 9xlParamTypeDecimal 3xlParamTypeDouble 8xlParamTypeFloat 6xlParamTypeInteger 4xlParamTypeLongVarBinary -4xlParamTypeLon
17、gVarChar -1xlParamTypeNumeric 2xlParamTypeReal 7xlParamTypeSmallInt 5xlParamTypeTime 10xlParamTypeTimestamp 11xlParamTypeTinyInt -6xlParamTypeUnknown 0xlParamTypeVarBinary -3xlParamTypeVarChar 12xlParamTypeWChar -8XlParameterType xlConstant 1xlPrompt 0xlRange 2XlPasteSpecialOperation xlPasteSpecialO
18、perationAdd 2xlPasteSpecialOperationDivide 5xlPasteSpecialOperationMultiply 4xlPasteSpecialOperationNone -4142xlPasteSpecialOperationSubtract 3XlPasteType xlPasteAll -4104xlPasteAllExceptBorders 7xlPasteColumnWidths 8xlPasteComments -4144xlPasteFormats -4122xlPasteFormulas -4123xlPasteFormulasAndNum
19、berFormats 11xlPasteValidation 6xlPasteValues -4163xlPasteValuesAndNumberFormats 12XlPattern xlPatternAutomatic -4105xlPatternChecker 9xlPatternCrissCross 16xlPatternDown -4121xlPatternGray16 17xlPatternGray25 -4124xlPatternGray50 -4125xlPatternGray75 -4126xlPatternGray8 18xlPatternGrid 15xlPatternH
20、orizontal -4128xlPatternLightDown 13xlPatternLightHorizontal 11xlPatternLightUp 14xlPatternLightVertical 12xlPatternNone -4142xlPatternSemiGray75 10xlPatternSolid 1xlPatternUp -4162xlPatternVertical -4166XlPhoneticAlignment xlPhoneticAlignCenter 2xlPhoneticAlignDistributed 3xlPhoneticAlignLeft 1xlPh
21、oneticAlignNoControl 0XlPhoneticCharacterType xlHiragana 2xlKatakana 1xlKatakanaHalf 0xlNoConversion 3XlPictureAppearance xlPrinter 2xlScreen 1XlPictureConvertorType xlBMP 1xlCGM 7xlDRW 4xlDXF 5xlEPS 8xlHGL 6xlPCT 13xlPCX 10xlPIC 11xlPLT 12xlTIF 9xlWMF 2xlWPG 3XlPivotCellType xlPivotCellBlankCell 9x
22、lPivotCellCustomSubtotal 7xlPivotCellDataField 4xlPivotCellDataPivotField 8xlPivotCellGrandTotal 3xlPivotCellPageFieldItem 6xlPivotCellPivotField 5xlPivotCellPivotItem 1xlPivotCellSubtotal 2xlPivotCellValue 0XlPivotFieldCalculation xlDifferenceFrom 2xlIndex 9xlNoAdditionalCalculation -4143xlPercentD
23、ifferenceFrom 4xlPercentOf 3xlPercentOfColumn 7xlPercentOfRow 6xlPercentOfTotal 8xlRunningTotal 5XlPivotFieldDataType xlDate 2xlNumber -4145xlText -4158XlPivotFieldOrientation xlColumnField 2xlDataField 4xlHidden 0xlPageField 3xlRowField 1XlPivotFormatType xlPTClassic 20xlPTNone 21xlReport1 0xlRepor
24、t10 9xlReport2 1xlReport3 2xlReport4 3xlReport5 4xlReport6 5xlReport7 6xlReport8 7xlReport9 8xlTable1 10xlTable10 19xlTable2 11xlTable3 12xlTable4 13xlTable5 14xlTable6 15xlTable7 16xlTable8 17xlTable9 18XlPivotTableMissingItems xlMissingItemsDefault -1xlMissingItemsMax 32500xlMissingItemsNone 0XlPi
25、votTableSourceType xlConsolidation 3xlDatabase 1xlExternal 2xlPivotTable -4148xlScenario 4XlPivotTableVersionList xlPivotTableVersion10 1xlPivotTableVersion2000 0xlPivotTableVersionCurrent -1XlPlacement xlFreeFloating 3xlMove 2xlMoveAndSize 1XlPlatform xlMacintosh 1xlMSDOS 3xlWindows 2XlPrintErrors
26、xlPrintErrorsBlank 1xlPrintErrorsDash 2xlPrintErrorsDisplayed 0xlPrintErrorsNA 3XlPrintLocation xlPrintInPlace 16xlPrintNoComments -4142xlPrintSheetEnd 1XlPriority xlPriorityHigh -4127xlPriorityLow -4134xlPriorityNormal -4143XlPTSelectionMode xlBlanks 4xlButton 15xlDataAndLabel 0xlDataOnly 2xlFirstR
27、ow 256xlLabelOnly 1xlOrigin 3XlQueryType xlADORecordset 7xlDAORecordset 2xlODBCQuery 1xlOLEDBQuery 5xlTextImport 6xlWebQuery 4XlRangeAutoFormat xlRangeAutoFormat3DEffects1 13xlRangeAutoFormat3DEffects2 14xlRangeAutoFormatAccounting1 4xlRangeAutoFormatAccounting2 5xlRangeAutoFormatAccounting3 6xlRangeAutoFormatAccounting4 17xlRangeAutoFormatClassic1 1xlRangeAutoFormatClassic2 2xlRangeAutoFormatClassic3 3xlRangeAutoFormatClassicPivotTable 31xlRangeAutoFormatColor1 7xlRangeAutoFormatColor2 8xlRangeAutoFormatColor3 9xlRangeAutoFo
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1