CSDN博客

img majingcn

Excel常用枚举常量列表对应的数字

发表于2008/9/29 16:36:00  398人阅读

http://blog.tiantiansoft.com/user1/9/archives/2005/1284.html

Microsoft Excel Constants [Excel 2003 VBA Language Reference

 

This topic lists all constants in the Microsoft Excel object model.

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

 

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

 

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

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

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

XlLocationInTable