-
转:Excel常用枚举常量列表
2009-09-17 14:20:56
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 19XlApplyNamesOrder
Constant Value
xlColumnThenRow 2
xlRowThenColumn 1XlArabicModes
Constant Value
xlArabicBothStrict 3
xlArabicNone 0
xlArabicStrictAlefHamza 1
xlArabicStrictFinalYaa 2XlArrangeStyle
Constant Value
xlArrangeStyleCascade 7
xlArrangeStyleHorizontal -4128
xlArrangeStyleTiled 1
xlArrangeStyleVertical -4166XlArrowHeadLength
Constant Value
xlArrowHeadLengthLong 3
xlArrowHeadLengthMedium -4138
xlArrowHeadLengthShort 1XlArrowHeadStyle
Constant Value
xlArrowHeadStyleClosed 3
xlArrowHeadStyleDoubleClosed 5
xlArrowHeadStyleDoubleOpen 4
xlArrowHeadStyleNone -4142
xlArrowHeadStyleOpen 2XlArrowHeadWidth
Constant Value
xlArrowHeadWidthMedium -4138
xlArrowHeadWidthNarrow 1
xlArrowHeadWidthWide 3XlAutoFillType
Constant Value
xlFillCopy 1
xlFillDays 5
xlFillDefault 0
xlFillFormats 3
xlFillMonths 7
xlFillSeries 2
xlFillValues 4
xlFillWeekdays 6
xlFillYears 8
xlGrowthTrend 10
xlLinearTrend 9XlAutoFilterOperator
Constant Value
xlAnd 1
xlBottom10Items 4
xlBottom10Percent 6
xlOr 2
xlTop10Items 3
xlTop10Percent 5XlAxisCrosses
Constant Value
xlAxisCrossesAutomatic -4105
xlAxisCrossesCustom -4114
xlAxisCrossesMaximum 2
xlAxisCrossesMinimum 4XlAxisGroup
Constant Value
xlPrimary 1
xlSecondary 2XlAxisType
Constant Value
xlCategory 1
xlSeriesAxis 3
xlValue 2XlBackground
Constant Value
xlBackgroundAutomatic -4105
xlBackgroundOpaque 3
xlBackgroundTransparent 2XlBarShape
Constant Value
xlBox 0
xlConeToMax 5
xlConeToPoint 4
xlCylinder 3
xlPyramidToMax 2
xlPyramidToPoint 1XlBordersIndex
Constant Value
xlDiagonalDown 5
xlDiagonalUp 6
xlEdgeBottom 9
xlEdgeLeft 7
xlEdgeRight 10
xlEdgeTop 8
xlInsideHorizontal 12
xlInsideVertical 11XlBorderWeight
Constant Value
xlHairline 1
xlMedium -4138
xlThick 4
xlThin 2XlBuiltInDialog
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 256XlCalculatedMemberType
Constant Value
xlCalculatedMember 0
xlCalculatedSet 1XlCalculation
Constant Value
xlCalculationAutomatic -4105
xlCalculationManual -4135
xlCalculationSemiautomatic 2XlCalculationInterruptKey
Constant Value
xlAnyKey 2
xlEscKey 1
xlNoKey 0XlCalculationState
Constant Value
xlCalculating 1
xlDone 0
xlPending 2XlCategoryType
Constant Value
xlAutomaticScale -4105
xlCategoryScale 2
xlTimeScale 3XlCellInsertionMode
Constant Value
xlInsertDeleteCells 1
xlInsertEntireRows 2
xlOverwriteCells 0XlCellType
Constant Value
xlCellTypeAllFormatConditions -4172
xlCellTypeAllValidation -4174
xlCellTypeBlanks 4
xlCellTypeComments -4144
xlCellTypeConstants 2
xlCellTypeFormulas -4123
xlCellTypeLastCell 11
xlCellTypeSameFormatConditions -4173
xlCellTypeSameValidation -4175
xlCellTypeVisible 12XlChartGallery
Constant Value
xlAnyGallery 23
xlBuiltIn 21
xlUserDefined 22XlChartItem
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 11XlChartLocation
Constant Value
xlLocationAsNewSheet 1
xlLocationAsObject 2
xlLocationAutomatic 3XlChartPicturePlacement
Constant Value
xlAllFaces 7
xlEnd 2
xlEndSides 3
xlFront 4
xlFrontEnd 6
xlFrontSides 5
xlSides 1XlChartPictureType
Constant Value
xlStack 2
xlStackScale 3
xlStretch 1XlChartSplitType
Constant Value
xlSplitByCustomSplit 4
xlSplitByPercentValue 3
xlSplitByPosition 1
xlSplitByValue 2XlChartType
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 73XlClipboardFormat
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 10XlCmdType
Constant Value
xlCmdCube 1
xlCmdDefault 4
xlCmdList 5
xlCmdSql 2
xlCmdTable 3XlColorIndex
Constant Value
xlColorIndexAutomatic -4105
xlColorIndexNone -4142XlColumnDataType
Constant Value
xlDMYFormat 4
xlDYMFormat 7
xlEMDFormat 10
xlGeneralFormat 1
xlMDYFormat 3
xlMYDFormat 6
xlSkipColumn 9
xlTextFormat 2
xlYDMFormat 8
xlYMDFormat 5XlCommandUnderlines
Constant Value
xlCommandUnderlinesAutomatic -4105
xlCommandUnderlinesOff -4146
xlCommandUnderlinesOn 1XlCommentDisplayMode
Constant Value
xlCommentAndIndicator 1
xlCommentIndicatorOnly -1
xlNoIndicator 0XlConsolidationFunction
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 -4165XlCopyPictureFormat
Constant Value
xlBitmap 2
xlPicture -4147XlCorruptLoad
Constant Value
xlExtractData 2
xlNormalLoad 0
xlRepairFile 1XlCreator
Constant Value
xlCreatorCode 1480803660XlCubeFieldType
Constant Value
xlHierarchy 1
xlMeasure 2
xlSet 3XlCutCopyMode
Constant Value
xlCopy 1
xlCut 2XlCVError
Constant Value
xlErrDiv0 2007
xlErrNA 2042
xlErrName 2029
xlErrNull 2000
xlErrNum 2036
xlErrRef 2023
xlErrValue 2015XlDataLabelPosition
Constant Value
xlLabelPositionAbove 0
xlLabelPositionBelow 1
xlLabelPositionBestFit 5
xlLabelPositionCenter -4108
xlLabelPositionCustom 7
xlLabelPositionInsideBase 4
xlLabelPositionInsideEnd 3
xlLabelPositionLeft -4131
xlLabelPositionMixed 6
xlLabelPositionOutsideEnd 2
xlLabelPositionRight -4152XlDataLabelSeparator
Constant Value
xlDataLabelSeparatorDefault 1XlDataLabelsType
Constant Value
xlDataLabelsShowBubbleSizes 6
xlDataLabelsShowLabel 4
xlDataLabelsShowLabelAndPercent 5
xlDataLabelsShowNone -4142
xlDataLabelsShowPercent 3
xlDataLabelsShowValue 2XlDataSeriesDate
Constant Value
xlDay 1
xlMonth 3
xlWeekday 2
xlYear 4XlDataSeriesType
Constant Value
xlAutoFill 4
xlChronological 3
xlDataSeriesLinear -4132
xlGrowth 2XlDeleteShiftDirection
Constant Value
xlShiftToLeft -4159
xlShiftUp -4162XlDirection
Constant Value
xlDown -4121
xlToLeft -4159
xlToRight -4161
xlUp -4162XlDisplayBlanksAs
Constant Value
xlInterpolated 3
xlNotPlotted 1
xlZero 2XlDisplayDrawingObjects
Constant Value
xlDisplayShapes -4104
xlHide 3
xlPlaceholders 2XlDisplayUnit
Constant Value
xlHundredMillions -8
xlHundreds -2
xlHundredThousands -5
xlMillionMillions -10
xlMillions -6
xlTenMillions -7
xlTenThousands -4
xlThousandMillions -9
xlThousands -3XlDVAlertStyle
Constant Value
xlValidAlertInformation 3
xlValidAlertStop 1
xlValidAlertWarning 2XlDVType
Constant Value
xlValidateCustom 7
xlValidateDate 4
xlValidateDecimal 2
xlValidateInputOnly 0
xlValidateList 3
xlValidateTextLength 6
xlValidateTime 5
xlValidateWholeNumber 1XlEditionFormat
Constant Value
xlBIFF 2
xlPICT 1
xlRTF 4
xlVALU 8XlEditionOptionsOption
Constant Value
xlAutomaticUpdate 4
xlCancel 1
xlChangeAttributes 6
xlManualUpdate 5
xlOpenSource 3
xlSelect 3
xlSendPublisher 2
xlUpdateSubscriber 2XlEditionType
Constant Value
xlPublisher 1
xlSubscriber 2XlEnableCancelKey
Constant Value
xlDisabled 0
xlErrorHandler 2
xlInterrupt 1XlEnableSelection
Constant Value
xlNoRestrictions 0
xlNoSelection -4142
xlUnlockedCells 1XlEndStyleCap
Constant Value
xlCap 1
xlNoCap 2XlErrorBarDirection
Constant Value
xlX -4168
xlY 1XlErrorBarInclude
Constant Value
xlErrorBarIncludeBoth 1
xlErrorBarIncludeMinusValues 3
xlErrorBarIncludeNone -4142
xlErrorBarIncludePlusValues 2XlErrorBarType
Constant Value
xlErrorBarTypeCustom -4114
xlErrorBarTypeFixedValue 1
xlErrorBarTypePercent 2
xlErrorBarTypeStDev -4155
xlErrorBarTypeStError 4XlErrorChecks
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 2XlFileFormat
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 个人主页 | 引用 | 返回 | 删除 | 回复
XlFillWithConstant Value
xlFillWithAll -4104
xlFillWithContents 2
xlFillWithFormats -4122XlFilterAction
Constant Value
xlFilterCopy 2
xlFilterInPlace 1XlFindLookIn
Constant Value
xlComments -4144
xlFormulas -4123
xlValues -4163XlFormatConditionOperator
Constant Value
xlBetween 1
xlEqual 3
xlGreater 5
xlGreaterEqual 7
xlLess 6
xlLessEqual 8
xlNotBetween 2
xlNotEqual 4XlFormatConditionType
Constant Value
xlCellValue 1
xlExpression 2XlFormControl
Constant Value
xlButtonControl 0
xlCheckBox 1
xlDropDown 2
xlEditBox 3
xlGroupBox 4
xlLabel 5
xlListBox 6
xlOptionButton 7
xlScrollBar 8
xlSpinner 9XlFormulaLabel
Constant Value
xlColumnLabels 2
xlMixedLabels 3
xlNoLabels -4142
xlRowLabels 1※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlHAlignConstant Value
xlHAlignCenter -4108
xlHAlignCenterAcrossSelection 7
xlHAlignDistributed -4117
xlHAlignFill 5
xlHAlignGeneral 1
xlHAlignJustify -4130
xlHAlignLeft -4131
xlHAlignRight -4152XlHebrewModes
Constant Value
xlHebrewFullScript 0
xlHebrewMixedAuthorizedScript 3
xlHebrewMixedScript 2
xlHebrewPartialScript 1XlHighlightChangesTime
Constant Value
xlAllChanges 2
xlNotYetReviewed 3
xlSinceMyLastSave 1XlHtmlType
Constant Value
xlHtmlCalc 1
xlHtmlChart 3
xlHtmlList 2
xlHtmlStatic 0XlIMEMode
Constant Value
xlIMEModeAlpha 8
xlIMEModeAlphaFull 7
xlIMEModeDisable 3
xlIMEModeHangul 10
xlIMEModeHangulFull 9
xlIMEModeHiragana 4
xlIMEModeKatakana 5
xlIMEModeKatakanaHalf 6
xlIMEModeNoControl 0
xlIMEModeOff 2
xlIMEModeOn 1XlImportDataAs
Constant Value
xlPivotTableReport 1
xlQueryTable 0XlInsertFormatOrigin
Constant Value
xlFormatFromLeftOrAbove 0
xlFormatFromRightOrBelow 1XlInsertShiftDirection
Constant Value
xlShiftDown -4121
xlShiftToRight -4161XlLayoutFormType
Constant Value
xlOutline 1
xlTabular 0XlLegendPosition
Constant Value
xlLegendPositionBottom -4107
xlLegendPositionCorner 2
xlLegendPositionLeft -4131
xlLegendPositionRight -4152
xlLegendPositionTop -4160※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:58:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlLineStyleConstant Value
xlContinuous 1
xlDash -4115
xlDashDot 4
xlDashDotDot 5
xlDot -4118
xlDouble -4119
xlLineStyleNone -4142
xlSlantDashDot 13XlLink
Constant Value
xlExcelLinks 1
xlOLELinks 2
xlPublishers 5
xlSubscribers 6XlLinkInfo
Constant Value
xlEditionDate 2
xlLinkInfoStatus 3
xlUpdateState 1XlLinkInfoType
Constant Value
xlLinkInfoOLELinks 2
xlLinkInfoPublishers 5
xlLinkInfoSubscribers 6XlLinkStatus
Constant Value
xlLinkStatusCopiedValues 10
xlLinkStatusIndeterminate 5
xlLinkStatusInvalidName 7
xlLinkStatusMissingFile 1
xlLinkStatusMissingSheet 2
xlLinkStatusNotStarted 6
xlLinkStatusOK 0
xlLinkStatusOld 3
xlLinkStatusSourceNotCalculated 4
xlLinkStatusSourceNotOpen 8
xlLinkStatusSourceOpen 9XlLinkType
Constant Value
xlLinkTypeExcelLinks 1
xlLinkTypeOLELinks 2XlListConflict
Constant Value
xlListConflictDialog 0
xlListConflictDiscardAllConflicts 2
xlListConflictError 3
xlListConflictRetryAllConflicts 1XlListDataType
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 1XlListObjectSourceType
Constant Value
xlSrcExternal 0
xlSrcRange 1
xlSrcXml 2※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlLocationInTableConstant Value
xlColumnHeader -4110
xlColumnItem 5
xlDataHeader 3
xlDataItem 7
xlPageHeader 2
xlPageItem 6
xlRowHeader -4153
xlRowItem 4
xlTableBody 8XlLookAt
Constant Value
xlPart 2
xlWhole 1XlMailSystem
Constant Value
xlMAPI 1
xlNoMailSystem 0
xlPowerTalk 2XlMarkerStyle
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 -4168XlMouseButton
Constant Value
xlNoButton 0
xlPrimaryButton 1
xlSecondaryButton 2XlMousePointer
Constant Value
xlDefault -4143
xlIBeam 3
xlNorthwestArrow 1
xlWait 2※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlMSApplicationConstant Value
xlMicrosoftAccess 4
xlMicrosoftFoxPro 5
xlMicrosoftMail 3
xlMicrosoftPowerPoint 2
xlMicrosoftProject 6
xlMicrosoftSchedulePlus 7
xlMicrosoftWord 1XlObjectSize
Constant Value
xlFitToPage 2
xlFullPage 3
xlScreenSize 1XlOLEType
Constant Value
xlOLEControl 2
xlOLEEmbed 1
xlOLELink 0XlOLEVerb
Constant Value
xlVerbOpen 2
xlVerbPrimary 1XlOrder
Constant Value
xlDownThenOver 1
xlOverThenDown 2XlOrientation
Constant Value
xlDownward -4170
xlHorizontal -4128
xlUpward -4171
xlVertical -4166XlPageBreak
Constant Value
xlPageBreakAutomatic -4105
xlPageBreakManual -4135
xlPageBreakNone -4142XlPageBreakExtent
Constant Value
xlPageBreakFull 1
xlPageBreakPartial 2XlPageOrientation
Constant Value
xlLandscape 2
xlPortrait 1※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 15:59:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlPaperSizeConstant 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 个人主页 | 引用 | 返回 | 删除 | 回复
XlParameterDataTypeConstant 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 -8XlParameterType
Constant Value
xlConstant 1
xlPrompt 0
xlRange 2XlPasteSpecialOperation
Constant Value
xlPasteSpecialOperationAdd 2
xlPasteSpecialOperationDivide 5
xlPasteSpecialOperationMultiply 4
xlPasteSpecialOperationNone -4142
xlPasteSpecialOperationSubtract 3※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlPasteTypeConstant Value
xlPasteAll -4104
xlPasteAllExceptBorders 7
xlPasteColumnWidths 8
xlPasteComments -4144
xlPasteFormats -4122
xlPasteFormulas -4123
xlPasteFormulasAndNumberFormats 11
xlPasteValidation 6
xlPasteValues -4163
xlPasteValuesAndNumberFormats 12XlPattern
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 个人主页 | 引用 | 返回 | 删除 | 回复
XlPhoneticAlignmentConstant Value
xlPhoneticAlignCenter 2
xlPhoneticAlignDistributed 3
xlPhoneticAlignLeft 1
xlPhoneticAlignNoControl 0XlPhoneticCharacterType
Constant Value
xlHiragana 2
xlKatakana 1
xlKatakanaHalf 0
xlNoConversion 3XlPictureAppearance
Constant Value
xlPrinter 2
xlScreen 1XlPictureConvertorType
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 3XlPivotCellType
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 个人主页 | 引用 | 返回 | 删除 | 回复
XlPivotFieldCalculationConstant Value
xlDifferenceFrom 2
xlIndex 9
xlNoAdditionalCalculation -4143
xlPercentDifferenceFrom 4
xlPercentOf 3
xlPercentOfColumn 7
xlPercentOfRow 6
xlPercentOfTotal 8
xlRunningTotal 5XlPivotFieldDataType
Constant Value
xlDate 2
xlNumber -4145
xlText -4158XlPivotFieldOrientation
Constant Value
xlColumnField 2
xlDataField 4
xlHidden 0
xlPageField 3
xlRowField 1XlPivotFormatType
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 18XlPivotTableMissingItems
Constant Value
xlMissingItemsDefault -1
xlMissingItemsMax 32500
xlMissingItemsNone 0XlPivotTableSourceType
Constant Value
xlConsolidation 3
xlDatabase 1
xlExternal 2
xlPivotTable -4148
xlScenario 4※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlPivotTableVersionListConstant Value
xlPivotTableVersion10 1
xlPivotTableVersion2000 0
xlPivotTableVersionCurrent -1XlPlacement
Constant Value
xlFreeFloating 3
xlMove 2
xlMoveAndSize 1XlPlatform
Constant Value
xlMacintosh 1
xlMSDOS 3
xlWindows 2XlPrintErrors
Constant Value
xlPrintErrorsBlank 1
xlPrintErrorsDash 2
xlPrintErrorsDisplayed 0
xlPrintErrorsNA 3XlPrintLocation
Constant Value
xlPrintInPlace 16
xlPrintNoComments -4142
xlPrintSheetEnd 1XlPriority
Constant Value
xlPriorityHigh -4127
xlPriorityLow -4134
xlPriorityNormal -4143XlPTSelectionMode
Constant Value
xlBlanks 4
xlButton 15
xlDataAndLabel 0
xlDataOnly 2
xlFirstRow 256
xlLabelOnly 1
xlOrigin 3XlQueryType
Constant Value
xlADORecordset 7
xlDAORecordset 2
xlODBCQuery 1
xlOLEDBQuery 5
xlTextImport 6
xlWebQuery 4※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:00:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlRangeAutoFormatConstant 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 40XlRangeValueDataType
Constant Value
xlRangeValueDefault 10
xlRangeValueMSPersistXML 12
xlRangeValueXMLSpreadsheet 11※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlReferenceStyleConstant Value
xlA1 1
xlR1C1 -4150XlReferenceType
Constant Value
xlAbsolute 1
xlAbsRowRelColumn 2
xlRelative 4
xlRelRowAbsColumn 3XlRobustConnect
Constant Value
xlAlways 1
xlAsRequired 0
xlNever 2XlRoutingSlipDelivery
Constant Value
xlAllAtOnce 2
xlOneAfterAnother 1XlRoutingSlipStatus
Constant Value
xlNotYetRouted 0
xlRoutingComplete 2
xlRoutingInProgress 1XlRowCol
Constant Value
xlColumns 2
xlRows 1XlRunAutoMacro
Constant Value
xlAutoActivate 3
xlAutoClose 2
xlAutoDeactivate 4
xlAutoOpen 1XlSaveAction
Constant Value
xlDoNotSaveChanges 2
xlSaveChanges 1XlSaveAsAccessMode
Constant Value
xlExclusive 3
xlNoChange 1
xlShared 2XlSaveConflictResolution
Constant Value
xlLocalSessionChanges 2
xlOtherSessionChanges 3
xlUserResolution 1XlScaleType
Constant Value
xlScaleLinear -4132
xlScaleLogarithmic -4133※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:01:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlSearchDirectionConstant Value
xlNext 1
xlPrevious 2XlSearchOrder
Constant Value
xlByColumns 2
xlByRows 1XlSearchWithin
Constant Value
xlWithinSheet 1
xlWithinWorkbook 2XlSheetType
Constant Value
xlChart -4109
xlDialogSheet -4116
xlExcel4IntlMacroSheet 4
xlExcel4MacroSheet 3
xlWorksheet -4167XlSheetVisibility
Constant Value
xlSheetHidden 0
xlSheetVeryHidden 2
xlSheetVisible -1XlSizeRepresents
Constant Value
xlSizeIsArea 1
xlSizeIsWidth 2XlSmartTagControlType
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 个人主页 | 引用 | 返回 | 删除 | 回复
XlSmartTagDisplayModeConstant Value
xlButtonOnly 2
xlDisplayNone 1
xlIndicatorAndButton 0XlSortDataOption
Constant Value
xlSortNormal 0
xlSortTextAsNumbers 1XlSortMethod
Constant Value
xlPinYin 1
xlStroke 2XlSortMethodOld
Constant Value
xlCodePage 2
xlSyllabary 1XlSortOrder
Constant Value
xlAscending 1
xlDescending 2XlSortOrientation
Constant Value
xlSortColumns 1
xlSortRows 2XlSortType
Constant Value
xlSortLabels 2
xlSortValues 1XlSourceType
Constant Value
xlSourceAutoFilter 3
xlSourceChart 5
xlSourcePivotTable 6
xlSourcePrintArea 2
xlSourceQuery 7
xlSourceRange 4
xlSourceSheet 1
xlSourceWorkbook 0XlSpeakDirection
Constant Value
xlSpeakByColumns 1
xlSpeakByRows 0XlSpecialCellsValue
Constant Value
xlErrors 16
xlLogical 4
xlNumbers 1
xlTextValues 2XlSubscribeToFormat
Constant Value
xlSubscribeToPicture -4147
xlSubscribeToText -4158XlSubtototalLocationType
Constant Value
xlAtBottom 2
xlAtTop 1※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlSummaryColumnConstant Value
xlSummaryOnLeft -4131
xlSummaryOnRight -4152XlSummaryReportType
Constant Value
xlStandardSummary 1
xlSummaryPivotTable -4148XlSummaryRow
Constant Value
xlSummaryAbove 0
xlSummaryBelow 1XlTabPosition
Constant Value
xlTabPositionFirst 0
xlTabPositionLast 1XlTextParsingType
Constant Value
xlDelimited 1
xlFixedWidth 2XlTextQualifier
Constant Value
xlTextQualifierDoubleQuote 1
xlTextQualifierNone -4142
xlTextQualifierSingleQuote 2XlTextVisualLayoutType
Constant Value
xlTextVisualLTR 1
xlTextVisualRTL 2XlTickLabelOrientation
Constant Value
xlTickLabelOrientationAutomatic -4105
xlTickLabelOrientationDownward -4170
xlTickLabelOrientationHorizontal -4128
xlTickLabelOrientationUpward -4171
xlTickLabelOrientationVertical -4166XlTickLabelPosition
Constant Value
xlTickLabelPositionHigh -4127
xlTickLabelPositionLow -4134
xlTickLabelPositionNextToAxis 4
xlTickLabelPositionNone -4142XlTickMark
Constant Value
xlTickMarkCross 4
xlTickMarkInside 2
xlTickMarkNone -4142
xlTickMarkOutside 3XlTimeUnit
Constant Value
xlDays 0
xlMonths 1
xlYears 2XlToolbarProtection
Constant Value
xlNoButtonChanges 1
xlNoChanges 4
xlNoDockingChanges 3
xlNoShapeChanges 2
xlToolbarProtectionNone -4143※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlTotalsCalculationConstant Value
xlTotalsCalculationAverage 2
xlTotalsCalculationCount 3
xlTotalsCalculationCountNums 4
xlTotalsCalculationMax 6
xlTotalsCalculationMin 5
xlTotalsCalculationNone 0
xlTotalsCalculationStdDev 7
xlTotalsCalculationSum 1
xlTotalsCalculationVar 8XlTrendlineType
Constant Value
xlExponential 5
xlLinear -4132
xlLogarithmic -4133
xlMovingAvg 6
xlPolynomial 3
xlPower 4XlUnderlineStyle
Constant Value
xlUnderlineStyleDouble -4119
xlUnderlineStyleDoubleAccounting 5
xlUnderlineStyleNone -4142
xlUnderlineStyleSingle 2
xlUnderlineStyleSingleAccounting 4XlUpdateLinks
Constant Value
xlUpdateLinksAlways 3
xlUpdateLinksNever 2
xlUpdateLinksUserSetting 1XlVAlign
Constant Value
xlVAlignBottom -4107
xlVAlignCenter -4108
xlVAlignDistributed -4117
xlVAlignJustify -4130
xlVAlignTop -4160※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:02:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlWBATemplateConstant Value
xlWBATChart -4109
xlWBATExcel4IntlMacroSheet 4
xlWBATExcel4MacroSheet 3
xlWBATWorksheet -4167XlWebFormatting
Constant Value
xlWebFormattingAll 1
xlWebFormattingNone 3
xlWebFormattingRTF 2XlWebSelectionType
Constant Value
xlAllTables 2
xlEntirePage 1
xlSpecifiedTables 3XlWindowState
Constant Value
xlMaximized -4137
xlMinimized -4140
xlNormal -4143XlWindowType
Constant Value
xlChartAsWindow 5
xlChartInPlace 4
xlClipboard 3
xlInfo -4129
xlWorkbook 1XlWindowView
Constant Value
xlNormalView 1
xlPageBreakPreview 2XlXLMMacroType
Constant Value
xlCommand 2
xlFunction 1
xlNotXLM 3XlXmlExportResult
Constant Value
xlXmlExportSuccess 0
xlXmlExportValidationFailed 1XlXmlImportResult
Constant Value
xlXmlImportElementsTruncated 1
xlXmlImportSuccess 0
xlXmlImportValidationFailed 2XlXmlLoadOption
Constant Value
xlXmlLoadImportToList 2
xlXmlLoadMapXml 3
xlXmlLoadOpenXml 1
xlXmlLoadPromptUser 0※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2005-11-6 16:07:00 个人主页 | 引用 | 返回 | 删除 | 回复
XlYesNoGuessConstant 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
};※ Re:Excel常用枚举常量列表,对应的数字终于全成查了
mountain315发表评论于2006-3-25 21:19:00 个人主页 | 引用 | 返回 | 删除 | 回复
enum MsoPresetTexture
{
msoPresetTextureMixed = -2,
msoTexturePapyrus = 1,
msoTextureCanvas = 2,
msoTextureDenim = 3,
msoTextureWovenMat = 4,
msoTextureWaterDroplets = 5,
msoTexturePaperBag = 6,
msoTextureFishFossil = 7,
msoTextureSand = 8,
msoTextureGreenMarble = 9,
msoTextureWhiteMarble = 10,
msoTextureBrownMarble = 11,
msoTextureGranite = 12,
msoTextureNewsprint = 13,
msoTextureRecycledPaper = 14,
msoTextureParchment = 15,
msoTextureStationery = 16,
msoTextureBlueTissueP
标题搜索
我的存档
数据统计
- 访问量: 10845
- 日志数: 11
- 文件数: 1
- 建立时间: 2007-05-21
- 更新时间: 2015-03-21