::Excel::EnumTop, Main, Index
CommandsTop, Main, Index
Constants [::Excel::Enum]Top, Main, Index
Constants
Parameters
xl3DBar | -4099 |
xl3DEffects1 | 13 |
xl3DEffects2 | 14 |
xl3DSurface | -4103 |
xlAbove | 0 |
xlAccounting1 | 4 |
xlAccounting2 | 5 |
xlAccounting3 | 6 |
xlAccounting4 | 17 |
xlAdd | 2 |
xlAll | -4104 |
xlAllExceptBorders | 7 |
xlAutomatic | -4105 |
xlBar | 2 |
xlBelow | 1 |
xlBidi | -5000 |
xlBidiCalendar | 3 |
xlBoth | 1 |
xlBottom | -4107 |
xlCascade | 7 |
xlCenter | -4108 |
xlCenterAcrossSelection | 7 |
xlChart4 | 2 |
xlChartSeries | 17 |
xlChartShort | 6 |
xlChartTitles | 18 |
xlChecker | 9 |
xlCircle | 8 |
xlClassic1 | 1 |
xlClassic2 | 2 |
xlClassic3 | 3 |
xlClosed | 3 |
xlColor1 | 7 |
xlColor2 | 8 |
xlColor3 | 9 |
xlColumn | 3 |
xlCombination | -4111 |
xlComplete | 4 |
xlConstants | 2 |
xlContents | 2 |
xlContext | -5002 |
xlCorner | 2 |
xlCrissCross | 16 |
xlCross | 4 |
xlCustom | -4114 |
xlDebugCodePane | 13 |
xlDefaultAutoFormat | -1 |
xlDesktop | 9 |
xlDiamond | 2 |
xlDirect | 1 |
xlDistributed | -4117 |
xlDivide | 5 |
xlDoubleAccounting | 5 |
xlDoubleClosed | 5 |
xlDoubleOpen | 4 |
xlDoubleQuote | 1 |
xlDrawingObject | 14 |
xlEntireChart | 20 |
xlExcelMenus | 1 |
xlExtended | 3 |
xlFill | 5 |
xlFirst | 0 |
xlFixedValue | 1 |
xlFloating | 5 |
xlFormats | -4122 |
xlFormula | 5 |
xlFullScript | 1 |
xlGeneral | 1 |
xlGray8 | 18 |
xlGray16 | 17 |
xlGray25 | -4124 |
xlGray50 | -4125 |
xlGray75 | -4126 |
xlGregorian | 2 |
xlGrid | 15 |
xlGridline | 22 |
xlHigh | -4127 |
xlHindiNumerals | 3 |
xlIcons | 1 |
xlImmediatePane | 12 |
xlInside | 2 |
xlInteger | 2 |
xlJustify | -4130 |
xlLast | 1 |
xlLastCell | 11 |
xlLatin | -5001 |
xlLeft | -4131 |
xlLeftToRight | 2 |
xlLightDown | 13 |
xlLightHorizontal | 11 |
xlLightUp | 14 |
xlLightVertical | 12 |
xlList1 | 10 |
xlList2 | 11 |
xlList3 | 12 |
xlLocalFormat1 | 15 |
xlLocalFormat2 | 16 |
xlLogicalCursor | 1 |
xlLong | 3 |
xlLotusHelp | 2 |
xlLow | -4134 |
xlLTR | -5003 |
xlMacrosheetCell | 7 |
xlManual | -4135 |
xlMaximum | 2 |
xlMinimum | 4 |
xlMinusValues | 3 |
xlMixed | 2 |
xlMixedAuthorizedScript | 4 |
xlMixedScript | 3 |
xlModule | -4141 |
xlMultiply | 4 |
xlNarrow | 1 |
xlNextToAxis | 4 |
xlNoDocuments | 3 |
xlNone | -4142 |
xlNotes | -4144 |
xlOff | -4146 |
xlOn | 1 |
xlOpaque | 3 |
xlOpen | 2 |
xlOutside | 3 |
xlPartial | 3 |
xlPartialScript | 2 |
xlPercent | 2 |
xlPlus | 9 |
xlPlusValues | 2 |
xlReference | 4 |
xlRight | -4152 |
xlRTL | -5004 |
xlScale | 3 |
xlSemiautomatic | 2 |
xlSemiGray75 | 10 |
xlShort | 1 |
xlShowLabel | 4 |
xlShowLabelAndPercent | 5 |
xlShowPercent | 3 |
xlShowValue | 2 |
xlSimple | -4154 |
xlSingle | 2 |
xlSingleAccounting | 4 |
xlSingleQuote | 2 |
xlSolid | 1 |
xlSquare | 1 |
xlStar | 5 |
xlStError | 4 |
xlStrict | 2 |
xlSubtract | 3 |
xlSystem | 1 |
xlTextBox | 16 |
xlTiled | 1 |
xlTitleBar | 8 |
xlToolbar | 1 |
xlToolbarButton | 2 |
xlTop | -4160 |
xlTopToBottom | 1 |
xlTransparent | 2 |
xlTriangle | 3 |
xlVeryHidden | 2 |
xlVisible | 12 |
xlVisualCursor | 2 |
xlWatchPane | 11 |
xlWide | 3 |
xlWorkbookTab | 6 |
xlWorksheet4 | 1 |
xlWorksheetCell | 3 |
xlWorksheetShort | 5 |
proc ::Excel::Enum::Constants {} { # xl3DBar - -4099 # xl3DEffects1 - 13 # xl3DEffects2 - 14 # xl3DSurface - -4103 # xlAbove - 0 # xlAccounting1 - 4 # xlAccounting2 - 5 # xlAccounting3 - 6 # xlAccounting4 - 17 # xlAdd - 2 # xlAll - -4104 # xlAllExceptBorders - 7 # xlAutomatic - -4105 # xlBar - 2 # xlBelow - 1 # xlBidi - -5000 # xlBidiCalendar - 3 # xlBoth - 1 # xlBottom - -4107 # xlCascade - 7 # xlCenter - -4108 # xlCenterAcrossSelection - 7 # xlChart4 - 2 # xlChartSeries - 17 # xlChartShort - 6 # xlChartTitles - 18 # xlChecker - 9 # xlCircle - 8 # xlClassic1 - 1 # xlClassic2 - 2 # xlClassic3 - 3 # xlClosed - 3 # xlColor1 - 7 # xlColor2 - 8 # xlColor3 - 9 # xlColumn - 3 # xlCombination - -4111 # xlComplete - 4 # xlConstants - 2 # xlContents - 2 # xlContext - -5002 # xlCorner - 2 # xlCrissCross - 16 # xlCross - 4 # xlCustom - -4114 # xlDebugCodePane - 13 # xlDefaultAutoFormat - -1 # xlDesktop - 9 # xlDiamond - 2 # xlDirect - 1 # xlDistributed - -4117 # xlDivide - 5 # xlDoubleAccounting - 5 # xlDoubleClosed - 5 # xlDoubleOpen - 4 # xlDoubleQuote - 1 # xlDrawingObject - 14 # xlEntireChart - 20 # xlExcelMenus - 1 # xlExtended - 3 # xlFill - 5 # xlFirst - 0 # xlFixedValue - 1 # xlFloating - 5 # xlFormats - -4122 # xlFormula - 5 # xlFullScript - 1 # xlGeneral - 1 # xlGray8 - 18 # xlGray16 - 17 # xlGray25 - -4124 # xlGray50 - -4125 # xlGray75 - -4126 # xlGregorian - 2 # xlGrid - 15 # xlGridline - 22 # xlHigh - -4127 # xlHindiNumerals - 3 # xlIcons - 1 # xlImmediatePane - 12 # xlInside - 2 # xlInteger - 2 # xlJustify - -4130 # xlLast - 1 # xlLastCell - 11 # xlLatin - -5001 # xlLeft - -4131 # xlLeftToRight - 2 # xlLightDown - 13 # xlLightHorizontal - 11 # xlLightUp - 14 # xlLightVertical - 12 # xlList1 - 10 # xlList2 - 11 # xlList3 - 12 # xlLocalFormat1 - 15 # xlLocalFormat2 - 16 # xlLogicalCursor - 1 # xlLong - 3 # xlLotusHelp - 2 # xlLow - -4134 # xlLTR - -5003 # xlMacrosheetCell - 7 # xlManual - -4135 # xlMaximum - 2 # xlMinimum - 4 # xlMinusValues - 3 # xlMixed - 2 # xlMixedAuthorizedScript - 4 # xlMixedScript - 3 # xlModule - -4141 # xlMultiply - 4 # xlNarrow - 1 # xlNextToAxis - 4 # xlNoDocuments - 3 # xlNone - -4142 # xlNotes - -4144 # xlOff - -4146 # xlOn - 1 # xlOpaque - 3 # xlOpen - 2 # xlOutside - 3 # xlPartial - 3 # xlPartialScript - 2 # xlPercent - 2 # xlPlus - 9 # xlPlusValues - 2 # xlReference - 4 # xlRight - -4152 # xlRTL - -5004 # xlScale - 3 # xlSemiautomatic - 2 # xlSemiGray75 - 10 # xlShort - 1 # xlShowLabel - 4 # xlShowLabelAndPercent - 5 # xlShowPercent - 3 # xlShowValue - 2 # xlSimple - -4154 # xlSingle - 2 # xlSingleAccounting - 4 # xlSingleQuote - 2 # xlSolid - 1 # xlSquare - 1 # xlStar - 5 # xlStError - 4 # xlStrict - 2 # xlSubtract - 3 # xlSystem - 1 # xlTextBox - 16 # xlTiled - 1 # xlTitleBar - 8 # xlToolbar - 1 # xlToolbarButton - 2 # xlTop - -4160 # xlTopToBottom - 1 # xlTransparent - 2 # xlTriangle - 3 # xlVeryHidden - 2 # xlVisible - 12 # xlVisualCursor - 2 # xlWatchPane - 11 # xlWide - 3 # xlWorkbookTab - 6 # xlWorksheet4 - 1 # xlWorksheetCell - 3 # xlWorksheetShort - 5 return { xl3DBar -4099 xl3DEffects1 13 xl3DEffects2 14 xl3DSurface -4103 xlAbove 0 xlAccounting1 4 xlAccounting2 5 xlAccounting3 6 xlAccounting4 17 xlAdd 2 xlAll -4104 xlAllExceptBorders 7 xlAutomatic -4105 xlBar 2 xlBelow 1 xlBidi -5000 xlBidiCalendar 3 xlBoth 1 xlBottom -4107 xlCascade 7 xlCenter -4108 xlCenterAcrossSelection 7 xlChart4 2 xlChartSeries 17 xlChartShort 6 xlChartTitles 18 xlChecker 9 xlCircle 8 xlClassic1 1 xlClassic2 2 xlClassic3 3 xlClosed 3 xlColor1 7 xlColor2 8 xlColor3 9 xlColumn 3 xlCombination -4111 xlComplete 4 xlConstants 2 xlContents 2 xlContext -5002 xlCorner 2 xlCrissCross 16 xlCross 4 xlCustom -4114 xlDebugCodePane 13 xlDefaultAutoFormat -1 xlDesktop 9 xlDiamond 2 xlDirect 1 xlDistributed -4117 xlDivide 5 xlDoubleAccounting 5 xlDoubleClosed 5 xlDoubleOpen 4 xlDoubleQuote 1 xlDrawingObject 14 xlEntireChart 20 xlExcelMenus 1 xlExtended 3 xlFill 5 xlFirst 0 xlFixedValue 1 xlFloating 5 xlFormats -4122 xlFormula 5 xlFullScript 1 xlGeneral 1 xlGray8 18 xlGray16 17 xlGray25 -4124 xlGray50 -4125 xlGray75 -4126 xlGregorian 2 xlGrid 15 xlGridline 22 xlHigh -4127 xlHindiNumerals 3 xlIcons 1 xlImmediatePane 12 xlInside 2 xlInteger 2 xlJustify -4130 xlLast 1 xlLastCell 11 xlLatin -5001 xlLeft -4131 xlLeftToRight 2 xlLightDown 13 xlLightHorizontal 11 xlLightUp 14 xlLightVertical 12 xlList1 10 xlList2 11 xlList3 12 xlLocalFormat1 15 xlLocalFormat2 16 xlLogicalCursor 1 xlLong 3 xlLotusHelp 2 xlLow -4134 xlLTR -5003 xlMacrosheetCell 7 xlManual -4135 xlMaximum 2 xlMinimum 4 xlMinusValues 3 xlMixed 2 xlMixedAuthorizedScript 4 xlMixedScript 3 xlModule -4141 xlMultiply 4 xlNarrow 1 xlNextToAxis 4 xlNoDocuments 3 xlNone -4142 xlNotes -4144 xlOff -4146 xlOn 1 xlOpaque 3 xlOpen 2 xlOutside 3 xlPartial 3 xlPartialScript 2 xlPercent 2 xlPlus 9 xlPlusValues 2 xlReference 4 xlRight -4152 xlRTL -5004 xlScale 3 xlSemiautomatic 2 xlSemiGray75 10 xlShort 1 xlShowLabel 4 xlShowLabelAndPercent 5 xlShowPercent 3 xlShowValue 2 xlSimple -4154 xlSingle 2 xlSingleAccounting 4 xlSingleQuote 2 xlSolid 1 xlSquare 1 xlStar 5 xlStError 4 xlStrict 2 xlSubtract 3 xlSystem 1 xlTextBox 16 xlTiled 1 xlTitleBar 8 xlToolbar 1 xlToolbarButton 2 xlTop -4160 xlTopToBottom 1 xlTransparent 2 xlTriangle 3 xlVeryHidden 2 xlVisible 12 xlVisualCursor 2 xlWatchPane 11 xlWide 3 xlWorkbookTab 6 xlWorksheet4 1 xlWorksheetCell 3 xlWorksheetShort 5 } }
XlAboveBelow [::Excel::Enum]Top, Main, Index
XlAboveBelow
Parameters
xlAboveAverage | 0 |
xlAboveStdDev | 4 |
xlBelowAverage | 1 |
xlBelowStdDev | 5 |
xlEqualAboveAverage | 2 |
xlEqualBelowAverage | 3 |
proc ::Excel::Enum::XlAboveBelow {} { # xlAboveAverage - 0 # xlAboveStdDev - 4 # xlBelowAverage - 1 # xlBelowStdDev - 5 # xlEqualAboveAverage - 2 # xlEqualBelowAverage - 3 return { xlAboveAverage 0 xlAboveStdDev 4 xlBelowAverage 1 xlBelowStdDev 5 xlEqualAboveAverage 2 xlEqualBelowAverage 3 } }
XlActionType [::Excel::Enum]Top, Main, Index
XlActionType
Parameters
xlActionTypeDrillthrough | 256 |
xlActionTypeReport | 128 |
xlActionTypeRowset | 16 |
xlActionTypeUrl | 1 |
proc ::Excel::Enum::XlActionType {} { # xlActionTypeDrillthrough - 256 # xlActionTypeReport - 128 # xlActionTypeRowset - 16 # xlActionTypeUrl - 1 return { xlActionTypeDrillthrough 256 xlActionTypeReport 128 xlActionTypeRowset 16 xlActionTypeUrl 1 } }
XlAllocation [::Excel::Enum]Top, Main, Index
XlAllocation
Parameters
xlAutomaticAllocation | 2 |
xlManualAllocation | 1 |
proc ::Excel::Enum::XlAllocation {} { # xlAutomaticAllocation - 2 # xlManualAllocation - 1 return { xlAutomaticAllocation 2 xlManualAllocation 1 } }
XlAllocationMethod [::Excel::Enum]Top, Main, Index
XlAllocationMethod
Parameters
xlEqualAllocation | 1 |
xlWeightedAllocation | 2 |
proc ::Excel::Enum::XlAllocationMethod {} { # xlEqualAllocation - 1 # xlWeightedAllocation - 2 return { xlEqualAllocation 1 xlWeightedAllocation 2 } }
XlAllocationValue [::Excel::Enum]Top, Main, Index
XlAllocationValue
Parameters
xlAllocateIncrement | 2 |
xlAllocateValue | 1 |
proc ::Excel::Enum::XlAllocationValue {} { # xlAllocateIncrement - 2 # xlAllocateValue - 1 return { xlAllocateIncrement 2 xlAllocateValue 1 } }
XlApplicationInternational [::Excel::Enum]Top, Main, Index
XlApplicationInternational
Parameters
xl4DigitYears | 43 |
xl24HourClock | 33 |
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 |
xlUICultureTag | 46 |
xlUpperCaseColumnLetter | 7 |
xlUpperCaseRowLetter | 6 |
xlWeekdayNameChars | 31 |
xlYearCode | 19 |
proc ::Excel::Enum::XlApplicationInternational {} { # xl4DigitYears - 43 # xl24HourClock - 33 # 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 # xlUICultureTag - 46 # xlUpperCaseColumnLetter - 7 # xlUpperCaseRowLetter - 6 # xlWeekdayNameChars - 31 # xlYearCode - 19 return { xl4DigitYears 43 xl24HourClock 33 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 xlUICultureTag 46 xlUpperCaseColumnLetter 7 xlUpperCaseRowLetter 6 xlWeekdayNameChars 31 xlYearCode 19 } }
XlApplyNamesOrder [::Excel::Enum]Top, Main, Index
XlApplyNamesOrder
Parameters
xlColumnThenRow | 2 |
xlRowThenColumn | 1 |
proc ::Excel::Enum::XlApplyNamesOrder {} { # xlColumnThenRow - 2 # xlRowThenColumn - 1 return { xlColumnThenRow 2 xlRowThenColumn 1 } }
XlArabicModes [::Excel::Enum]Top, Main, Index
XlArabicModes
Parameters
xlArabicBothStrict | 3 |
xlArabicNone | 0 |
xlArabicStrictAlefHamza | 1 |
xlArabicStrictFinalYaa | 2 |
proc ::Excel::Enum::XlArabicModes {} { # xlArabicBothStrict - 3 # xlArabicNone - 0 # xlArabicStrictAlefHamza - 1 # xlArabicStrictFinalYaa - 2 return { xlArabicBothStrict 3 xlArabicNone 0 xlArabicStrictAlefHamza 1 xlArabicStrictFinalYaa 2 } }
XlArrangeStyle [::Excel::Enum]Top, Main, Index
XlArrangeStyle
Parameters
xlArrangeStyleCascade | 7 |
xlArrangeStyleHorizontal | -4128 |
xlArrangeStyleTiled | 1 |
xlArrangeStyleVertical | -4166 |
proc ::Excel::Enum::XlArrangeStyle {} { # xlArrangeStyleCascade - 7 # xlArrangeStyleHorizontal - -4128 # xlArrangeStyleTiled - 1 # xlArrangeStyleVertical - -4166 return { xlArrangeStyleCascade 7 xlArrangeStyleHorizontal -4128 xlArrangeStyleTiled 1 xlArrangeStyleVertical -4166 } }
XlArrowHeadLength [::Excel::Enum]Top, Main, Index
XlArrowHeadLength
Parameters
xlArrowHeadLengthLong | 3 |
xlArrowHeadLengthMedium | -4138 |
xlArrowHeadLengthShort | 1 |
proc ::Excel::Enum::XlArrowHeadLength {} { # xlArrowHeadLengthLong - 3 # xlArrowHeadLengthMedium - -4138 # xlArrowHeadLengthShort - 1 return { xlArrowHeadLengthLong 3 xlArrowHeadLengthMedium -4138 xlArrowHeadLengthShort 1 } }
XlArrowHeadStyle [::Excel::Enum]Top, Main, Index
XlArrowHeadStyle
Parameters
xlArrowHeadStyleClosed | 3 |
xlArrowHeadStyleDoubleClosed | 5 |
xlArrowHeadStyleDoubleOpen | 4 |
xlArrowHeadStyleNone | -4142 |
xlArrowHeadStyleOpen | 2 |
proc ::Excel::Enum::XlArrowHeadStyle {} { # xlArrowHeadStyleClosed - 3 # xlArrowHeadStyleDoubleClosed - 5 # xlArrowHeadStyleDoubleOpen - 4 # xlArrowHeadStyleNone - -4142 # xlArrowHeadStyleOpen - 2 return { xlArrowHeadStyleClosed 3 xlArrowHeadStyleDoubleClosed 5 xlArrowHeadStyleDoubleOpen 4 xlArrowHeadStyleNone -4142 xlArrowHeadStyleOpen 2 } }
XlArrowHeadWidth [::Excel::Enum]Top, Main, Index
XlArrowHeadWidth
Parameters
xlArrowHeadWidthMedium | -4138 |
xlArrowHeadWidthNarrow | 1 |
xlArrowHeadWidthWide | 3 |
proc ::Excel::Enum::XlArrowHeadWidth {} { # xlArrowHeadWidthMedium - -4138 # xlArrowHeadWidthNarrow - 1 # xlArrowHeadWidthWide - 3 return { xlArrowHeadWidthMedium -4138 xlArrowHeadWidthNarrow 1 xlArrowHeadWidthWide 3 } }
XlAutoFillType [::Excel::Enum]Top, Main, Index
XlAutoFillType
Parameters
xlFillCopy | 1 |
xlFillDays | 5 |
xlFillDefault | 0 |
xlFillFormats | 3 |
xlFillMonths | 7 |
xlFillSeries | 2 |
xlFillValues | 4 |
xlFillWeekdays | 6 |
xlFillYears | 8 |
xlFlashFill | 11 |
xlGrowthTrend | 10 |
xlLinearTrend | 9 |
proc ::Excel::Enum::XlAutoFillType {} { # xlFillCopy - 1 # xlFillDays - 5 # xlFillDefault - 0 # xlFillFormats - 3 # xlFillMonths - 7 # xlFillSeries - 2 # xlFillValues - 4 # xlFillWeekdays - 6 # xlFillYears - 8 # xlFlashFill - 11 # xlGrowthTrend - 10 # xlLinearTrend - 9 return { xlFillCopy 1 xlFillDays 5 xlFillDefault 0 xlFillFormats 3 xlFillMonths 7 xlFillSeries 2 xlFillValues 4 xlFillWeekdays 6 xlFillYears 8 xlFlashFill 11 xlGrowthTrend 10 xlLinearTrend 9 } }
XlAutoFilterOperator [::Excel::Enum]Top, Main, Index
XlAutoFilterOperator
Parameters
xlAnd | 1 |
xlBottom10Items | 4 |
xlBottom10Percent | 6 |
xlFilterAutomaticFontColor | 13 |
xlFilterCellColor | 8 |
xlFilterDynamic | 11 |
xlFilterFontColor | 9 |
xlFilterIcon | 10 |
xlFilterNoFill | 12 |
xlFilterNoIcon | 14 |
xlFilterValues | 7 |
xlOr | 2 |
xlTop10Items | 3 |
xlTop10Percent | 5 |
proc ::Excel::Enum::XlAutoFilterOperator {} { # xlAnd - 1 # xlBottom10Items - 4 # xlBottom10Percent - 6 # xlFilterAutomaticFontColor - 13 # xlFilterCellColor - 8 # xlFilterDynamic - 11 # xlFilterFontColor - 9 # xlFilterIcon - 10 # xlFilterNoFill - 12 # xlFilterNoIcon - 14 # xlFilterValues - 7 # xlOr - 2 # xlTop10Items - 3 # xlTop10Percent - 5 return { xlAnd 1 xlBottom10Items 4 xlBottom10Percent 6 xlFilterAutomaticFontColor 13 xlFilterCellColor 8 xlFilterDynamic 11 xlFilterFontColor 9 xlFilterIcon 10 xlFilterNoFill 12 xlFilterNoIcon 14 xlFilterValues 7 xlOr 2 xlTop10Items 3 xlTop10Percent 5 } }
XlAxisCrosses [::Excel::Enum]Top, Main, Index
XlAxisCrosses
Parameters
xlAxisCrossesAutomatic | -4105 |
xlAxisCrossesCustom | -4114 |
xlAxisCrossesMaximum | 2 |
xlAxisCrossesMinimum | 4 |
proc ::Excel::Enum::XlAxisCrosses {} { # xlAxisCrossesAutomatic - -4105 # xlAxisCrossesCustom - -4114 # xlAxisCrossesMaximum - 2 # xlAxisCrossesMinimum - 4 return { xlAxisCrossesAutomatic -4105 xlAxisCrossesCustom -4114 xlAxisCrossesMaximum 2 xlAxisCrossesMinimum 4 } }
XlAxisGroup [::Excel::Enum]Top, Main, Index
XlAxisGroup
Parameters
xlPrimary | 1 |
xlSecondary | 2 |
proc ::Excel::Enum::XlAxisGroup {} { # xlPrimary - 1 # xlSecondary - 2 return { xlPrimary 1 xlSecondary 2 } }
XlAxisType [::Excel::Enum]Top, Main, Index
XlAxisType
Parameters
xlCategory | 1 |
xlSeriesAxis | 3 |
xlValue | 2 |
proc ::Excel::Enum::XlAxisType {} { # xlCategory - 1 # xlSeriesAxis - 3 # xlValue - 2 return { xlCategory 1 xlSeriesAxis 3 xlValue 2 } }
XlBackground [::Excel::Enum]Top, Main, Index
XlBackground
Parameters
xlBackgroundAutomatic | -4105 |
xlBackgroundOpaque | 3 |
xlBackgroundTransparent | 2 |
proc ::Excel::Enum::XlBackground {} { # xlBackgroundAutomatic - -4105 # xlBackgroundOpaque - 3 # xlBackgroundTransparent - 2 return { xlBackgroundAutomatic -4105 xlBackgroundOpaque 3 xlBackgroundTransparent 2 } }
XlBarShape [::Excel::Enum]Top, Main, Index
XlBarShape
Parameters
xlBox | 0 |
xlConeToMax | 5 |
xlConeToPoint | 4 |
xlCylinder | 3 |
xlPyramidToMax | 2 |
xlPyramidToPoint | 1 |
proc ::Excel::Enum::XlBarShape {} { # xlBox - 0 # xlConeToMax - 5 # xlConeToPoint - 4 # xlCylinder - 3 # xlPyramidToMax - 2 # xlPyramidToPoint - 1 return { xlBox 0 xlConeToMax 5 xlConeToPoint 4 xlCylinder 3 xlPyramidToMax 2 xlPyramidToPoint 1 } }
XlBinsType [::Excel::Enum]Top, Main, Index
XlBinsType
Parameters
xlBinsTypeAutomatic | 0 |
xlBinsTypeBinCount | 4 |
xlBinsTypeBinSize | 3 |
xlBinsTypeCategorical | 1 |
xlBinsTypeManual | 2 |
proc ::Excel::Enum::XlBinsType {} { # xlBinsTypeAutomatic - 0 # xlBinsTypeBinCount - 4 # xlBinsTypeBinSize - 3 # xlBinsTypeCategorical - 1 # xlBinsTypeManual - 2 return { xlBinsTypeAutomatic 0 xlBinsTypeBinCount 4 xlBinsTypeBinSize 3 xlBinsTypeCategorical 1 xlBinsTypeManual 2 } }
XlBordersIndex [::Excel::Enum]Top, Main, Index
XlBordersIndex
Parameters
xlDiagonalDown | 5 |
xlDiagonalUp | 6 |
xlEdgeBottom | 9 |
xlEdgeLeft | 7 |
xlEdgeRight | 10 |
xlEdgeTop | 8 |
xlInsideHorizontal | 12 |
xlInsideVertical | 11 |
proc ::Excel::Enum::XlBordersIndex {} { # xlDiagonalDown - 5 # xlDiagonalUp - 6 # xlEdgeBottom - 9 # xlEdgeLeft - 7 # xlEdgeRight - 10 # xlEdgeTop - 8 # xlInsideHorizontal - 12 # xlInsideVertical - 11 return { xlDiagonalDown 5 xlDiagonalUp 6 xlEdgeBottom 9 xlEdgeLeft 7 xlEdgeRight 10 xlEdgeTop 8 xlInsideHorizontal 12 xlInsideVertical 11 } }
XlBorderWeight [::Excel::Enum]Top, Main, Index
XlBorderWeight
Parameters
xlHairline | 1 |
xlMedium | -4138 |
xlThick | 4 |
xlThin | 2 |
proc ::Excel::Enum::XlBorderWeight {} { # xlHairline - 1 # xlMedium - -4138 # xlThick - 4 # xlThin - 2 return { xlHairline 1 xlMedium -4138 xlThick 4 xlThin 2 } }
XlBuiltInDialog [::Excel::Enum]Top, Main, Index
XlBuiltInDialog
Parameters
_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 |
xlDialogCreateRelationship | 1272 |
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 |
xlDialogDocumentInspector | 862 |
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 |
xlDialogForecastETS | 1300 |
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 |
xlDialogManageRelationships | 1271 |
xlDialogMenuEditor | 322 |
xlDialogMove | 262 |
xlDialogMyPermission | 834 |
xlDialogNameManager | 977 |
xlDialogNew | 119 |
xlDialogNewName | 978 |
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 |
xlDialogPivotDefaultLayout | 1360 |
xlDialogPivotFieldGroup | 433 |
xlDialogPivotFieldProperties | 313 |
xlDialogPivotFieldUngroup | 434 |
xlDialogPivotShowPages | 421 |
xlDialogPivotSolveOrder | 568 |
xlDialogPivotTableOptions | 567 |
xlDialogPivotTableSlicerConnections | 1183 |
xlDialogPivotTableWhatIfAnalysisSettings | 1153 |
xlDialogPivotTableWizard | 312 |
xlDialogPlacement | 300 |
xlDialogPrint | 8 |
xlDialogPrinterSetup | 9 |
xlDialogPrintPreview | 222 |
xlDialogPromote | 202 |
xlDialogProperties | 474 |
xlDialogPropertyFields | 754 |
xlDialogProtectDocument | 28 |
xlDialogProtectSharing | 620 |
xlDialogPublishAsWebPage | 653 |
xlDialogPushbuttonProperties | 445 |
xlDialogRecommendedPivotTables | 1258 |
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 |
xlDialogSetManager | 1109 |
xlDialogSetMDXEditor | 1208 |
xlDialogSetPrintTitles | 23 |
xlDialogSetTupleEditorOnColumns | 1108 |
xlDialogSetTupleEditorOnRows | 1107 |
xlDialogSetUpdateStatus | 159 |
xlDialogShowDetail | 204 |
xlDialogShowToolbar | 220 |
xlDialogSize | 261 |
xlDialogSlicerCreation | 1182 |
xlDialogSlicerPivotTableConnections | 1184 |
xlDialogSlicerSettings | 1179 |
xlDialogSort | 39 |
xlDialogSortSpecial | 192 |
xlDialogSparklineInsertColumn | 1134 |
xlDialogSparklineInsertLine | 1133 |
xlDialogSparklineInsertWinLoss | 1135 |
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 |
proc ::Excel::Enum::XlBuiltInDialog {} { # _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 # xlDialogCreateRelationship - 1272 # 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 # xlDialogDocumentInspector - 862 # 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 # xlDialogForecastETS - 1300 # 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 # xlDialogManageRelationships - 1271 # xlDialogMenuEditor - 322 # xlDialogMove - 262 # xlDialogMyPermission - 834 # xlDialogNameManager - 977 # xlDialogNew - 119 # xlDialogNewName - 978 # 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 # xlDialogPivotDefaultLayout - 1360 # xlDialogPivotFieldGroup - 433 # xlDialogPivotFieldProperties - 313 # xlDialogPivotFieldUngroup - 434 # xlDialogPivotShowPages - 421 # xlDialogPivotSolveOrder - 568 # xlDialogPivotTableOptions - 567 # xlDialogPivotTableSlicerConnections - 1183 # xlDialogPivotTableWhatIfAnalysisSettings - 1153 # xlDialogPivotTableWizard - 312 # xlDialogPlacement - 300 # xlDialogPrint - 8 # xlDialogPrinterSetup - 9 # xlDialogPrintPreview - 222 # xlDialogPromote - 202 # xlDialogProperties - 474 # xlDialogPropertyFields - 754 # xlDialogProtectDocument - 28 # xlDialogProtectSharing - 620 # xlDialogPublishAsWebPage - 653 # xlDialogPushbuttonProperties - 445 # xlDialogRecommendedPivotTables - 1258 # 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 # xlDialogSetManager - 1109 # xlDialogSetMDXEditor - 1208 # xlDialogSetPrintTitles - 23 # xlDialogSetTupleEditorOnColumns - 1108 # xlDialogSetTupleEditorOnRows - 1107 # xlDialogSetUpdateStatus - 159 # xlDialogShowDetail - 204 # xlDialogShowToolbar - 220 # xlDialogSize - 261 # xlDialogSlicerCreation - 1182 # xlDialogSlicerPivotTableConnections - 1184 # xlDialogSlicerSettings - 1179 # xlDialogSort - 39 # xlDialogSortSpecial - 192 # xlDialogSparklineInsertColumn - 1134 # xlDialogSparklineInsertLine - 1133 # xlDialogSparklineInsertWinLoss - 1135 # 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 return { _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 xlDialogCreateRelationship 1272 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 xlDialogDocumentInspector 862 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 xlDialogForecastETS 1300 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 xlDialogManageRelationships 1271 xlDialogMenuEditor 322 xlDialogMove 262 xlDialogMyPermission 834 xlDialogNameManager 977 xlDialogNew 119 xlDialogNewName 978 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 xlDialogPivotDefaultLayout 1360 xlDialogPivotFieldGroup 433 xlDialogPivotFieldProperties 313 xlDialogPivotFieldUngroup 434 xlDialogPivotShowPages 421 xlDialogPivotSolveOrder 568 xlDialogPivotTableOptions 567 xlDialogPivotTableSlicerConnections 1183 xlDialogPivotTableWhatIfAnalysisSettings 1153 xlDialogPivotTableWizard 312 xlDialogPlacement 300 xlDialogPrint 8 xlDialogPrinterSetup 9 xlDialogPrintPreview 222 xlDialogPromote 202 xlDialogProperties 474 xlDialogPropertyFields 754 xlDialogProtectDocument 28 xlDialogProtectSharing 620 xlDialogPublishAsWebPage 653 xlDialogPushbuttonProperties 445 xlDialogRecommendedPivotTables 1258 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 xlDialogSetManager 1109 xlDialogSetMDXEditor 1208 xlDialogSetPrintTitles 23 xlDialogSetTupleEditorOnColumns 1108 xlDialogSetTupleEditorOnRows 1107 xlDialogSetUpdateStatus 159 xlDialogShowDetail 204 xlDialogShowToolbar 220 xlDialogSize 261 xlDialogSlicerCreation 1182 xlDialogSlicerPivotTableConnections 1184 xlDialogSlicerSettings 1179 xlDialogSort 39 xlDialogSortSpecial 192 xlDialogSparklineInsertColumn 1134 xlDialogSparklineInsertLine 1133 xlDialogSparklineInsertWinLoss 1135 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 } }
XlCalcFor [::Excel::Enum]Top, Main, Index
XlCalcFor
Parameters
xlAllValues | 0 |
xlColGroups | 2 |
xlRowGroups | 1 |
proc ::Excel::Enum::XlCalcFor {} { # xlAllValues - 0 # xlColGroups - 2 # xlRowGroups - 1 return { xlAllValues 0 xlColGroups 2 xlRowGroups 1 } }
XlCalcMemNumberFormatType [::Excel::Enum]Top, Main, Index
XlCalcMemNumberFormatType
Parameters
xlNumberFormatTypeDefault | 0 |
xlNumberFormatTypeNumber | 1 |
xlNumberFormatTypePercent | 2 |
proc ::Excel::Enum::XlCalcMemNumberFormatType {} { # xlNumberFormatTypeDefault - 0 # xlNumberFormatTypeNumber - 1 # xlNumberFormatTypePercent - 2 return { xlNumberFormatTypeDefault 0 xlNumberFormatTypeNumber 1 xlNumberFormatTypePercent 2 } }
XlCalculatedMemberType [::Excel::Enum]Top, Main, Index
XlCalculatedMemberType
Parameters
xlCalculatedMeasure | 2 |
xlCalculatedMember | 0 |
xlCalculatedSet | 1 |
proc ::Excel::Enum::XlCalculatedMemberType {} { # xlCalculatedMeasure - 2 # xlCalculatedMember - 0 # xlCalculatedSet - 1 return { xlCalculatedMeasure 2 xlCalculatedMember 0 xlCalculatedSet 1 } }
XlCalculation [::Excel::Enum]Top, Main, Index
XlCalculation
Parameters
xlCalculationAutomatic | -4105 |
xlCalculationManual | -4135 |
xlCalculationSemiautomatic | 2 |
proc ::Excel::Enum::XlCalculation {} { # xlCalculationAutomatic - -4105 # xlCalculationManual - -4135 # xlCalculationSemiautomatic - 2 return { xlCalculationAutomatic -4105 xlCalculationManual -4135 xlCalculationSemiautomatic 2 } }
XlCalculationInterruptKey [::Excel::Enum]Top, Main, Index
XlCalculationInterruptKey
Parameters
xlAnyKey | 2 |
xlEscKey | 1 |
xlNoKey | 0 |
proc ::Excel::Enum::XlCalculationInterruptKey {} { # xlAnyKey - 2 # xlEscKey - 1 # xlNoKey - 0 return { xlAnyKey 2 xlEscKey 1 xlNoKey 0 } }
XlCalculationState [::Excel::Enum]Top, Main, Index
XlCalculationState
Parameters
xlCalculating | 1 |
xlDone | 0 |
xlPending | 2 |
proc ::Excel::Enum::XlCalculationState {} { # xlCalculating - 1 # xlDone - 0 # xlPending - 2 return { xlCalculating 1 xlDone 0 xlPending 2 } }
XlCategoryLabelLevel [::Excel::Enum]Top, Main, Index
XlCategoryLabelLevel
Parameters
xlCategoryLabelLevelAll | -1 |
xlCategoryLabelLevelCustom | -2 |
xlCategoryLabelLevelNone | -3 |
proc ::Excel::Enum::XlCategoryLabelLevel {} { # xlCategoryLabelLevelAll - -1 # xlCategoryLabelLevelCustom - -2 # xlCategoryLabelLevelNone - -3 return { xlCategoryLabelLevelAll -1 xlCategoryLabelLevelCustom -2 xlCategoryLabelLevelNone -3 } }
XlCategorySortOrder [::Excel::Enum]Top, Main, Index
XlCategorySortOrder
Parameters
xlCategoryAscending | 2 |
xlCategoryDescending | 3 |
xlIndexAscending | 0 |
xlIndexDescending | 1 |
proc ::Excel::Enum::XlCategorySortOrder {} { # xlCategoryAscending - 2 # xlCategoryDescending - 3 # xlIndexAscending - 0 # xlIndexDescending - 1 return { xlCategoryAscending 2 xlCategoryDescending 3 xlIndexAscending 0 xlIndexDescending 1 } }
XlCategoryType [::Excel::Enum]Top, Main, Index
XlCategoryType
Parameters
xlAutomaticScale | -4105 |
xlCategoryScale | 2 |
xlTimeScale | 3 |
proc ::Excel::Enum::XlCategoryType {} { # xlAutomaticScale - -4105 # xlCategoryScale - 2 # xlTimeScale - 3 return { xlAutomaticScale -4105 xlCategoryScale 2 xlTimeScale 3 } }
XlCellChangedState [::Excel::Enum]Top, Main, Index
XlCellChangedState
Parameters
xlCellChangeApplied | 3 |
xlCellChanged | 2 |
xlCellNotChanged | 1 |
proc ::Excel::Enum::XlCellChangedState {} { # xlCellChangeApplied - 3 # xlCellChanged - 2 # xlCellNotChanged - 1 return { xlCellChangeApplied 3 xlCellChanged 2 xlCellNotChanged 1 } }
XlCellInsertionMode [::Excel::Enum]Top, Main, Index
XlCellInsertionMode
Parameters
xlInsertDeleteCells | 1 |
xlInsertEntireRows | 2 |
xlOverwriteCells | 0 |
proc ::Excel::Enum::XlCellInsertionMode {} { # xlInsertDeleteCells - 1 # xlInsertEntireRows - 2 # xlOverwriteCells - 0 return { xlInsertDeleteCells 1 xlInsertEntireRows 2 xlOverwriteCells 0 } }
XlCellType [::Excel::Enum]Top, Main, Index
XlCellType
Parameters
xlCellTypeAllFormatConditions | -4172 |
xlCellTypeAllValidation | -4174 |
xlCellTypeBlanks | 4 |
xlCellTypeComments | -4144 |
xlCellTypeConstants | 2 |
xlCellTypeFormulas | -4123 |
xlCellTypeLastCell | 11 |
xlCellTypeSameFormatConditions | -4173 |
xlCellTypeSameValidation | -4175 |
xlCellTypeVisible | 12 |
proc ::Excel::Enum::XlCellType {} { # xlCellTypeAllFormatConditions - -4172 # xlCellTypeAllValidation - -4174 # xlCellTypeBlanks - 4 # xlCellTypeComments - -4144 # xlCellTypeConstants - 2 # xlCellTypeFormulas - -4123 # xlCellTypeLastCell - 11 # xlCellTypeSameFormatConditions - -4173 # xlCellTypeSameValidation - -4175 # xlCellTypeVisible - 12 return { xlCellTypeAllFormatConditions -4172 xlCellTypeAllValidation -4174 xlCellTypeBlanks 4 xlCellTypeComments -4144 xlCellTypeConstants 2 xlCellTypeFormulas -4123 xlCellTypeLastCell 11 xlCellTypeSameFormatConditions -4173 xlCellTypeSameValidation -4175 xlCellTypeVisible 12 } }
XlChartElementPosition [::Excel::Enum]Top, Main, Index
XlChartElementPosition
Parameters
xlChartElementPositionAutomatic | -4105 |
xlChartElementPositionCustom | -4114 |
proc ::Excel::Enum::XlChartElementPosition {} { # xlChartElementPositionAutomatic - -4105 # xlChartElementPositionCustom - -4114 return { xlChartElementPositionAutomatic -4105 xlChartElementPositionCustom -4114 } }
XlChartGallery [::Excel::Enum]Top, Main, Index
XlChartGallery
Parameters
xlAnyGallery | 23 |
xlBuiltIn | 21 |
xlUserDefined | 22 |
proc ::Excel::Enum::XlChartGallery {} { # xlAnyGallery - 23 # xlBuiltIn - 21 # xlUserDefined - 22 return { xlAnyGallery 23 xlBuiltIn 21 xlUserDefined 22 } }
XlChartItem [::Excel::Enum]Top, Main, Index
XlChartItem
Parameters
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 |
xlPivotChartCollapseEntireFieldButton | 34 |
xlPivotChartDropZone | 32 |
xlPivotChartExpandEntireFieldButton | 33 |
xlPivotChartFieldButton | 31 |
xlPlotArea | 19 |
xlRadarAxisLabels | 27 |
xlSeries | 3 |
xlSeriesLines | 22 |
xlShape | 14 |
xlTrendline | 8 |
xlUpBars | 18 |
xlWalls | 5 |
xlXErrorBars | 10 |
xlYErrorBars | 11 |
proc ::Excel::Enum::XlChartItem {} { # 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 # xlPivotChartCollapseEntireFieldButton - 34 # xlPivotChartDropZone - 32 # xlPivotChartExpandEntireFieldButton - 33 # xlPivotChartFieldButton - 31 # xlPlotArea - 19 # xlRadarAxisLabels - 27 # xlSeries - 3 # xlSeriesLines - 22 # xlShape - 14 # xlTrendline - 8 # xlUpBars - 18 # xlWalls - 5 # xlXErrorBars - 10 # xlYErrorBars - 11 return { 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 xlPivotChartCollapseEntireFieldButton 34 xlPivotChartDropZone 32 xlPivotChartExpandEntireFieldButton 33 xlPivotChartFieldButton 31 xlPlotArea 19 xlRadarAxisLabels 27 xlSeries 3 xlSeriesLines 22 xlShape 14 xlTrendline 8 xlUpBars 18 xlWalls 5 xlXErrorBars 10 xlYErrorBars 11 } }
XlChartLocation [::Excel::Enum]Top, Main, Index
XlChartLocation
Parameters
xlLocationAsNewSheet | 1 |
xlLocationAsObject | 2 |
xlLocationAutomatic | 3 |
proc ::Excel::Enum::XlChartLocation {} { # xlLocationAsNewSheet - 1 # xlLocationAsObject - 2 # xlLocationAutomatic - 3 return { xlLocationAsNewSheet 1 xlLocationAsObject 2 xlLocationAutomatic 3 } }
XlChartPicturePlacement [::Excel::Enum]Top, Main, Index
XlChartPicturePlacement
Parameters
xlAllFaces | 7 |
xlEnd | 2 |
xlEndSides | 3 |
xlFront | 4 |
xlFrontEnd | 6 |
xlFrontSides | 5 |
xlSides | 1 |
proc ::Excel::Enum::XlChartPicturePlacement {} { # xlAllFaces - 7 # xlEnd - 2 # xlEndSides - 3 # xlFront - 4 # xlFrontEnd - 6 # xlFrontSides - 5 # xlSides - 1 return { xlAllFaces 7 xlEnd 2 xlEndSides 3 xlFront 4 xlFrontEnd 6 xlFrontSides 5 xlSides 1 } }
XlChartPictureType [::Excel::Enum]Top, Main, Index
XlChartPictureType
Parameters
xlStack | 2 |
xlStackScale | 3 |
xlStretch | 1 |
proc ::Excel::Enum::XlChartPictureType {} { # xlStack - 2 # xlStackScale - 3 # xlStretch - 1 return { xlStack 2 xlStackScale 3 xlStretch 1 } }
XlChartSplitType [::Excel::Enum]Top, Main, Index
XlChartSplitType
Parameters
xlSplitByCustomSplit | 4 |
xlSplitByPercentValue | 3 |
xlSplitByPosition | 1 |
xlSplitByValue | 2 |
proc ::Excel::Enum::XlChartSplitType {} { # xlSplitByCustomSplit - 4 # xlSplitByPercentValue - 3 # xlSplitByPosition - 1 # xlSplitByValue - 2 return { xlSplitByCustomSplit 4 xlSplitByPercentValue 3 xlSplitByPosition 1 xlSplitByValue 2 } }
XlChartType [::Excel::Enum]Top, Main, Index
XlChartType
Parameters
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 |
xlBoxwhisker | 121 |
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 |
xlFunnel | 123 |
xlHistogram | 118 |
xlLine | 4 |
xlLineMarkers | 65 |
xlLineMarkersStacked | 66 |
xlLineMarkersStacked100 | 67 |
xlLineStacked | 63 |
xlLineStacked100 | 64 |
xlPareto | 122 |
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 |
xlRegionMap | 140 |
xlStockHLC | 88 |
xlStockOHLC | 89 |
xlStockVHLC | 90 |
xlStockVOHLC | 91 |
xlSunburst | 120 |
xlSurface | 83 |
xlSurfaceTopView | 85 |
xlSurfaceTopViewWireframe | 86 |
xlSurfaceWireframe | 84 |
xlTreemap | 117 |
xlWaterfall | 119 |
xlXYScatter | -4169 |
xlXYScatterLines | 74 |
xlXYScatterLinesNoMarkers | 75 |
xlXYScatterSmooth | 72 |
xlXYScatterSmoothNoMarkers | 73 |
proc ::Excel::Enum::XlChartType {} { # 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 # xlBoxwhisker - 121 # 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 # xlFunnel - 123 # xlHistogram - 118 # xlLine - 4 # xlLineMarkers - 65 # xlLineMarkersStacked - 66 # xlLineMarkersStacked100 - 67 # xlLineStacked - 63 # xlLineStacked100 - 64 # xlPareto - 122 # 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 # xlRegionMap - 140 # xlStockHLC - 88 # xlStockOHLC - 89 # xlStockVHLC - 90 # xlStockVOHLC - 91 # xlSunburst - 120 # xlSurface - 83 # xlSurfaceTopView - 85 # xlSurfaceTopViewWireframe - 86 # xlSurfaceWireframe - 84 # xlTreemap - 117 # xlWaterfall - 119 # xlXYScatter - -4169 # xlXYScatterLines - 74 # xlXYScatterLinesNoMarkers - 75 # xlXYScatterSmooth - 72 # xlXYScatterSmoothNoMarkers - 73 return { 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 xlBoxwhisker 121 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 xlFunnel 123 xlHistogram 118 xlLine 4 xlLineMarkers 65 xlLineMarkersStacked 66 xlLineMarkersStacked100 67 xlLineStacked 63 xlLineStacked100 64 xlPareto 122 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 xlRegionMap 140 xlStockHLC 88 xlStockOHLC 89 xlStockVHLC 90 xlStockVOHLC 91 xlSunburst 120 xlSurface 83 xlSurfaceTopView 85 xlSurfaceTopViewWireframe 86 xlSurfaceWireframe 84 xlTreemap 117 xlWaterfall 119 xlXYScatter -4169 xlXYScatterLines 74 xlXYScatterLinesNoMarkers 75 xlXYScatterSmooth 72 xlXYScatterSmoothNoMarkers 73 } }
XlCheckInVersionType [::Excel::Enum]Top, Main, Index
XlCheckInVersionType
Parameters
xlCheckInMajorVersion | 1 |
xlCheckInMinorVersion | 0 |
xlCheckInOverwriteVersion | 2 |
proc ::Excel::Enum::XlCheckInVersionType {} { # xlCheckInMajorVersion - 1 # xlCheckInMinorVersion - 0 # xlCheckInOverwriteVersion - 2 return { xlCheckInMajorVersion 1 xlCheckInMinorVersion 0 xlCheckInOverwriteVersion 2 } }
XlClipboardFormat [::Excel::Enum]Top, Main, Index
XlClipboardFormat
Parameters
xlClipboardFormatBIFF | 8 |
xlClipboardFormatBIFF2 | 18 |
xlClipboardFormatBIFF3 | 20 |
xlClipboardFormatBIFF4 | 30 |
xlClipboardFormatBIFF12 | 63 |
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 |
proc ::Excel::Enum::XlClipboardFormat {} { # xlClipboardFormatBIFF - 8 # xlClipboardFormatBIFF2 - 18 # xlClipboardFormatBIFF3 - 20 # xlClipboardFormatBIFF4 - 30 # xlClipboardFormatBIFF12 - 63 # 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 return { xlClipboardFormatBIFF 8 xlClipboardFormatBIFF2 18 xlClipboardFormatBIFF3 20 xlClipboardFormatBIFF4 30 xlClipboardFormatBIFF12 63 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 [::Excel::Enum]Top, Main, Index
XlCmdType
Parameters
xlCmdCube | 1 |
xlCmdDAX | 8 |
xlCmdDefault | 4 |
xlCmdExcel | 7 |
xlCmdList | 5 |
xlCmdSql | 2 |
xlCmdTable | 3 |
xlCmdTableCollection | 6 |
proc ::Excel::Enum::XlCmdType {} { # xlCmdCube - 1 # xlCmdDAX - 8 # xlCmdDefault - 4 # xlCmdExcel - 7 # xlCmdList - 5 # xlCmdSql - 2 # xlCmdTable - 3 # xlCmdTableCollection - 6 return { xlCmdCube 1 xlCmdDAX 8 xlCmdDefault 4 xlCmdExcel 7 xlCmdList 5 xlCmdSql 2 xlCmdTable 3 xlCmdTableCollection 6 } }
XlColorIndex [::Excel::Enum]Top, Main, Index
XlColorIndex
Parameters
xlColorIndexAutomatic | -4105 |
xlColorIndexNone | -4142 |
proc ::Excel::Enum::XlColorIndex {} { # xlColorIndexAutomatic - -4105 # xlColorIndexNone - -4142 return { xlColorIndexAutomatic -4105 xlColorIndexNone -4142 } }
XlColumnDataType [::Excel::Enum]Top, Main, Index
XlColumnDataType
Parameters
xlDMYFormat | 4 |
xlDYMFormat | 7 |
xlEMDFormat | 10 |
xlGeneralFormat | 1 |
xlMDYFormat | 3 |
xlMYDFormat | 6 |
xlSkipColumn | 9 |
xlTextFormat | 2 |
xlYDMFormat | 8 |
xlYMDFormat | 5 |
proc ::Excel::Enum::XlColumnDataType {} { # xlDMYFormat - 4 # xlDYMFormat - 7 # xlEMDFormat - 10 # xlGeneralFormat - 1 # xlMDYFormat - 3 # xlMYDFormat - 6 # xlSkipColumn - 9 # xlTextFormat - 2 # xlYDMFormat - 8 # xlYMDFormat - 5 return { xlDMYFormat 4 xlDYMFormat 7 xlEMDFormat 10 xlGeneralFormat 1 xlMDYFormat 3 xlMYDFormat 6 xlSkipColumn 9 xlTextFormat 2 xlYDMFormat 8 xlYMDFormat 5 } }
XlCommandUnderlines [::Excel::Enum]Top, Main, Index
XlCommandUnderlines
Parameters
xlCommandUnderlinesAutomatic | -4105 |
xlCommandUnderlinesOff | -4146 |
xlCommandUnderlinesOn | 1 |
proc ::Excel::Enum::XlCommandUnderlines {} { # xlCommandUnderlinesAutomatic - -4105 # xlCommandUnderlinesOff - -4146 # xlCommandUnderlinesOn - 1 return { xlCommandUnderlinesAutomatic -4105 xlCommandUnderlinesOff -4146 xlCommandUnderlinesOn 1 } }
XlCommentDisplayMode [::Excel::Enum]Top, Main, Index
XlCommentDisplayMode
Parameters
xlCommentAndIndicator | 1 |
xlCommentIndicatorOnly | -1 |
xlNoIndicator | 0 |
proc ::Excel::Enum::XlCommentDisplayMode {} { # xlCommentAndIndicator - 1 # xlCommentIndicatorOnly - -1 # xlNoIndicator - 0 return { xlCommentAndIndicator 1 xlCommentIndicatorOnly -1 xlNoIndicator 0 } }
XlConditionValueTypes [::Excel::Enum]Top, Main, Index
XlConditionValueTypes
Parameters
xlConditionValueAutomaticMax | 7 |
xlConditionValueAutomaticMin | 6 |
xlConditionValueFormula | 4 |
xlConditionValueHighestValue | 2 |
xlConditionValueLowestValue | 1 |
xlConditionValueNone | -1 |
xlConditionValueNumber | 0 |
xlConditionValuePercent | 3 |
xlConditionValuePercentile | 5 |
proc ::Excel::Enum::XlConditionValueTypes {} { # xlConditionValueAutomaticMax - 7 # xlConditionValueAutomaticMin - 6 # xlConditionValueFormula - 4 # xlConditionValueHighestValue - 2 # xlConditionValueLowestValue - 1 # xlConditionValueNone - -1 # xlConditionValueNumber - 0 # xlConditionValuePercent - 3 # xlConditionValuePercentile - 5 return { xlConditionValueAutomaticMax 7 xlConditionValueAutomaticMin 6 xlConditionValueFormula 4 xlConditionValueHighestValue 2 xlConditionValueLowestValue 1 xlConditionValueNone -1 xlConditionValueNumber 0 xlConditionValuePercent 3 xlConditionValuePercentile 5 } }
XlConnectionType [::Excel::Enum]Top, Main, Index
XlConnectionType
Parameters
xlConnectionTypeDATAFEED | 6 |
xlConnectionTypeMODEL | 7 |
xlConnectionTypeNOSOURCE | 9 |
xlConnectionTypeODBC | 2 |
xlConnectionTypeOLEDB | 1 |
xlConnectionTypeTEXT | 4 |
xlConnectionTypeWEB | 5 |
xlConnectionTypeWORKSHEET | 8 |
xlConnectionTypeXMLMAP | 3 |
proc ::Excel::Enum::XlConnectionType {} { # xlConnectionTypeDATAFEED - 6 # xlConnectionTypeMODEL - 7 # xlConnectionTypeNOSOURCE - 9 # xlConnectionTypeODBC - 2 # xlConnectionTypeOLEDB - 1 # xlConnectionTypeTEXT - 4 # xlConnectionTypeWEB - 5 # xlConnectionTypeWORKSHEET - 8 # xlConnectionTypeXMLMAP - 3 return { xlConnectionTypeDATAFEED 6 xlConnectionTypeMODEL 7 xlConnectionTypeNOSOURCE 9 xlConnectionTypeODBC 2 xlConnectionTypeOLEDB 1 xlConnectionTypeTEXT 4 xlConnectionTypeWEB 5 xlConnectionTypeWORKSHEET 8 xlConnectionTypeXMLMAP 3 } }
XlConsolidationFunction [::Excel::Enum]Top, Main, Index
XlConsolidationFunction
Parameters
xlAverage | -4106 |
xlCount | -4112 |
xlCountNums | -4113 |
xlDistinctCount | 11 |
xlMax | -4136 |
xlMin | -4139 |
xlProduct | -4149 |
xlStDev | -4155 |
xlStDevP | -4156 |
xlSum | -4157 |
xlUnknown | 1000 |
xlVar | -4164 |
xlVarP | -4165 |
proc ::Excel::Enum::XlConsolidationFunction {} { # xlAverage - -4106 # xlCount - -4112 # xlCountNums - -4113 # xlDistinctCount - 11 # xlMax - -4136 # xlMin - -4139 # xlProduct - -4149 # xlStDev - -4155 # xlStDevP - -4156 # xlSum - -4157 # xlUnknown - 1000 # xlVar - -4164 # xlVarP - -4165 return { xlAverage -4106 xlCount -4112 xlCountNums -4113 xlDistinctCount 11 xlMax -4136 xlMin -4139 xlProduct -4149 xlStDev -4155 xlStDevP -4156 xlSum -4157 xlUnknown 1000 xlVar -4164 xlVarP -4165 } }
XlContainsOperator [::Excel::Enum]Top, Main, Index
XlContainsOperator
Parameters
xlBeginsWith | 2 |
xlContains | 0 |
xlDoesNotContain | 1 |
xlEndsWith | 3 |
proc ::Excel::Enum::XlContainsOperator {} { # xlBeginsWith - 2 # xlContains - 0 # xlDoesNotContain - 1 # xlEndsWith - 3 return { xlBeginsWith 2 xlContains 0 xlDoesNotContain 1 xlEndsWith 3 } }
XlCopyPictureFormat [::Excel::Enum]Top, Main, Index
XlCopyPictureFormat
Parameters
xlBitmap | 2 |
xlPicture | -4147 |
proc ::Excel::Enum::XlCopyPictureFormat {} { # xlBitmap - 2 # xlPicture - -4147 return { xlBitmap 2 xlPicture -4147 } }
XlCorruptLoad [::Excel::Enum]Top, Main, Index
XlCorruptLoad
Parameters
xlExtractData | 2 |
xlNormalLoad | 0 |
xlRepairFile | 1 |
proc ::Excel::Enum::XlCorruptLoad {} { # xlExtractData - 2 # xlNormalLoad - 0 # xlRepairFile - 1 return { xlExtractData 2 xlNormalLoad 0 xlRepairFile 1 } }
XlCreator [::Excel::Enum]Top, Main, Index
XlCreator
Parameters
xlCreatorCode | 1480803660 |
proc ::Excel::Enum::XlCreator {} { # xlCreatorCode - 1480803660 return { xlCreatorCode 1480803660 } }
XlCredentialsMethod [::Excel::Enum]Top, Main, Index
XlCredentialsMethod
Parameters
xlCredentialsMethodIntegrated | 0 |
xlCredentialsMethodNone | 1 |
xlCredentialsMethodStored | 2 |
proc ::Excel::Enum::XlCredentialsMethod {} { # xlCredentialsMethodIntegrated - 0 # xlCredentialsMethodNone - 1 # xlCredentialsMethodStored - 2 return { xlCredentialsMethodIntegrated 0 xlCredentialsMethodNone 1 xlCredentialsMethodStored 2 } }
XlCubeFieldSubType [::Excel::Enum]Top, Main, Index
XlCubeFieldSubType
Parameters
xlCubeAttribute | 4 |
xlCubeCalculatedMeasure | 5 |
xlCubeHierarchy | 1 |
xlCubeImplicitMeasure | 11 |
xlCubeKPIGoal | 7 |
xlCubeKPIStatus | 8 |
xlCubeKPITrend | 9 |
xlCubeKPIValue | 6 |
xlCubeKPIWeight | 10 |
xlCubeMeasure | 2 |
xlCubeSet | 3 |
proc ::Excel::Enum::XlCubeFieldSubType {} { # xlCubeAttribute - 4 # xlCubeCalculatedMeasure - 5 # xlCubeHierarchy - 1 # xlCubeImplicitMeasure - 11 # xlCubeKPIGoal - 7 # xlCubeKPIStatus - 8 # xlCubeKPITrend - 9 # xlCubeKPIValue - 6 # xlCubeKPIWeight - 10 # xlCubeMeasure - 2 # xlCubeSet - 3 return { xlCubeAttribute 4 xlCubeCalculatedMeasure 5 xlCubeHierarchy 1 xlCubeImplicitMeasure 11 xlCubeKPIGoal 7 xlCubeKPIStatus 8 xlCubeKPITrend 9 xlCubeKPIValue 6 xlCubeKPIWeight 10 xlCubeMeasure 2 xlCubeSet 3 } }
XlCubeFieldType [::Excel::Enum]Top, Main, Index
XlCubeFieldType
Parameters
xlHierarchy | 1 |
xlMeasure | 2 |
xlSet | 3 |
proc ::Excel::Enum::XlCubeFieldType {} { # xlHierarchy - 1 # xlMeasure - 2 # xlSet - 3 return { xlHierarchy 1 xlMeasure 2 xlSet 3 } }
XlCutCopyMode [::Excel::Enum]Top, Main, Index
XlCutCopyMode
Parameters
xlCopy | 1 |
xlCut | 2 |
proc ::Excel::Enum::XlCutCopyMode {} { # xlCopy - 1 # xlCut - 2 return { xlCopy 1 xlCut 2 } }
XlCVError [::Excel::Enum]Top, Main, Index
XlCVError
Parameters
xlErrBlocked | 2047 |
xlErrCalc | 2050 |
xlErrConnect | 2046 |
xlErrDiv0 | 2007 |
xlErrField | 2049 |
xlErrGettingData | 2043 |
xlErrNA | 2042 |
xlErrName | 2029 |
xlErrNull | 2000 |
xlErrNum | 2036 |
xlErrRef | 2023 |
xlErrSpill | 2045 |
xlErrUnknown | 2048 |
xlErrValue | 2015 |
proc ::Excel::Enum::XlCVError {} { # xlErrBlocked - 2047 # xlErrCalc - 2050 # xlErrConnect - 2046 # xlErrDiv0 - 2007 # xlErrField - 2049 # xlErrGettingData - 2043 # xlErrNA - 2042 # xlErrName - 2029 # xlErrNull - 2000 # xlErrNum - 2036 # xlErrRef - 2023 # xlErrSpill - 2045 # xlErrUnknown - 2048 # xlErrValue - 2015 return { xlErrBlocked 2047 xlErrCalc 2050 xlErrConnect 2046 xlErrDiv0 2007 xlErrField 2049 xlErrGettingData 2043 xlErrNA 2042 xlErrName 2029 xlErrNull 2000 xlErrNum 2036 xlErrRef 2023 xlErrSpill 2045 xlErrUnknown 2048 xlErrValue 2015 } }
XlDataBarAxisPosition [::Excel::Enum]Top, Main, Index
XlDataBarAxisPosition
Parameters
xlDataBarAxisAutomatic | 0 |
xlDataBarAxisMidpoint | 1 |
xlDataBarAxisNone | 2 |
proc ::Excel::Enum::XlDataBarAxisPosition {} { # xlDataBarAxisAutomatic - 0 # xlDataBarAxisMidpoint - 1 # xlDataBarAxisNone - 2 return { xlDataBarAxisAutomatic 0 xlDataBarAxisMidpoint 1 xlDataBarAxisNone 2 } }
XlDataBarBorderType [::Excel::Enum]Top, Main, Index
XlDataBarBorderType
Parameters
xlDataBarBorderNone | 0 |
xlDataBarBorderSolid | 1 |
proc ::Excel::Enum::XlDataBarBorderType {} { # xlDataBarBorderNone - 0 # xlDataBarBorderSolid - 1 return { xlDataBarBorderNone 0 xlDataBarBorderSolid 1 } }
XlDataBarFillType [::Excel::Enum]Top, Main, Index
XlDataBarFillType
Parameters
xlDataBarFillGradient | 1 |
xlDataBarFillSolid | 0 |
proc ::Excel::Enum::XlDataBarFillType {} { # xlDataBarFillGradient - 1 # xlDataBarFillSolid - 0 return { xlDataBarFillGradient 1 xlDataBarFillSolid 0 } }
XlDataBarNegativeColorType [::Excel::Enum]Top, Main, Index
XlDataBarNegativeColorType
Parameters
xlDataBarColor | 0 |
xlDataBarSameAsPositive | 1 |
proc ::Excel::Enum::XlDataBarNegativeColorType {} { # xlDataBarColor - 0 # xlDataBarSameAsPositive - 1 return { xlDataBarColor 0 xlDataBarSameAsPositive 1 } }
XlDataLabelPosition [::Excel::Enum]Top, Main, Index
XlDataLabelPosition
Parameters
xlLabelPositionAbove | 0 |
xlLabelPositionBelow | 1 |
xlLabelPositionBestFit | 5 |
xlLabelPositionCenter | -4108 |
xlLabelPositionCustom | 7 |
xlLabelPositionInsideBase | 4 |
xlLabelPositionInsideEnd | 3 |
xlLabelPositionLeft | -4131 |
xlLabelPositionMixed | 6 |
xlLabelPositionOutsideEnd | 2 |
xlLabelPositionRight | -4152 |
proc ::Excel::Enum::XlDataLabelPosition {} { # xlLabelPositionAbove - 0 # xlLabelPositionBelow - 1 # xlLabelPositionBestFit - 5 # xlLabelPositionCenter - -4108 # xlLabelPositionCustom - 7 # xlLabelPositionInsideBase - 4 # xlLabelPositionInsideEnd - 3 # xlLabelPositionLeft - -4131 # xlLabelPositionMixed - 6 # xlLabelPositionOutsideEnd - 2 # xlLabelPositionRight - -4152 return { xlLabelPositionAbove 0 xlLabelPositionBelow 1 xlLabelPositionBestFit 5 xlLabelPositionCenter -4108 xlLabelPositionCustom 7 xlLabelPositionInsideBase 4 xlLabelPositionInsideEnd 3 xlLabelPositionLeft -4131 xlLabelPositionMixed 6 xlLabelPositionOutsideEnd 2 xlLabelPositionRight -4152 } }
XlDataLabelSeparator [::Excel::Enum]Top, Main, Index
XlDataLabelSeparator
Parameters
xlDataLabelSeparatorDefault | 1 |
proc ::Excel::Enum::XlDataLabelSeparator {} { # xlDataLabelSeparatorDefault - 1 return { xlDataLabelSeparatorDefault 1 } }
XlDataLabelsType [::Excel::Enum]Top, Main, Index
XlDataLabelsType
Parameters
xlDataLabelsShowBubbleSizes | 6 |
xlDataLabelsShowLabel | 4 |
xlDataLabelsShowLabelAndPercent | 5 |
xlDataLabelsShowNone | -4142 |
xlDataLabelsShowPercent | 3 |
xlDataLabelsShowValue | 2 |
proc ::Excel::Enum::XlDataLabelsType {} { # xlDataLabelsShowBubbleSizes - 6 # xlDataLabelsShowLabel - 4 # xlDataLabelsShowLabelAndPercent - 5 # xlDataLabelsShowNone - -4142 # xlDataLabelsShowPercent - 3 # xlDataLabelsShowValue - 2 return { xlDataLabelsShowBubbleSizes 6 xlDataLabelsShowLabel 4 xlDataLabelsShowLabelAndPercent 5 xlDataLabelsShowNone -4142 xlDataLabelsShowPercent 3 xlDataLabelsShowValue 2 } }
XlDataSeriesDate [::Excel::Enum]Top, Main, Index
XlDataSeriesDate
Parameters
xlDay | 1 |
xlMonth | 3 |
xlWeekday | 2 |
xlYear | 4 |
proc ::Excel::Enum::XlDataSeriesDate {} { # xlDay - 1 # xlMonth - 3 # xlWeekday - 2 # xlYear - 4 return { xlDay 1 xlMonth 3 xlWeekday 2 xlYear 4 } }
XlDataSeriesType [::Excel::Enum]Top, Main, Index
XlDataSeriesType
Parameters
xlAutoFill | 4 |
xlChronological | 3 |
xlDataSeriesLinear | -4132 |
xlGrowth | 2 |
proc ::Excel::Enum::XlDataSeriesType {} { # xlAutoFill - 4 # xlChronological - 3 # xlDataSeriesLinear - -4132 # xlGrowth - 2 return { xlAutoFill 4 xlChronological 3 xlDataSeriesLinear -4132 xlGrowth 2 } }
XlDeleteShiftDirection [::Excel::Enum]Top, Main, Index
XlDeleteShiftDirection
Parameters
xlShiftToLeft | -4159 |
xlShiftUp | -4162 |
proc ::Excel::Enum::XlDeleteShiftDirection {} { # xlShiftToLeft - -4159 # xlShiftUp - -4162 return { xlShiftToLeft -4159 xlShiftUp -4162 } }
XlDirection [::Excel::Enum]Top, Main, Index
XlDirection
Parameters
xlDown | -4121 |
xlToLeft | -4159 |
xlToRight | -4161 |
xlUp | -4162 |
proc ::Excel::Enum::XlDirection {} { # xlDown - -4121 # xlToLeft - -4159 # xlToRight - -4161 # xlUp - -4162 return { xlDown -4121 xlToLeft -4159 xlToRight -4161 xlUp -4162 } }
XlDisplayBlanksAs [::Excel::Enum]Top, Main, Index
XlDisplayBlanksAs
Parameters
xlInterpolated | 3 |
xlNotPlotted | 1 |
xlZero | 2 |
proc ::Excel::Enum::XlDisplayBlanksAs {} { # xlInterpolated - 3 # xlNotPlotted - 1 # xlZero - 2 return { xlInterpolated 3 xlNotPlotted 1 xlZero 2 } }
XlDisplayDrawingObjects [::Excel::Enum]Top, Main, Index
XlDisplayDrawingObjects
Parameters
xlDisplayShapes | -4104 |
xlHide | 3 |
xlPlaceholders | 2 |
proc ::Excel::Enum::XlDisplayDrawingObjects {} { # xlDisplayShapes - -4104 # xlHide - 3 # xlPlaceholders - 2 return { xlDisplayShapes -4104 xlHide 3 xlPlaceholders 2 } }
XlDisplayUnit [::Excel::Enum]Top, Main, Index
XlDisplayUnit
Parameters
xlHundredMillions | -8 |
xlHundreds | -2 |
xlHundredThousands | -5 |
xlMillionMillions | -10 |
xlMillions | -6 |
xlTenMillions | -7 |
xlTenThousands | -4 |
xlThousandMillions | -9 |
xlThousands | -3 |
proc ::Excel::Enum::XlDisplayUnit {} { # xlHundredMillions - -8 # xlHundreds - -2 # xlHundredThousands - -5 # xlMillionMillions - -10 # xlMillions - -6 # xlTenMillions - -7 # xlTenThousands - -4 # xlThousandMillions - -9 # xlThousands - -3 return { xlHundredMillions -8 xlHundreds -2 xlHundredThousands -5 xlMillionMillions -10 xlMillions -6 xlTenMillions -7 xlTenThousands -4 xlThousandMillions -9 xlThousands -3 } }
XlDupeUnique [::Excel::Enum]Top, Main, Index
XlDupeUnique
Parameters
xlDuplicate | 1 |
xlUnique | 0 |
proc ::Excel::Enum::XlDupeUnique {} { # xlDuplicate - 1 # xlUnique - 0 return { xlDuplicate 1 xlUnique 0 } }
XlDVAlertStyle [::Excel::Enum]Top, Main, Index
XlDVAlertStyle
Parameters
xlValidAlertInformation | 3 |
xlValidAlertStop | 1 |
xlValidAlertWarning | 2 |
proc ::Excel::Enum::XlDVAlertStyle {} { # xlValidAlertInformation - 3 # xlValidAlertStop - 1 # xlValidAlertWarning - 2 return { xlValidAlertInformation 3 xlValidAlertStop 1 xlValidAlertWarning 2 } }
XlDVType [::Excel::Enum]Top, Main, Index
XlDVType
Parameters
xlValidateCustom | 7 |
xlValidateDate | 4 |
xlValidateDecimal | 2 |
xlValidateInputOnly | 0 |
xlValidateList | 3 |
xlValidateTextLength | 6 |
xlValidateTime | 5 |
xlValidateWholeNumber | 1 |
proc ::Excel::Enum::XlDVType {} { # xlValidateCustom - 7 # xlValidateDate - 4 # xlValidateDecimal - 2 # xlValidateInputOnly - 0 # xlValidateList - 3 # xlValidateTextLength - 6 # xlValidateTime - 5 # xlValidateWholeNumber - 1 return { xlValidateCustom 7 xlValidateDate 4 xlValidateDecimal 2 xlValidateInputOnly 0 xlValidateList 3 xlValidateTextLength 6 xlValidateTime 5 xlValidateWholeNumber 1 } }
XlDynamicFilterCriteria [::Excel::Enum]Top, Main, Index
XlDynamicFilterCriteria
Parameters
xlFilterAboveAverage | 33 |
xlFilterAllDatesInPeriodApril | 24 |
xlFilterAllDatesInPeriodAugust | 28 |
xlFilterAllDatesInPeriodDecember | 32 |
xlFilterAllDatesInPeriodFebruray | 22 |
xlFilterAllDatesInPeriodJanuary | 21 |
xlFilterAllDatesInPeriodJuly | 27 |
xlFilterAllDatesInPeriodJune | 26 |
xlFilterAllDatesInPeriodMarch | 23 |
xlFilterAllDatesInPeriodMay | 25 |
xlFilterAllDatesInPeriodNovember | 31 |
xlFilterAllDatesInPeriodOctober | 30 |
xlFilterAllDatesInPeriodQuarter1 | 17 |
xlFilterAllDatesInPeriodQuarter2 | 18 |
xlFilterAllDatesInPeriodQuarter3 | 19 |
xlFilterAllDatesInPeriodQuarter4 | 20 |
xlFilterAllDatesInPeriodSeptember | 29 |
xlFilterBelowAverage | 34 |
xlFilterLastMonth | 8 |
xlFilterLastQuarter | 11 |
xlFilterLastWeek | 5 |
xlFilterLastYear | 14 |
xlFilterNextMonth | 9 |
xlFilterNextQuarter | 12 |
xlFilterNextWeek | 6 |
xlFilterNextYear | 15 |
xlFilterThisMonth | 7 |
xlFilterThisQuarter | 10 |
xlFilterThisWeek | 4 |
xlFilterThisYear | 13 |
xlFilterToday | 1 |
xlFilterTomorrow | 3 |
xlFilterYearToDate | 16 |
xlFilterYesterday | 2 |
proc ::Excel::Enum::XlDynamicFilterCriteria {} { # xlFilterAboveAverage - 33 # xlFilterAllDatesInPeriodApril - 24 # xlFilterAllDatesInPeriodAugust - 28 # xlFilterAllDatesInPeriodDecember - 32 # xlFilterAllDatesInPeriodFebruray - 22 # xlFilterAllDatesInPeriodJanuary - 21 # xlFilterAllDatesInPeriodJuly - 27 # xlFilterAllDatesInPeriodJune - 26 # xlFilterAllDatesInPeriodMarch - 23 # xlFilterAllDatesInPeriodMay - 25 # xlFilterAllDatesInPeriodNovember - 31 # xlFilterAllDatesInPeriodOctober - 30 # xlFilterAllDatesInPeriodQuarter1 - 17 # xlFilterAllDatesInPeriodQuarter2 - 18 # xlFilterAllDatesInPeriodQuarter3 - 19 # xlFilterAllDatesInPeriodQuarter4 - 20 # xlFilterAllDatesInPeriodSeptember - 29 # xlFilterBelowAverage - 34 # xlFilterLastMonth - 8 # xlFilterLastQuarter - 11 # xlFilterLastWeek - 5 # xlFilterLastYear - 14 # xlFilterNextMonth - 9 # xlFilterNextQuarter - 12 # xlFilterNextWeek - 6 # xlFilterNextYear - 15 # xlFilterThisMonth - 7 # xlFilterThisQuarter - 10 # xlFilterThisWeek - 4 # xlFilterThisYear - 13 # xlFilterToday - 1 # xlFilterTomorrow - 3 # xlFilterYearToDate - 16 # xlFilterYesterday - 2 return { xlFilterAboveAverage 33 xlFilterAllDatesInPeriodApril 24 xlFilterAllDatesInPeriodAugust 28 xlFilterAllDatesInPeriodDecember 32 xlFilterAllDatesInPeriodFebruray 22 xlFilterAllDatesInPeriodJanuary 21 xlFilterAllDatesInPeriodJuly 27 xlFilterAllDatesInPeriodJune 26 xlFilterAllDatesInPeriodMarch 23 xlFilterAllDatesInPeriodMay 25 xlFilterAllDatesInPeriodNovember 31 xlFilterAllDatesInPeriodOctober 30 xlFilterAllDatesInPeriodQuarter1 17 xlFilterAllDatesInPeriodQuarter2 18 xlFilterAllDatesInPeriodQuarter3 19 xlFilterAllDatesInPeriodQuarter4 20 xlFilterAllDatesInPeriodSeptember 29 xlFilterBelowAverage 34 xlFilterLastMonth 8 xlFilterLastQuarter 11 xlFilterLastWeek 5 xlFilterLastYear 14 xlFilterNextMonth 9 xlFilterNextQuarter 12 xlFilterNextWeek 6 xlFilterNextYear 15 xlFilterThisMonth 7 xlFilterThisQuarter 10 xlFilterThisWeek 4 xlFilterThisYear 13 xlFilterToday 1 xlFilterTomorrow 3 xlFilterYearToDate 16 xlFilterYesterday 2 } }
XlEditionFormat [::Excel::Enum]Top, Main, Index
XlEditionFormat
Parameters
xlBIFF | 2 |
xlPICT | 1 |
xlRTF | 4 |
xlVALU | 8 |
proc ::Excel::Enum::XlEditionFormat {} { # xlBIFF - 2 # xlPICT - 1 # xlRTF - 4 # xlVALU - 8 return { xlBIFF 2 xlPICT 1 xlRTF 4 xlVALU 8 } }
XlEditionOptionsOption [::Excel::Enum]Top, Main, Index
XlEditionOptionsOption
Parameters
xlAutomaticUpdate | 4 |
xlCancel | 1 |
xlChangeAttributes | 6 |
xlManualUpdate | 5 |
xlOpenSource | 3 |
xlSelect | 3 |
xlSendPublisher | 2 |
xlUpdateSubscriber | 2 |
proc ::Excel::Enum::XlEditionOptionsOption {} { # xlAutomaticUpdate - 4 # xlCancel - 1 # xlChangeAttributes - 6 # xlManualUpdate - 5 # xlOpenSource - 3 # xlSelect - 3 # xlSendPublisher - 2 # xlUpdateSubscriber - 2 return { xlAutomaticUpdate 4 xlCancel 1 xlChangeAttributes 6 xlManualUpdate 5 xlOpenSource 3 xlSelect 3 xlSendPublisher 2 xlUpdateSubscriber 2 } }
XlEditionType [::Excel::Enum]Top, Main, Index
XlEditionType
Parameters
xlPublisher | 1 |
xlSubscriber | 2 |
proc ::Excel::Enum::XlEditionType {} { # xlPublisher - 1 # xlSubscriber - 2 return { xlPublisher 1 xlSubscriber 2 } }
XlEnableCancelKey [::Excel::Enum]Top, Main, Index
XlEnableCancelKey
Parameters
xlDisabled | 0 |
xlErrorHandler | 2 |
xlInterrupt | 1 |
proc ::Excel::Enum::XlEnableCancelKey {} { # xlDisabled - 0 # xlErrorHandler - 2 # xlInterrupt - 1 return { xlDisabled 0 xlErrorHandler 2 xlInterrupt 1 } }
XlEnableSelection [::Excel::Enum]Top, Main, Index
XlEnableSelection
Parameters
xlNoRestrictions | 0 |
xlNoSelection | -4142 |
xlUnlockedCells | 1 |
proc ::Excel::Enum::XlEnableSelection {} { # xlNoRestrictions - 0 # xlNoSelection - -4142 # xlUnlockedCells - 1 return { xlNoRestrictions 0 xlNoSelection -4142 xlUnlockedCells 1 } }
XlEndStyleCap [::Excel::Enum]Top, Main, Index
XlEndStyleCap
Parameters
xlCap | 1 |
xlNoCap | 2 |
proc ::Excel::Enum::XlEndStyleCap {} { # xlCap - 1 # xlNoCap - 2 return { xlCap 1 xlNoCap 2 } }
XlErrorBarDirection [::Excel::Enum]Top, Main, Index
XlErrorBarDirection
Parameters
xlX | -4168 |
xlY | 1 |
proc ::Excel::Enum::XlErrorBarDirection {} { # xlX - -4168 # xlY - 1 return { xlX -4168 xlY 1 } }
XlErrorBarInclude [::Excel::Enum]Top, Main, Index
XlErrorBarInclude
Parameters
xlErrorBarIncludeBoth | 1 |
xlErrorBarIncludeMinusValues | 3 |
xlErrorBarIncludeNone | -4142 |
xlErrorBarIncludePlusValues | 2 |
proc ::Excel::Enum::XlErrorBarInclude {} { # xlErrorBarIncludeBoth - 1 # xlErrorBarIncludeMinusValues - 3 # xlErrorBarIncludeNone - -4142 # xlErrorBarIncludePlusValues - 2 return { xlErrorBarIncludeBoth 1 xlErrorBarIncludeMinusValues 3 xlErrorBarIncludeNone -4142 xlErrorBarIncludePlusValues 2 } }
XlErrorBarType [::Excel::Enum]Top, Main, Index
XlErrorBarType
Parameters
xlErrorBarTypeCustom | -4114 |
xlErrorBarTypeFixedValue | 1 |
xlErrorBarTypePercent | 2 |
xlErrorBarTypeStDev | -4155 |
xlErrorBarTypeStError | 4 |
proc ::Excel::Enum::XlErrorBarType {} { # xlErrorBarTypeCustom - -4114 # xlErrorBarTypeFixedValue - 1 # xlErrorBarTypePercent - 2 # xlErrorBarTypeStDev - -4155 # xlErrorBarTypeStError - 4 return { xlErrorBarTypeCustom -4114 xlErrorBarTypeFixedValue 1 xlErrorBarTypePercent 2 xlErrorBarTypeStDev -4155 xlErrorBarTypeStError 4 } }
XlErrorChecks [::Excel::Enum]Top, Main, Index
XlErrorChecks
Parameters
xlEmptyCellReferences | 7 |
xlEvaluateToError | 1 |
xlInconsistentFormula | 4 |
xlInconsistentListFormula | 9 |
xlListDataValidation | 8 |
xlMisleadingFormat | 10 |
xlNumberAsText | 3 |
xlOmittedCells | 5 |
xlTextDate | 2 |
xlUnlockedFormulaCells | 6 |
proc ::Excel::Enum::XlErrorChecks {} { # xlEmptyCellReferences - 7 # xlEvaluateToError - 1 # xlInconsistentFormula - 4 # xlInconsistentListFormula - 9 # xlListDataValidation - 8 # xlMisleadingFormat - 10 # xlNumberAsText - 3 # xlOmittedCells - 5 # xlTextDate - 2 # xlUnlockedFormulaCells - 6 return { xlEmptyCellReferences 7 xlEvaluateToError 1 xlInconsistentFormula 4 xlInconsistentListFormula 9 xlListDataValidation 8 xlMisleadingFormat 10 xlNumberAsText 3 xlOmittedCells 5 xlTextDate 2 xlUnlockedFormulaCells 6 } }
XlFileAccess [::Excel::Enum]Top, Main, Index
XlFileAccess
Parameters
xlReadOnly | 3 |
xlReadWrite | 2 |
proc ::Excel::Enum::XlFileAccess {} { # xlReadOnly - 3 # xlReadWrite - 2 return { xlReadOnly 3 xlReadWrite 2 } }
XlFileFormat [::Excel::Enum]Top, Main, Index
XlFileFormat
Parameters
xlAddIn | 18 |
xlAddIn8 | 18 |
xlCSV | 6 |
xlCSVMac | 22 |
xlCSVMSDOS | 24 |
xlCSVUTF8 | 62 |
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 |
xlExcel8 | 56 |
xlExcel12 | 50 |
xlExcel9795 | 43 |
xlHtml | 44 |
xlIntlAddIn | 26 |
xlIntlMacro | 25 |
xlOpenDocumentSpreadsheet | 60 |
xlOpenXMLAddIn | 55 |
xlOpenXMLStrictWorkbook | 61 |
xlOpenXMLTemplate | 54 |
xlOpenXMLTemplateMacroEnabled | 53 |
xlOpenXMLWorkbook | 51 |
xlOpenXMLWorkbookMacroEnabled | 52 |
xlSYLK | 2 |
xlTemplate | 17 |
xlTemplate8 | 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 |
xlWorkbookDefault | 51 |
xlWorkbookNormal | -4143 |
xlWorks2FarEast | 28 |
xlWQ1 | 34 |
xlXMLSpreadsheet | 46 |
proc ::Excel::Enum::XlFileFormat {} { # xlAddIn - 18 # xlAddIn8 - 18 # xlCSV - 6 # xlCSVMac - 22 # xlCSVMSDOS - 24 # xlCSVUTF8 - 62 # 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 # xlExcel8 - 56 # xlExcel12 - 50 # xlExcel9795 - 43 # xlHtml - 44 # xlIntlAddIn - 26 # xlIntlMacro - 25 # xlOpenDocumentSpreadsheet - 60 # xlOpenXMLAddIn - 55 # xlOpenXMLStrictWorkbook - 61 # xlOpenXMLTemplate - 54 # xlOpenXMLTemplateMacroEnabled - 53 # xlOpenXMLWorkbook - 51 # xlOpenXMLWorkbookMacroEnabled - 52 # xlSYLK - 2 # xlTemplate - 17 # xlTemplate8 - 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 # xlWorkbookDefault - 51 # xlWorkbookNormal - -4143 # xlWorks2FarEast - 28 # xlWQ1 - 34 # xlXMLSpreadsheet - 46 return { xlAddIn 18 xlAddIn8 18 xlCSV 6 xlCSVMac 22 xlCSVMSDOS 24 xlCSVUTF8 62 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 xlExcel8 56 xlExcel12 50 xlExcel9795 43 xlHtml 44 xlIntlAddIn 26 xlIntlMacro 25 xlOpenDocumentSpreadsheet 60 xlOpenXMLAddIn 55 xlOpenXMLStrictWorkbook 61 xlOpenXMLTemplate 54 xlOpenXMLTemplateMacroEnabled 53 xlOpenXMLWorkbook 51 xlOpenXMLWorkbookMacroEnabled 52 xlSYLK 2 xlTemplate 17 xlTemplate8 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 xlWorkbookDefault 51 xlWorkbookNormal -4143 xlWorks2FarEast 28 xlWQ1 34 xlXMLSpreadsheet 46 } }
XlFileValidationPivotMode [::Excel::Enum]Top, Main, Index
XlFileValidationPivotMode
Parameters
xlFileValidationPivotDefault | 0 |
xlFileValidationPivotRun | 1 |
xlFileValidationPivotSkip | 2 |
proc ::Excel::Enum::XlFileValidationPivotMode {} { # xlFileValidationPivotDefault - 0 # xlFileValidationPivotRun - 1 # xlFileValidationPivotSkip - 2 return { xlFileValidationPivotDefault 0 xlFileValidationPivotRun 1 xlFileValidationPivotSkip 2 } }
XlFillWith [::Excel::Enum]Top, Main, Index
XlFillWith
Parameters
xlFillWithAll | -4104 |
xlFillWithContents | 2 |
xlFillWithFormats | -4122 |
proc ::Excel::Enum::XlFillWith {} { # xlFillWithAll - -4104 # xlFillWithContents - 2 # xlFillWithFormats - -4122 return { xlFillWithAll -4104 xlFillWithContents 2 xlFillWithFormats -4122 } }
XlFilterAction [::Excel::Enum]Top, Main, Index
XlFilterAction
Parameters
xlFilterCopy | 2 |
xlFilterInPlace | 1 |
proc ::Excel::Enum::XlFilterAction {} { # xlFilterCopy - 2 # xlFilterInPlace - 1 return { xlFilterCopy 2 xlFilterInPlace 1 } }
XlFilterAllDatesInPeriod [::Excel::Enum]Top, Main, Index
XlFilterAllDatesInPeriod
Parameters
xlFilterAllDatesInPeriodDay | 2 |
xlFilterAllDatesInPeriodHour | 3 |
xlFilterAllDatesInPeriodMinute | 4 |
xlFilterAllDatesInPeriodMonth | 1 |
xlFilterAllDatesInPeriodSecond | 5 |
xlFilterAllDatesInPeriodYear | 0 |
proc ::Excel::Enum::XlFilterAllDatesInPeriod {} { # xlFilterAllDatesInPeriodDay - 2 # xlFilterAllDatesInPeriodHour - 3 # xlFilterAllDatesInPeriodMinute - 4 # xlFilterAllDatesInPeriodMonth - 1 # xlFilterAllDatesInPeriodSecond - 5 # xlFilterAllDatesInPeriodYear - 0 return { xlFilterAllDatesInPeriodDay 2 xlFilterAllDatesInPeriodHour 3 xlFilterAllDatesInPeriodMinute 4 xlFilterAllDatesInPeriodMonth 1 xlFilterAllDatesInPeriodSecond 5 xlFilterAllDatesInPeriodYear 0 } }
XlFilterStatus [::Excel::Enum]Top, Main, Index
XlFilterStatus
Parameters
xlFilterStatusDateHasTime | 2 |
xlFilterStatusDateWrongOrder | 1 |
xlFilterStatusInvalidDate | 3 |
xlFilterStatusOK | 0 |
proc ::Excel::Enum::XlFilterStatus {} { # xlFilterStatusDateHasTime - 2 # xlFilterStatusDateWrongOrder - 1 # xlFilterStatusInvalidDate - 3 # xlFilterStatusOK - 0 return { xlFilterStatusDateHasTime 2 xlFilterStatusDateWrongOrder 1 xlFilterStatusInvalidDate 3 xlFilterStatusOK 0 } }
XlFindLookIn [::Excel::Enum]Top, Main, Index
XlFindLookIn
Parameters
xlComments | -4144 |
xlCommentsThreaded | -4184 |
xlFormulas | -4123 |
xlFormulas2 | -4185 |
xlValues | -4163 |
proc ::Excel::Enum::XlFindLookIn {} { # xlComments - -4144 # xlCommentsThreaded - -4184 # xlFormulas - -4123 # xlFormulas2 - -4185 # xlValues - -4163 return { xlComments -4144 xlCommentsThreaded -4184 xlFormulas -4123 xlFormulas2 -4185 xlValues -4163 } }
XlFixedFormatQuality [::Excel::Enum]Top, Main, Index
XlFixedFormatQuality
Parameters
xlQualityMinimum | 1 |
xlQualityStandard | 0 |
proc ::Excel::Enum::XlFixedFormatQuality {} { # xlQualityMinimum - 1 # xlQualityStandard - 0 return { xlQualityMinimum 1 xlQualityStandard 0 } }
XlFixedFormatType [::Excel::Enum]Top, Main, Index
XlFixedFormatType
Parameters
xlTypePDF | 0 |
xlTypeXPS | 1 |
proc ::Excel::Enum::XlFixedFormatType {} { # xlTypePDF - 0 # xlTypeXPS - 1 return { xlTypePDF 0 xlTypeXPS 1 } }
XlForecastAggregation [::Excel::Enum]Top, Main, Index
XlForecastAggregation
Parameters
xlForecastAggregationAverage | 1 |
xlForecastAggregationCount | 2 |
xlForecastAggregationCountA | 3 |
xlForecastAggregationMax | 4 |
xlForecastAggregationMedian | 5 |
xlForecastAggregationMin | 6 |
xlForecastAggregationSum | 7 |
proc ::Excel::Enum::XlForecastAggregation {} { # xlForecastAggregationAverage - 1 # xlForecastAggregationCount - 2 # xlForecastAggregationCountA - 3 # xlForecastAggregationMax - 4 # xlForecastAggregationMedian - 5 # xlForecastAggregationMin - 6 # xlForecastAggregationSum - 7 return { xlForecastAggregationAverage 1 xlForecastAggregationCount 2 xlForecastAggregationCountA 3 xlForecastAggregationMax 4 xlForecastAggregationMedian 5 xlForecastAggregationMin 6 xlForecastAggregationSum 7 } }
XlForecastChartType [::Excel::Enum]Top, Main, Index
XlForecastChartType
Parameters
xlForecastChartTypeColumn | 1 |
xlForecastChartTypeLine | 0 |
proc ::Excel::Enum::XlForecastChartType {} { # xlForecastChartTypeColumn - 1 # xlForecastChartTypeLine - 0 return { xlForecastChartTypeColumn 1 xlForecastChartTypeLine 0 } }
XlForecastDataCompletion [::Excel::Enum]Top, Main, Index
XlForecastDataCompletion
Parameters
xlForecastDataCompletionInterpolate | 1 |
xlForecastDataCompletionZeros | 0 |
proc ::Excel::Enum::XlForecastDataCompletion {} { # xlForecastDataCompletionInterpolate - 1 # xlForecastDataCompletionZeros - 0 return { xlForecastDataCompletionInterpolate 1 xlForecastDataCompletionZeros 0 } }
XlFormatConditionOperator [::Excel::Enum]Top, Main, Index
XlFormatConditionOperator
Parameters
xlBetween | 1 |
xlEqual | 3 |
xlGreater | 5 |
xlGreaterEqual | 7 |
xlLess | 6 |
xlLessEqual | 8 |
xlNotBetween | 2 |
xlNotEqual | 4 |
proc ::Excel::Enum::XlFormatConditionOperator {} { # xlBetween - 1 # xlEqual - 3 # xlGreater - 5 # xlGreaterEqual - 7 # xlLess - 6 # xlLessEqual - 8 # xlNotBetween - 2 # xlNotEqual - 4 return { xlBetween 1 xlEqual 3 xlGreater 5 xlGreaterEqual 7 xlLess 6 xlLessEqual 8 xlNotBetween 2 xlNotEqual 4 } }
XlFormatConditionType [::Excel::Enum]Top, Main, Index
XlFormatConditionType
Parameters
xlAboveAverageCondition | 12 |
xlBlanksCondition | 10 |
xlCellValue | 1 |
xlColorScale | 3 |
xlDatabar | 4 |
xlErrorsCondition | 16 |
xlExpression | 2 |
xlIconSets | 6 |
xlNoBlanksCondition | 13 |
xlNoErrorsCondition | 17 |
xlTextString | 9 |
xlTimePeriod | 11 |
xlTop10 | 5 |
xlUniqueValues | 8 |
proc ::Excel::Enum::XlFormatConditionType {} { # xlAboveAverageCondition - 12 # xlBlanksCondition - 10 # xlCellValue - 1 # xlColorScale - 3 # xlDatabar - 4 # xlErrorsCondition - 16 # xlExpression - 2 # xlIconSets - 6 # xlNoBlanksCondition - 13 # xlNoErrorsCondition - 17 # xlTextString - 9 # xlTimePeriod - 11 # xlTop10 - 5 # xlUniqueValues - 8 return { xlAboveAverageCondition 12 xlBlanksCondition 10 xlCellValue 1 xlColorScale 3 xlDatabar 4 xlErrorsCondition 16 xlExpression 2 xlIconSets 6 xlNoBlanksCondition 13 xlNoErrorsCondition 17 xlTextString 9 xlTimePeriod 11 xlTop10 5 xlUniqueValues 8 } }
XlFormatFilterTypes [::Excel::Enum]Top, Main, Index
XlFormatFilterTypes
Parameters
xlFilterBottom | 0 |
xlFilterBottomPercent | 2 |
xlFilterTop | 1 |
xlFilterTopPercent | 3 |
proc ::Excel::Enum::XlFormatFilterTypes {} { # xlFilterBottom - 0 # xlFilterBottomPercent - 2 # xlFilterTop - 1 # xlFilterTopPercent - 3 return { xlFilterBottom 0 xlFilterBottomPercent 2 xlFilterTop 1 xlFilterTopPercent 3 } }
XlFormControl [::Excel::Enum]Top, Main, Index
XlFormControl
Parameters
xlButtonControl | 0 |
xlCheckBox | 1 |
xlDropDown | 2 |
xlEditBox | 3 |
xlGroupBox | 4 |
xlLabel | 5 |
xlListBox | 6 |
xlOptionButton | 7 |
xlScrollBar | 8 |
xlSpinner | 9 |
proc ::Excel::Enum::XlFormControl {} { # xlButtonControl - 0 # xlCheckBox - 1 # xlDropDown - 2 # xlEditBox - 3 # xlGroupBox - 4 # xlLabel - 5 # xlListBox - 6 # xlOptionButton - 7 # xlScrollBar - 8 # xlSpinner - 9 return { xlButtonControl 0 xlCheckBox 1 xlDropDown 2 xlEditBox 3 xlGroupBox 4 xlLabel 5 xlListBox 6 xlOptionButton 7 xlScrollBar 8 xlSpinner 9 } }
XlFormulaLabel [::Excel::Enum]Top, Main, Index
XlFormulaLabel
Parameters
xlColumnLabels | 2 |
xlMixedLabels | 3 |
xlNoLabels | -4142 |
xlRowLabels | 1 |
proc ::Excel::Enum::XlFormulaLabel {} { # xlColumnLabels - 2 # xlMixedLabels - 3 # xlNoLabels - -4142 # xlRowLabels - 1 return { xlColumnLabels 2 xlMixedLabels 3 xlNoLabels -4142 xlRowLabels 1 } }
XlFormulaVersion [::Excel::Enum]Top, Main, Index
XlFormulaVersion
Parameters
xlReplaceFormula | 0 |
xlReplaceFormula2 | 1 |
proc ::Excel::Enum::XlFormulaVersion {} { # xlReplaceFormula - 0 # xlReplaceFormula2 - 1 return { xlReplaceFormula 0 xlReplaceFormula2 1 } }
XlGenerateTableRefs [::Excel::Enum]Top, Main, Index
XlGenerateTableRefs
Parameters
xlGenerateTableRefA1 | 0 |
xlGenerateTableRefStruct | 1 |
proc ::Excel::Enum::XlGenerateTableRefs {} { # xlGenerateTableRefA1 - 0 # xlGenerateTableRefStruct - 1 return { xlGenerateTableRefA1 0 xlGenerateTableRefStruct 1 } }
XlGeoMappingLevel [::Excel::Enum]Top, Main, Index
XlGeoMappingLevel
Parameters
xlGeoMappingLevelAutomatic | 0 |
xlGeoMappingLevelCountryRegion | 5 |
xlGeoMappingLevelCountryRegionList | 6 |
xlGeoMappingLevelCounty | 3 |
xlGeoMappingLevelDataOnly | 1 |
xlGeoMappingLevelPostalCode | 2 |
xlGeoMappingLevelState | 4 |
xlGeoMappingLevelWorld | 7 |
proc ::Excel::Enum::XlGeoMappingLevel {} { # xlGeoMappingLevelAutomatic - 0 # xlGeoMappingLevelCountryRegion - 5 # xlGeoMappingLevelCountryRegionList - 6 # xlGeoMappingLevelCounty - 3 # xlGeoMappingLevelDataOnly - 1 # xlGeoMappingLevelPostalCode - 2 # xlGeoMappingLevelState - 4 # xlGeoMappingLevelWorld - 7 return { xlGeoMappingLevelAutomatic 0 xlGeoMappingLevelCountryRegion 5 xlGeoMappingLevelCountryRegionList 6 xlGeoMappingLevelCounty 3 xlGeoMappingLevelDataOnly 1 xlGeoMappingLevelPostalCode 2 xlGeoMappingLevelState 4 xlGeoMappingLevelWorld 7 } }
XlGeoProjectionType [::Excel::Enum]Top, Main, Index
XlGeoProjectionType
Parameters
xlGeoProjectionTypeAlbers | 3 |
xlGeoProjectionTypeAutomatic | 0 |
xlGeoProjectionTypeMercator | 1 |
xlGeoProjectionTypeMiller | 2 |
xlGeoProjectionTypeRobinson | 4 |
proc ::Excel::Enum::XlGeoProjectionType {} { # xlGeoProjectionTypeAlbers - 3 # xlGeoProjectionTypeAutomatic - 0 # xlGeoProjectionTypeMercator - 1 # xlGeoProjectionTypeMiller - 2 # xlGeoProjectionTypeRobinson - 4 return { xlGeoProjectionTypeAlbers 3 xlGeoProjectionTypeAutomatic 0 xlGeoProjectionTypeMercator 1 xlGeoProjectionTypeMiller 2 xlGeoProjectionTypeRobinson 4 } }
XlGradientFillType [::Excel::Enum]Top, Main, Index
XlGradientFillType
Parameters
xlGradientFillLinear | 0 |
xlGradientFillPath | 1 |
proc ::Excel::Enum::XlGradientFillType {} { # xlGradientFillLinear - 0 # xlGradientFillPath - 1 return { xlGradientFillLinear 0 xlGradientFillPath 1 } }
XlGradientStopPositionType [::Excel::Enum]Top, Main, Index
XlGradientStopPositionType
Parameters
xlGradientStopPositionTypeExtremeValue | 0 |
xlGradientStopPositionTypeNumber | 1 |
xlGradientStopPositionTypePercent | 2 |
proc ::Excel::Enum::XlGradientStopPositionType {} { # xlGradientStopPositionTypeExtremeValue - 0 # xlGradientStopPositionTypeNumber - 1 # xlGradientStopPositionTypePercent - 2 return { xlGradientStopPositionTypeExtremeValue 0 xlGradientStopPositionTypeNumber 1 xlGradientStopPositionTypePercent 2 } }
XlHAlign [::Excel::Enum]Top, Main, Index
XlHAlign
Parameters
xlHAlignCenter | -4108 |
xlHAlignCenterAcrossSelection | 7 |
xlHAlignDistributed | -4117 |
xlHAlignFill | 5 |
xlHAlignGeneral | 1 |
xlHAlignJustify | -4130 |
xlHAlignLeft | -4131 |
xlHAlignRight | -4152 |
proc ::Excel::Enum::XlHAlign {} { # xlHAlignCenter - -4108 # xlHAlignCenterAcrossSelection - 7 # xlHAlignDistributed - -4117 # xlHAlignFill - 5 # xlHAlignGeneral - 1 # xlHAlignJustify - -4130 # xlHAlignLeft - -4131 # xlHAlignRight - -4152 return { xlHAlignCenter -4108 xlHAlignCenterAcrossSelection 7 xlHAlignDistributed -4117 xlHAlignFill 5 xlHAlignGeneral 1 xlHAlignJustify -4130 xlHAlignLeft -4131 xlHAlignRight -4152 } }
XlHebrewModes [::Excel::Enum]Top, Main, Index
XlHebrewModes
Parameters
xlHebrewFullScript | 0 |
xlHebrewMixedAuthorizedScript | 3 |
xlHebrewMixedScript | 2 |
xlHebrewPartialScript | 1 |
proc ::Excel::Enum::XlHebrewModes {} { # xlHebrewFullScript - 0 # xlHebrewMixedAuthorizedScript - 3 # xlHebrewMixedScript - 2 # xlHebrewPartialScript - 1 return { xlHebrewFullScript 0 xlHebrewMixedAuthorizedScript 3 xlHebrewMixedScript 2 xlHebrewPartialScript 1 } }
XlHighlightChangesTime [::Excel::Enum]Top, Main, Index
XlHighlightChangesTime
Parameters
xlAllChanges | 2 |
xlNotYetReviewed | 3 |
xlSinceMyLastSave | 1 |
proc ::Excel::Enum::XlHighlightChangesTime {} { # xlAllChanges - 2 # xlNotYetReviewed - 3 # xlSinceMyLastSave - 1 return { xlAllChanges 2 xlNotYetReviewed 3 xlSinceMyLastSave 1 } }
XlHtmlType [::Excel::Enum]Top, Main, Index
XlHtmlType
Parameters
xlHtmlCalc | 1 |
xlHtmlChart | 3 |
xlHtmlList | 2 |
xlHtmlStatic | 0 |
proc ::Excel::Enum::XlHtmlType {} { # xlHtmlCalc - 1 # xlHtmlChart - 3 # xlHtmlList - 2 # xlHtmlStatic - 0 return { xlHtmlCalc 1 xlHtmlChart 3 xlHtmlList 2 xlHtmlStatic 0 } }
XlIcon [::Excel::Enum]Top, Main, Index
XlIcon
Parameters
xlIcon0Bars | 37 |
xlIcon0FilledBoxes | 52 |
xlIcon1Bar | 38 |
xlIcon1FilledBox | 51 |
xlIcon2Bars | 39 |
xlIcon2FilledBoxes | 50 |
xlIcon3Bars | 40 |
xlIcon3FilledBoxes | 49 |
xlIcon4Bars | 41 |
xlIcon4FilledBoxes | 48 |
xlIconBlackCircle | 32 |
xlIconBlackCircleWithBorder | 13 |
xlIconCircleWithOneWhiteQuarter | 33 |
xlIconCircleWithThreeWhiteQuarters | 35 |
xlIconCircleWithTwoWhiteQuarters | 34 |
xlIconGoldStar | 42 |
xlIconGrayCircle | 31 |
xlIconGrayDownArrow | 6 |
xlIconGrayDownInclineArrow | 28 |
xlIconGraySideArrow | 5 |
xlIconGrayUpArrow | 4 |
xlIconGrayUpInclineArrow | 27 |
xlIconGreenCheck | 22 |
xlIconGreenCheckSymbol | 19 |
xlIconGreenCircle | 10 |
xlIconGreenFlag | 7 |
xlIconGreenTrafficLight | 14 |
xlIconGreenUpArrow | 1 |
xlIconGreenUpTriangle | 45 |
xlIconHalfGoldStar | 43 |
xlIconNoCellIcon | -1 |
xlIconPinkCircle | 30 |
xlIconRedCircle | 29 |
xlIconRedCircleWithBorder | 12 |
xlIconRedCross | 24 |
xlIconRedCrossSymbol | 21 |
xlIconRedDiamond | 18 |
xlIconRedDownArrow | 3 |
xlIconRedDownTriangle | 47 |
xlIconRedFlag | 9 |
xlIconRedTrafficLight | 16 |
xlIconSilverStar | 44 |
xlIconWhiteCircleAllWhiteQuarters | 36 |
xlIconYellowCircle | 11 |
xlIconYellowDash | 46 |
xlIconYellowDownInclineArrow | 26 |
xlIconYellowExclamation | 23 |
xlIconYellowExclamationSymbol | 20 |
xlIconYellowFlag | 8 |
xlIconYellowSideArrow | 2 |
xlIconYellowTrafficLight | 15 |
xlIconYellowTriangle | 17 |
xlIconYellowUpInclineArrow | 25 |
proc ::Excel::Enum::XlIcon {} { # xlIcon0Bars - 37 # xlIcon0FilledBoxes - 52 # xlIcon1Bar - 38 # xlIcon1FilledBox - 51 # xlIcon2Bars - 39 # xlIcon2FilledBoxes - 50 # xlIcon3Bars - 40 # xlIcon3FilledBoxes - 49 # xlIcon4Bars - 41 # xlIcon4FilledBoxes - 48 # xlIconBlackCircle - 32 # xlIconBlackCircleWithBorder - 13 # xlIconCircleWithOneWhiteQuarter - 33 # xlIconCircleWithThreeWhiteQuarters - 35 # xlIconCircleWithTwoWhiteQuarters - 34 # xlIconGoldStar - 42 # xlIconGrayCircle - 31 # xlIconGrayDownArrow - 6 # xlIconGrayDownInclineArrow - 28 # xlIconGraySideArrow - 5 # xlIconGrayUpArrow - 4 # xlIconGrayUpInclineArrow - 27 # xlIconGreenCheck - 22 # xlIconGreenCheckSymbol - 19 # xlIconGreenCircle - 10 # xlIconGreenFlag - 7 # xlIconGreenTrafficLight - 14 # xlIconGreenUpArrow - 1 # xlIconGreenUpTriangle - 45 # xlIconHalfGoldStar - 43 # xlIconNoCellIcon - -1 # xlIconPinkCircle - 30 # xlIconRedCircle - 29 # xlIconRedCircleWithBorder - 12 # xlIconRedCross - 24 # xlIconRedCrossSymbol - 21 # xlIconRedDiamond - 18 # xlIconRedDownArrow - 3 # xlIconRedDownTriangle - 47 # xlIconRedFlag - 9 # xlIconRedTrafficLight - 16 # xlIconSilverStar - 44 # xlIconWhiteCircleAllWhiteQuarters - 36 # xlIconYellowCircle - 11 # xlIconYellowDash - 46 # xlIconYellowDownInclineArrow - 26 # xlIconYellowExclamation - 23 # xlIconYellowExclamationSymbol - 20 # xlIconYellowFlag - 8 # xlIconYellowSideArrow - 2 # xlIconYellowTrafficLight - 15 # xlIconYellowTriangle - 17 # xlIconYellowUpInclineArrow - 25 return { xlIcon0Bars 37 xlIcon0FilledBoxes 52 xlIcon1Bar 38 xlIcon1FilledBox 51 xlIcon2Bars 39 xlIcon2FilledBoxes 50 xlIcon3Bars 40 xlIcon3FilledBoxes 49 xlIcon4Bars 41 xlIcon4FilledBoxes 48 xlIconBlackCircle 32 xlIconBlackCircleWithBorder 13 xlIconCircleWithOneWhiteQuarter 33 xlIconCircleWithThreeWhiteQuarters 35 xlIconCircleWithTwoWhiteQuarters 34 xlIconGoldStar 42 xlIconGrayCircle 31 xlIconGrayDownArrow 6 xlIconGrayDownInclineArrow 28 xlIconGraySideArrow 5 xlIconGrayUpArrow 4 xlIconGrayUpInclineArrow 27 xlIconGreenCheck 22 xlIconGreenCheckSymbol 19 xlIconGreenCircle 10 xlIconGreenFlag 7 xlIconGreenTrafficLight 14 xlIconGreenUpArrow 1 xlIconGreenUpTriangle 45 xlIconHalfGoldStar 43 xlIconNoCellIcon -1 xlIconPinkCircle 30 xlIconRedCircle 29 xlIconRedCircleWithBorder 12 xlIconRedCross 24 xlIconRedCrossSymbol 21 xlIconRedDiamond 18 xlIconRedDownArrow 3 xlIconRedDownTriangle 47 xlIconRedFlag 9 xlIconRedTrafficLight 16 xlIconSilverStar 44 xlIconWhiteCircleAllWhiteQuarters 36 xlIconYellowCircle 11 xlIconYellowDash 46 xlIconYellowDownInclineArrow 26 xlIconYellowExclamation 23 xlIconYellowExclamationSymbol 20 xlIconYellowFlag 8 xlIconYellowSideArrow 2 xlIconYellowTrafficLight 15 xlIconYellowTriangle 17 xlIconYellowUpInclineArrow 25 } }
XlIconSet [::Excel::Enum]Top, Main, Index
XlIconSet
Parameters
xl3Arrows | 1 |
xl3ArrowsGray | 2 |
xl3Flags | 3 |
xl3Signs | 6 |
xl3Stars | 18 |
xl3Symbols | 7 |
xl3Symbols2 | 8 |
xl3TrafficLights1 | 4 |
xl3TrafficLights2 | 5 |
xl3Triangles | 19 |
xl4Arrows | 9 |
xl4ArrowsGray | 10 |
xl4CRV | 12 |
xl4RedToBlack | 11 |
xl4TrafficLights | 13 |
xl5Arrows | 14 |
xl5ArrowsGray | 15 |
xl5Boxes | 20 |
xl5CRV | 16 |
xl5Quarters | 17 |
xlCustomSet | -1 |
proc ::Excel::Enum::XlIconSet {} { # xl3Arrows - 1 # xl3ArrowsGray - 2 # xl3Flags - 3 # xl3Signs - 6 # xl3Stars - 18 # xl3Symbols - 7 # xl3Symbols2 - 8 # xl3TrafficLights1 - 4 # xl3TrafficLights2 - 5 # xl3Triangles - 19 # xl4Arrows - 9 # xl4ArrowsGray - 10 # xl4CRV - 12 # xl4RedToBlack - 11 # xl4TrafficLights - 13 # xl5Arrows - 14 # xl5ArrowsGray - 15 # xl5Boxes - 20 # xl5CRV - 16 # xl5Quarters - 17 # xlCustomSet - -1 return { xl3Arrows 1 xl3ArrowsGray 2 xl3Flags 3 xl3Signs 6 xl3Stars 18 xl3Symbols 7 xl3Symbols2 8 xl3TrafficLights1 4 xl3TrafficLights2 5 xl3Triangles 19 xl4Arrows 9 xl4ArrowsGray 10 xl4CRV 12 xl4RedToBlack 11 xl4TrafficLights 13 xl5Arrows 14 xl5ArrowsGray 15 xl5Boxes 20 xl5CRV 16 xl5Quarters 17 xlCustomSet -1 } }
XlIMEMode [::Excel::Enum]Top, Main, Index
XlIMEMode
Parameters
xlIMEModeAlpha | 8 |
xlIMEModeAlphaFull | 7 |
xlIMEModeDisable | 3 |
xlIMEModeHangul | 10 |
xlIMEModeHangulFull | 9 |
xlIMEModeHiragana | 4 |
xlIMEModeKatakana | 5 |
xlIMEModeKatakanaHalf | 6 |
xlIMEModeNoControl | 0 |
xlIMEModeOff | 2 |
xlIMEModeOn | 1 |
proc ::Excel::Enum::XlIMEMode {} { # xlIMEModeAlpha - 8 # xlIMEModeAlphaFull - 7 # xlIMEModeDisable - 3 # xlIMEModeHangul - 10 # xlIMEModeHangulFull - 9 # xlIMEModeHiragana - 4 # xlIMEModeKatakana - 5 # xlIMEModeKatakanaHalf - 6 # xlIMEModeNoControl - 0 # xlIMEModeOff - 2 # xlIMEModeOn - 1 return { xlIMEModeAlpha 8 xlIMEModeAlphaFull 7 xlIMEModeDisable 3 xlIMEModeHangul 10 xlIMEModeHangulFull 9 xlIMEModeHiragana 4 xlIMEModeKatakana 5 xlIMEModeKatakanaHalf 6 xlIMEModeNoControl 0 xlIMEModeOff 2 xlIMEModeOn 1 } }
XlImportDataAs [::Excel::Enum]Top, Main, Index
XlImportDataAs
Parameters
xlPivotTableReport | 1 |
xlQueryTable | 0 |
xlTable | 2 |
proc ::Excel::Enum::XlImportDataAs {} { # xlPivotTableReport - 1 # xlQueryTable - 0 # xlTable - 2 return { xlPivotTableReport 1 xlQueryTable 0 xlTable 2 } }
XlInsertFormatOrigin [::Excel::Enum]Top, Main, Index
XlInsertFormatOrigin
Parameters
xlFormatFromLeftOrAbove | 0 |
xlFormatFromRightOrBelow | 1 |
proc ::Excel::Enum::XlInsertFormatOrigin {} { # xlFormatFromLeftOrAbove - 0 # xlFormatFromRightOrBelow - 1 return { xlFormatFromLeftOrAbove 0 xlFormatFromRightOrBelow 1 } }
XlInsertShiftDirection [::Excel::Enum]Top, Main, Index
XlInsertShiftDirection
Parameters
xlShiftDown | -4121 |
xlShiftToRight | -4161 |
proc ::Excel::Enum::XlInsertShiftDirection {} { # xlShiftDown - -4121 # xlShiftToRight - -4161 return { xlShiftDown -4121 xlShiftToRight -4161 } }
XlLayoutFormType [::Excel::Enum]Top, Main, Index
XlLayoutFormType
Parameters
xlOutline | 1 |
xlTabular | 0 |
proc ::Excel::Enum::XlLayoutFormType {} { # xlOutline - 1 # xlTabular - 0 return { xlOutline 1 xlTabular 0 } }
XlLayoutRowType [::Excel::Enum]Top, Main, Index
XlLayoutRowType
Parameters
xlCompactRow | 0 |
xlOutlineRow | 2 |
xlTabularRow | 1 |
proc ::Excel::Enum::XlLayoutRowType {} { # xlCompactRow - 0 # xlOutlineRow - 2 # xlTabularRow - 1 return { xlCompactRow 0 xlOutlineRow 2 xlTabularRow 1 } }
XlLegendPosition [::Excel::Enum]Top, Main, Index
XlLegendPosition
Parameters
xlLegendPositionBottom | -4107 |
xlLegendPositionCorner | 2 |
xlLegendPositionCustom | -4161 |
xlLegendPositionLeft | -4131 |
xlLegendPositionRight | -4152 |
xlLegendPositionTop | -4160 |
proc ::Excel::Enum::XlLegendPosition {} { # xlLegendPositionBottom - -4107 # xlLegendPositionCorner - 2 # xlLegendPositionCustom - -4161 # xlLegendPositionLeft - -4131 # xlLegendPositionRight - -4152 # xlLegendPositionTop - -4160 return { xlLegendPositionBottom -4107 xlLegendPositionCorner 2 xlLegendPositionCustom -4161 xlLegendPositionLeft -4131 xlLegendPositionRight -4152 xlLegendPositionTop -4160 } }
XlLineStyle [::Excel::Enum]Top, Main, Index
XlLineStyle
Parameters
xlContinuous | 1 |
xlDash | -4115 |
xlDashDot | 4 |
xlDashDotDot | 5 |
xlDot | -4118 |
xlDouble | -4119 |
xlLineStyleNone | -4142 |
xlSlantDashDot | 13 |
proc ::Excel::Enum::XlLineStyle {} { # xlContinuous - 1 # xlDash - -4115 # xlDashDot - 4 # xlDashDotDot - 5 # xlDot - -4118 # xlDouble - -4119 # xlLineStyleNone - -4142 # xlSlantDashDot - 13 return { xlContinuous 1 xlDash -4115 xlDashDot 4 xlDashDotDot 5 xlDot -4118 xlDouble -4119 xlLineStyleNone -4142 xlSlantDashDot 13 } }
XlLink [::Excel::Enum]Top, Main, Index
XlLink
Parameters
xlExcelLinks | 1 |
xlOLELinks | 2 |
xlPublishers | 5 |
xlSubscribers | 6 |
proc ::Excel::Enum::XlLink {} { # xlExcelLinks - 1 # xlOLELinks - 2 # xlPublishers - 5 # xlSubscribers - 6 return { xlExcelLinks 1 xlOLELinks 2 xlPublishers 5 xlSubscribers 6 } }
XlLinkedDataTypeState [::Excel::Enum]Top, Main, Index
XlLinkedDataTypeState
Parameters
xlLinkedDataTypeStateBrokenLinkedData | 3 |
xlLinkedDataTypeStateDisambiguationNeeded | 2 |
xlLinkedDataTypeStateFetchingData | 4 |
xlLinkedDataTypeStateNone | 0 |
xlLinkedDataTypeStateValidLinkedData | 1 |
proc ::Excel::Enum::XlLinkedDataTypeState {} { # xlLinkedDataTypeStateBrokenLinkedData - 3 # xlLinkedDataTypeStateDisambiguationNeeded - 2 # xlLinkedDataTypeStateFetchingData - 4 # xlLinkedDataTypeStateNone - 0 # xlLinkedDataTypeStateValidLinkedData - 1 return { xlLinkedDataTypeStateBrokenLinkedData 3 xlLinkedDataTypeStateDisambiguationNeeded 2 xlLinkedDataTypeStateFetchingData 4 xlLinkedDataTypeStateNone 0 xlLinkedDataTypeStateValidLinkedData 1 } }
XlLinkInfo [::Excel::Enum]Top, Main, Index
XlLinkInfo
Parameters
xlEditionDate | 2 |
xlLinkInfoStatus | 3 |
xlUpdateState | 1 |
proc ::Excel::Enum::XlLinkInfo {} { # xlEditionDate - 2 # xlLinkInfoStatus - 3 # xlUpdateState - 1 return { xlEditionDate 2 xlLinkInfoStatus 3 xlUpdateState 1 } }
XlLinkInfoType [::Excel::Enum]Top, Main, Index
XlLinkInfoType
Parameters
xlLinkInfoOLELinks | 2 |
xlLinkInfoPublishers | 5 |
xlLinkInfoSubscribers | 6 |
proc ::Excel::Enum::XlLinkInfoType {} { # xlLinkInfoOLELinks - 2 # xlLinkInfoPublishers - 5 # xlLinkInfoSubscribers - 6 return { xlLinkInfoOLELinks 2 xlLinkInfoPublishers 5 xlLinkInfoSubscribers 6 } }
XlLinkStatus [::Excel::Enum]Top, Main, Index
XlLinkStatus
Parameters
xlLinkStatusCopiedValues | 10 |
xlLinkStatusIndeterminate | 5 |
xlLinkStatusInvalidName | 7 |
xlLinkStatusMissingFile | 1 |
xlLinkStatusMissingSheet | 2 |
xlLinkStatusNotStarted | 6 |
xlLinkStatusOK | 0 |
xlLinkStatusOld | 3 |
xlLinkStatusSourceNotCalculated | 4 |
xlLinkStatusSourceNotOpen | 8 |
xlLinkStatusSourceOpen | 9 |
proc ::Excel::Enum::XlLinkStatus {} { # xlLinkStatusCopiedValues - 10 # xlLinkStatusIndeterminate - 5 # xlLinkStatusInvalidName - 7 # xlLinkStatusMissingFile - 1 # xlLinkStatusMissingSheet - 2 # xlLinkStatusNotStarted - 6 # xlLinkStatusOK - 0 # xlLinkStatusOld - 3 # xlLinkStatusSourceNotCalculated - 4 # xlLinkStatusSourceNotOpen - 8 # xlLinkStatusSourceOpen - 9 return { xlLinkStatusCopiedValues 10 xlLinkStatusIndeterminate 5 xlLinkStatusInvalidName 7 xlLinkStatusMissingFile 1 xlLinkStatusMissingSheet 2 xlLinkStatusNotStarted 6 xlLinkStatusOK 0 xlLinkStatusOld 3 xlLinkStatusSourceNotCalculated 4 xlLinkStatusSourceNotOpen 8 xlLinkStatusSourceOpen 9 } }
XlLinkType [::Excel::Enum]Top, Main, Index
XlLinkType
Parameters
xlLinkTypeExcelLinks | 1 |
xlLinkTypeOLELinks | 2 |
proc ::Excel::Enum::XlLinkType {} { # xlLinkTypeExcelLinks - 1 # xlLinkTypeOLELinks - 2 return { xlLinkTypeExcelLinks 1 xlLinkTypeOLELinks 2 } }
XlListConflict [::Excel::Enum]Top, Main, Index
XlListConflict
Parameters
xlListConflictDialog | 0 |
xlListConflictDiscardAllConflicts | 2 |
xlListConflictError | 3 |
xlListConflictRetryAllConflicts | 1 |
proc ::Excel::Enum::XlListConflict {} { # xlListConflictDialog - 0 # xlListConflictDiscardAllConflicts - 2 # xlListConflictError - 3 # xlListConflictRetryAllConflicts - 1 return { xlListConflictDialog 0 xlListConflictDiscardAllConflicts 2 xlListConflictError 3 xlListConflictRetryAllConflicts 1 } }
XlListDataType [::Excel::Enum]Top, Main, Index
XlListDataType
Parameters
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 |
proc ::Excel::Enum::XlListDataType {} { # 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 return { 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 [::Excel::Enum]Top, Main, Index
XlListObjectSourceType
Parameters
xlSrcExternal | 0 |
xlSrcModel | 4 |
xlSrcQuery | 3 |
xlSrcRange | 1 |
xlSrcXml | 2 |
proc ::Excel::Enum::XlListObjectSourceType {} { # xlSrcExternal - 0 # xlSrcModel - 4 # xlSrcQuery - 3 # xlSrcRange - 1 # xlSrcXml - 2 return { xlSrcExternal 0 xlSrcModel 4 xlSrcQuery 3 xlSrcRange 1 xlSrcXml 2 } }
XlLocationInTable [::Excel::Enum]Top, Main, Index
XlLocationInTable
Parameters
xlColumnHeader | -4110 |
xlColumnItem | 5 |
xlDataHeader | 3 |
xlDataItem | 7 |
xlPageHeader | 2 |
xlPageItem | 6 |
xlRowHeader | -4153 |
xlRowItem | 4 |
xlTableBody | 8 |
proc ::Excel::Enum::XlLocationInTable {} { # xlColumnHeader - -4110 # xlColumnItem - 5 # xlDataHeader - 3 # xlDataItem - 7 # xlPageHeader - 2 # xlPageItem - 6 # xlRowHeader - -4153 # xlRowItem - 4 # xlTableBody - 8 return { xlColumnHeader -4110 xlColumnItem 5 xlDataHeader 3 xlDataItem 7 xlPageHeader 2 xlPageItem 6 xlRowHeader -4153 xlRowItem 4 xlTableBody 8 } }
XlLookAt [::Excel::Enum]Top, Main, Index
XlLookAt
Parameters
xlPart | 2 |
xlWhole | 1 |
proc ::Excel::Enum::XlLookAt {} { # xlPart - 2 # xlWhole - 1 return { xlPart 2 xlWhole 1 } }
XlLookFor [::Excel::Enum]Top, Main, Index
XlLookFor
Parameters
xlLookForBlanks | 0 |
xlLookForErrors | 1 |
xlLookForFormulas | 2 |
proc ::Excel::Enum::XlLookFor {} { # xlLookForBlanks - 0 # xlLookForErrors - 1 # xlLookForFormulas - 2 return { xlLookForBlanks 0 xlLookForErrors 1 xlLookForFormulas 2 } }
XlMailSystem [::Excel::Enum]Top, Main, Index
XlMailSystem
Parameters
xlMAPI | 1 |
xlNoMailSystem | 0 |
xlPowerTalk | 2 |
proc ::Excel::Enum::XlMailSystem {} { # xlMAPI - 1 # xlNoMailSystem - 0 # xlPowerTalk - 2 return { xlMAPI 1 xlNoMailSystem 0 xlPowerTalk 2 } }
XlMarkerStyle [::Excel::Enum]Top, Main, Index
XlMarkerStyle
Parameters
xlMarkerStyleAutomatic | -4105 |
xlMarkerStyleCircle | 8 |
xlMarkerStyleDash | -4115 |
xlMarkerStyleDiamond | 2 |
xlMarkerStyleDot | -4118 |
xlMarkerStyleNone | -4142 |
xlMarkerStylePicture | -4147 |
xlMarkerStylePlus | 9 |
xlMarkerStyleSquare | 1 |
xlMarkerStyleStar | 5 |
xlMarkerStyleTriangle | 3 |
xlMarkerStyleX | -4168 |
proc ::Excel::Enum::XlMarkerStyle {} { # xlMarkerStyleAutomatic - -4105 # xlMarkerStyleCircle - 8 # xlMarkerStyleDash - -4115 # xlMarkerStyleDiamond - 2 # xlMarkerStyleDot - -4118 # xlMarkerStyleNone - -4142 # xlMarkerStylePicture - -4147 # xlMarkerStylePlus - 9 # xlMarkerStyleSquare - 1 # xlMarkerStyleStar - 5 # xlMarkerStyleTriangle - 3 # xlMarkerStyleX - -4168 return { xlMarkerStyleAutomatic -4105 xlMarkerStyleCircle 8 xlMarkerStyleDash -4115 xlMarkerStyleDiamond 2 xlMarkerStyleDot -4118 xlMarkerStyleNone -4142 xlMarkerStylePicture -4147 xlMarkerStylePlus 9 xlMarkerStyleSquare 1 xlMarkerStyleStar 5 xlMarkerStyleTriangle 3 xlMarkerStyleX -4168 } }
XlMeasurementUnits [::Excel::Enum]Top, Main, Index
XlMeasurementUnits
Parameters
xlCentimeters | 1 |
xlInches | 0 |
xlMillimeters | 2 |
proc ::Excel::Enum::XlMeasurementUnits {} { # xlCentimeters - 1 # xlInches - 0 # xlMillimeters - 2 return { xlCentimeters 1 xlInches 0 xlMillimeters 2 } }
XlModelChangeSource [::Excel::Enum]Top, Main, Index
XlModelChangeSource
Parameters
xlChangeByExcel | 0 |
xlChangeByPowerPivotAddIn | 1 |
proc ::Excel::Enum::XlModelChangeSource {} { # xlChangeByExcel - 0 # xlChangeByPowerPivotAddIn - 1 return { xlChangeByExcel 0 xlChangeByPowerPivotAddIn 1 } }
XlMouseButton [::Excel::Enum]Top, Main, Index
XlMouseButton
Parameters
xlNoButton | 0 |
xlPrimaryButton | 1 |
xlSecondaryButton | 2 |
proc ::Excel::Enum::XlMouseButton {} { # xlNoButton - 0 # xlPrimaryButton - 1 # xlSecondaryButton - 2 return { xlNoButton 0 xlPrimaryButton 1 xlSecondaryButton 2 } }
XlMousePointer [::Excel::Enum]Top, Main, Index
XlMousePointer
Parameters
xlDefault | -4143 |
xlIBeam | 3 |
xlNorthwestArrow | 1 |
xlWait | 2 |
proc ::Excel::Enum::XlMousePointer {} { # xlDefault - -4143 # xlIBeam - 3 # xlNorthwestArrow - 1 # xlWait - 2 return { xlDefault -4143 xlIBeam 3 xlNorthwestArrow 1 xlWait 2 } }
XlMSApplication [::Excel::Enum]Top, Main, Index
XlMSApplication
Parameters
xlMicrosoftAccess | 4 |
xlMicrosoftFoxPro | 5 |
xlMicrosoftMail | 3 |
xlMicrosoftPowerPoint | 2 |
xlMicrosoftProject | 6 |
xlMicrosoftSchedulePlus | 7 |
xlMicrosoftWord | 1 |
proc ::Excel::Enum::XlMSApplication {} { # xlMicrosoftAccess - 4 # xlMicrosoftFoxPro - 5 # xlMicrosoftMail - 3 # xlMicrosoftPowerPoint - 2 # xlMicrosoftProject - 6 # xlMicrosoftSchedulePlus - 7 # xlMicrosoftWord - 1 return { xlMicrosoftAccess 4 xlMicrosoftFoxPro 5 xlMicrosoftMail 3 xlMicrosoftPowerPoint 2 xlMicrosoftProject 6 xlMicrosoftSchedulePlus 7 xlMicrosoftWord 1 } }
XlOartHorizontalOverflow [::Excel::Enum]Top, Main, Index
XlOartHorizontalOverflow
Parameters
xlOartHorizontalOverflowClip | 1 |
xlOartHorizontalOverflowOverflow | 0 |
proc ::Excel::Enum::XlOartHorizontalOverflow {} { # xlOartHorizontalOverflowClip - 1 # xlOartHorizontalOverflowOverflow - 0 return { xlOartHorizontalOverflowClip 1 xlOartHorizontalOverflowOverflow 0 } }
XlOartVerticalOverflow [::Excel::Enum]Top, Main, Index
XlOartVerticalOverflow
Parameters
xlOartVerticalOverflowClip | 1 |
xlOartVerticalOverflowEllipsis | 2 |
xlOartVerticalOverflowOverflow | 0 |
proc ::Excel::Enum::XlOartVerticalOverflow {} { # xlOartVerticalOverflowClip - 1 # xlOartVerticalOverflowEllipsis - 2 # xlOartVerticalOverflowOverflow - 0 return { xlOartVerticalOverflowClip 1 xlOartVerticalOverflowEllipsis 2 xlOartVerticalOverflowOverflow 0 } }
XlObjectSize [::Excel::Enum]Top, Main, Index
XlObjectSize
Parameters
xlFitToPage | 2 |
xlFullPage | 3 |
xlScreenSize | 1 |
proc ::Excel::Enum::XlObjectSize {} { # xlFitToPage - 2 # xlFullPage - 3 # xlScreenSize - 1 return { xlFitToPage 2 xlFullPage 3 xlScreenSize 1 } }
XlOLEType [::Excel::Enum]Top, Main, Index
XlOLEType
Parameters
xlOLEControl | 2 |
xlOLEEmbed | 1 |
xlOLELink | 0 |
proc ::Excel::Enum::XlOLEType {} { # xlOLEControl - 2 # xlOLEEmbed - 1 # xlOLELink - 0 return { xlOLEControl 2 xlOLEEmbed 1 xlOLELink 0 } }
XlOLEVerb [::Excel::Enum]Top, Main, Index
XlOLEVerb
Parameters
xlVerbOpen | 2 |
xlVerbPrimary | 1 |
proc ::Excel::Enum::XlOLEVerb {} { # xlVerbOpen - 2 # xlVerbPrimary - 1 return { xlVerbOpen 2 xlVerbPrimary 1 } }
XlOrder [::Excel::Enum]Top, Main, Index
XlOrder
Parameters
xlDownThenOver | 1 |
xlOverThenDown | 2 |
proc ::Excel::Enum::XlOrder {} { # xlDownThenOver - 1 # xlOverThenDown - 2 return { xlDownThenOver 1 xlOverThenDown 2 } }
XlOrientation [::Excel::Enum]Top, Main, Index
XlOrientation
Parameters
xlDownward | -4170 |
xlHorizontal | -4128 |
xlUpward | -4171 |
xlVertical | -4166 |
proc ::Excel::Enum::XlOrientation {} { # xlDownward - -4170 # xlHorizontal - -4128 # xlUpward - -4171 # xlVertical - -4166 return { xlDownward -4170 xlHorizontal -4128 xlUpward -4171 xlVertical -4166 } }
XlPageBreak [::Excel::Enum]Top, Main, Index
XlPageBreak
Parameters
xlPageBreakAutomatic | -4105 |
xlPageBreakManual | -4135 |
xlPageBreakNone | -4142 |
proc ::Excel::Enum::XlPageBreak {} { # xlPageBreakAutomatic - -4105 # xlPageBreakManual - -4135 # xlPageBreakNone - -4142 return { xlPageBreakAutomatic -4105 xlPageBreakManual -4135 xlPageBreakNone -4142 } }
XlPageBreakExtent [::Excel::Enum]Top, Main, Index
XlPageBreakExtent
Parameters
xlPageBreakFull | 1 |
xlPageBreakPartial | 2 |
proc ::Excel::Enum::XlPageBreakExtent {} { # xlPageBreakFull - 1 # xlPageBreakPartial - 2 return { xlPageBreakFull 1 xlPageBreakPartial 2 } }
XlPageOrientation [::Excel::Enum]Top, Main, Index
XlPageOrientation
Parameters
xlLandscape | 2 |
xlPortrait | 1 |
proc ::Excel::Enum::XlPageOrientation {} { # xlLandscape - 2 # xlPortrait - 1 return { xlLandscape 2 xlPortrait 1 } }
XlPaperSize [::Excel::Enum]Top, Main, Index
XlPaperSize
Parameters
xlPaper10x14 | 16 |
xlPaper11x17 | 17 |
xlPaperA3 | 8 |
xlPaperA4 | 9 |
xlPaperA4Small | 10 |
xlPaperA5 | 11 |
xlPaperB4 | 12 |
xlPaperB5 | 13 |
xlPaperCsheet | 24 |
xlPaperDsheet | 25 |
xlPaperEnvelope9 | 19 |
xlPaperEnvelope10 | 20 |
xlPaperEnvelope11 | 21 |
xlPaperEnvelope12 | 22 |
xlPaperEnvelope14 | 23 |
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 |
proc ::Excel::Enum::XlPaperSize {} { # xlPaper10x14 - 16 # xlPaper11x17 - 17 # xlPaperA3 - 8 # xlPaperA4 - 9 # xlPaperA4Small - 10 # xlPaperA5 - 11 # xlPaperB4 - 12 # xlPaperB5 - 13 # xlPaperCsheet - 24 # xlPaperDsheet - 25 # xlPaperEnvelope9 - 19 # xlPaperEnvelope10 - 20 # xlPaperEnvelope11 - 21 # xlPaperEnvelope12 - 22 # xlPaperEnvelope14 - 23 # 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 return { xlPaper10x14 16 xlPaper11x17 17 xlPaperA3 8 xlPaperA4 9 xlPaperA4Small 10 xlPaperA5 11 xlPaperB4 12 xlPaperB5 13 xlPaperCsheet 24 xlPaperDsheet 25 xlPaperEnvelope9 19 xlPaperEnvelope10 20 xlPaperEnvelope11 21 xlPaperEnvelope12 22 xlPaperEnvelope14 23 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 } }
XlParameterDataType [::Excel::Enum]Top, Main, Index
XlParameterDataType
Parameters
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 |
proc ::Excel::Enum::XlParameterDataType {} { # 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 return { 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 [::Excel::Enum]Top, Main, Index
XlParameterType
Parameters
xlConstant | 1 |
xlPrompt | 0 |
xlRange | 2 |
proc ::Excel::Enum::XlParameterType {} { # xlConstant - 1 # xlPrompt - 0 # xlRange - 2 return { xlConstant 1 xlPrompt 0 xlRange 2 } }
XlParentDataLabelOptions [::Excel::Enum]Top, Main, Index
XlParentDataLabelOptions
Parameters
xlParentDataLabelOptionsBanner | 1 |
xlParentDataLabelOptionsNone | 0 |
xlParentDataLabelOptionsOverlapping | 2 |
proc ::Excel::Enum::XlParentDataLabelOptions {} { # xlParentDataLabelOptionsBanner - 1 # xlParentDataLabelOptionsNone - 0 # xlParentDataLabelOptionsOverlapping - 2 return { xlParentDataLabelOptionsBanner 1 xlParentDataLabelOptionsNone 0 xlParentDataLabelOptionsOverlapping 2 } }
XlPasteSpecialOperation [::Excel::Enum]Top, Main, Index
XlPasteSpecialOperation
Parameters
xlPasteSpecialOperationAdd | 2 |
xlPasteSpecialOperationDivide | 5 |
xlPasteSpecialOperationMultiply | 4 |
xlPasteSpecialOperationNone | -4142 |
xlPasteSpecialOperationSubtract | 3 |
proc ::Excel::Enum::XlPasteSpecialOperation {} { # xlPasteSpecialOperationAdd - 2 # xlPasteSpecialOperationDivide - 5 # xlPasteSpecialOperationMultiply - 4 # xlPasteSpecialOperationNone - -4142 # xlPasteSpecialOperationSubtract - 3 return { xlPasteSpecialOperationAdd 2 xlPasteSpecialOperationDivide 5 xlPasteSpecialOperationMultiply 4 xlPasteSpecialOperationNone -4142 xlPasteSpecialOperationSubtract 3 } }
XlPasteType [::Excel::Enum]Top, Main, Index
XlPasteType
Parameters
xlPasteAll | -4104 |
xlPasteAllExceptBorders | 7 |
xlPasteAllMergingConditionalFormats | 14 |
xlPasteAllUsingSourceTheme | 13 |
xlPasteColumnWidths | 8 |
xlPasteComments | -4144 |
xlPasteFormats | -4122 |
xlPasteFormulas | -4123 |
xlPasteFormulasAndNumberFormats | 11 |
xlPasteValidation | 6 |
xlPasteValues | -4163 |
xlPasteValuesAndNumberFormats | 12 |
proc ::Excel::Enum::XlPasteType {} { # xlPasteAll - -4104 # xlPasteAllExceptBorders - 7 # xlPasteAllMergingConditionalFormats - 14 # xlPasteAllUsingSourceTheme - 13 # xlPasteColumnWidths - 8 # xlPasteComments - -4144 # xlPasteFormats - -4122 # xlPasteFormulas - -4123 # xlPasteFormulasAndNumberFormats - 11 # xlPasteValidation - 6 # xlPasteValues - -4163 # xlPasteValuesAndNumberFormats - 12 return { xlPasteAll -4104 xlPasteAllExceptBorders 7 xlPasteAllMergingConditionalFormats 14 xlPasteAllUsingSourceTheme 13 xlPasteColumnWidths 8 xlPasteComments -4144 xlPasteFormats -4122 xlPasteFormulas -4123 xlPasteFormulasAndNumberFormats 11 xlPasteValidation 6 xlPasteValues -4163 xlPasteValuesAndNumberFormats 12 } }
XlPattern [::Excel::Enum]Top, Main, Index
XlPattern
Parameters
xlPatternAutomatic | -4105 |
xlPatternChecker | 9 |
xlPatternCrissCross | 16 |
xlPatternDown | -4121 |
xlPatternGray8 | 18 |
xlPatternGray16 | 17 |
xlPatternGray25 | -4124 |
xlPatternGray50 | -4125 |
xlPatternGray75 | -4126 |
xlPatternGrid | 15 |
xlPatternHorizontal | -4128 |
xlPatternLightDown | 13 |
xlPatternLightHorizontal | 11 |
xlPatternLightUp | 14 |
xlPatternLightVertical | 12 |
xlPatternLinearGradient | 4000 |
xlPatternNone | -4142 |
xlPatternRectangularGradient | 4001 |
xlPatternSemiGray75 | 10 |
xlPatternSolid | 1 |
xlPatternUp | -4162 |
xlPatternVertical | -4166 |
proc ::Excel::Enum::XlPattern {} { # xlPatternAutomatic - -4105 # xlPatternChecker - 9 # xlPatternCrissCross - 16 # xlPatternDown - -4121 # xlPatternGray8 - 18 # xlPatternGray16 - 17 # xlPatternGray25 - -4124 # xlPatternGray50 - -4125 # xlPatternGray75 - -4126 # xlPatternGrid - 15 # xlPatternHorizontal - -4128 # xlPatternLightDown - 13 # xlPatternLightHorizontal - 11 # xlPatternLightUp - 14 # xlPatternLightVertical - 12 # xlPatternLinearGradient - 4000 # xlPatternNone - -4142 # xlPatternRectangularGradient - 4001 # xlPatternSemiGray75 - 10 # xlPatternSolid - 1 # xlPatternUp - -4162 # xlPatternVertical - -4166 return { xlPatternAutomatic -4105 xlPatternChecker 9 xlPatternCrissCross 16 xlPatternDown -4121 xlPatternGray8 18 xlPatternGray16 17 xlPatternGray25 -4124 xlPatternGray50 -4125 xlPatternGray75 -4126 xlPatternGrid 15 xlPatternHorizontal -4128 xlPatternLightDown 13 xlPatternLightHorizontal 11 xlPatternLightUp 14 xlPatternLightVertical 12 xlPatternLinearGradient 4000 xlPatternNone -4142 xlPatternRectangularGradient 4001 xlPatternSemiGray75 10 xlPatternSolid 1 xlPatternUp -4162 xlPatternVertical -4166 } }
XlPhoneticAlignment [::Excel::Enum]Top, Main, Index
XlPhoneticAlignment
Parameters
xlPhoneticAlignCenter | 2 |
xlPhoneticAlignDistributed | 3 |
xlPhoneticAlignLeft | 1 |
xlPhoneticAlignNoControl | 0 |
proc ::Excel::Enum::XlPhoneticAlignment {} { # xlPhoneticAlignCenter - 2 # xlPhoneticAlignDistributed - 3 # xlPhoneticAlignLeft - 1 # xlPhoneticAlignNoControl - 0 return { xlPhoneticAlignCenter 2 xlPhoneticAlignDistributed 3 xlPhoneticAlignLeft 1 xlPhoneticAlignNoControl 0 } }
XlPhoneticCharacterType [::Excel::Enum]Top, Main, Index
XlPhoneticCharacterType
Parameters
xlHiragana | 2 |
xlKatakana | 1 |
xlKatakanaHalf | 0 |
xlNoConversion | 3 |
proc ::Excel::Enum::XlPhoneticCharacterType {} { # xlHiragana - 2 # xlKatakana - 1 # xlKatakanaHalf - 0 # xlNoConversion - 3 return { xlHiragana 2 xlKatakana 1 xlKatakanaHalf 0 xlNoConversion 3 } }
XlPictureAppearance [::Excel::Enum]Top, Main, Index
XlPictureAppearance
Parameters
xlPrinter | 2 |
xlScreen | 1 |
proc ::Excel::Enum::XlPictureAppearance {} { # xlPrinter - 2 # xlScreen - 1 return { xlPrinter 2 xlScreen 1 } }
XlPictureConvertorType [::Excel::Enum]Top, Main, Index
XlPictureConvertorType
Parameters
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 |
proc ::Excel::Enum::XlPictureConvertorType {} { # 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 return { 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 } }
XlPieSliceIndex [::Excel::Enum]Top, Main, Index
XlPieSliceIndex
Parameters
xlCenterPoint | 5 |
xlInnerCenterPoint | 8 |
xlInnerClockwisePoint | 7 |
xlInnerCounterClockwisePoint | 9 |
xlMidClockwiseRadiusPoint | 4 |
xlMidCounterClockwiseRadiusPoint | 6 |
xlOuterCenterPoint | 2 |
xlOuterClockwisePoint | 3 |
xlOuterCounterClockwisePoint | 1 |
proc ::Excel::Enum::XlPieSliceIndex {} { # xlCenterPoint - 5 # xlInnerCenterPoint - 8 # xlInnerClockwisePoint - 7 # xlInnerCounterClockwisePoint - 9 # xlMidClockwiseRadiusPoint - 4 # xlMidCounterClockwiseRadiusPoint - 6 # xlOuterCenterPoint - 2 # xlOuterClockwisePoint - 3 # xlOuterCounterClockwisePoint - 1 return { xlCenterPoint 5 xlInnerCenterPoint 8 xlInnerClockwisePoint 7 xlInnerCounterClockwisePoint 9 xlMidClockwiseRadiusPoint 4 xlMidCounterClockwiseRadiusPoint 6 xlOuterCenterPoint 2 xlOuterClockwisePoint 3 xlOuterCounterClockwisePoint 1 } }
XlPieSliceLocation [::Excel::Enum]Top, Main, Index
XlPieSliceLocation
Parameters
xlHorizontalCoordinate | 1 |
xlVerticalCoordinate | 2 |
proc ::Excel::Enum::XlPieSliceLocation {} { # xlHorizontalCoordinate - 1 # xlVerticalCoordinate - 2 return { xlHorizontalCoordinate 1 xlVerticalCoordinate 2 } }
XlPivotCellType [::Excel::Enum]Top, Main, Index
XlPivotCellType
Parameters
xlPivotCellBlankCell | 9 |
xlPivotCellCustomSubtotal | 7 |
xlPivotCellDataField | 4 |
xlPivotCellDataPivotField | 8 |
xlPivotCellGrandTotal | 3 |
xlPivotCellPageFieldItem | 6 |
xlPivotCellPivotField | 5 |
xlPivotCellPivotItem | 1 |
xlPivotCellSubtotal | 2 |
xlPivotCellValue | 0 |
proc ::Excel::Enum::XlPivotCellType {} { # xlPivotCellBlankCell - 9 # xlPivotCellCustomSubtotal - 7 # xlPivotCellDataField - 4 # xlPivotCellDataPivotField - 8 # xlPivotCellGrandTotal - 3 # xlPivotCellPageFieldItem - 6 # xlPivotCellPivotField - 5 # xlPivotCellPivotItem - 1 # xlPivotCellSubtotal - 2 # xlPivotCellValue - 0 return { xlPivotCellBlankCell 9 xlPivotCellCustomSubtotal 7 xlPivotCellDataField 4 xlPivotCellDataPivotField 8 xlPivotCellGrandTotal 3 xlPivotCellPageFieldItem 6 xlPivotCellPivotField 5 xlPivotCellPivotItem 1 xlPivotCellSubtotal 2 xlPivotCellValue 0 } }
XlPivotConditionScope [::Excel::Enum]Top, Main, Index
XlPivotConditionScope
Parameters
xlDataFieldScope | 2 |
xlFieldsScope | 1 |
xlSelectionScope | 0 |
proc ::Excel::Enum::XlPivotConditionScope {} { # xlDataFieldScope - 2 # xlFieldsScope - 1 # xlSelectionScope - 0 return { xlDataFieldScope 2 xlFieldsScope 1 xlSelectionScope 0 } }
XlPivotFieldCalculation [::Excel::Enum]Top, Main, Index
XlPivotFieldCalculation
Parameters
xlDifferenceFrom | 2 |
xlIndex | 9 |
xlNoAdditionalCalculation | -4143 |
xlPercentDifferenceFrom | 4 |
xlPercentOf | 3 |
xlPercentOfColumn | 7 |
xlPercentOfParent | 12 |
xlPercentOfParentColumn | 11 |
xlPercentOfParentRow | 10 |
xlPercentOfRow | 6 |
xlPercentOfTotal | 8 |
xlPercentRunningTotal | 13 |
xlRankAscending | 14 |
xlRankDecending | 15 |
xlRunningTotal | 5 |
proc ::Excel::Enum::XlPivotFieldCalculation {} { # xlDifferenceFrom - 2 # xlIndex - 9 # xlNoAdditionalCalculation - -4143 # xlPercentDifferenceFrom - 4 # xlPercentOf - 3 # xlPercentOfColumn - 7 # xlPercentOfParent - 12 # xlPercentOfParentColumn - 11 # xlPercentOfParentRow - 10 # xlPercentOfRow - 6 # xlPercentOfTotal - 8 # xlPercentRunningTotal - 13 # xlRankAscending - 14 # xlRankDecending - 15 # xlRunningTotal - 5 return { xlDifferenceFrom 2 xlIndex 9 xlNoAdditionalCalculation -4143 xlPercentDifferenceFrom 4 xlPercentOf 3 xlPercentOfColumn 7 xlPercentOfParent 12 xlPercentOfParentColumn 11 xlPercentOfParentRow 10 xlPercentOfRow 6 xlPercentOfTotal 8 xlPercentRunningTotal 13 xlRankAscending 14 xlRankDecending 15 xlRunningTotal 5 } }
XlPivotFieldDataType [::Excel::Enum]Top, Main, Index
XlPivotFieldDataType
Parameters
xlDate | 2 |
xlNumber | -4145 |
xlText | -4158 |
proc ::Excel::Enum::XlPivotFieldDataType {} { # xlDate - 2 # xlNumber - -4145 # xlText - -4158 return { xlDate 2 xlNumber -4145 xlText -4158 } }
XlPivotFieldOrientation [::Excel::Enum]Top, Main, Index
XlPivotFieldOrientation
Parameters
xlColumnField | 2 |
xlDataField | 4 |
xlHidden | 0 |
xlPageField | 3 |
xlRowField | 1 |
proc ::Excel::Enum::XlPivotFieldOrientation {} { # xlColumnField - 2 # xlDataField - 4 # xlHidden - 0 # xlPageField - 3 # xlRowField - 1 return { xlColumnField 2 xlDataField 4 xlHidden 0 xlPageField 3 xlRowField 1 } }
XlPivotFieldRepeatLabels [::Excel::Enum]Top, Main, Index
XlPivotFieldRepeatLabels
Parameters
xlDoNotRepeatLabels | 1 |
xlRepeatLabels | 2 |
proc ::Excel::Enum::XlPivotFieldRepeatLabels {} { # xlDoNotRepeatLabels - 1 # xlRepeatLabels - 2 return { xlDoNotRepeatLabels 1 xlRepeatLabels 2 } }
XlPivotFilterType [::Excel::Enum]Top, Main, Index
XlPivotFilterType
Parameters
xlAfter | 33 |
xlAfterOrEqualTo | 34 |
xlAllDatesInPeriodApril | 60 |
xlAllDatesInPeriodAugust | 64 |
xlAllDatesInPeriodDecember | 68 |
xlAllDatesInPeriodFebruary | 58 |
xlAllDatesInPeriodJanuary | 57 |
xlAllDatesInPeriodJuly | 63 |
xlAllDatesInPeriodJune | 62 |
xlAllDatesInPeriodMarch | 59 |
xlAllDatesInPeriodMay | 61 |
xlAllDatesInPeriodNovember | 67 |
xlAllDatesInPeriodOctober | 66 |
xlAllDatesInPeriodQuarter1 | 53 |
xlAllDatesInPeriodQuarter2 | 54 |
xlAllDatesInPeriodQuarter3 | 55 |
xlAllDatesInPeriodQuarter4 | 56 |
xlAllDatesInPeriodSeptember | 65 |
xlBefore | 31 |
xlBeforeOrEqualTo | 32 |
xlBottomCount | 2 |
xlBottomPercent | 4 |
xlBottomSum | 6 |
xlCaptionBeginsWith | 17 |
xlCaptionContains | 21 |
xlCaptionDoesNotBeginWith | 18 |
xlCaptionDoesNotContain | 22 |
xlCaptionDoesNotEndWith | 20 |
xlCaptionDoesNotEqual | 16 |
xlCaptionEndsWith | 19 |
xlCaptionEquals | 15 |
xlCaptionIsBetween | 27 |
xlCaptionIsGreaterThan | 23 |
xlCaptionIsGreaterThanOrEqualTo | 24 |
xlCaptionIsLessThan | 25 |
xlCaptionIsLessThanOrEqualTo | 26 |
xlCaptionIsNotBetween | 28 |
xlDateBetween | 35 |
xlDateLastMonth | 45 |
xlDateLastQuarter | 48 |
xlDateLastWeek | 42 |
xlDateLastYear | 51 |
xlDateNextMonth | 43 |
xlDateNextQuarter | 46 |
xlDateNextWeek | 40 |
xlDateNextYear | 49 |
xlDateNotBetween | 36 |
xlDateThisMonth | 44 |
xlDateThisQuarter | 47 |
xlDateThisWeek | 41 |
xlDateThisYear | 50 |
xlDateToday | 38 |
xlDateTomorrow | 37 |
xlDateYesterday | 39 |
xlNotSpecificDate | 30 |
xlSpecificDate | 29 |
xlTopCount | 1 |
xlTopPercent | 3 |
xlTopSum | 5 |
xlValueDoesNotEqual | 8 |
xlValueEquals | 7 |
xlValueIsBetween | 13 |
xlValueIsGreaterThan | 9 |
xlValueIsGreaterThanOrEqualTo | 10 |
xlValueIsLessThan | 11 |
xlValueIsLessThanOrEqualTo | 12 |
xlValueIsNotBetween | 14 |
xlYearToDate | 52 |
proc ::Excel::Enum::XlPivotFilterType {} { # xlAfter - 33 # xlAfterOrEqualTo - 34 # xlAllDatesInPeriodApril - 60 # xlAllDatesInPeriodAugust - 64 # xlAllDatesInPeriodDecember - 68 # xlAllDatesInPeriodFebruary - 58 # xlAllDatesInPeriodJanuary - 57 # xlAllDatesInPeriodJuly - 63 # xlAllDatesInPeriodJune - 62 # xlAllDatesInPeriodMarch - 59 # xlAllDatesInPeriodMay - 61 # xlAllDatesInPeriodNovember - 67 # xlAllDatesInPeriodOctober - 66 # xlAllDatesInPeriodQuarter1 - 53 # xlAllDatesInPeriodQuarter2 - 54 # xlAllDatesInPeriodQuarter3 - 55 # xlAllDatesInPeriodQuarter4 - 56 # xlAllDatesInPeriodSeptember - 65 # xlBefore - 31 # xlBeforeOrEqualTo - 32 # xlBottomCount - 2 # xlBottomPercent - 4 # xlBottomSum - 6 # xlCaptionBeginsWith - 17 # xlCaptionContains - 21 # xlCaptionDoesNotBeginWith - 18 # xlCaptionDoesNotContain - 22 # xlCaptionDoesNotEndWith - 20 # xlCaptionDoesNotEqual - 16 # xlCaptionEndsWith - 19 # xlCaptionEquals - 15 # xlCaptionIsBetween - 27 # xlCaptionIsGreaterThan - 23 # xlCaptionIsGreaterThanOrEqualTo - 24 # xlCaptionIsLessThan - 25 # xlCaptionIsLessThanOrEqualTo - 26 # xlCaptionIsNotBetween - 28 # xlDateBetween - 35 # xlDateLastMonth - 45 # xlDateLastQuarter - 48 # xlDateLastWeek - 42 # xlDateLastYear - 51 # xlDateNextMonth - 43 # xlDateNextQuarter - 46 # xlDateNextWeek - 40 # xlDateNextYear - 49 # xlDateNotBetween - 36 # xlDateThisMonth - 44 # xlDateThisQuarter - 47 # xlDateThisWeek - 41 # xlDateThisYear - 50 # xlDateToday - 38 # xlDateTomorrow - 37 # xlDateYesterday - 39 # xlNotSpecificDate - 30 # xlSpecificDate - 29 # xlTopCount - 1 # xlTopPercent - 3 # xlTopSum - 5 # xlValueDoesNotEqual - 8 # xlValueEquals - 7 # xlValueIsBetween - 13 # xlValueIsGreaterThan - 9 # xlValueIsGreaterThanOrEqualTo - 10 # xlValueIsLessThan - 11 # xlValueIsLessThanOrEqualTo - 12 # xlValueIsNotBetween - 14 # xlYearToDate - 52 return { xlAfter 33 xlAfterOrEqualTo 34 xlAllDatesInPeriodApril 60 xlAllDatesInPeriodAugust 64 xlAllDatesInPeriodDecember 68 xlAllDatesInPeriodFebruary 58 xlAllDatesInPeriodJanuary 57 xlAllDatesInPeriodJuly 63 xlAllDatesInPeriodJune 62 xlAllDatesInPeriodMarch 59 xlAllDatesInPeriodMay 61 xlAllDatesInPeriodNovember 67 xlAllDatesInPeriodOctober 66 xlAllDatesInPeriodQuarter1 53 xlAllDatesInPeriodQuarter2 54 xlAllDatesInPeriodQuarter3 55 xlAllDatesInPeriodQuarter4 56 xlAllDatesInPeriodSeptember 65 xlBefore 31 xlBeforeOrEqualTo 32 xlBottomCount 2 xlBottomPercent 4 xlBottomSum 6 xlCaptionBeginsWith 17 xlCaptionContains 21 xlCaptionDoesNotBeginWith 18 xlCaptionDoesNotContain 22 xlCaptionDoesNotEndWith 20 xlCaptionDoesNotEqual 16 xlCaptionEndsWith 19 xlCaptionEquals 15 xlCaptionIsBetween 27 xlCaptionIsGreaterThan 23 xlCaptionIsGreaterThanOrEqualTo 24 xlCaptionIsLessThan 25 xlCaptionIsLessThanOrEqualTo 26 xlCaptionIsNotBetween 28 xlDateBetween 35 xlDateLastMonth 45 xlDateLastQuarter 48 xlDateLastWeek 42 xlDateLastYear 51 xlDateNextMonth 43 xlDateNextQuarter 46 xlDateNextWeek 40 xlDateNextYear 49 xlDateNotBetween 36 xlDateThisMonth 44 xlDateThisQuarter 47 xlDateThisWeek 41 xlDateThisYear 50 xlDateToday 38 xlDateTomorrow 37 xlDateYesterday 39 xlNotSpecificDate 30 xlSpecificDate 29 xlTopCount 1 xlTopPercent 3 xlTopSum 5 xlValueDoesNotEqual 8 xlValueEquals 7 xlValueIsBetween 13 xlValueIsGreaterThan 9 xlValueIsGreaterThanOrEqualTo 10 xlValueIsLessThan 11 xlValueIsLessThanOrEqualTo 12 xlValueIsNotBetween 14 xlYearToDate 52 } }
XlPivotFormatType [::Excel::Enum]Top, Main, Index
XlPivotFormatType
Parameters
xlPTClassic | 20 |
xlPTNone | 21 |
xlReport1 | 0 |
xlReport2 | 1 |
xlReport3 | 2 |
xlReport4 | 3 |
xlReport5 | 4 |
xlReport6 | 5 |
xlReport7 | 6 |
xlReport8 | 7 |
xlReport9 | 8 |
xlReport10 | 9 |
xlTable1 | 10 |
xlTable2 | 11 |
xlTable3 | 12 |
xlTable4 | 13 |
xlTable5 | 14 |
xlTable6 | 15 |
xlTable7 | 16 |
xlTable8 | 17 |
xlTable9 | 18 |
xlTable10 | 19 |
proc ::Excel::Enum::XlPivotFormatType {} { # xlPTClassic - 20 # xlPTNone - 21 # xlReport1 - 0 # xlReport2 - 1 # xlReport3 - 2 # xlReport4 - 3 # xlReport5 - 4 # xlReport6 - 5 # xlReport7 - 6 # xlReport8 - 7 # xlReport9 - 8 # xlReport10 - 9 # xlTable1 - 10 # xlTable2 - 11 # xlTable3 - 12 # xlTable4 - 13 # xlTable5 - 14 # xlTable6 - 15 # xlTable7 - 16 # xlTable8 - 17 # xlTable9 - 18 # xlTable10 - 19 return { xlPTClassic 20 xlPTNone 21 xlReport1 0 xlReport2 1 xlReport3 2 xlReport4 3 xlReport5 4 xlReport6 5 xlReport7 6 xlReport8 7 xlReport9 8 xlReport10 9 xlTable1 10 xlTable2 11 xlTable3 12 xlTable4 13 xlTable5 14 xlTable6 15 xlTable7 16 xlTable8 17 xlTable9 18 xlTable10 19 } }
XlPivotLineType [::Excel::Enum]Top, Main, Index
XlPivotLineType
Parameters
xlPivotLineBlank | 3 |
xlPivotLineGrandTotal | 2 |
xlPivotLineRegular | 0 |
xlPivotLineSubtotal | 1 |
proc ::Excel::Enum::XlPivotLineType {} { # xlPivotLineBlank - 3 # xlPivotLineGrandTotal - 2 # xlPivotLineRegular - 0 # xlPivotLineSubtotal - 1 return { xlPivotLineBlank 3 xlPivotLineGrandTotal 2 xlPivotLineRegular 0 xlPivotLineSubtotal 1 } }
XlPivotTableMissingItems [::Excel::Enum]Top, Main, Index
XlPivotTableMissingItems
Parameters
xlMissingItemsDefault | -1 |
xlMissingItemsMax | 32500 |
xlMissingItemsMax2 | 1048576 |
xlMissingItemsNone | 0 |
proc ::Excel::Enum::XlPivotTableMissingItems {} { # xlMissingItemsDefault - -1 # xlMissingItemsMax - 32500 # xlMissingItemsMax2 - 1048576 # xlMissingItemsNone - 0 return { xlMissingItemsDefault -1 xlMissingItemsMax 32500 xlMissingItemsMax2 1048576 xlMissingItemsNone 0 } }
XlPivotTableSourceType [::Excel::Enum]Top, Main, Index
XlPivotTableSourceType
Parameters
xlConsolidation | 3 |
xlDatabase | 1 |
xlExternal | 2 |
xlPivotTable | -4148 |
xlScenario | 4 |
proc ::Excel::Enum::XlPivotTableSourceType {} { # xlConsolidation - 3 # xlDatabase - 1 # xlExternal - 2 # xlPivotTable - -4148 # xlScenario - 4 return { xlConsolidation 3 xlDatabase 1 xlExternal 2 xlPivotTable -4148 xlScenario 4 } }
XlPivotTableVersionList [::Excel::Enum]Top, Main, Index
XlPivotTableVersionList
Parameters
xlPivotTableVersion10 | 1 |
xlPivotTableVersion11 | 2 |
xlPivotTableVersion12 | 3 |
xlPivotTableVersion14 | 4 |
xlPivotTableVersion15 | 5 |
xlPivotTableVersion2000 | 0 |
xlPivotTableVersionCurrent | -1 |
proc ::Excel::Enum::XlPivotTableVersionList {} { # xlPivotTableVersion10 - 1 # xlPivotTableVersion11 - 2 # xlPivotTableVersion12 - 3 # xlPivotTableVersion14 - 4 # xlPivotTableVersion15 - 5 # xlPivotTableVersion2000 - 0 # xlPivotTableVersionCurrent - -1 return { xlPivotTableVersion10 1 xlPivotTableVersion11 2 xlPivotTableVersion12 3 xlPivotTableVersion14 4 xlPivotTableVersion15 5 xlPivotTableVersion2000 0 xlPivotTableVersionCurrent -1 } }
XlPlacement [::Excel::Enum]Top, Main, Index
XlPlacement
Parameters
xlFreeFloating | 3 |
xlMove | 2 |
xlMoveAndSize | 1 |
proc ::Excel::Enum::XlPlacement {} { # xlFreeFloating - 3 # xlMove - 2 # xlMoveAndSize - 1 return { xlFreeFloating 3 xlMove 2 xlMoveAndSize 1 } }
XlPlatform [::Excel::Enum]Top, Main, Index
XlPlatform
Parameters
xlMacintosh | 1 |
xlMSDOS | 3 |
xlWindows | 2 |
proc ::Excel::Enum::XlPlatform {} { # xlMacintosh - 1 # xlMSDOS - 3 # xlWindows - 2 return { xlMacintosh 1 xlMSDOS 3 xlWindows 2 } }
XlPortugueseReform [::Excel::Enum]Top, Main, Index
XlPortugueseReform
Parameters
xlPortugueseBoth | 3 |
xlPortuguesePostReform | 2 |
xlPortuguesePreReform | 1 |
proc ::Excel::Enum::XlPortugueseReform {} { # xlPortugueseBoth - 3 # xlPortuguesePostReform - 2 # xlPortuguesePreReform - 1 return { xlPortugueseBoth 3 xlPortuguesePostReform 2 xlPortuguesePreReform 1 } }
XlPrintErrors [::Excel::Enum]Top, Main, Index
XlPrintErrors
Parameters
xlPrintErrorsBlank | 1 |
xlPrintErrorsDash | 2 |
xlPrintErrorsDisplayed | 0 |
xlPrintErrorsNA | 3 |
proc ::Excel::Enum::XlPrintErrors {} { # xlPrintErrorsBlank - 1 # xlPrintErrorsDash - 2 # xlPrintErrorsDisplayed - 0 # xlPrintErrorsNA - 3 return { xlPrintErrorsBlank 1 xlPrintErrorsDash 2 xlPrintErrorsDisplayed 0 xlPrintErrorsNA 3 } }
XlPrintLocation [::Excel::Enum]Top, Main, Index
XlPrintLocation
Parameters
xlPrintInPlace | 16 |
xlPrintNoComments | -4142 |
xlPrintSheetEnd | 1 |
proc ::Excel::Enum::XlPrintLocation {} { # xlPrintInPlace - 16 # xlPrintNoComments - -4142 # xlPrintSheetEnd - 1 return { xlPrintInPlace 16 xlPrintNoComments -4142 xlPrintSheetEnd 1 } }
XlPriority [::Excel::Enum]Top, Main, Index
XlPriority
Parameters
xlPriorityHigh | -4127 |
xlPriorityLow | -4134 |
xlPriorityNormal | -4143 |
proc ::Excel::Enum::XlPriority {} { # xlPriorityHigh - -4127 # xlPriorityLow - -4134 # xlPriorityNormal - -4143 return { xlPriorityHigh -4127 xlPriorityLow -4134 xlPriorityNormal -4143 } }
XlPropertyDisplayedIn [::Excel::Enum]Top, Main, Index
XlPropertyDisplayedIn
Parameters
xlDisplayPropertyInPivotTable | 1 |
xlDisplayPropertyInPivotTableAndTooltip | 3 |
xlDisplayPropertyInTooltip | 2 |
proc ::Excel::Enum::XlPropertyDisplayedIn {} { # xlDisplayPropertyInPivotTable - 1 # xlDisplayPropertyInPivotTableAndTooltip - 3 # xlDisplayPropertyInTooltip - 2 return { xlDisplayPropertyInPivotTable 1 xlDisplayPropertyInPivotTableAndTooltip 3 xlDisplayPropertyInTooltip 2 } }
XlProtectedViewCloseReason [::Excel::Enum]Top, Main, Index
XlProtectedViewCloseReason
Parameters
xlProtectedViewCloseEdit | 1 |
xlProtectedViewCloseForced | 2 |
xlProtectedViewCloseNormal | 0 |
proc ::Excel::Enum::XlProtectedViewCloseReason {} { # xlProtectedViewCloseEdit - 1 # xlProtectedViewCloseForced - 2 # xlProtectedViewCloseNormal - 0 return { xlProtectedViewCloseEdit 1 xlProtectedViewCloseForced 2 xlProtectedViewCloseNormal 0 } }
XlProtectedViewWindowState [::Excel::Enum]Top, Main, Index
XlProtectedViewWindowState
Parameters
xlProtectedViewWindowMaximized | 2 |
xlProtectedViewWindowMinimized | 1 |
xlProtectedViewWindowNormal | 0 |
proc ::Excel::Enum::XlProtectedViewWindowState {} { # xlProtectedViewWindowMaximized - 2 # xlProtectedViewWindowMinimized - 1 # xlProtectedViewWindowNormal - 0 return { xlProtectedViewWindowMaximized 2 xlProtectedViewWindowMinimized 1 xlProtectedViewWindowNormal 0 } }
XlPTSelectionMode [::Excel::Enum]Top, Main, Index
XlPTSelectionMode
Parameters
xlBlanks | 4 |
xlButton | 15 |
xlDataAndLabel | 0 |
xlDataOnly | 2 |
xlFirstRow | 256 |
xlLabelOnly | 1 |
xlOrigin | 3 |
proc ::Excel::Enum::XlPTSelectionMode {} { # xlBlanks - 4 # xlButton - 15 # xlDataAndLabel - 0 # xlDataOnly - 2 # xlFirstRow - 256 # xlLabelOnly - 1 # xlOrigin - 3 return { xlBlanks 4 xlButton 15 xlDataAndLabel 0 xlDataOnly 2 xlFirstRow 256 xlLabelOnly 1 xlOrigin 3 } }
XlPublishToDocsDisclosureScope [::Excel::Enum]Top, Main, Index
XlPublishToDocsDisclosureScope
Parameters
msoLimited | 1 |
msoNoOverwrite | 3 |
msoOrganization | 2 |
msoPublic | 0 |
proc ::Excel::Enum::XlPublishToDocsDisclosureScope {} { # msoLimited - 1 # msoNoOverwrite - 3 # msoOrganization - 2 # msoPublic - 0 return { msoLimited 1 msoNoOverwrite 3 msoOrganization 2 msoPublic 0 } }
XlPublishToPBINameConflictAction [::Excel::Enum]Top, Main, Index
XlPublishToPBINameConflictAction
Parameters
msoPBIAbort | 1 |
msoPBIIgnore | 0 |
msoPBIOverwrite | 2 |
proc ::Excel::Enum::XlPublishToPBINameConflictAction {} { # msoPBIAbort - 1 # msoPBIIgnore - 0 # msoPBIOverwrite - 2 return { msoPBIAbort 1 msoPBIIgnore 0 msoPBIOverwrite 2 } }
XlPublishToPBIPublishType [::Excel::Enum]Top, Main, Index
XlPublishToPBIPublishType
Parameters
msoPBIExport | 0 |
msoPBIUpload | 1 |
proc ::Excel::Enum::XlPublishToPBIPublishType {} { # msoPBIExport - 0 # msoPBIUpload - 1 return { msoPBIExport 0 msoPBIUpload 1 } }
XlQueryType [::Excel::Enum]Top, Main, Index
XlQueryType
Parameters
xlADORecordset | 7 |
xlDAORecordset | 2 |
xlODBCQuery | 1 |
xlOLEDBQuery | 5 |
xlTextImport | 6 |
xlWebQuery | 4 |
proc ::Excel::Enum::XlQueryType {} { # xlADORecordset - 7 # xlDAORecordset - 2 # xlODBCQuery - 1 # xlOLEDBQuery - 5 # xlTextImport - 6 # xlWebQuery - 4 return { xlADORecordset 7 xlDAORecordset 2 xlODBCQuery 1 xlOLEDBQuery 5 xlTextImport 6 xlWebQuery 4 } }
XlQuickAnalysisMode [::Excel::Enum]Top, Main, Index
XlQuickAnalysisMode
Parameters
xlFormatConditions | 1 |
xlLensOnly | 0 |
xlRecommendedCharts | 2 |
xlSparklines | 5 |
xlTables | 4 |
xlTotals | 3 |
proc ::Excel::Enum::XlQuickAnalysisMode {} { # xlFormatConditions - 1 # xlLensOnly - 0 # xlRecommendedCharts - 2 # xlSparklines - 5 # xlTables - 4 # xlTotals - 3 return { xlFormatConditions 1 xlLensOnly 0 xlRecommendedCharts 2 xlSparklines 5 xlTables 4 xlTotals 3 } }
XlRangeAutoFormat [::Excel::Enum]Top, Main, Index
XlRangeAutoFormat
Parameters
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 |
xlRangeAutoFormatReport2 | 22 |
xlRangeAutoFormatReport3 | 23 |
xlRangeAutoFormatReport4 | 24 |
xlRangeAutoFormatReport5 | 25 |
xlRangeAutoFormatReport6 | 26 |
xlRangeAutoFormatReport7 | 27 |
xlRangeAutoFormatReport8 | 28 |
xlRangeAutoFormatReport9 | 29 |
xlRangeAutoFormatReport10 | 30 |
xlRangeAutoFormatSimple | -4154 |
xlRangeAutoFormatTable1 | 32 |
xlRangeAutoFormatTable2 | 33 |
xlRangeAutoFormatTable3 | 34 |
xlRangeAutoFormatTable4 | 35 |
xlRangeAutoFormatTable5 | 36 |
xlRangeAutoFormatTable6 | 37 |
xlRangeAutoFormatTable7 | 38 |
xlRangeAutoFormatTable8 | 39 |
xlRangeAutoFormatTable9 | 40 |
xlRangeAutoFormatTable10 | 41 |
proc ::Excel::Enum::XlRangeAutoFormat {} { # 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 # xlRangeAutoFormatReport2 - 22 # xlRangeAutoFormatReport3 - 23 # xlRangeAutoFormatReport4 - 24 # xlRangeAutoFormatReport5 - 25 # xlRangeAutoFormatReport6 - 26 # xlRangeAutoFormatReport7 - 27 # xlRangeAutoFormatReport8 - 28 # xlRangeAutoFormatReport9 - 29 # xlRangeAutoFormatReport10 - 30 # xlRangeAutoFormatSimple - -4154 # xlRangeAutoFormatTable1 - 32 # xlRangeAutoFormatTable2 - 33 # xlRangeAutoFormatTable3 - 34 # xlRangeAutoFormatTable4 - 35 # xlRangeAutoFormatTable5 - 36 # xlRangeAutoFormatTable6 - 37 # xlRangeAutoFormatTable7 - 38 # xlRangeAutoFormatTable8 - 39 # xlRangeAutoFormatTable9 - 40 # xlRangeAutoFormatTable10 - 41 return { 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 xlRangeAutoFormatReport2 22 xlRangeAutoFormatReport3 23 xlRangeAutoFormatReport4 24 xlRangeAutoFormatReport5 25 xlRangeAutoFormatReport6 26 xlRangeAutoFormatReport7 27 xlRangeAutoFormatReport8 28 xlRangeAutoFormatReport9 29 xlRangeAutoFormatReport10 30 xlRangeAutoFormatSimple -4154 xlRangeAutoFormatTable1 32 xlRangeAutoFormatTable2 33 xlRangeAutoFormatTable3 34 xlRangeAutoFormatTable4 35 xlRangeAutoFormatTable5 36 xlRangeAutoFormatTable6 37 xlRangeAutoFormatTable7 38 xlRangeAutoFormatTable8 39 xlRangeAutoFormatTable9 40 xlRangeAutoFormatTable10 41 } }
XlRangeValueDataType [::Excel::Enum]Top, Main, Index
XlRangeValueDataType
Parameters
xlRangeValueDefault | 10 |
xlRangeValueMSPersistXML | 12 |
xlRangeValueXMLSpreadsheet | 11 |
proc ::Excel::Enum::XlRangeValueDataType {} { # xlRangeValueDefault - 10 # xlRangeValueMSPersistXML - 12 # xlRangeValueXMLSpreadsheet - 11 return { xlRangeValueDefault 10 xlRangeValueMSPersistXML 12 xlRangeValueXMLSpreadsheet 11 } }
XlReferenceStyle [::Excel::Enum]Top, Main, Index
XlReferenceStyle
Parameters
xlA1 | 1 |
xlR1C1 | -4150 |
proc ::Excel::Enum::XlReferenceStyle {} { # xlA1 - 1 # xlR1C1 - -4150 return { xlA1 1 xlR1C1 -4150 } }
XlReferenceType [::Excel::Enum]Top, Main, Index
XlReferenceType
Parameters
xlAbsolute | 1 |
xlAbsRowRelColumn | 2 |
xlRelative | 4 |
xlRelRowAbsColumn | 3 |
proc ::Excel::Enum::XlReferenceType {} { # xlAbsolute - 1 # xlAbsRowRelColumn - 2 # xlRelative - 4 # xlRelRowAbsColumn - 3 return { xlAbsolute 1 xlAbsRowRelColumn 2 xlRelative 4 xlRelRowAbsColumn 3 } }
XlRegionLabelOptions [::Excel::Enum]Top, Main, Index
XlRegionLabelOptions
Parameters
xlRegionLabelOptionsBestFitOnly | 1 |
xlRegionLabelOptionsNone | 0 |
xlRegionLabelOptionsShowAll | 2 |
proc ::Excel::Enum::XlRegionLabelOptions {} { # xlRegionLabelOptionsBestFitOnly - 1 # xlRegionLabelOptionsNone - 0 # xlRegionLabelOptionsShowAll - 2 return { xlRegionLabelOptionsBestFitOnly 1 xlRegionLabelOptionsNone 0 xlRegionLabelOptionsShowAll 2 } }
XlRemoveDocInfoType [::Excel::Enum]Top, Main, Index
XlRemoveDocInfoType
Parameters
xlRDIAll | 99 |
xlRDIComments | 1 |
xlRDIContentType | 16 |
xlRDIDefinedNameComments | 18 |
xlRDIDocumentManagementPolicy | 15 |
xlRDIDocumentProperties | 8 |
xlRDIDocumentServerProperties | 14 |
xlRDIDocumentWorkspace | 10 |
xlRDIEmailHeader | 5 |
xlRDIExcelDataModel | 23 |
xlRDIInactiveDataConnections | 19 |
xlRDIInkAnnotations | 11 |
xlRDIInlineWebExtensions | 21 |
xlRDIPrinterPath | 20 |
xlRDIPublishInfo | 13 |
xlRDIRemovePersonalInformation | 4 |
xlRDIRoutingSlip | 6 |
xlRDIScenarioComments | 12 |
xlRDISendForReview | 7 |
xlRDITaskpaneWebExtensions | 22 |
proc ::Excel::Enum::XlRemoveDocInfoType {} { # xlRDIAll - 99 # xlRDIComments - 1 # xlRDIContentType - 16 # xlRDIDefinedNameComments - 18 # xlRDIDocumentManagementPolicy - 15 # xlRDIDocumentProperties - 8 # xlRDIDocumentServerProperties - 14 # xlRDIDocumentWorkspace - 10 # xlRDIEmailHeader - 5 # xlRDIExcelDataModel - 23 # xlRDIInactiveDataConnections - 19 # xlRDIInkAnnotations - 11 # xlRDIInlineWebExtensions - 21 # xlRDIPrinterPath - 20 # xlRDIPublishInfo - 13 # xlRDIRemovePersonalInformation - 4 # xlRDIRoutingSlip - 6 # xlRDIScenarioComments - 12 # xlRDISendForReview - 7 # xlRDITaskpaneWebExtensions - 22 return { xlRDIAll 99 xlRDIComments 1 xlRDIContentType 16 xlRDIDefinedNameComments 18 xlRDIDocumentManagementPolicy 15 xlRDIDocumentProperties 8 xlRDIDocumentServerProperties 14 xlRDIDocumentWorkspace 10 xlRDIEmailHeader 5 xlRDIExcelDataModel 23 xlRDIInactiveDataConnections 19 xlRDIInkAnnotations 11 xlRDIInlineWebExtensions 21 xlRDIPrinterPath 20 xlRDIPublishInfo 13 xlRDIRemovePersonalInformation 4 xlRDIRoutingSlip 6 xlRDIScenarioComments 12 xlRDISendForReview 7 xlRDITaskpaneWebExtensions 22 } }
XlRgbColor [::Excel::Enum]Top, Main, Index
XlRgbColor
Parameters
rgbAliceBlue | 16775408 |
rgbAntiqueWhite | 14150650 |
rgbAqua | 16776960 |
rgbAquamarine | 13959039 |
rgbAzure | 16777200 |
rgbBeige | 14480885 |
rgbBisque | 12903679 |
rgbBlack | 0 |
rgbBlanchedAlmond | 13495295 |
rgbBlue | 16711680 |
rgbBlueViolet | 14822282 |
rgbBrown | 2763429 |
rgbBurlyWood | 8894686 |
rgbCadetBlue | 10526303 |
rgbChartreuse | 65407 |
rgbCoral | 5275647 |
rgbCornflowerBlue | 15570276 |
rgbCornsilk | 14481663 |
rgbCrimson | 3937500 |
rgbDarkBlue | 9109504 |
rgbDarkCyan | 9145088 |
rgbDarkGoldenrod | 755384 |
rgbDarkGray | 11119017 |
rgbDarkGreen | 25600 |
rgbDarkGrey | 11119017 |
rgbDarkKhaki | 7059389 |
rgbDarkMagenta | 9109643 |
rgbDarkOliveGreen | 3107669 |
rgbDarkOrange | 36095 |
rgbDarkOrchid | 13382297 |
rgbDarkRed | 139 |
rgbDarkSalmon | 8034025 |
rgbDarkSeaGreen | 9419919 |
rgbDarkSlateBlue | 9125192 |
rgbDarkSlateGray | 5197615 |
rgbDarkSlateGrey | 5197615 |
rgbDarkTurquoise | 13749760 |
rgbDarkViolet | 13828244 |
rgbDeepPink | 9639167 |
rgbDeepSkyBlue | 16760576 |
rgbDimGray | 6908265 |
rgbDimGrey | 6908265 |
rgbDodgerBlue | 16748574 |
rgbFireBrick | 2237106 |
rgbFloralWhite | 15792895 |
rgbForestGreen | 2263842 |
rgbFuchsia | 16711935 |
rgbGainsboro | 14474460 |
rgbGhostWhite | 16775416 |
rgbGold | 55295 |
rgbGoldenrod | 2139610 |
rgbGray | 8421504 |
rgbGreen | 32768 |
rgbGreenYellow | 3145645 |
rgbGrey | 8421504 |
rgbHoneydew | 15794160 |
rgbHotPink | 11823615 |
rgbIndianRed | 6053069 |
rgbIndigo | 8519755 |
rgbIvory | 15794175 |
rgbKhaki | 9234160 |
rgbLavender | 16443110 |
rgbLavenderBlush | 16118015 |
rgbLawnGreen | 64636 |
rgbLemonChiffon | 13499135 |
rgbLightBlue | 15128749 |
rgbLightCoral | 8421616 |
rgbLightCyan | 9145088 |
rgbLightGoldenrodYellow | 13826810 |
rgbLightGray | 13882323 |
rgbLightGreen | 9498256 |
rgbLightGrey | 13882323 |
rgbLightPink | 12695295 |
rgbLightSalmon | 8036607 |
rgbLightSeaGreen | 11186720 |
rgbLightSkyBlue | 16436871 |
rgbLightSlateGray | 10061943 |
rgbLightSlateGrey | 10061943 |
rgbLightSteelBlue | 14599344 |
rgbLightYellow | 14745599 |
rgbLime | 65280 |
rgbLimeGreen | 3329330 |
rgbLinen | 15134970 |
rgbMaroon | 128 |
rgbMediumAquamarine | 11206502 |
rgbMediumBlue | 13434880 |
rgbMediumOrchid | 13850042 |
rgbMediumPurple | 14381203 |
rgbMediumSeaGreen | 7451452 |
rgbMediumSlateBlue | 15624315 |
rgbMediumSpringGreen | 10156544 |
rgbMediumTurquoise | 13422920 |
rgbMediumVioletRed | 8721863 |
rgbMidnightBlue | 7346457 |
rgbMintCream | 16449525 |
rgbMistyRose | 14804223 |
rgbMoccasin | 11920639 |
rgbNavajoWhite | 11394815 |
rgbNavy | 8388608 |
rgbNavyBlue | 8388608 |
rgbOldLace | 15136253 |
rgbOlive | 32896 |
rgbOliveDrab | 2330219 |
rgbOrange | 42495 |
rgbOrangeRed | 17919 |
rgbOrchid | 14053594 |
rgbPaleGoldenrod | 7071982 |
rgbPaleGreen | 10025880 |
rgbPaleTurquoise | 15658671 |
rgbPaleVioletRed | 9662683 |
rgbPapayaWhip | 14020607 |
rgbPeachPuff | 12180223 |
rgbPeru | 4163021 |
rgbPink | 13353215 |
rgbPlum | 14524637 |
rgbPowderBlue | 15130800 |
rgbPurple | 8388736 |
rgbRed | 255 |
rgbRosyBrown | 9408444 |
rgbRoyalBlue | 14772545 |
rgbSalmon | 7504122 |
rgbSandyBrown | 6333684 |
rgbSeaGreen | 5737262 |
rgbSeashell | 15660543 |
rgbSienna | 2970272 |
rgbSilver | 12632256 |
rgbSkyBlue | 15453831 |
rgbSlateBlue | 13458026 |
rgbSlateGray | 9470064 |
rgbSlateGrey | 9470064 |
rgbSnow | 16448255 |
rgbSpringGreen | 8388352 |
rgbSteelBlue | 11829830 |
rgbTan | 9221330 |
rgbTeal | 8421376 |
rgbThistle | 14204888 |
rgbTomato | 4678655 |
rgbTurquoise | 13688896 |
rgbViolet | 15631086 |
rgbWheat | 11788021 |
rgbWhite | 16777215 |
rgbWhiteSmoke | 16119285 |
rgbYellow | 65535 |
rgbYellowGreen | 3329434 |
proc ::Excel::Enum::XlRgbColor {} { # rgbAliceBlue - 16775408 # rgbAntiqueWhite - 14150650 # rgbAqua - 16776960 # rgbAquamarine - 13959039 # rgbAzure - 16777200 # rgbBeige - 14480885 # rgbBisque - 12903679 # rgbBlack - 0 # rgbBlanchedAlmond - 13495295 # rgbBlue - 16711680 # rgbBlueViolet - 14822282 # rgbBrown - 2763429 # rgbBurlyWood - 8894686 # rgbCadetBlue - 10526303 # rgbChartreuse - 65407 # rgbCoral - 5275647 # rgbCornflowerBlue - 15570276 # rgbCornsilk - 14481663 # rgbCrimson - 3937500 # rgbDarkBlue - 9109504 # rgbDarkCyan - 9145088 # rgbDarkGoldenrod - 755384 # rgbDarkGray - 11119017 # rgbDarkGreen - 25600 # rgbDarkGrey - 11119017 # rgbDarkKhaki - 7059389 # rgbDarkMagenta - 9109643 # rgbDarkOliveGreen - 3107669 # rgbDarkOrange - 36095 # rgbDarkOrchid - 13382297 # rgbDarkRed - 139 # rgbDarkSalmon - 8034025 # rgbDarkSeaGreen - 9419919 # rgbDarkSlateBlue - 9125192 # rgbDarkSlateGray - 5197615 # rgbDarkSlateGrey - 5197615 # rgbDarkTurquoise - 13749760 # rgbDarkViolet - 13828244 # rgbDeepPink - 9639167 # rgbDeepSkyBlue - 16760576 # rgbDimGray - 6908265 # rgbDimGrey - 6908265 # rgbDodgerBlue - 16748574 # rgbFireBrick - 2237106 # rgbFloralWhite - 15792895 # rgbForestGreen - 2263842 # rgbFuchsia - 16711935 # rgbGainsboro - 14474460 # rgbGhostWhite - 16775416 # rgbGold - 55295 # rgbGoldenrod - 2139610 # rgbGray - 8421504 # rgbGreen - 32768 # rgbGreenYellow - 3145645 # rgbGrey - 8421504 # rgbHoneydew - 15794160 # rgbHotPink - 11823615 # rgbIndianRed - 6053069 # rgbIndigo - 8519755 # rgbIvory - 15794175 # rgbKhaki - 9234160 # rgbLavender - 16443110 # rgbLavenderBlush - 16118015 # rgbLawnGreen - 64636 # rgbLemonChiffon - 13499135 # rgbLightBlue - 15128749 # rgbLightCoral - 8421616 # rgbLightCyan - 9145088 # rgbLightGoldenrodYellow - 13826810 # rgbLightGray - 13882323 # rgbLightGreen - 9498256 # rgbLightGrey - 13882323 # rgbLightPink - 12695295 # rgbLightSalmon - 8036607 # rgbLightSeaGreen - 11186720 # rgbLightSkyBlue - 16436871 # rgbLightSlateGray - 10061943 # rgbLightSlateGrey - 10061943 # rgbLightSteelBlue - 14599344 # rgbLightYellow - 14745599 # rgbLime - 65280 # rgbLimeGreen - 3329330 # rgbLinen - 15134970 # rgbMaroon - 128 # rgbMediumAquamarine - 11206502 # rgbMediumBlue - 13434880 # rgbMediumOrchid - 13850042 # rgbMediumPurple - 14381203 # rgbMediumSeaGreen - 7451452 # rgbMediumSlateBlue - 15624315 # rgbMediumSpringGreen - 10156544 # rgbMediumTurquoise - 13422920 # rgbMediumVioletRed - 8721863 # rgbMidnightBlue - 7346457 # rgbMintCream - 16449525 # rgbMistyRose - 14804223 # rgbMoccasin - 11920639 # rgbNavajoWhite - 11394815 # rgbNavy - 8388608 # rgbNavyBlue - 8388608 # rgbOldLace - 15136253 # rgbOlive - 32896 # rgbOliveDrab - 2330219 # rgbOrange - 42495 # rgbOrangeRed - 17919 # rgbOrchid - 14053594 # rgbPaleGoldenrod - 7071982 # rgbPaleGreen - 10025880 # rgbPaleTurquoise - 15658671 # rgbPaleVioletRed - 9662683 # rgbPapayaWhip - 14020607 # rgbPeachPuff - 12180223 # rgbPeru - 4163021 # rgbPink - 13353215 # rgbPlum - 14524637 # rgbPowderBlue - 15130800 # rgbPurple - 8388736 # rgbRed - 255 # rgbRosyBrown - 9408444 # rgbRoyalBlue - 14772545 # rgbSalmon - 7504122 # rgbSandyBrown - 6333684 # rgbSeaGreen - 5737262 # rgbSeashell - 15660543 # rgbSienna - 2970272 # rgbSilver - 12632256 # rgbSkyBlue - 15453831 # rgbSlateBlue - 13458026 # rgbSlateGray - 9470064 # rgbSlateGrey - 9470064 # rgbSnow - 16448255 # rgbSpringGreen - 8388352 # rgbSteelBlue - 11829830 # rgbTan - 9221330 # rgbTeal - 8421376 # rgbThistle - 14204888 # rgbTomato - 4678655 # rgbTurquoise - 13688896 # rgbViolet - 15631086 # rgbWheat - 11788021 # rgbWhite - 16777215 # rgbWhiteSmoke - 16119285 # rgbYellow - 65535 # rgbYellowGreen - 3329434 return { rgbAliceBlue 16775408 rgbAntiqueWhite 14150650 rgbAqua 16776960 rgbAquamarine 13959039 rgbAzure 16777200 rgbBeige 14480885 rgbBisque 12903679 rgbBlack 0 rgbBlanchedAlmond 13495295 rgbBlue 16711680 rgbBlueViolet 14822282 rgbBrown 2763429 rgbBurlyWood 8894686 rgbCadetBlue 10526303 rgbChartreuse 65407 rgbCoral 5275647 rgbCornflowerBlue 15570276 rgbCornsilk 14481663 rgbCrimson 3937500 rgbDarkBlue 9109504 rgbDarkCyan 9145088 rgbDarkGoldenrod 755384 rgbDarkGray 11119017 rgbDarkGreen 25600 rgbDarkGrey 11119017 rgbDarkKhaki 7059389 rgbDarkMagenta 9109643 rgbDarkOliveGreen 3107669 rgbDarkOrange 36095 rgbDarkOrchid 13382297 rgbDarkRed 139 rgbDarkSalmon 8034025 rgbDarkSeaGreen 9419919 rgbDarkSlateBlue 9125192 rgbDarkSlateGray 5197615 rgbDarkSlateGrey 5197615 rgbDarkTurquoise 13749760 rgbDarkViolet 13828244 rgbDeepPink 9639167 rgbDeepSkyBlue 16760576 rgbDimGray 6908265 rgbDimGrey 6908265 rgbDodgerBlue 16748574 rgbFireBrick 2237106 rgbFloralWhite 15792895 rgbForestGreen 2263842 rgbFuchsia 16711935 rgbGainsboro 14474460 rgbGhostWhite 16775416 rgbGold 55295 rgbGoldenrod 2139610 rgbGray 8421504 rgbGreen 32768 rgbGreenYellow 3145645 rgbGrey 8421504 rgbHoneydew 15794160 rgbHotPink 11823615 rgbIndianRed 6053069 rgbIndigo 8519755 rgbIvory 15794175 rgbKhaki 9234160 rgbLavender 16443110 rgbLavenderBlush 16118015 rgbLawnGreen 64636 rgbLemonChiffon 13499135 rgbLightBlue 15128749 rgbLightCoral 8421616 rgbLightCyan 9145088 rgbLightGoldenrodYellow 13826810 rgbLightGray 13882323 rgbLightGreen 9498256 rgbLightGrey 13882323 rgbLightPink 12695295 rgbLightSalmon 8036607 rgbLightSeaGreen 11186720 rgbLightSkyBlue 16436871 rgbLightSlateGray 10061943 rgbLightSlateGrey 10061943 rgbLightSteelBlue 14599344 rgbLightYellow 14745599 rgbLime 65280 rgbLimeGreen 3329330 rgbLinen 15134970 rgbMaroon 128 rgbMediumAquamarine 11206502 rgbMediumBlue 13434880 rgbMediumOrchid 13850042 rgbMediumPurple 14381203 rgbMediumSeaGreen 7451452 rgbMediumSlateBlue 15624315 rgbMediumSpringGreen 10156544 rgbMediumTurquoise 13422920 rgbMediumVioletRed 8721863 rgbMidnightBlue 7346457 rgbMintCream 16449525 rgbMistyRose 14804223 rgbMoccasin 11920639 rgbNavajoWhite 11394815 rgbNavy 8388608 rgbNavyBlue 8388608 rgbOldLace 15136253 rgbOlive 32896 rgbOliveDrab 2330219 rgbOrange 42495 rgbOrangeRed 17919 rgbOrchid 14053594 rgbPaleGoldenrod 7071982 rgbPaleGreen 10025880 rgbPaleTurquoise 15658671 rgbPaleVioletRed 9662683 rgbPapayaWhip 14020607 rgbPeachPuff 12180223 rgbPeru 4163021 rgbPink 13353215 rgbPlum 14524637 rgbPowderBlue 15130800 rgbPurple 8388736 rgbRed 255 rgbRosyBrown 9408444 rgbRoyalBlue 14772545 rgbSalmon 7504122 rgbSandyBrown 6333684 rgbSeaGreen 5737262 rgbSeashell 15660543 rgbSienna 2970272 rgbSilver 12632256 rgbSkyBlue 15453831 rgbSlateBlue 13458026 rgbSlateGray 9470064 rgbSlateGrey 9470064 rgbSnow 16448255 rgbSpringGreen 8388352 rgbSteelBlue 11829830 rgbTan 9221330 rgbTeal 8421376 rgbThistle 14204888 rgbTomato 4678655 rgbTurquoise 13688896 rgbViolet 15631086 rgbWheat 11788021 rgbWhite 16777215 rgbWhiteSmoke 16119285 rgbYellow 65535 rgbYellowGreen 3329434 } }
XlRobustConnect [::Excel::Enum]Top, Main, Index
XlRobustConnect
Parameters
xlAlways | 1 |
xlAsRequired | 0 |
xlNever | 2 |
proc ::Excel::Enum::XlRobustConnect {} { # xlAlways - 1 # xlAsRequired - 0 # xlNever - 2 return { xlAlways 1 xlAsRequired 0 xlNever 2 } }
XlRoutingSlipDelivery [::Excel::Enum]Top, Main, Index
XlRoutingSlipDelivery
Parameters
xlAllAtOnce | 2 |
xlOneAfterAnother | 1 |
proc ::Excel::Enum::XlRoutingSlipDelivery {} { # xlAllAtOnce - 2 # xlOneAfterAnother - 1 return { xlAllAtOnce 2 xlOneAfterAnother 1 } }
XlRoutingSlipStatus [::Excel::Enum]Top, Main, Index
XlRoutingSlipStatus
Parameters
xlNotYetRouted | 0 |
xlRoutingComplete | 2 |
xlRoutingInProgress | 1 |
proc ::Excel::Enum::XlRoutingSlipStatus {} { # xlNotYetRouted - 0 # xlRoutingComplete - 2 # xlRoutingInProgress - 1 return { xlNotYetRouted 0 xlRoutingComplete 2 xlRoutingInProgress 1 } }
XlRowCol [::Excel::Enum]Top, Main, Index
XlRowCol
Parameters
xlColumns | 2 |
xlRows | 1 |
proc ::Excel::Enum::XlRowCol {} { # xlColumns - 2 # xlRows - 1 return { xlColumns 2 xlRows 1 } }
XlRunAutoMacro [::Excel::Enum]Top, Main, Index
XlRunAutoMacro
Parameters
xlAutoActivate | 3 |
xlAutoClose | 2 |
xlAutoDeactivate | 4 |
xlAutoOpen | 1 |
proc ::Excel::Enum::XlRunAutoMacro {} { # xlAutoActivate - 3 # xlAutoClose - 2 # xlAutoDeactivate - 4 # xlAutoOpen - 1 return { xlAutoActivate 3 xlAutoClose 2 xlAutoDeactivate 4 xlAutoOpen 1 } }
XlSaveAction [::Excel::Enum]Top, Main, Index
XlSaveAction
Parameters
xlDoNotSaveChanges | 2 |
xlSaveChanges | 1 |
proc ::Excel::Enum::XlSaveAction {} { # xlDoNotSaveChanges - 2 # xlSaveChanges - 1 return { xlDoNotSaveChanges 2 xlSaveChanges 1 } }
XlSaveAsAccessMode [::Excel::Enum]Top, Main, Index
XlSaveAsAccessMode
Parameters
xlExclusive | 3 |
xlNoChange | 1 |
xlShared | 2 |
proc ::Excel::Enum::XlSaveAsAccessMode {} { # xlExclusive - 3 # xlNoChange - 1 # xlShared - 2 return { xlExclusive 3 xlNoChange 1 xlShared 2 } }
XlSaveConflictResolution [::Excel::Enum]Top, Main, Index
XlSaveConflictResolution
Parameters
xlLocalSessionChanges | 2 |
xlOtherSessionChanges | 3 |
xlUserResolution | 1 |
proc ::Excel::Enum::XlSaveConflictResolution {} { # xlLocalSessionChanges - 2 # xlOtherSessionChanges - 3 # xlUserResolution - 1 return { xlLocalSessionChanges 2 xlOtherSessionChanges 3 xlUserResolution 1 } }
XlScaleType [::Excel::Enum]Top, Main, Index
XlScaleType
Parameters
xlScaleLinear | -4132 |
xlScaleLogarithmic | -4133 |
proc ::Excel::Enum::XlScaleType {} { # xlScaleLinear - -4132 # xlScaleLogarithmic - -4133 return { xlScaleLinear -4132 xlScaleLogarithmic -4133 } }
XlSearchDirection [::Excel::Enum]Top, Main, Index
XlSearchDirection
Parameters
xlNext | 1 |
xlPrevious | 2 |
proc ::Excel::Enum::XlSearchDirection {} { # xlNext - 1 # xlPrevious - 2 return { xlNext 1 xlPrevious 2 } }
XlSearchOrder [::Excel::Enum]Top, Main, Index
XlSearchOrder
Parameters
xlByColumns | 2 |
xlByRows | 1 |
proc ::Excel::Enum::XlSearchOrder {} { # xlByColumns - 2 # xlByRows - 1 return { xlByColumns 2 xlByRows 1 } }
XlSearchWithin [::Excel::Enum]Top, Main, Index
XlSearchWithin
Parameters
xlWithinSheet | 1 |
xlWithinWorkbook | 2 |
proc ::Excel::Enum::XlSearchWithin {} { # xlWithinSheet - 1 # xlWithinWorkbook - 2 return { xlWithinSheet 1 xlWithinWorkbook 2 } }
XlSeriesColorGradientStyle [::Excel::Enum]Top, Main, Index
XlSeriesColorGradientStyle
Parameters
xlSeriesColorGradientStyleDiverging | 1 |
xlSeriesColorGradientStyleSequential | 0 |
proc ::Excel::Enum::XlSeriesColorGradientStyle {} { # xlSeriesColorGradientStyleDiverging - 1 # xlSeriesColorGradientStyleSequential - 0 return { xlSeriesColorGradientStyleDiverging 1 xlSeriesColorGradientStyleSequential 0 } }
XlSeriesNameLevel [::Excel::Enum]Top, Main, Index
XlSeriesNameLevel
Parameters
xlSeriesNameLevelAll | -1 |
xlSeriesNameLevelCustom | -2 |
xlSeriesNameLevelNone | -3 |
proc ::Excel::Enum::XlSeriesNameLevel {} { # xlSeriesNameLevelAll - -1 # xlSeriesNameLevelCustom - -2 # xlSeriesNameLevelNone - -3 return { xlSeriesNameLevelAll -1 xlSeriesNameLevelCustom -2 xlSeriesNameLevelNone -3 } }
XlSheetType [::Excel::Enum]Top, Main, Index
XlSheetType
Parameters
xlChart | -4109 |
xlDialogSheet | -4116 |
xlExcel4IntlMacroSheet | 4 |
xlExcel4MacroSheet | 3 |
xlWorksheet | -4167 |
proc ::Excel::Enum::XlSheetType {} { # xlChart - -4109 # xlDialogSheet - -4116 # xlExcel4IntlMacroSheet - 4 # xlExcel4MacroSheet - 3 # xlWorksheet - -4167 return { xlChart -4109 xlDialogSheet -4116 xlExcel4IntlMacroSheet 4 xlExcel4MacroSheet 3 xlWorksheet -4167 } }
XlSheetVisibility [::Excel::Enum]Top, Main, Index
XlSheetVisibility
Parameters
xlSheetHidden | 0 |
xlSheetVeryHidden | 2 |
xlSheetVisible | -1 |
proc ::Excel::Enum::XlSheetVisibility {} { # xlSheetHidden - 0 # xlSheetVeryHidden - 2 # xlSheetVisible - -1 return { xlSheetHidden 0 xlSheetVeryHidden 2 xlSheetVisible -1 } }
XlSizeRepresents [::Excel::Enum]Top, Main, Index
XlSizeRepresents
Parameters
xlSizeIsArea | 1 |
xlSizeIsWidth | 2 |
proc ::Excel::Enum::XlSizeRepresents {} { # xlSizeIsArea - 1 # xlSizeIsWidth - 2 return { xlSizeIsArea 1 xlSizeIsWidth 2 } }
XlSlicerCacheType [::Excel::Enum]Top, Main, Index
XlSlicerCacheType
Parameters
xlSlicer | 1 |
xlTimeline | 2 |
proc ::Excel::Enum::XlSlicerCacheType {} { # xlSlicer - 1 # xlTimeline - 2 return { xlSlicer 1 xlTimeline 2 } }
XlSlicerCrossFilterType [::Excel::Enum]Top, Main, Index
XlSlicerCrossFilterType
Parameters
xlSlicerCrossFilterHideButtonsWithNoData | 4 |
xlSlicerCrossFilterShowItemsWithDataAtTop | 2 |
xlSlicerCrossFilterShowItemsWithNoData | 3 |
xlSlicerNoCrossFilter | 1 |
proc ::Excel::Enum::XlSlicerCrossFilterType {} { # xlSlicerCrossFilterHideButtonsWithNoData - 4 # xlSlicerCrossFilterShowItemsWithDataAtTop - 2 # xlSlicerCrossFilterShowItemsWithNoData - 3 # xlSlicerNoCrossFilter - 1 return { xlSlicerCrossFilterHideButtonsWithNoData 4 xlSlicerCrossFilterShowItemsWithDataAtTop 2 xlSlicerCrossFilterShowItemsWithNoData 3 xlSlicerNoCrossFilter 1 } }
XlSlicerSort [::Excel::Enum]Top, Main, Index
XlSlicerSort
Parameters
xlSlicerSortAscending | 2 |
xlSlicerSortDataSourceOrder | 1 |
xlSlicerSortDescending | 3 |
proc ::Excel::Enum::XlSlicerSort {} { # xlSlicerSortAscending - 2 # xlSlicerSortDataSourceOrder - 1 # xlSlicerSortDescending - 3 return { xlSlicerSortAscending 2 xlSlicerSortDataSourceOrder 1 xlSlicerSortDescending 3 } }
XlSmartTagControlType [::Excel::Enum]Top, Main, Index
XlSmartTagControlType
Parameters
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 |
proc ::Excel::Enum::XlSmartTagControlType {} { # 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 return { 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 } }
XlSmartTagDisplayMode [::Excel::Enum]Top, Main, Index
XlSmartTagDisplayMode
Parameters
xlButtonOnly | 2 |
xlDisplayNone | 1 |
xlIndicatorAndButton | 0 |
proc ::Excel::Enum::XlSmartTagDisplayMode {} { # xlButtonOnly - 2 # xlDisplayNone - 1 # xlIndicatorAndButton - 0 return { xlButtonOnly 2 xlDisplayNone 1 xlIndicatorAndButton 0 } }
XlSortDataOption [::Excel::Enum]Top, Main, Index
XlSortDataOption
Parameters
xlSortNormal | 0 |
xlSortTextAsNumbers | 1 |
proc ::Excel::Enum::XlSortDataOption {} { # xlSortNormal - 0 # xlSortTextAsNumbers - 1 return { xlSortNormal 0 xlSortTextAsNumbers 1 } }
XlSortMethod [::Excel::Enum]Top, Main, Index
XlSortMethod
Parameters
xlPinYin | 1 |
xlStroke | 2 |
proc ::Excel::Enum::XlSortMethod {} { # xlPinYin - 1 # xlStroke - 2 return { xlPinYin 1 xlStroke 2 } }
XlSortMethodOld [::Excel::Enum]Top, Main, Index
XlSortMethodOld
Parameters
xlCodePage | 2 |
xlSyllabary | 1 |
proc ::Excel::Enum::XlSortMethodOld {} { # xlCodePage - 2 # xlSyllabary - 1 return { xlCodePage 2 xlSyllabary 1 } }
XlSortOn [::Excel::Enum]Top, Main, Index
XlSortOn
Parameters
xlSortOnCellColor | 1 |
xlSortOnFontColor | 2 |
xlSortOnIcon | 3 |
xlSortOnValues | 0 |
proc ::Excel::Enum::XlSortOn {} { # xlSortOnCellColor - 1 # xlSortOnFontColor - 2 # xlSortOnIcon - 3 # xlSortOnValues - 0 return { xlSortOnCellColor 1 xlSortOnFontColor 2 xlSortOnIcon 3 xlSortOnValues 0 } }
XlSortOrder [::Excel::Enum]Top, Main, Index
XlSortOrder
Parameters
xlAscending | 1 |
xlDescending | 2 |
proc ::Excel::Enum::XlSortOrder {} { # xlAscending - 1 # xlDescending - 2 return { xlAscending 1 xlDescending 2 } }
XlSortOrientation [::Excel::Enum]Top, Main, Index
XlSortOrientation
Parameters
xlSortColumns | 1 |
xlSortRows | 2 |
proc ::Excel::Enum::XlSortOrientation {} { # xlSortColumns - 1 # xlSortRows - 2 return { xlSortColumns 1 xlSortRows 2 } }
XlSortType [::Excel::Enum]Top, Main, Index
XlSortType
Parameters
xlSortLabels | 2 |
xlSortValues | 1 |
proc ::Excel::Enum::XlSortType {} { # xlSortLabels - 2 # xlSortValues - 1 return { xlSortLabels 2 xlSortValues 1 } }
XlSourceType [::Excel::Enum]Top, Main, Index
XlSourceType
Parameters
xlSourceAutoFilter | 3 |
xlSourceChart | 5 |
xlSourcePivotTable | 6 |
xlSourcePrintArea | 2 |
xlSourceQuery | 7 |
xlSourceRange | 4 |
xlSourceSheet | 1 |
xlSourceWorkbook | 0 |
proc ::Excel::Enum::XlSourceType {} { # xlSourceAutoFilter - 3 # xlSourceChart - 5 # xlSourcePivotTable - 6 # xlSourcePrintArea - 2 # xlSourceQuery - 7 # xlSourceRange - 4 # xlSourceSheet - 1 # xlSourceWorkbook - 0 return { xlSourceAutoFilter 3 xlSourceChart 5 xlSourcePivotTable 6 xlSourcePrintArea 2 xlSourceQuery 7 xlSourceRange 4 xlSourceSheet 1 xlSourceWorkbook 0 } }
XlSpanishModes [::Excel::Enum]Top, Main, Index
XlSpanishModes
Parameters
xlSpanishTuteoAndVoseo | 1 |
xlSpanishTuteoOnly | 0 |
xlSpanishVoseoOnly | 2 |
proc ::Excel::Enum::XlSpanishModes {} { # xlSpanishTuteoAndVoseo - 1 # xlSpanishTuteoOnly - 0 # xlSpanishVoseoOnly - 2 return { xlSpanishTuteoAndVoseo 1 xlSpanishTuteoOnly 0 xlSpanishVoseoOnly 2 } }
XlSparklineRowCol [::Excel::Enum]Top, Main, Index
XlSparklineRowCol
Parameters
xlSparklineColumnsSquare | 2 |
xlSparklineNonSquare | 0 |
xlSparklineRowsSquare | 1 |
proc ::Excel::Enum::XlSparklineRowCol {} { # xlSparklineColumnsSquare - 2 # xlSparklineNonSquare - 0 # xlSparklineRowsSquare - 1 return { xlSparklineColumnsSquare 2 xlSparklineNonSquare 0 xlSparklineRowsSquare 1 } }
XlSparkScale [::Excel::Enum]Top, Main, Index
XlSparkScale
Parameters
xlSparkScaleCustom | 3 |
xlSparkScaleGroup | 1 |
xlSparkScaleSingle | 2 |
proc ::Excel::Enum::XlSparkScale {} { # xlSparkScaleCustom - 3 # xlSparkScaleGroup - 1 # xlSparkScaleSingle - 2 return { xlSparkScaleCustom 3 xlSparkScaleGroup 1 xlSparkScaleSingle 2 } }
XlSparkType [::Excel::Enum]Top, Main, Index
XlSparkType
Parameters
xlSparkColumn | 2 |
xlSparkColumnStacked100 | 3 |
xlSparkLine | 1 |
proc ::Excel::Enum::XlSparkType {} { # xlSparkColumn - 2 # xlSparkColumnStacked100 - 3 # xlSparkLine - 1 return { xlSparkColumn 2 xlSparkColumnStacked100 3 xlSparkLine 1 } }
XlSpeakDirection [::Excel::Enum]Top, Main, Index
XlSpeakDirection
Parameters
xlSpeakByColumns | 1 |
xlSpeakByRows | 0 |
proc ::Excel::Enum::XlSpeakDirection {} { # xlSpeakByColumns - 1 # xlSpeakByRows - 0 return { xlSpeakByColumns 1 xlSpeakByRows 0 } }
XlSpecialCellsValue [::Excel::Enum]Top, Main, Index
XlSpecialCellsValue
Parameters
xlErrors | 16 |
xlLogical | 4 |
xlNumbers | 1 |
xlTextValues | 2 |
proc ::Excel::Enum::XlSpecialCellsValue {} { # xlErrors - 16 # xlLogical - 4 # xlNumbers - 1 # xlTextValues - 2 return { xlErrors 16 xlLogical 4 xlNumbers 1 xlTextValues 2 } }
XlStdColorScale [::Excel::Enum]Top, Main, Index
XlStdColorScale
Parameters
xlColorScaleBlackWhite | 3 |
xlColorScaleGYR | 2 |
xlColorScaleRYG | 1 |
xlColorScaleWhiteBlack | 4 |
proc ::Excel::Enum::XlStdColorScale {} { # xlColorScaleBlackWhite - 3 # xlColorScaleGYR - 2 # xlColorScaleRYG - 1 # xlColorScaleWhiteBlack - 4 return { xlColorScaleBlackWhite 3 xlColorScaleGYR 2 xlColorScaleRYG 1 xlColorScaleWhiteBlack 4 } }
XlSubscribeToFormat [::Excel::Enum]Top, Main, Index
XlSubscribeToFormat
Parameters
xlSubscribeToPicture | -4147 |
xlSubscribeToText | -4158 |
proc ::Excel::Enum::XlSubscribeToFormat {} { # xlSubscribeToPicture - -4147 # xlSubscribeToText - -4158 return { xlSubscribeToPicture -4147 xlSubscribeToText -4158 } }
XlSubtototalLocationType [::Excel::Enum]Top, Main, Index
XlSubtototalLocationType
Parameters
xlAtBottom | 2 |
xlAtTop | 1 |
proc ::Excel::Enum::XlSubtototalLocationType {} { # xlAtBottom - 2 # xlAtTop - 1 return { xlAtBottom 2 xlAtTop 1 } }
XlSummaryColumn [::Excel::Enum]Top, Main, Index
XlSummaryColumn
Parameters
xlSummaryOnLeft | -4131 |
xlSummaryOnRight | -4152 |
proc ::Excel::Enum::XlSummaryColumn {} { # xlSummaryOnLeft - -4131 # xlSummaryOnRight - -4152 return { xlSummaryOnLeft -4131 xlSummaryOnRight -4152 } }
XlSummaryReportType [::Excel::Enum]Top, Main, Index
XlSummaryReportType
Parameters
xlStandardSummary | 1 |
xlSummaryPivotTable | -4148 |
proc ::Excel::Enum::XlSummaryReportType {} { # xlStandardSummary - 1 # xlSummaryPivotTable - -4148 return { xlStandardSummary 1 xlSummaryPivotTable -4148 } }
XlSummaryRow [::Excel::Enum]Top, Main, Index
XlSummaryRow
Parameters
xlSummaryAbove | 0 |
xlSummaryBelow | 1 |
proc ::Excel::Enum::XlSummaryRow {} { # xlSummaryAbove - 0 # xlSummaryBelow - 1 return { xlSummaryAbove 0 xlSummaryBelow 1 } }
XlTableStyleElementType [::Excel::Enum]Top, Main, Index
XlTableStyleElementType
Parameters
xlBlankRow | 19 |
xlColumnStripe1 | 7 |
xlColumnStripe2 | 8 |
xlColumnSubheading1 | 20 |
xlColumnSubheading2 | 21 |
xlColumnSubheading3 | 22 |
xlFirstColumn | 3 |
xlFirstHeaderCell | 9 |
xlFirstTotalCell | 11 |
xlGrandTotalColumn | 4 |
xlGrandTotalRow | 2 |
xlHeaderRow | 1 |
xlLastColumn | 4 |
xlLastHeaderCell | 10 |
xlLastTotalCell | 12 |
xlPageFieldLabels | 26 |
xlPageFieldValues | 27 |
xlRowStripe1 | 5 |
xlRowStripe2 | 6 |
xlRowSubheading1 | 23 |
xlRowSubheading2 | 24 |
xlRowSubheading3 | 25 |
xlSlicerHoveredSelectedItemWithData | 33 |
xlSlicerHoveredSelectedItemWithNoData | 35 |
xlSlicerHoveredUnselectedItemWithData | 32 |
xlSlicerHoveredUnselectedItemWithNoData | 34 |
xlSlicerSelectedItemWithData | 30 |
xlSlicerSelectedItemWithNoData | 31 |
xlSlicerUnselectedItemWithData | 28 |
xlSlicerUnselectedItemWithNoData | 29 |
xlSubtotalColumn1 | 13 |
xlSubtotalColumn2 | 14 |
xlSubtotalColumn3 | 15 |
xlSubtotalRow1 | 16 |
xlSubtotalRow2 | 17 |
xlSubtotalRow3 | 18 |
xlTimelinePeriodLabels1 | 38 |
xlTimelinePeriodLabels2 | 39 |
xlTimelineSelectedTimeBlock | 40 |
xlTimelineSelectedTimeBlockSpace | 42 |
xlTimelineSelectionLabel | 36 |
xlTimelineTimeLevel | 37 |
xlTimelineUnselectedTimeBlock | 41 |
xlTotalRow | 2 |
xlWholeTable | 0 |
proc ::Excel::Enum::XlTableStyleElementType {} { # xlBlankRow - 19 # xlColumnStripe1 - 7 # xlColumnStripe2 - 8 # xlColumnSubheading1 - 20 # xlColumnSubheading2 - 21 # xlColumnSubheading3 - 22 # xlFirstColumn - 3 # xlFirstHeaderCell - 9 # xlFirstTotalCell - 11 # xlGrandTotalColumn - 4 # xlGrandTotalRow - 2 # xlHeaderRow - 1 # xlLastColumn - 4 # xlLastHeaderCell - 10 # xlLastTotalCell - 12 # xlPageFieldLabels - 26 # xlPageFieldValues - 27 # xlRowStripe1 - 5 # xlRowStripe2 - 6 # xlRowSubheading1 - 23 # xlRowSubheading2 - 24 # xlRowSubheading3 - 25 # xlSlicerHoveredSelectedItemWithData - 33 # xlSlicerHoveredSelectedItemWithNoData - 35 # xlSlicerHoveredUnselectedItemWithData - 32 # xlSlicerHoveredUnselectedItemWithNoData - 34 # xlSlicerSelectedItemWithData - 30 # xlSlicerSelectedItemWithNoData - 31 # xlSlicerUnselectedItemWithData - 28 # xlSlicerUnselectedItemWithNoData - 29 # xlSubtotalColumn1 - 13 # xlSubtotalColumn2 - 14 # xlSubtotalColumn3 - 15 # xlSubtotalRow1 - 16 # xlSubtotalRow2 - 17 # xlSubtotalRow3 - 18 # xlTimelinePeriodLabels1 - 38 # xlTimelinePeriodLabels2 - 39 # xlTimelineSelectedTimeBlock - 40 # xlTimelineSelectedTimeBlockSpace - 42 # xlTimelineSelectionLabel - 36 # xlTimelineTimeLevel - 37 # xlTimelineUnselectedTimeBlock - 41 # xlTotalRow - 2 # xlWholeTable - 0 return { xlBlankRow 19 xlColumnStripe1 7 xlColumnStripe2 8 xlColumnSubheading1 20 xlColumnSubheading2 21 xlColumnSubheading3 22 xlFirstColumn 3 xlFirstHeaderCell 9 xlFirstTotalCell 11 xlGrandTotalColumn 4 xlGrandTotalRow 2 xlHeaderRow 1 xlLastColumn 4 xlLastHeaderCell 10 xlLastTotalCell 12 xlPageFieldLabels 26 xlPageFieldValues 27 xlRowStripe1 5 xlRowStripe2 6 xlRowSubheading1 23 xlRowSubheading2 24 xlRowSubheading3 25 xlSlicerHoveredSelectedItemWithData 33 xlSlicerHoveredSelectedItemWithNoData 35 xlSlicerHoveredUnselectedItemWithData 32 xlSlicerHoveredUnselectedItemWithNoData 34 xlSlicerSelectedItemWithData 30 xlSlicerSelectedItemWithNoData 31 xlSlicerUnselectedItemWithData 28 xlSlicerUnselectedItemWithNoData 29 xlSubtotalColumn1 13 xlSubtotalColumn2 14 xlSubtotalColumn3 15 xlSubtotalRow1 16 xlSubtotalRow2 17 xlSubtotalRow3 18 xlTimelinePeriodLabels1 38 xlTimelinePeriodLabels2 39 xlTimelineSelectedTimeBlock 40 xlTimelineSelectedTimeBlockSpace 42 xlTimelineSelectionLabel 36 xlTimelineTimeLevel 37 xlTimelineUnselectedTimeBlock 41 xlTotalRow 2 xlWholeTable 0 } }
XlTabPosition [::Excel::Enum]Top, Main, Index
XlTabPosition
Parameters
xlTabPositionFirst | 0 |
xlTabPositionLast | 1 |
proc ::Excel::Enum::XlTabPosition {} { # xlTabPositionFirst - 0 # xlTabPositionLast - 1 return { xlTabPositionFirst 0 xlTabPositionLast 1 } }
XlTextParsingType [::Excel::Enum]Top, Main, Index
XlTextParsingType
Parameters
xlDelimited | 1 |
xlFixedWidth | 2 |
proc ::Excel::Enum::XlTextParsingType {} { # xlDelimited - 1 # xlFixedWidth - 2 return { xlDelimited 1 xlFixedWidth 2 } }
XlTextQualifier [::Excel::Enum]Top, Main, Index
XlTextQualifier
Parameters
xlTextQualifierDoubleQuote | 1 |
xlTextQualifierNone | -4142 |
xlTextQualifierSingleQuote | 2 |
proc ::Excel::Enum::XlTextQualifier {} { # xlTextQualifierDoubleQuote - 1 # xlTextQualifierNone - -4142 # xlTextQualifierSingleQuote - 2 return { xlTextQualifierDoubleQuote 1 xlTextQualifierNone -4142 xlTextQualifierSingleQuote 2 } }
XlTextVisualLayoutType [::Excel::Enum]Top, Main, Index
XlTextVisualLayoutType
Parameters
xlTextVisualLTR | 1 |
xlTextVisualRTL | 2 |
proc ::Excel::Enum::XlTextVisualLayoutType {} { # xlTextVisualLTR - 1 # xlTextVisualRTL - 2 return { xlTextVisualLTR 1 xlTextVisualRTL 2 } }
XlThemeColor [::Excel::Enum]Top, Main, Index
XlThemeColor
Parameters
xlThemeColorAccent1 | 5 |
xlThemeColorAccent2 | 6 |
xlThemeColorAccent3 | 7 |
xlThemeColorAccent4 | 8 |
xlThemeColorAccent5 | 9 |
xlThemeColorAccent6 | 10 |
xlThemeColorDark1 | 1 |
xlThemeColorDark2 | 3 |
xlThemeColorFollowedHyperlink | 12 |
xlThemeColorHyperlink | 11 |
xlThemeColorLight1 | 2 |
xlThemeColorLight2 | 4 |
proc ::Excel::Enum::XlThemeColor {} { # xlThemeColorAccent1 - 5 # xlThemeColorAccent2 - 6 # xlThemeColorAccent3 - 7 # xlThemeColorAccent4 - 8 # xlThemeColorAccent5 - 9 # xlThemeColorAccent6 - 10 # xlThemeColorDark1 - 1 # xlThemeColorDark2 - 3 # xlThemeColorFollowedHyperlink - 12 # xlThemeColorHyperlink - 11 # xlThemeColorLight1 - 2 # xlThemeColorLight2 - 4 return { xlThemeColorAccent1 5 xlThemeColorAccent2 6 xlThemeColorAccent3 7 xlThemeColorAccent4 8 xlThemeColorAccent5 9 xlThemeColorAccent6 10 xlThemeColorDark1 1 xlThemeColorDark2 3 xlThemeColorFollowedHyperlink 12 xlThemeColorHyperlink 11 xlThemeColorLight1 2 xlThemeColorLight2 4 } }
XlThemeFont [::Excel::Enum]Top, Main, Index
XlThemeFont
Parameters
xlThemeFontMajor | 1 |
xlThemeFontMinor | 2 |
xlThemeFontNone | 0 |
proc ::Excel::Enum::XlThemeFont {} { # xlThemeFontMajor - 1 # xlThemeFontMinor - 2 # xlThemeFontNone - 0 return { xlThemeFontMajor 1 xlThemeFontMinor 2 xlThemeFontNone 0 } }
XlThreadMode [::Excel::Enum]Top, Main, Index
XlThreadMode
Parameters
xlThreadModeAutomatic | 0 |
xlThreadModeManual | 1 |
proc ::Excel::Enum::XlThreadMode {} { # xlThreadModeAutomatic - 0 # xlThreadModeManual - 1 return { xlThreadModeAutomatic 0 xlThreadModeManual 1 } }
XlTickLabelOrientation [::Excel::Enum]Top, Main, Index
XlTickLabelOrientation
Parameters
xlTickLabelOrientationAutomatic | -4105 |
xlTickLabelOrientationDownward | -4170 |
xlTickLabelOrientationHorizontal | -4128 |
xlTickLabelOrientationUpward | -4171 |
xlTickLabelOrientationVertical | -4166 |
proc ::Excel::Enum::XlTickLabelOrientation {} { # xlTickLabelOrientationAutomatic - -4105 # xlTickLabelOrientationDownward - -4170 # xlTickLabelOrientationHorizontal - -4128 # xlTickLabelOrientationUpward - -4171 # xlTickLabelOrientationVertical - -4166 return { xlTickLabelOrientationAutomatic -4105 xlTickLabelOrientationDownward -4170 xlTickLabelOrientationHorizontal -4128 xlTickLabelOrientationUpward -4171 xlTickLabelOrientationVertical -4166 } }
XlTickLabelPosition [::Excel::Enum]Top, Main, Index
XlTickLabelPosition
Parameters
xlTickLabelPositionHigh | -4127 |
xlTickLabelPositionLow | -4134 |
xlTickLabelPositionNextToAxis | 4 |
xlTickLabelPositionNone | -4142 |
proc ::Excel::Enum::XlTickLabelPosition {} { # xlTickLabelPositionHigh - -4127 # xlTickLabelPositionLow - -4134 # xlTickLabelPositionNextToAxis - 4 # xlTickLabelPositionNone - -4142 return { xlTickLabelPositionHigh -4127 xlTickLabelPositionLow -4134 xlTickLabelPositionNextToAxis 4 xlTickLabelPositionNone -4142 } }
XlTickMark [::Excel::Enum]Top, Main, Index
XlTickMark
Parameters
xlTickMarkCross | 4 |
xlTickMarkInside | 2 |
xlTickMarkNone | -4142 |
xlTickMarkOutside | 3 |
proc ::Excel::Enum::XlTickMark {} { # xlTickMarkCross - 4 # xlTickMarkInside - 2 # xlTickMarkNone - -4142 # xlTickMarkOutside - 3 return { xlTickMarkCross 4 xlTickMarkInside 2 xlTickMarkNone -4142 xlTickMarkOutside 3 } }
XlTimelineLevel [::Excel::Enum]Top, Main, Index
XlTimelineLevel
Parameters
xlTimelineLevelDays | 3 |
xlTimelineLevelMonths | 2 |
xlTimelineLevelQuarters | 1 |
xlTimelineLevelYears | 0 |
proc ::Excel::Enum::XlTimelineLevel {} { # xlTimelineLevelDays - 3 # xlTimelineLevelMonths - 2 # xlTimelineLevelQuarters - 1 # xlTimelineLevelYears - 0 return { xlTimelineLevelDays 3 xlTimelineLevelMonths 2 xlTimelineLevelQuarters 1 xlTimelineLevelYears 0 } }
XlTimePeriods [::Excel::Enum]Top, Main, Index
XlTimePeriods
Parameters
xlLast7Days | 2 |
xlLastMonth | 5 |
xlLastWeek | 4 |
xlNextMonth | 8 |
xlNextWeek | 7 |
xlThisMonth | 9 |
xlThisWeek | 3 |
xlToday | 0 |
xlTomorrow | 6 |
xlYesterday | 1 |
proc ::Excel::Enum::XlTimePeriods {} { # xlLast7Days - 2 # xlLastMonth - 5 # xlLastWeek - 4 # xlNextMonth - 8 # xlNextWeek - 7 # xlThisMonth - 9 # xlThisWeek - 3 # xlToday - 0 # xlTomorrow - 6 # xlYesterday - 1 return { xlLast7Days 2 xlLastMonth 5 xlLastWeek 4 xlNextMonth 8 xlNextWeek 7 xlThisMonth 9 xlThisWeek 3 xlToday 0 xlTomorrow 6 xlYesterday 1 } }
XlTimeUnit [::Excel::Enum]Top, Main, Index
XlTimeUnit
Parameters
xlDays | 0 |
xlMonths | 1 |
xlYears | 2 |
proc ::Excel::Enum::XlTimeUnit {} { # xlDays - 0 # xlMonths - 1 # xlYears - 2 return { xlDays 0 xlMonths 1 xlYears 2 } }
XlToolbarProtection [::Excel::Enum]Top, Main, Index
XlToolbarProtection
Parameters
xlNoButtonChanges | 1 |
xlNoChanges | 4 |
xlNoDockingChanges | 3 |
xlNoShapeChanges | 2 |
xlToolbarProtectionNone | -4143 |
proc ::Excel::Enum::XlToolbarProtection {} { # xlNoButtonChanges - 1 # xlNoChanges - 4 # xlNoDockingChanges - 3 # xlNoShapeChanges - 2 # xlToolbarProtectionNone - -4143 return { xlNoButtonChanges 1 xlNoChanges 4 xlNoDockingChanges 3 xlNoShapeChanges 2 xlToolbarProtectionNone -4143 } }
XlTopBottom [::Excel::Enum]Top, Main, Index
XlTopBottom
Parameters
xlTop10Bottom | 0 |
xlTop10Top | 1 |
proc ::Excel::Enum::XlTopBottom {} { # xlTop10Bottom - 0 # xlTop10Top - 1 return { xlTop10Bottom 0 xlTop10Top 1 } }
XlTotalsCalculation [::Excel::Enum]Top, Main, Index
XlTotalsCalculation
Parameters
xlTotalsCalculationAverage | 2 |
xlTotalsCalculationCount | 3 |
xlTotalsCalculationCountNums | 4 |
xlTotalsCalculationCustom | 9 |
xlTotalsCalculationMax | 6 |
xlTotalsCalculationMin | 5 |
xlTotalsCalculationNone | 0 |
xlTotalsCalculationStdDev | 7 |
xlTotalsCalculationSum | 1 |
xlTotalsCalculationVar | 8 |
proc ::Excel::Enum::XlTotalsCalculation {} { # xlTotalsCalculationAverage - 2 # xlTotalsCalculationCount - 3 # xlTotalsCalculationCountNums - 4 # xlTotalsCalculationCustom - 9 # xlTotalsCalculationMax - 6 # xlTotalsCalculationMin - 5 # xlTotalsCalculationNone - 0 # xlTotalsCalculationStdDev - 7 # xlTotalsCalculationSum - 1 # xlTotalsCalculationVar - 8 return { xlTotalsCalculationAverage 2 xlTotalsCalculationCount 3 xlTotalsCalculationCountNums 4 xlTotalsCalculationCustom 9 xlTotalsCalculationMax 6 xlTotalsCalculationMin 5 xlTotalsCalculationNone 0 xlTotalsCalculationStdDev 7 xlTotalsCalculationSum 1 xlTotalsCalculationVar 8 } }
XlTrendlineType [::Excel::Enum]Top, Main, Index
XlTrendlineType
Parameters
xlExponential | 5 |
xlLinear | -4132 |
xlLogarithmic | -4133 |
xlMovingAvg | 6 |
xlPolynomial | 3 |
xlPower | 4 |
proc ::Excel::Enum::XlTrendlineType {} { # xlExponential - 5 # xlLinear - -4132 # xlLogarithmic - -4133 # xlMovingAvg - 6 # xlPolynomial - 3 # xlPower - 4 return { xlExponential 5 xlLinear -4132 xlLogarithmic -4133 xlMovingAvg 6 xlPolynomial 3 xlPower 4 } }
XlUnderlineStyle [::Excel::Enum]Top, Main, Index
XlUnderlineStyle
Parameters
xlUnderlineStyleDouble | -4119 |
xlUnderlineStyleDoubleAccounting | 5 |
xlUnderlineStyleNone | -4142 |
xlUnderlineStyleSingle | 2 |
xlUnderlineStyleSingleAccounting | 4 |
proc ::Excel::Enum::XlUnderlineStyle {} { # xlUnderlineStyleDouble - -4119 # xlUnderlineStyleDoubleAccounting - 5 # xlUnderlineStyleNone - -4142 # xlUnderlineStyleSingle - 2 # xlUnderlineStyleSingleAccounting - 4 return { xlUnderlineStyleDouble -4119 xlUnderlineStyleDoubleAccounting 5 xlUnderlineStyleNone -4142 xlUnderlineStyleSingle 2 xlUnderlineStyleSingleAccounting 4 } }
XlUpdateLinks [::Excel::Enum]Top, Main, Index
XlUpdateLinks
Parameters
xlUpdateLinksAlways | 3 |
xlUpdateLinksNever | 2 |
xlUpdateLinksUserSetting | 1 |
proc ::Excel::Enum::XlUpdateLinks {} { # xlUpdateLinksAlways - 3 # xlUpdateLinksNever - 2 # xlUpdateLinksUserSetting - 1 return { xlUpdateLinksAlways 3 xlUpdateLinksNever 2 xlUpdateLinksUserSetting 1 } }
XlVAlign [::Excel::Enum]Top, Main, Index
XlVAlign
Parameters
xlVAlignBottom | -4107 |
xlVAlignCenter | -4108 |
xlVAlignDistributed | -4117 |
xlVAlignJustify | -4130 |
xlVAlignTop | -4160 |
proc ::Excel::Enum::XlVAlign {} { # xlVAlignBottom - -4107 # xlVAlignCenter - -4108 # xlVAlignDistributed - -4117 # xlVAlignJustify - -4130 # xlVAlignTop - -4160 return { xlVAlignBottom -4107 xlVAlignCenter -4108 xlVAlignDistributed -4117 xlVAlignJustify -4130 xlVAlignTop -4160 } }
XlValueSortOrder [::Excel::Enum]Top, Main, Index
XlValueSortOrder
Parameters
xlValueAscending | 1 |
xlValueDescending | 2 |
xlValueNone | 0 |
proc ::Excel::Enum::XlValueSortOrder {} { # xlValueAscending - 1 # xlValueDescending - 2 # xlValueNone - 0 return { xlValueAscending 1 xlValueDescending 2 xlValueNone 0 } }
XlWBATemplate [::Excel::Enum]Top, Main, Index
XlWBATemplate
Parameters
xlWBATChart | -4109 |
xlWBATExcel4IntlMacroSheet | 4 |
xlWBATExcel4MacroSheet | 3 |
xlWBATWorksheet | -4167 |
proc ::Excel::Enum::XlWBATemplate {} { # xlWBATChart - -4109 # xlWBATExcel4IntlMacroSheet - 4 # xlWBATExcel4MacroSheet - 3 # xlWBATWorksheet - -4167 return { xlWBATChart -4109 xlWBATExcel4IntlMacroSheet 4 xlWBATExcel4MacroSheet 3 xlWBATWorksheet -4167 } }
XlWebFormatting [::Excel::Enum]Top, Main, Index
XlWebFormatting
Parameters
xlWebFormattingAll | 1 |
xlWebFormattingNone | 3 |
xlWebFormattingRTF | 2 |
proc ::Excel::Enum::XlWebFormatting {} { # xlWebFormattingAll - 1 # xlWebFormattingNone - 3 # xlWebFormattingRTF - 2 return { xlWebFormattingAll 1 xlWebFormattingNone 3 xlWebFormattingRTF 2 } }
XlWebSelectionType [::Excel::Enum]Top, Main, Index
XlWebSelectionType
Parameters
xlAllTables | 2 |
xlEntirePage | 1 |
xlSpecifiedTables | 3 |
proc ::Excel::Enum::XlWebSelectionType {} { # xlAllTables - 2 # xlEntirePage - 1 # xlSpecifiedTables - 3 return { xlAllTables 2 xlEntirePage 1 xlSpecifiedTables 3 } }
XlWindowState [::Excel::Enum]Top, Main, Index
XlWindowState
Parameters
xlMaximized | -4137 |
xlMinimized | -4140 |
xlNormal | -4143 |
proc ::Excel::Enum::XlWindowState {} { # xlMaximized - -4137 # xlMinimized - -4140 # xlNormal - -4143 return { xlMaximized -4137 xlMinimized -4140 xlNormal -4143 } }
XlWindowType [::Excel::Enum]Top, Main, Index
XlWindowType
Parameters
xlChartAsWindow | 5 |
xlChartInPlace | 4 |
xlClipboard | 3 |
xlInfo | -4129 |
xlWorkbook | 1 |
proc ::Excel::Enum::XlWindowType {} { # xlChartAsWindow - 5 # xlChartInPlace - 4 # xlClipboard - 3 # xlInfo - -4129 # xlWorkbook - 1 return { xlChartAsWindow 5 xlChartInPlace 4 xlClipboard 3 xlInfo -4129 xlWorkbook 1 } }
XlWindowView [::Excel::Enum]Top, Main, Index
XlWindowView
Parameters
xlNormalView | 1 |
xlPageBreakPreview | 2 |
xlPageLayoutView | 3 |
proc ::Excel::Enum::XlWindowView {} { # xlNormalView - 1 # xlPageBreakPreview - 2 # xlPageLayoutView - 3 return { xlNormalView 1 xlPageBreakPreview 2 xlPageLayoutView 3 } }
XlXLMMacroType [::Excel::Enum]Top, Main, Index
XlXLMMacroType
Parameters
xlCommand | 2 |
xlFunction | 1 |
xlNotXLM | 3 |
proc ::Excel::Enum::XlXLMMacroType {} { # xlCommand - 2 # xlFunction - 1 # xlNotXLM - 3 return { xlCommand 2 xlFunction 1 xlNotXLM 3 } }
XlXmlExportResult [::Excel::Enum]Top, Main, Index
XlXmlExportResult
Parameters
xlXmlExportSuccess | 0 |
xlXmlExportValidationFailed | 1 |
proc ::Excel::Enum::XlXmlExportResult {} { # xlXmlExportSuccess - 0 # xlXmlExportValidationFailed - 1 return { xlXmlExportSuccess 0 xlXmlExportValidationFailed 1 } }
XlXmlImportResult [::Excel::Enum]Top, Main, Index
XlXmlImportResult
Parameters
xlXmlImportElementsTruncated | 1 |
xlXmlImportSuccess | 0 |
xlXmlImportValidationFailed | 2 |
proc ::Excel::Enum::XlXmlImportResult {} { # xlXmlImportElementsTruncated - 1 # xlXmlImportSuccess - 0 # xlXmlImportValidationFailed - 2 return { xlXmlImportElementsTruncated 1 xlXmlImportSuccess 0 xlXmlImportValidationFailed 2 } }
XlXmlLoadOption [::Excel::Enum]Top, Main, Index
XlXmlLoadOption
Parameters
xlXmlLoadImportToList | 2 |
xlXmlLoadMapXml | 3 |
xlXmlLoadOpenXml | 1 |
xlXmlLoadPromptUser | 0 |
proc ::Excel::Enum::XlXmlLoadOption {} { # xlXmlLoadImportToList - 2 # xlXmlLoadMapXml - 3 # xlXmlLoadOpenXml - 1 # xlXmlLoadPromptUser - 0 return { xlXmlLoadImportToList 2 xlXmlLoadMapXml 3 xlXmlLoadOpenXml 1 xlXmlLoadPromptUser 0 } }
XlYesNoGuess [::Excel::Enum]Top, Main, Index
XlYesNoGuess
Parameters
xlGuess | 0 |
xlNo | 2 |
xlYes | 1 |
proc ::Excel::Enum::XlYesNoGuess {} { # xlGuess - 0 # xlNo - 2 # xlYes - 1 return { xlGuess 0 xlNo 2 xlYes 1 } }