XlApplicationInternational
Constant Value
xl24HourClock 33
xl4DigitYears 43
xlAlternateArraySeparator 16
xlColumnSeparator 14
xlCountryCode 1
xlCountrySetting 2
xlCurrencyBefore 37
xlCurrencyCode 25
xlCurrencyDigits 27
xlCurrencyLeadingZeros 40
xlCurrencyMinusSign 38
xlCurrencyNegative 28
xlCurrencySpaceBefore 36
xlCurrencyTrailingZeros 39
xlDateOrder 32
xlDateSeparator 17
xlDayCode 21
xlDayLeadingZero 42
xlDecimalSeparator 3
xlGeneralFormatName 26
xlHourCode 22
xlLeftBrace 12
xlLeftBracket 10
xlListSeparator 5
xlLowerCaseColumnLetter 9
xlLowerCaseRowLetter 8
xlMDY 44
xlMetric 35
xlMinuteCode 23
xlMonthCode 20
xlMonthLeadingZero 41
xlMonthNameChars 30
xlNoncurrencyDigits 29
xlNonEnglishFunctions 34
xlRightBrace 13
xlRightBracket 11
xlRowSeparator 15
xlSecondCode 24
xlThousandsSeparator 4
xlTimeLeadingZero 45
xlTimeSeparator 18
xlUpperCaseColumnLetter 7
xlUpperCaseRowLetter 6
xlWeekdayNameChars 31
xlYearCode 19
XlApplyNamesOrder
Constant Value
xlColumnThenRow 2
xlRowThenColumn 1
XlArabicModes
Constant Value
xlArabicBothStrict 3
xlArabicNone 0
xlArabicStrictAlefHamza 1
xlArabicStrictFinalYaa 2
XlArrangeStyle
Constant Value
xlArrangeStyleCascade 7
xlArrangeStyleHorizontal -4128
xlArrangeStyleTiled 1
xlArrangeStyleVertical -4166
XlArrowHeadLength
Constant Value
xlArrowHeadLengthLong 3
xlArrowHeadLengthMedium -4138
xlArrowHeadLengthShort 1
XlArrowHeadStyle
Constant Value
xlArrowHeadStyleClosed 3
xlArrowHeadStyleDoubleClosed 5
xlArrowHeadStyleDoubleOpen 4
xlArrowHeadStyleNone -4142
xlArrowHeadStyleOpen 2
XlArrowHeadWidth
Constant Value
xlArrowHeadWidthMedium -4138
xlArrowHeadWidthNarrow 1
xlArrowHeadWidthWide 3
XlAutoFillType
Constant Value
xlFillCopy 1
xlFillDays 5
xlFillDefault 0
xlFillFormats 3
xlFillMonths 7
xlFillSeries 2
xlFillValues 4
xlFillWeekdays 6
xlFillYears 8
xlGrowthTrend 10
xlLinearTrend 9
XlAutoFilterOperator
Constant Value
xlAnd 1
xlBottom10Items 4
xlBottom10Percent 6
xlOr 2
xlTop10Items 3
xlTop10Percent 5
XlAxisCrosses
Constant Value
xlAxisCrossesAutomatic -4105
xlAxisCrossesCustom -4114
xlAxisCrossesMaximum 2
xlAxisCrossesMinimum 4
XlAxisGroup
Constant Value
xlPrimary 1
xlSecondary 2
XlAxisType
Constant Value
xlCategory 1
xlSeriesAxis 3
xlValue 2
XlBackground
Constant Value
xlBackgroundAutomatic -4105
xlBackgroundOpaque 3
xlBackgroundTransparent 2
XlBarShape
Constant Value
xlBox 0
xlConeToMax 5
xlConeToPoint 4
xlCylinder 3
xlPyramidToMax 2
xlPyramidToPoint 1
XlBordersIndex
Constant Value
xlDiagonalDown 5
xlDiagonalUp 6
xlEdgeBottom 9
xlEdgeLeft 7
xlEdgeRight 10
xlEdgeTop 8
xlInsideHorizontal 12
xlInsideVertical 11
XlBorderWeight
Constant Value
xlHairline 1
xlMedium -4138
xlThick 4
xlThin 2
XlBuiltInDialog
Constant Value
_xlDialogChartSourceData 541
_xlDialogPhonetic 538
xlDialogActivate 103
xlDialogActiveCellFont 476
xlDialogAddChartAutoformat 390
xlDialogAddinManager 321
xlDialogAlignment 43
xlDialogApplyNames 133
xlDialogApplyStyle 212
xlDialogAppMove 170
xlDialogAppSize 171
xlDialogArrangeAll 12
xlDialogAssignToObject 213
xlDialogAssignToTool 293
xlDialogAttachText 80
xlDialogAttachToolbars 323
xlDialogAutoCorrect 485
xlDialogAxes 78
xlDialogBorder 45
xlDialogCalculation 32
xlDialogCellProtection 46
xlDialogChangeLink 166
xlDialogChartAddData 392
xlDialogChartLocation 527
xlDialogChartOptionsDataLabelMultiple 724
xlDialogChartOptionsDataLabels 505
xlDialogChartOptionsDataTable 506
xlDialogChartSourceData 540
xlDialogChartTrend 350
xlDialogChartType 526
xlDialogChartWizard 288
xlDialogCheckboxProperties 435
xlDialogClear 52
xlDialogColorPalette 161
xlDialogColumnWidth 47
xlDialogCombination 73
xlDialogConditionalFormatting 583
xlDialogConsolidate 191
xlDialogCopyChart 147
xlDialogCopyPicture 108
xlDialogCreateList 796
xlDialogCreateNames 62
xlDialogCreatePublisher 217
xlDialogCustomizeToolbar 276
xlDialogCustomViews 493
xlDialogDataDelete 36
xlDialogDataLabel 379
xlDialogDataLabelMultiple 723
xlDialogDataSeries 40
xlDialogDataValidation 525
xlDialogDefineName 61
xlDialogDefineStyle 229
xlDialogDeleteFormat 111
xlDialogDeleteName 110
xlDialogDemote 203
xlDialogDisplay 27
xlDialogEditboxProperties 438
xlDialogEditColor 223
xlDialogEditDelete 54
xlDialogEditionOptions 251
xlDialogEditSeries 228
xlDialogErrorbarX 463
xlDialogErrorbarY 464
xlDialogErrorChecking 732
xlDialogEvaluateFormula 709
xlDialogExternalDataProperties 530
xlDialogExtract 35
xlDialogFileDelete 6
xlDialogFileSharing 481
xlDialogFillGroup 200
xlDialogFillWorkgroup 301
xlDialogFilter 447
xlDialogFilterAdvanced 370
xlDialogFindFile 475
xlDialogFont 26
xlDialogFontProperties 381
xlDialogFormatAuto 269
xlDialogFormatChart 465
xlDialogFormatCharttype 423
xlDialogFormatFont 150
xlDialogFormatLegend 88
xlDialogFormatMain 225
xlDialogFormatMove 128
xlDialogFormatNumber 42
xlDialogFormatOverlay 226
xlDialogFormatSize 129
xlDialogFormatText 89
xlDialogFormulaFind 64
xlDialogFormulaGoto 63
xlDialogFormulaReplace 130
xlDialogFunctionWizard 450
xlDialogGallery3dArea 193
xlDialogGallery3dBar 272
xlDialogGallery3dColumn 194
xlDialogGallery3dLine 195
xlDialogGallery3dPie 196
xlDialogGallery3dSurface 273
xlDialogGalleryArea 67
xlDialogGalleryBar 68
xlDialogGalleryColumn 69
xlDialogGalleryCustom 388
xlDialogGalleryDoughnut 344
xlDialogGalleryLine 70
xlDialogGalleryPie 71
xlDialogGalleryRadar 249
xlDialogGalleryScatter 72
xlDialogGoalSeek 198
xlDialogGridlines 76
xlDialogImportTextFile 666
xlDialogInsert 55
xlDialogInsertHyperlink 596
xlDialogInsertNameLabel 496
xlDialogInsertObject 259
xlDialogInsertPicture 342
xlDialogInsertTitle 380
xlDialogLabelProperties 436
xlDialogListboxProperties 437
xlDialogMacroOptions 382
xlDialogMailEditMailer 470
xlDialogMailLogon 339
xlDialogMailNextLetter 378
xlDialogMainChart 85
xlDialogMainChartType 185
xlDialogMenuEditor 322
xlDialogMove 262
xlDialogMyPermission 834
xlDialogNew 119
xlDialogNewWebQuery 667
xlDialogNote 154
xlDialogObjectProperties 207
xlDialogObjectProtection 214
xlDialogOpen 1
xlDialogOpenLinks 2
xlDialogOpenMail 188
xlDialogOpenText 441
xlDialogOptionsCalculation 318
xlDialogOptionsChart 325
xlDialogOptionsEdit 319
xlDialogOptionsGeneral 356
xlDialogOptionsListsAdd 458
xlDialogOptionsME 647
xlDialogOptionsTransition 355
xlDialogOptionsView 320
xlDialogOutline 142
xlDialogOverlay 86
xlDialogOverlayChartType 186
xlDialogPageSetup 7
xlDialogParse 91
xlDialogPasteNames 58
xlDialogPasteSpecial 53
xlDialogPatterns 84
xlDialogPermission 832
xlDialogPhonetic 656
xlDialogPivotCalculatedField 570
xlDialogPivotCalculatedItem 572
xlDialogPivotClientServerSet 689
xlDialogPivotFieldGroup 433
xlDialogPivotFieldProperties 313
xlDialogPivotFieldUngroup 434
xlDialogPivotShowPages 421
xlDialogPivotSolveOrder 568
xlDialogPivotTableOptions 567
xlDialogPivotTableWizard 312
xlDialogPlacement 300
xlDialogPrint 8
xlDialogPrinterSetup 9
xlDialogPrintPreview 222
xlDialogPromote 202
xlDialogProperties 474
xlDialogPropertyFields 754
xlDialogProtectDocument 28
xlDialogProtectSharing 620
xlDialogPublishAsWebPage 653
xlDialogPushbuttonProperties 445
xlDialogReplaceFont 134
xlDialogRoutingSlip 336
xlDialogRowHeight 127
xlDialogRun 17
xlDialogSaveAs 5
xlDialogSaveCopyAs 456
xlDialogSaveNewObject 208
xlDialogSaveWorkbook 145
xlDialogSaveWorkspace 285
xlDialogScale 87
xlDialogScenarioAdd 307
xlDialogScenarioCells 305
xlDialogScenarioEdit 308
xlDialogScenarioMerge 473
xlDialogScenarioSummary 311
xlDialogScrollbarProperties 420
xlDialogSearch 731
xlDialogSelectSpecial 132
xlDialogSendMail 189
xlDialogSeriesAxes 460
xlDialogSeriesOptions 557
xlDialogSeriesOrder 466
xlDialogSeriesShape 504
xlDialogSeriesX 461
xlDialogSeriesY 462
xlDialogSetBackgroundPicture 509
xlDialogSetPrintTitles 23
xlDialogSetUpdateStatus 159
xlDialogShowDetail 204
xlDialogShowToolbar 220
xlDialogSize 261
xlDialogSort 39
xlDialogSortSpecial 192
xlDialogSplit 137
xlDialogStandardFont 190
xlDialogStandardWidth 472
xlDialogStyle 44
xlDialogSubscribeTo 218
xlDialogSubtotalCreate 398
xlDialogSummaryInfo 474
xlDialogTable 41
xlDialogTabOrder 394
xlDialogTextToColumns 422
xlDialogUnhide 94
xlDialogUpdateLink 201
xlDialogVbaInsertFile 328
xlDialogVbaMakeAddin 478
xlDialogVbaProcedureDefinition 330
xlDialogView3d 197
xlDialogWebOptionsBrowsers 773
xlDialogWebOptionsEncoding 686
xlDialogWebOptionsFiles 684
xlDialogWebOptionsFonts 687
xlDialogWebOptionsGeneral 683
xlDialogWebOptionsPictures 685
xlDialogWindowMove 14
xlDialogWindowSize 13
xlDialogWorkbookAdd 281
xlDialogWorkbookCopy 283
xlDialogWorkbookInsert 354
xlDialogWorkbookMove 282
xlDialogWorkbookName 386
xlDialogWorkbookNew 302
xlDialogWorkbookOptions 284
xlDialogWorkbookProtect 417
xlDialogWorkbookTabSplit 415
xlDialogWorkbookUnhide 384
xlDialogWorkgroup 199
xlDialogWorkspace 95
xlDialogZoom 256
XlCalculatedMemberType
Constant Value
xlCalculatedMember 0
xlCalculatedSet 1
XlCalculation
Constant Value
xlCalculationAutomatic -4105
xlCalculationManual -4135
xlCalculationSemiautomatic 2
XlCalculationInterruptKey
Constant Value
xlAnyKey 2
xlEscKey 1
xlNoKey 0
XlCalculationState
Constant Value
xlCalculating 1
xlDone 0
xlPending 2
XlCategoryType
Constant Value
xlAutomaticScale -4105
xlCategoryScale 2
xlTimeScale 3
XlCellInsertionMode
Constant Value
xlInsertDeleteCells 1
xlInsertEntireRows 2
xlOverwriteCells 0
XlCellType
Constant Value
xlCellTypeAllFormatConditions -4172
xlCellTypeAllValidation -4174
xlCellTypeBlanks 4
xlCellTypeComments -4144
xlCellTypeConstants 2
xlCellTypeFormulas -4123
xlCellTypeLastCell 11
xlCellTypeSameFormatConditions -4173
xlCellTypeSameValidation -4175
xlCellTypeVisible 12
XlChartGallery
Constant Value
xlAnyGallery 23
xlBuiltIn 21
xlUserDefined 22
XlChartItem
Constant Value
xlAxis 21
xlAxisTitle 17
xlChartArea 2
xlChartTitle 4
xlCorners 6
xlDataLabel 0
xlDataTable 7
xlDisplayUnitLabel 30
xlDownBars 20
xlDropLines 26
xlErrorBars 9
xlFloor 23
xlHiLoLines 25
xlLeaderLines 29
xlLegend 24
xlLegendEntry 12
xlLegendKey 13
xlMajorGridlines 15
xlMinorGridlines 16
xlNothing 28
xlPivotChartDropZone 32
xlPivotChartFieldButton 31
xlPlotArea 19
xlRadarAxisLabels 27
xlSeries 3
xlSeriesLines 22
xlShape 14
xlTrendline 8
xlUpBars 18
xlWalls 5
xlXErrorBars 10
xlYErrorBars 11
XlChartLocation
Constant Value
xlLocationAsNewSheet 1
xlLocationAsObject 2
xlLocationAutomatic 3
XlChartPicturePlacement
Constant Value
xlAllFaces 7
xlEnd 2
xlEndSides 3
xlFront 4
xlFrontEnd 6
xlFrontSides 5
xlSides 1
XlChartPictureType
Constant Value
xlStack 2
xlStackScale 3
xlStretch 1
XlChartSplitType
Constant Value
xlSplitByCustomSplit 4
xlSplitByPercentValue 3
xlSplitByPosition 1
xlSplitByValue 2
XlChartType
Constant Value
xl3DArea -4098
xl3DAreaStacked 78
xl3DAreaStacked100 79
xl3DBarClustered 60
xl3DBarStacked 61
xl3DBarStacked100 62
xl3DColumn -4100
xl3DColumnClustered 54
xl3DColumnStacked 55
xl3DColumnStacked100 56
xl3DLine -4101
xl3DPie -4102
xl3DPieExploded 70
xlArea 1
xlAreaStacked 76
xlAreaStacked100 77
xlBarClustered 57
xlBarOfPie 71
xlBarStacked 58
xlBarStacked100 59
xlBubble 15
xlBubble3DEffect 87
xlColumnClustered 51
xlColumnStacked 52
xlColumnStacked100 53
xlConeBarClustered 102
xlConeBarStacked 103
xlConeBarStacked100 104
xlConeCol 105
xlConeColClustered 99
xlConeColStacked 100
xlConeColStacked100 101
xlCylinderBarClustered 95
xlCylinderBarStacked 96
xlCylinderBarStacked100 97
xlCylinderCol 98
xlCylinderColClustered 92
xlCylinderColStacked 93
xlCylinderColStacked100 94
xlDoughnut -4120
xlDoughnutExploded 80
xlLine 4
xlLineMarkers 65
xlLineMarkersStacked 66
xlLineMarkersStacked100 67
xlLineStacked 63
xlLineStacked100 64
xlPie 5
xlPieExploded 69
xlPieOfPie 68
xlPyramidBarClustered 109
xlPyramidBarStacked 110
xlPyramidBarStacked100 111
xlPyramidCol 112
xlPyramidColClustered 106
xlPyramidColStacked 107
xlPyramidColStacked100 108
xlRadar -4151
xlRadarFilled 82
xlRadarMarkers 81
xlStockHLC 88
xlStockOHLC 89
xlStockVHLC 90
xlStockVOHLC 91
xlSurface 83
xlSurfaceTopView 85
xlSurfaceTopViewWireframe 86
xlSurfaceWireframe 84
xlXYScatter -4169
xlXYScatterLines 74
xlXYScatterLinesNoMarkers 75
xlXYScatterSmooth 72
xlXYScatterSmoothNoMarkers 73
XlClipboardFormat
Constant Value
xlClipboardFormatBIFF 8
xlClipboardFormatBIFF2 18
xlClipboardFormatBIFF3 20
xlClipboardFormatBIFF4 30
xlClipboardFormatBinary 15
xlClipboardFormatBitmap 9
xlClipboardFormatCGM 13
xlClipboardFormatCSV 5
xlClipboardFormatDIF 4
xlClipboardFormatDspText 12
xlClipboardFormatEmbeddedObject 21
xlClipboardFormatEmbedSource 22
xlClipboardFormatLink 11
xlClipboardFormatLinkSource 23
xlClipboardFormatLinkSourceDesc 32
xlClipboardFormatMovie 24
xlClipboardFormatNative 14
xlClipboardFormatObjectDesc 31
xlClipboardFormatObjectLink 19
xlClipboardFormatOwnerLink 17
xlClipboardFormatPICT 2
xlClipboardFormatPrintPICT 3
xlClipboardFormatRTF 7
xlClipboardFormatScreenPICT 29
xlClipboardFormatStandardFont 28
xlClipboardFormatStandardScale 27
xlClipboardFormatSYLK 6
xlClipboardFormatTable 16
xlClipboardFormatText 0
xlClipboardFormatToolFace 25
xlClipboardFormatToolFacePICT 26
xlClipboardFormatVALU 1
xlClipboardFormatWK1 10
XlCmdType
Constant Value
xlCmdCube 1
xlCmdDefault 4
xlCmdList 5
xlCmdSql 2
xlCmdTable 3
XlColorIndex
Constant Value
xlColorIndexAutomatic -4105
xlColorIndexNone -4142
XlColumnDataType
Constant Value
xlDMYFormat 4
xlDYMFormat 7
xlEMDFormat 10
xlGeneralFormat 1
xlMDYFormat 3
xlMYDFormat 6
xlSkipColumn 9
xlTextFormat 2
xlYDMFormat 8
xlYMDFormat 5
XlCommandUnderlines
Constant Value
xlCommandUnderlinesAutomatic -4105
xlCommandUnderlinesOff -4146
xlCommandUnderlinesOn 1
XlCommentDisplayMode
Constant Value
xlCommentAndIndicator 1
xlCommentIndicatorOnly -1
xlNoIndicator 0
XlConsolidationFunction
Constant Value
xlAverage -4106
xlCount -4112
xlCountNums -4113
xlMax -4136
xlMin -4139
xlProduct -4149
xlStDev -4155
xlStDevP -4156
xlSum -4157
xlUnknown 1000
xlVar -4164
xlVarP -4165
XlCopyPictureFormat
Constant Value
xlBitmap 2
xlPicture -4147
XlCorruptLoad
Constant Value
xlExtractData 2
xlNormalLoad 0
xlRepairFile 1
XlCreator
Constant Value
xlCreatorCode 1480803660
XlCubeFieldType
Constant Value
xlHierarchy 1
xlMeasure 2
xlSet 3
XlCutCopyMode
Constant Value
xlCopy 1
xlCut 2
XlCVError
Constant Value
xlErrDiv0 2007
xlErrNA 2042
xlErrName 2029
xlErrNull 2000
xlErrNum 2036
xlErrRef 2023
xlErrValue 2015
XlDataLabelPosition
Constant Value
xlLabelPositionAbove 0
xlLabelPositionBelow 1
xlLabelPositionBestFit 5
xlLabelPositionCenter -4108
xlLabelPositionCustom 7
xlLabelPositionInsideBase 4
xlLabelPositionInsideEnd 3
xlLabelPositionLeft -4131
xlLabelPositionMixed 6
xlLabelPositionOutsideEnd 2
xlLabelPositionRight -4152
XlDataLabelSeparator
Constant Value
xlDataLabelSeparatorDefault 1
XlDataLabelsType
Constant Value
xlDataLabelsShowBubbleSizes 6
xlDataLabelsShowLabel 4
xlDataLabelsShowLabelAndPercent 5
xlDataLabelsShowNone -4142
xlDataLabelsShowPercent 3
xlDataLabelsShowValue 2
XlDataSeriesDate
Constant Value
xlDay 1
xlMonth 3
xlWeekday 2
xlYear 4
XlDataSeriesType
Constant Value
xlAutoFill 4
xlChronological 3
xlDataSeriesLinear -4132
xlGrowth 2
XlDeleteShiftDirection
Constant Value
xlShiftToLeft -4159
xlShiftUp -4162
XlDirection
Constant Value
xlDown -4121
xlToLeft -4159
xlToRight -4161
xlUp -4162
XlDisplayBlanksAs
Constant Value
xlInterpolated 3
xlNotPlotted 1
xlZero 2
XlDisplayDrawingObjects
Constant Value
xlDisplayShapes -4104
xlHide 3
xlPlaceholders 2
XlDisplayUnit
Constant Value
xlHundredMillions -8
xlHundreds -2
xlHundredThousands -5
xlMillionMillions -10
xlMillions -6
xlTenMillions -7
xlTenThousands -4
xlThousandMillions -9
xlThousands -3
XlDVAlertStyle
Constant Value
xlValidAlertInformation 3
xlValidAlertStop 1
xlValidAlertWarning 2
XlDVType
Constant Value
xlValidateCustom 7
xlValidateDate 4
xlValidateDecimal 2
xlValidateInputOnly 0
xlValidateList 3
xlValidateTextLength 6
xlValidateTime 5
xlValidateWholeNumber 1
XlEditionFormat
Constant Value
xlBIFF 2
xlPICT 1
xlRTF 4
xlVALU 8
XlEditionOptionsOption
Constant Value
xlAutomaticUpdate 4
xlCancel 1
xlChangeAttributes 6
xlManualUpdate 5
xlOpenSource 3
xlSelect 3
xlSendPublisher 2
xlUpdateSubscriber 2
XlEditionType
Constant Value
xlPublisher 1
xlSubscriber 2
XlEnableCancelKey
Constant Value
xlDisabled 0
xlErrorHandler 2
xlInterrupt 1
XlEnableSelection
Constant Value
xlNoRestrictions 0
xlNoSelection -4142
xlUnlockedCells 1
XlEndStyleCap
Constant Value
xlCap 1
xlNoCap 2
XlErrorBarDirection
Constant Value
xlX -4168
xlY 1
XlErrorBarInclude
Constant Value
xlErrorBarIncludeBoth 1
xlErrorBarIncludeMinusValues 3
xlErrorBarIncludeNone -4142
xlErrorBarIncludePlusValues 2
XlErrorBarType
Constant Value
xlErrorBarTypeCustom -4114
xlErrorBarTypeFixedValue 1
xlErrorBarTypePercent 2
xlErrorBarTypeStDev -4155
xlErrorBarTypeStError 4
XlErrorChecks
Constant Value
xlEmptyCellReferences 7
xlEvaluateToError 1
xlInconsistentFormula 4
xlListDataValidation 8
xlNumberAsText 3
xlOmittedCells 5
xlTextDate 2
xlUnlockedFormulaCells <
上一篇:pb的error.number,各种出错的中文解释
下一篇:关于鼠标按键单击变双击问题解决集锦
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:57:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlFileAccess
Constant Value
xlReadOnly 3
xlReadWrite 2
XlFileFormat
Constant Value
xlAddIn 18
xlCSV 6
xlCSVMac 22
xlCSVMSDOS 24
xlCSVWindows 23
xlCurrentPlatformText -4158
xlDBF2 7
xlDBF3 8
xlDBF4 11
xlDIF 9
xlExcel2 16
xlExcel2FarEast 27
xlExcel3 29
xlExcel4 33
xlExcel4Workbook 35
xlExcel5 39
xlExcel7 39
xlExcel9795 43
xlHtml 44
xlIntlAddIn 26
xlIntlMacro 25
xlSYLK 2
xlTemplate 17
xlTextMac 19
xlTextMSDOS 21
xlTextPrinter 36
xlTextWindows 20
xlUnicodeText 42
xlWebArchive 45
xlWJ2WD1 14
xlWJ3 40
xlWJ3FJ3 41
xlWK1 5
xlWK1ALL 31
xlWK1FMT 30
xlWK3 15
xlWK3FM3 32
xlWK4 38
xlWKS 4
xlWorkbookNormal -4143
xlWorks2FarEast 28
xlWQ1 34
xlXMLData 47
xlXMLSpreadsheet 46
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlFillWith
Constant Value
xlFillWithAll -4104
xlFillWithContents 2
xlFillWithFormats -4122
XlFilterAction
Constant Value
xlFilterCopy 2
xlFilterInPlace 1
XlFindLookIn
Constant Value
xlComments -4144
xlFormulas -4123
xlValues -4163
XlFormatConditionOperator
Constant Value
xlBetween 1
xlEqual 3
xlGreater 5
xlGreaterEqual 7
xlLess 6
xlLessEqual 8
xlNotBetween 2
xlNotEqual 4
XlFormatConditionType
Constant Value
xlCellValue 1
xlExpression 2
XlFormControl
Constant Value
xlButtonControl 0
xlCheckBox 1
xlDropDown 2
xlEditBox 3
xlGroupBox 4
xlLabel 5
xlListBox 6
xlOptionButton 7
xlScrollBar 8
xlSpinner 9
XlFormulaLabel
Constant Value
xlColumnLabels 2
xlMixedLabels 3
xlNoLabels -4142
xlRowLabels 1
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlHAlign
Constant Value
xlHAlignCenter -4108
xlHAlignCenterAcrossSelection 7
xlHAlignDistributed -4117
xlHAlignFill 5
xlHAlignGeneral 1
xlHAlignJustify -4130
xlHAlignLeft -4131
xlHAlignRight -4152
XlHebrewModes
Constant Value
xlHebrewFullScript 0
xlHebrewMixedAuthorizedScript 3
xlHebrewMixedScript 2
xlHebrewPartialScript 1
XlHighlightChangesTime
Constant Value
xlAllChanges 2
xlNotYetReviewed 3
xlSinceMyLastSave 1
XlHtmlType
Constant Value
xlHtmlCalc 1
xlHtmlChart 3
xlHtmlList 2
xlHtmlStatic 0
XlIMEMode
Constant Value
xlIMEModeAlpha 8
xlIMEModeAlphaFull 7
xlIMEModeDisable 3
xlIMEModeHangul 10
xlIMEModeHangulFull 9
xlIMEModeHiragana 4
xlIMEModeKatakana 5
xlIMEModeKatakanaHalf 6
xlIMEModeNoControl 0
xlIMEModeOff 2
xlIMEModeOn 1
XlImportDataAs
Constant Value
xlPivotTableReport 1
xlQueryTable 0
XlInsertFormatOrigin
Constant Value
xlFormatFromLeftOrAbove 0
xlFormatFromRightOrBelow 1
XlInsertShiftDirection
Constant Value
xlShiftDown -4121
xlShiftToRight -4161
XlLayoutFormType
Constant Value
xlOutline 1
xlTabular 0
XlLegendPosition
Constant Value
xlLegendPositionBottom -4107
xlLegendPositionCorner 2
xlLegendPositionLeft -4131
xlLegendPositionRight -4152
xlLegendPositionTop -4160
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlLineStyle
Constant Value
xlContinuous 1
xlDash -4115
xlDashDot 4
xlDashDotDot 5
xlDot -4118
xlDouble -4119
xlLineStyleNone -4142
xlSlantDashDot 13
XlLink
Constant Value
xlExcelLinks 1
xlOLELinks 2
xlPublishers 5
xlSubscribers 6
XlLinkInfo
Constant Value
xlEditionDate 2
xlLinkInfoStatus 3
xlUpdateState 1
XlLinkInfoType
Constant Value
xlLinkInfoOLELinks 2
xlLinkInfoPublishers 5
xlLinkInfoSubscribers 6
XlLinkStatus
Constant Value
xlLinkStatusCopiedValues 10
xlLinkStatusIndeterminate 5
xlLinkStatusInvalidName 7
xlLinkStatusMissingFile 1
xlLinkStatusMissingSheet 2
xlLinkStatusNotStarted 6
xlLinkStatusOK 0
xlLinkStatusOld 3
xlLinkStatusSourceNotCalculated 4
xlLinkStatusSourceNotOpen 8
xlLinkStatusSourceOpen 9
XlLinkType
Constant Value
xlLinkTypeExcelLinks 1
xlLinkTypeOLELinks 2
XlListConflict
Constant Value
xlListConflictDialog 0
xlListConflictDiscardAllConflicts 2
xlListConflictError 3
xlListConflictRetryAllConflicts 1
XlListDataType
Constant Value
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
Constant Value
xlSrcExternal 0
xlSrcRange 1
xlSrcXml 2
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlLocationInTable
Constant Value
xlColumnHeader -4110
xlColumnItem 5
xlDataHeader 3
xlDataItem 7
xlPageHeader 2
xlPageItem 6
xlRowHeader -4153
xlRowItem 4
xlTableBody 8
XlLookAt
Constant Value
xlPart 2
xlWhole 1
XlMailSystem
Constant Value
xlMAPI 1
xlNoMailSystem 0
xlPowerTalk 2
XlMarkerStyle
Constant Value
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
Constant Value
xlNoButton 0
xlPrimaryButton 1
xlSecondaryButton 2
XlMousePointer
Constant Value
xlDefault -4143
xlIBeam 3
xlNorthwestArrow 1
xlWait 2
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlMSApplication
Constant Value
xlMicrosoftAccess 4
xlMicrosoftFoxPro 5
xlMicrosoftMail 3
xlMicrosoftPowerPoint 2
xlMicrosoftProject 6
xlMicrosoftSchedulePlus 7
xlMicrosoftWord 1
XlObjectSize
Constant Value
xlFitToPage 2
xlFullPage 3
xlScreenSize 1
XlOLEType
Constant Value
xlOLEControl 2
xlOLEEmbed 1
xlOLELink 0
XlOLEVerb
Constant Value
xlVerbOpen 2
xlVerbPrimary 1
XlOrder
Constant Value
xlDownThenOver 1
xlOverThenDown 2
XlOrientation
Constant Value
xlDownward -4170
xlHorizontal -4128
xlUpward -4171
xlVertical -4166
XlPageBreak
Constant Value
xlPageBreakAutomatic -4105
xlPageBreakManual -4135
xlPageBreakNone -4142
XlPageBreakExtent
Constant Value
xlPageBreakFull 1
xlPageBreakPartial 2
XlPageOrientation
Constant Value
xlLandscape 2
xlPortrait 1
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlPaperSize
Constant Value
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
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlParameterDataType
Constant Value
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
Constant Value
xlConstant 1
xlPrompt 0
xlRange 2
XlPasteSpecialOperation
Constant Value
xlPasteSpecialOperationAdd 2
xlPasteSpecialOperationDivide 5
xlPasteSpecialOperationMultiply 4
xlPasteSpecialOperationNone -4142
xlPasteSpecialOperationSubtract 3
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlPasteType
Constant Value
xlPasteAll -4104
xlPasteAllExceptBorders 7
xlPasteColumnWidths 8
xlPasteComments -4144
xlPasteFormats -4122
xlPasteFormulas -4123
xlPasteFormulasAndNumberFormats 11
xlPasteValidation 6
xlPasteValues -4163
xlPasteValuesAndNumberFormats 12
XlPattern
Constant Value
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
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlPhoneticAlignment
Constant Value
xlPhoneticAlignCenter 2
xlPhoneticAlignDistributed 3
xlPhoneticAlignLeft 1
xlPhoneticAlignNoControl 0
XlPhoneticCharacterType
Constant Value
xlHiragana 2
xlKatakana 1
xlKatakanaHalf 0
xlNoConversion 3
XlPictureAppearance
Constant Value
xlPrinter 2
xlScreen 1
XlPictureConvertorType
Constant Value
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
Constant Value
xlPivotCellBlankCell 9
xlPivotCellCustomSubtotal 7
xlPivotCellDataField 4
xlPivotCellDataPivotField 8
xlPivotCellGrandTotal 3
xlPivotCellPageFieldItem 6
xlPivotCellPivotField 5
xlPivotCellPivotItem 1
xlPivotCellSubtotal 2
xlPivotCellValue 0
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlPivotFieldCalculation
Constant Value
xlDifferenceFrom 2
xlIndex 9
xlNoAdditionalCalculation -4143
xlPercentDifferenceFrom 4
xlPercentOf 3
xlPercentOfColumn 7
xlPercentOfRow 6
xlPercentOfTotal 8
xlRunningTotal 5
XlPivotFieldDataType
Constant Value
xlDate 2
xlNumber -4145
xlText -4158
XlPivotFieldOrientation
Constant Value
xlColumnField 2
xlDataField 4
xlHidden 0
xlPageField 3
xlRowField 1
XlPivotFormatType
Constant Value
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
xlTable8 17
xlTable9 18
XlPivotTableMissingItems
Constant Value
xlMissingItemsDefault -1
xlMissingItemsMax 32500
xlMissingItemsNone 0
XlPivotTableSourceType
Constant Value
xlConsolidation 3
xlDatabase 1
xlExternal 2
xlPivotTable -4148
xlScenario 4
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlPivotTableVersionList
Constant Value
xlPivotTableVersion10 1
xlPivotTableVersion2000 0
xlPivotTableVersionCurrent -1
XlPlacement
Constant Value
xlFreeFloating 3
xlMove 2
xlMoveAndSize 1
XlPlatform
Constant Value
xlMacintosh 1
xlMSDOS 3
xlWindows 2
XlPrintErrors
Constant Value
xlPrintErrorsBlank 1
xlPrintErrorsDash 2
xlPrintErrorsDisplayed 0
xlPrintErrorsNA 3
XlPrintLocation
Constant Value
xlPrintInPlace 16
xlPrintNoComments -4142
xlPrintSheetEnd 1
XlPriority
Constant Value
xlPriorityHigh -4127
xlPriorityLow -4134
xlPriorityNormal -4143
XlPTSelectionMode
Constant Value
xlBlanks 4
xlButton 15
xlDataAndLabel 0
xlDataOnly 2
xlFirstRow 256
xlLabelOnly 1
xlOrigin 3
XlQueryType
Constant Value
xlADORecordset 7
xlDAORecordset 2
xlODBCQuery 1
xlOLEDBQuery 5
xlTextImport 6
xlWebQuery 4
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlRangeAutoFormat
Constant Value
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
Constant Value
xlRangeValueDefault 10
xlRangeValueMSPersistXML 12
xlRangeValueXMLSpreadsheet 11
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlReferenceStyle
Constant Value
xlA1 1
xlR1C1 -4150
XlReferenceType
Constant Value
xlAbsolute 1
xlAbsRowRelColumn 2
xlRelative 4
xlRelRowAbsColumn 3
XlRobustConnect
Constant Value
xlAlways 1
xlAsRequired 0
xlNever 2
XlRoutingSlipDelivery
Constant Value
xlAllAtOnce 2
xlOneAfterAnother 1
XlRoutingSlipStatus
Constant Value
xlNotYetRouted 0
xlRoutingComplete 2
xlRoutingInProgress 1
XlRowCol
Constant Value
xlColumns 2
xlRows 1
XlRunAutoMacro
Constant Value
xlAutoActivate 3
xlAutoClose 2
xlAutoDeactivate 4
xlAutoOpen 1
XlSaveAction
Constant Value
xlDoNotSaveChanges 2
xlSaveChanges 1
XlSaveAsAccessMode
Constant Value
xlExclusive 3
xlNoChange 1
xlShared 2
XlSaveConflictResolution
Constant Value
xlLocalSessionChanges 2
xlOtherSessionChanges 3
xlUserResolution 1
XlScaleType
Constant Value
xlScaleLinear -4132
xlScaleLogarithmic -4133
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlSearchDirection
Constant Value
xlNext 1
xlPrevious 2
XlSearchOrder
Constant Value
xlByColumns 2
xlByRows 1
XlSearchWithin
Constant Value
xlWithinSheet 1
xlWithinWorkbook 2
XlSheetType
Constant Value
xlChart -4109
xlDialogSheet -4116
xlExcel4IntlMacroSheet 4
xlExcel4MacroSheet 3
xlWorksheet -4167
XlSheetVisibility
Constant Value
xlSheetHidden 0
xlSheetVeryHidden 2
xlSheetVisible -1
XlSizeRepresents
Constant Value
xlSizeIsArea 1
xlSizeIsWidth 2
XlSmartTagControlType
Constant Value
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
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlSmartTagDisplayMode
Constant Value
xlButtonOnly 2
xlDisplayNone 1
xlIndicatorAndButton 0
XlSortDataOption
Constant Value
xlSortNormal 0
xlSortTextAsNumbers 1
XlSortMethod
Constant Value
xlPinYin 1
xlStroke 2
XlSortMethodOld
Constant Value
xlCodePage 2
xlSyllabary 1
XlSortOrder
Constant Value
xlAscending 1
xlDescending 2
XlSortOrientation
Constant Value
xlSortColumns 1
xlSortRows 2
XlSortType
Constant Value
xlSortLabels 2
xlSortValues 1
XlSourceType
Constant Value
xlSourceAutoFilter 3
xlSourceChart 5
xlSourcePivotTable 6
xlSourcePrintArea 2
xlSourceQuery 7
xlSourceRange 4
xlSourceSheet 1
xlSourceWorkbook 0
XlSpeakDirection
Constant Value
xlSpeakByColumns 1
xlSpeakByRows 0
XlSpecialCellsValue
Constant Value
xlErrors 16
xlLogical 4
xlNumbers 1
xlTextValues 2
XlSubscribeToFormat
Constant Value
xlSubscribeToPicture -4147
xlSubscribeToText -4158
XlSubtototalLocationType
Constant Value
xlAtBottom 2
xlAtTop 1
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlSummaryColumn
Constant Value
xlSummaryOnLeft -4131
xlSummaryOnRight -4152
XlSummaryReportType
Constant Value
xlStandardSummary 1
xlSummaryPivotTable -4148
XlSummaryRow
Constant Value
xlSummaryAbove 0
xlSummaryBelow 1
XlTabPosition
Constant Value
xlTabPositionFirst 0
xlTabPositionLast 1
XlTextParsingType
Constant Value
xlDelimited 1
xlFixedWidth 2
XlTextQualifier
Constant Value
xlTextQualifierDoubleQuote 1
xlTextQualifierNone -4142
xlTextQualifierSingleQuote 2
XlTextVisualLayoutType
Constant Value
xlTextVisualLTR 1
xlTextVisualRTL 2
XlTickLabelOrientation
Constant Value
xlTickLabelOrientationAutomatic -4105
xlTickLabelOrientationDownward -4170
xlTickLabelOrientationHorizontal -4128
xlTickLabelOrientationUpward -4171
xlTickLabelOrientationVertical -4166
XlTickLabelPosition
Constant Value
xlTickLabelPositionHigh -4127
xlTickLabelPositionLow -4134
xlTickLabelPositionNextToAxis 4
xlTickLabelPositionNone -4142
XlTickMark
Constant Value
xlTickMarkCross 4
xlTickMarkInside 2
xlTickMarkNone -4142
xlTickMarkOutside 3
XlTimeUnit
Constant Value
xlDays 0
xlMonths 1
xlYears 2
XlToolbarProtection
Constant Value
xlNoButtonChanges 1
xlNoChanges 4
xlNoDockingChanges 3
xlNoShapeChanges 2
xlToolbarProtectionNone -4143
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlTotalsCalculation
Constant Value
xlTotalsCalculationAverage 2
xlTotalsCalculationCount 3
xlTotalsCalculationCountNums 4
xlTotalsCalculationMax 6
xlTotalsCalculationMin 5
xlTotalsCalculationNone 0
xlTotalsCalculationStdDev 7
xlTotalsCalculationSum 1
xlTotalsCalculationVar 8
XlTrendlineType
Constant Value
xlExponential 5
xlLinear -4132
xlLogarithmic -4133
xlMovingAvg 6
xlPolynomial 3
xlPower 4
XlUnderlineStyle
Constant Value
xlUnderlineStyleDouble -4119
xlUnderlineStyleDoubleAccounting 5
xlUnderlineStyleNone -4142
xlUnderlineStyleSingle 2
xlUnderlineStyleSingleAccounting 4
XlUpdateLinks
Constant Value
xlUpdateLinksAlways 3
xlUpdateLinksNever 2
xlUpdateLinksUserSetting 1
XlVAlign
Constant Value
xlVAlignBottom -4107
xlVAlignCenter -4108
xlVAlignDistributed -4117
xlVAlignJustify -4130
xlVAlignTop -4160
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlWBATemplate
Constant Value
xlWBATChart -4109
xlWBATExcel4IntlMacroSheet 4
xlWBATExcel4MacroSheet 3
xlWBATWorksheet -4167
XlWebFormatting
Constant Value
xlWebFormattingAll 1
xlWebFormattingNone 3
xlWebFormattingRTF 2
XlWebSelectionType
Constant Value
xlAllTables 2
xlEntirePage 1
xlSpecifiedTables 3
XlWindowState
Constant Value
xlMaximized -4137
xlMinimized -4140
xlNormal -4143
XlWindowType
Constant Value
xlChartAsWindow 5
xlChartInPlace 4
xlClipboard 3
xlInfo -4129
xlWorkbook 1
XlWindowView
Constant Value
xlNormalView 1
xlPageBreakPreview 2
XlXLMMacroType
Constant Value
xlCommand 2
xlFunction 1
xlNotXLM 3
XlXmlExportResult
Constant Value
xlXmlExportSuccess 0
xlXmlExportValidationFailed 1
XlXmlImportResult
Constant Value
xlXmlImportElementsTruncated 1
xlXmlImportSuccess 0
xlXmlImportValidationFailed 2
XlXmlLoadOption
Constant Value
xlXmlLoadImportToList 2
xlXmlLoadMapXml 3
xlXmlLoadOpenXml 1
xlXmlLoadPromptUser 0
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:07:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlYesNoGuess
Constant Value
xlGuess 0
xlNo 2
xlYes 1
完了,excel里常用的常量都在这里,如果要在程序里操作excel的话呢,可以打开excel,然后呢,选菜单里的录制宏,然后呢,干你想要干的操作,录制完后呢,再强加宏,这样子就成在vba的编辑器里查到宏的代码了,刚才的操作如果成要用代码生成就成用这些宏的代码
不过宏里的代码用的全是常数来的,要转成数字才成在其它语言里用,这里成查到这些常数对应的数字
在www.tiantiansoft.com/bbs/index.asp里,成查到更多的资料
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2006-3-25 18:33:00 个人主页 | 引用 | 返回 | 删除 | 回复
{ XlSheetType }
xlChart = -4109;
xlDialogSheet = -4116;
xlExcel4IntlMacroSheet = 4;
xlExcel4MacroSheet = 3;
xlWorksheet = -4167;
{ XlWBATemplate }
xlWBATChart = -4109;
xlWBATExcel4IntlMacroSheet = 4;
xlWBATExcel4MacroSheet = 3;
xlWBATWorksheet = -4167;
{ 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;
{ XlBordersIndex }
xlInsideHorizontal = 12;
xlInsideVertical = 11;
xlDiagonalDown = 5;
xlDiagonalUp = 6;
xlEdgeBottom = 9;
xlEdgeLeft = 7;
xlEdgeRight = 10;
xlEdgeTop = 8;
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2006-3-25 18:33:00 个人主页 | 引用 | 返回 | 删除 | 回复
{ XlLineStyle. }
xlContinuous = 1;
xlDash = -4115;
xlDashDot = 4;
xlDashDotDot = 5;
xlDot = -4118;
xlDouble = -4119;
xlSlantDashDot = 13;
xlLineStyleNone = -4142;
{ XlChartType }
xlColumnClustered = 51;
xlColumnStacked = 52;
xlColumnStacked100 = 53;
xl3DColumnClustered = 54;
xl3DColumnStacked = 55;
xl3DColumnStacked100 = 56;
xlBarClustered = 57;
xlBarStacked = 58;
xlBarStacked100 = 59;
xl3DBarClustered = 60;
xl3DBarStacked = 61;
xl3DBarStacked100 = 62;
xlLineStacked = 63;
xlLineStacked100 = 64;
xlLineMarkers = 65;
xlLineMarkersStacked = 66;
xlLineMarkersStacked100 = 67;
xlPieOfPie = 68;
xlPieExploded = 69;
xl3DPieExploded = 70;
xlBarOfPie = 71;
xlXYScatterSmooth = 72;
xlXYScatterSmoothNoMarkers = 73;
xlXYScatterLines = 74;
xlXYScatterLinesNoMarkers = 75;
xlAreaStacked = 76;
xlAreaStacked100 = 77;
xl3DAreaStacked = 78;
xl3DAreaStacked100 = 79;
xlDoughnutExploded = 80;
xlRadarMarkers = 81;
xlRadarFilled = 82;
xlSurface = 83;
xlSurfaceWireframe. = 84;
xlSurfaceTopView = 85;
xlSurfaceTopViewWireframe. = 86;
xlBubble = 15;
xlBubble3DEffect = 87;
xlStockHLC = 88;
xlStockOHLC = 89;
xlStockVHLC = 90;
xlStockVOHLC = 91;
xlCylinderColClustered = 92;
xlCylinderColStacked = 93;
xlCylinderColStacked100 = 94;
xlCylinderBarClustered = 95;
xlCylinderBarStacked = 96;
xlCylinderBarStacked100 = 97;
xlCylinderCol = 98;
xlConeColClustered = 99;
xlConeColStacked = 100;
xlConeColStacked100 = 101;
xlConeBarClustered = 102;
xlConeBarStacked = 103;
xlConeBarStacked100 = 104;
xlConeCol = 105;
xlPyramidColClustered = 106;
xlPyramidColStacked = 107;
xlPyramidColStacked100 = 108;
xlPyramidBarClustered = 109;
xlPyramidBarStacked = 110;
xlPyramidBarStacked100 = 111;
xlPyramidCol = 112;
xl3DColumn = -4100;
xlLine = 4;
xl3DLine = -4101;
xl3DPie = -4102;
xlPie = 5;
xlXYScatter = -4169;
xl3DArea = -4098;
xlArea = 1;
xlDoughnut = -4120;
xlRadar = -4151;
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2006-3-25 18:34:00 个人主页 | 引用 | 返回 | 删除 | 回复
{ Various Constants }
xlAll = -4104;
xlAutomatic = -4105;
xlBoth = 1;
xlCenter = -4108;
xlChecker = 9;
xlCircle = 8;
xlCorner = 2;
xlCrissCross = 16;
xlCross = 4;
xlDiamond = 2;
xlDistributed = -4117;
xlDoubleAccounting = 5;
xlFixedvalue = 1;
xlFormats = -4122;
xlGray16 = 17;
xlGray8 = 18;
xlGrid = 15;
xlHigh = -4127;
xlInside = 2;
xlJustify = -4130;
xlLightDown = 13;
xlLightHorizontal = 11;
xlLightUp = 14;
xlLightVertical = 12;
xlLow = -4134;
xlManual = -4135;
xlMinusvalues = 3;
xlModule = -4141;
xlNextToAxis = 4;
xlNone = -4142;
xlNotes = -4144;
xlOff = -4146;
xlOn = 1;
xlPercent = 2;
xlPlus = 9;
xlPlusvalues = 2;
xlSemiGray75 = 10;
xlShowLabel = 4;
xlShowLabelAndPercent = 5;
xlShowPercent = 3;
xlShowvalue = 2;
xlSimple = -4154;
xlSingle = 2;
xlSingleAccounting = 4;
xlSolid = 1;
xlSquare = 1;
xlStar = 5;
xlStError = 4;
xlToolbarButton = 2;
xlTriangle = 3;
xlGray25 = -4124;
xlGray50 = -4125;
xlGray75 = -4126;
xlBottom = -4107;
xlLeft = -4131;
xlRight = -4152;
xlTop = -4160;
xl3DBar = -4099;
xl3DSurface = -4103;
xlBar = 2;
xlColumn = 3;
xlCombination = -4111;
xlCustom = -4114;
xlDefaultAutoFormat = -1;
xlMaximum = 2;
xlMinimum = 4;
xlOpaque = 3;
xlTransparent = 2;
xlBidi = -5000;
xlLatin = -5001;
xlContext = -5002;
xlLTR = -5003;
xlRTL = -5004;
xlVisualCursor = 2;
xlLogicalCursor = 1;
xlSystem = 1;
xlPartial = 3;
xlHindiNumerals = 3;
xlBidiCalendar = 3;
xlGregorian = 2;
xlComplete = 4;
xlScale = 3;
xlClosed = 3;
xlColor1 = 7;
xlColor2 = 8;
xlColor3 = 9;
xlConstants = 2;
xlContents = 2;
xlBelow = 1;
xlCascade = 7;
xlCenterAcrossSelection = 7;
xlChart4 = 2;
xlChartSeries = 17;
xlChartShort = 6;
xlChartTitles = 18;
xlClassic1 = 1;
xlClassic2 = 2;
xlClassic3 = 3;
xl3DEffects1 = 13;
xl3DEffects2 = 14;
xlAbove = 0;
xlAccounting1 = 4;
xlAccounting2 = 5;
xlAccounting3 = 6;
xlAccounting4 = 17;
xlAdd = 2;
xlDebugCodePane = 13;
xlDesktop = 9;
xlDirect = 1;
xlDivide = 5;
xlDoubleClosed = 5;
xlDoubleOpen = 4;
xlDoubleQuote = 1;
xlEntireChart = 20;
xlExcelMenus = 1;
xlExtended = 3;
xlFill = 5;
xlFirst = 0;
xlFloating = 5;
xlFormula = 5;
xlGeneral = 1;
xlGridline = 22;
xlIcons = 1;
xlImmediatePane = 12;
xlInteger = 2;
xlLast = 1;
xlLastCell = 11;
xlList1 = 10;
xlList2 = 11;
xlList3 = 12;
xlLocalFormat1 = 15;
xlLocalFormat2 = 16;
xlLong = 3;
xlLotusHelp = 2;
xlMacrosheetCell = 7;
xlMixed = 2;
xlMultiply = 4;
xlNarrow = 1;
xlNodocument. = 3;
xlOpen = 2;
xlOutside = 3;
xlReference = 4;
xlSemiautomatic = 2;
xlShort = 1;
xlSingleQuote = 2;
xlStrict = 2;
xlSubtract = 3;
xlTextBox = 16;
xlTiled = 1;
xlTitleBar = 8;
xlToolbar = 1;
xlVisible = 12;
xlWatchPane = 11;
xlWide = 3;
xlWorkbookTab = 6;
xlWorksheet4 = 1;
xlWorksheetCell = 3;
xlWorksheetShort = 5;
xlAllExceptBorders = 6;
xlLeftToRight = 2;
xlTopToBottom = 1;
xlVeryHidden = 2;
xlDrawingObject = 14;
※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:19:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoLineDashStyle
{
msoLineDashStyleMixed = -2,
msoLineSolid = 1,
msoLineSquareDot = 2,
msoLineRoundDot = 3,
msoLineDash = 4,
msoLineDashDot = 5,
msoLineDashDotDot = 6,
msoLineLongDash = 7,
msoLineLongDashDot = 8
};
enum MsoLineStyle
{
msoLineStyleMixed = -2,
msoLineSingle = 1,
msoLineThinThin = 2,
msoLineThinThick = 3,
msoLineThickThin = 4,
msoLineThickBetweenThin = 5
};
enum MsoArrowheadStyle
{
msoArrowheadStyleMixed = -2,
msoArrowheadNone = 1,
msoArrowheadTriangle = 2,
msoArrowheadOpen = 3,
msoArrowheadStealth = 4,
msoArrowheadDiamond = 5,
msoArrowheadOval = 6
};
enum MsoArrowheadWidth
{
msoArrowheadWidthMixed = -2,
msoArrowheadNarrow = 1,
msoArrowheadWidthMedium = 2,
msoArrowheadWide = 3
};
enum MsoArrowheadLength
{
msoArrowheadLengthMixed = -2,
msoArrowheadShort = 1,
msoArrowheadLengthMedium = 2,
msoArrowheadLong = 3
};
enum MsoFillType
{
msoFillMixed = -2,
msoFillSolid = 1,
msoFillPatterned = 2,
msoFillGradient = 3,
msoFillTextured = 4,
msoFillBackground = 5,
msoFillPicture = 6
};
enum MsoGradientStyle
{
msoGradientMixed = -2,
msoGradientHorizontal = 1,
msoGradientVertical = 2,
msoGradientDiagonalUp = 3,
msoGradientDiagonalDown = 4,
msoGradientFromCorner = 5,
msoGradientFromTitle = 6,
msoGradientFromCenter = 7
};
enum MsoGradientColorType
{
msoGradientColorMixed = -2,
msoGradientOneColor = 1,
msoGradientTwoColors = 2,
msoGradientPresetColors = 3
};
enum MsoTextureType
{
msoTextureTypeMixed = -2,
msoTexturePreset = 1,
msoTextureUserDefined = 2
};