希望在测试这条路上可以走得很远

转：Excel常用枚举常量列表

上一篇 / 下一篇  2009-09-17 14:20:56 / 个人分类：qtp

查看( 1911 ) / 评论( 0 ) / 评分( 0 / 0 )

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
};

※ 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

收藏 举报

TAG: Excel excel 常数

 

评分：0

我来说两句

我的栏目

日历

« 2024-05-01  
日 一 二 三 四 五 六
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 10832
  • 日志数: 11
  • 文件数: 1
  • 建立时间: 2007-05-21
  • 更新时间: 2015-03-21

RSS订阅

Open Toolbar