Forum |  HardWare.fr | News | Articles | PC | S'identifier | S'inscrire | Shop Recherche
655 connectés 

  FORUM HardWare.fr
  Programmation
  API Win32

  Excel OLE Automation : comment acceder aux constantes ?

 


 Mot :   Pseudo :  
 
Bas de page
Auteur Sujet :

Excel OLE Automation : comment acceder aux constantes ?

n°1888308
Shinigami ​Delroen
Posté le 27-05-2009 à 06:38:04  profilanswer
 

Bonjour,
 
Je fais un peu d'automatisation d'Excel et je suis confronté a un probleme de taille : je n'arrive pas a acceder aux constantes.
 
En l'occurrence, le langage que j'utilise est Javascript, mais je pense que c'est pareil avec n'importe lequel.
 
Voila un exemple ou j'ai besoin d'une constante :

var ExcelApp = new ActiveXObject("Excel.Application" );
var result = ExcelApp.Dialogs(xlDialogOpen).Show


 
Mais evidemment, xlDialogOpen n'etant pas definie, le script ne marche pas.
 
Comment puis-je acceder a la valeur de cette variable ?
 
Merci !

mood
Publicité
Posté le 27-05-2009 à 06:38:04  profilanswer
 

n°1888391
Shinigami ​Delroen
Posté le 27-05-2009 à 10:10:12  profilanswer
 

Bon, apparemment c'est pas possible...
 
Mais la liste complete est disponible ici, avec quelques regexp il est tres facile de transformer ce html en un charmant Javascript...
 
Ceci dit, si ca vous interesse, je l'ai fait pour vous :

// XlApplicationInternational  
 var xl24HourClock = 33;
 var xl4DigitYears = 43;
 var xlAlternateArraySeparator = 16;
 var xlColumnSeparator = 14;
 var xlCountryCode = 1;
 var xlCountrySetting = 2;
 var xlCurrencyBefore = 37;
 var xlCurrencyCode = 25;;
 var xlCurrencyDigits = 27;
 var xlCurrencyLeadingZeros = 40;
 var xlCurrencyMinusSign = 38;
 var xlCurrencyNegative = 28;
 var xlCurrencySpaceBefore = 36;
 var xlCurrencyTrailingZeros = 39;
 var xlDateOrder = 32;
 var xlDateSeparator = 17;
 var xlDayCode = 21;
 var xlDayLeadingZero = 42;
 var xlDecimalSeparator = 3;
 var xlGeneralFormatName = 26;
 var xlHourCode = 22;
 var xlLeftBrace = 12;
 var xlLeftBracket = 10;
 var xlListSeparator = 5;
 var xlLowerCaseColumnLetter = 9;
 var xlLowerCaseRowLetter = 8;
 var xlMDY = 44;
 var xlMetric = 35;
 var xlMinuteCode = 23;
 var xlMonthCode = 20;
 var xlMonthLeadingZero = 41;
 var xlMonthNameChars = 30;
 var xlNoncurrencyDigits = 29;
 var xlNonEnglishFunctions = 34;
 var xlRightBrace = 13;
 var xlRightBracket = 11;
 var xlRowSeparator = 15;
 var xlSecondCode = 24;
 var xlThousandsSeparator = 4;
 var xlTimeLeadingZero = 45;
 var xlTimeSeparator = 18;
 var xlUpperCaseColumnLetter = 7;
 var xlUpperCaseRowLetter = 6;
 var xlWeekdayNameChars = 31;
 var xlYearCode = 19;
 
// XlApplyNamesOrder  
 var xlColumnThenRow = 2;
 var xlRowThenColumn = 1;
 
// XlArabicModes  
 var xlArabicBothStrict = 3;
 var xlArabicNone = 0;
 var xlArabicStrictAlefHamza = 1;
 var xlArabicStrictFinalYaa = 2;
 
//// XlArrangeStyle  
 var xlArrangeStyleCascade = 7;
 var xlArrangeStyleHorizontal = -4128;
 var xlArrangeStyleTiled = 1;
 var xlArrangeStyleVertical = -4166;
 
// XlArrowHeadLength  
 var xlArrowHeadLengthLong = 3;
 var xlArrowHeadLengthMedium = -4138;
 var xlArrowHeadLengthShort = 1;
 
// XlArrowHeadStyle  
 var xlArrowHeadStyleClosed = 3;
 var xlArrowHeadStyleDoubleClosed = 5;
 var xlArrowHeadStyleDoubleOpen = 4;
 var xlArrowHeadStyleNone = -4142;
 var xlArrowHeadStyleOpen = 2;
 
// XlArrowHeadWidth  
 var xlArrowHeadWidthMedium = -4138;
 var xlArrowHeadWidthNarrow = 1;
 var xlArrowHeadWidthWide = 3;
 
// XlAutoFillType  
 var xlFillCopy = 1;
 var xlFillDays = 5;
 var xlFillDefault = 0;
 var xlFillFormats = 3;
 var xlFillMonths = 7;
 var xlFillSeries = 2;
 var xlFillValues = 4;
 var xlFillWeekdays = 6;
 var xlFillYears = 8;
 var xlGrowthTrend = 10;
 var xlLinearTrend = 9;
 
// XlAutoFilterOperator  
 var xlAnd = 1;
 var xlBottom10Items = 4;
 var xlBottom10Percent = 6;
 var xlOr = 2;
 var xlTop10Items = 3;
 var xlTop10Percent = 5;
 
// XlAxisCrosses  
 var xlAxisCrossesAutomatic = -4105;
 var xlAxisCrossesCustom = -4114;
 var xlAxisCrossesMaximum = 2;
 var xlAxisCrossesMinimum = 4;
 
// XlAxisGroup  
 var xlPrimary = 1;
 var xlSecondary = 2;
 
// XlAxisType  
 var xlCategory = 1;
 var xlSeriesAxis = 3;
 var xlValue = 2;
 
// XlBackground  
 var xlBackgroundAutomatic = -4105;
 var xlBackgroundOpaque = 3;
 var xlBackgroundTransparent = 2;
 
// XlBarShape  
 var xlBox = 0;
 var xlConeToMax = 5;
 var xlConeToPoint = 4;
 var xlCylinder = 3;
 var xlPyramidToMax = 2;
 var xlPyramidToPoint = 1;
 
// XlBordersIndex  
 var xlDiagonalDown = 5;
 var xlDiagonalUp = 6;
 var xlEdgeBottom = 9;
 var xlEdgeLeft = 7;
 var xlEdgeRight = 10;
 var xlEdgeTop = 8;
 var xlInsideHorizontal = 12;
 var xlInsideVertical = 11;
 
// XlBorderWeight  
 var xlHairline = 1;
 var xlMedium = -4138;
 var xlThick = 4;
 var xlThin = 2;
 
// XlBuiltInDialog  
// var _xlDialogChartSourceData 541
// var _xlDialogPhonetic 538
 var xlDialogActivate = 103;
 var xlDialogActiveCellFont = 476;
 var xlDialogAddChartAutoformat = 390;
 var xlDialogAddinManager = 321;
 var xlDialogAlignment = 43;
 var xlDialogApplyNames = 133;
 var xlDialogApplyStyle = 212;
 var xlDialogAppMove = 170;
 var xlDialogAppSize = 171;
 var xlDialogArrangeAll = 12;
 var xlDialogAssignToObject = 213;
 var xlDialogAssignToTool = 293;
 var xlDialogAttachText = 80;
 var xlDialogAttachToolbars = 323;
 var xlDialogAutoCorrect = 485;
 var xlDialogAxes = 78;
 var xlDialogBorder = 45;
 var xlDialogCalculation = 32;
 var xlDialogCellProtection = 46;
 var xlDialogChangeLink = 166;
 var xlDialogChartAddData = 392;
 var xlDialogChartLocation = 527;
 var xlDialogChartOptionsDataLabelMultiple = 724;
 var xlDialogChartOptionsDataLabels = 505;
 var xlDialogChartOptionsDataTable = 506;
 var xlDialogChartSourceData = 540;
 var xlDialogChartTrend = 350;
 var xlDialogChartType = 526;
 var xlDialogChartWizard = 288;
 var xlDialogCheckboxProperties = 435;
 var xlDialogClear = 52;
 var xlDialogColorPalette = 161;
 var xlDialogColumnWidth = 47;
 var xlDialogCombination = 73;
 var xlDialogConditionalFormatting = 583;
 var xlDialogConsolidate = 191;
 var xlDialogCopyChart = 147;
 var xlDialogCopyPicture = 108;
 var xlDialogCreateList = 796;
 var xlDialogCreateNames = 62;
 var xlDialogCreatePublisher = 217;
 var xlDialogCustomizeToolbar = 276;
 var xlDialogCustomViews = 493;
 var xlDialogDataDelete = 36;
 var xlDialogDataLabel = 379;
 var xlDialogDataLabelMultiple = 723;
 var xlDialogDataSeries = 40;
 var xlDialogDataValidation = 525;
 var xlDialogDefineName = 61;
 var xlDialogDefineStyle = 229;
 var xlDialogDeleteFormat = 111;
 var xlDialogDeleteName = 110;
 var xlDialogDemote = 203;
 var xlDialogDisplay = 27;
 var xlDialogEditboxProperties = 438;
 var xlDialogEditColor = 223;
 var xlDialogEditDelete = 54;
 var xlDialogEditionOptions = 251;
 var xlDialogEditSeries = 228;
 var xlDialogErrorbarX = 463;
 var xlDialogErrorbarY = 464;
 var xlDialogErrorChecking = 732;
 var xlDialogEvaluateFormula = 709;
 var xlDialogExternalDataProperties = 530;
 var xlDialogExtract = 35;
 var xlDialogFileDelete = 6;
 var xlDialogFileSharing = 481;
 var xlDialogFillGroup = 200;
 var xlDialogFillWorkgroup = 301;
 var xlDialogFilter = 447;
 var xlDialogFilterAdvanced = 370;
 var xlDialogFindFile = 475;
 var xlDialogFont = 26;
 var xlDialogFontProperties = 381;
 var xlDialogFormatAuto = 269;
 var xlDialogFormatChart = 465;
 var xlDialogFormatCharttype = 423;
 var xlDialogFormatFont = 150;
 var xlDialogFormatLegend = 88;
 var xlDialogFormatMain = 225;
 var xlDialogFormatMove = 128;
 var xlDialogFormatNumber = 42;
 var xlDialogFormatOverlay = 226;
 var xlDialogFormatSize = 129;
 var xlDialogFormatText = 89;
 var xlDialogFormulaFind = 64;
 var xlDialogFormulaGoto = 63;
 var xlDialogFormulaReplace = 130;
 var xlDialogFunctionWizard = 450;
 var xlDialogGallery3dArea = 193;
 var xlDialogGallery3dBar = 272;
 var xlDialogGallery3dColumn = 194;
 var xlDialogGallery3dLine = 195;
 var xlDialogGallery3dPie = 196;
 var xlDialogGallery3dSurface = 273;
 var xlDialogGalleryArea = 67;
 var xlDialogGalleryBar = 68;
 var xlDialogGalleryColumn = 69;
 var xlDialogGalleryCustom = 388;
 var xlDialogGalleryDoughnut = 344;
 var xlDialogGalleryLine = 70;
 var xlDialogGalleryPie = 71;
 var xlDialogGalleryRadar = 249;
 var xlDialogGalleryScatter = 72;
 var xlDialogGoalSeek = 198;
 var xlDialogGridlines = 76;
 var xlDialogImportTextFile = 666;
 var xlDialogInsert = 55;
 var xlDialogInsertHyperlink = 596;
 var xlDialogInsertNameLabel = 496;
 var xlDialogInsertObject = 259;
 var xlDialogInsertPicture = 342;
 var xlDialogInsertTitle = 380;
 var xlDialogLabelProperties = 436;
 var xlDialogListboxProperties = 437;
 var xlDialogMacroOptions = 382;
 var xlDialogMailEditMailer = 470;
 var xlDialogMailLogon = 339;
 var xlDialogMailNextLetter = 378;
 var xlDialogMainChart = 85;
 var xlDialogMainChartType = 185;
 var xlDialogMenuEditor = 322;
 var xlDialogMove = 262;
 var xlDialogMyPermission = 834;
 var xlDialogNew = 119;
 var xlDialogNewWebQuery = 667;
 var xlDialogNote = 154;
 var xlDialogObjectProperties = 207;
 var xlDialogObjectProtection = 214;
 var xlDialogOpen = 1;
 var xlDialogOpenLinks = 2;
 var xlDialogOpenMail = 188;
 var xlDialogOpenText = 441;
 var xlDialogOptionsCalculation = 318;
 var xlDialogOptionsChart = 325;
 var xlDialogOptionsEdit = 319;
 var xlDialogOptionsGeneral = 356;
 var xlDialogOptionsListsAdd = 458;
 var xlDialogOptionsME = 647;
 var xlDialogOptionsTransition = 355;
 var xlDialogOptionsView = 320;
 var xlDialogOutline = 142;
 var xlDialogOverlay = 86;
 var xlDialogOverlayChartType = 186;
 var xlDialogPageSetup = 7;
 var xlDialogParse = 91;
 var xlDialogPasteNames = 58;
 var xlDialogPasteSpecial = 53;
 var xlDialogPatterns = 84;
 var xlDialogPermission = 832;
 var xlDialogPhonetic = 656;
 var xlDialogPivotCalculatedField = 570;
 var xlDialogPivotCalculatedItem = 572;
 var xlDialogPivotClientServerSet = 689;
 var xlDialogPivotFieldGroup = 433;
 var xlDialogPivotFieldProperties = 313;
 var xlDialogPivotFieldUngroup = 434;
 var xlDialogPivotShowPages = 421;
 var xlDialogPivotSolveOrder = 568;
 var xlDialogPivotTableOptions = 567;
 var xlDialogPivotTableWizard = 312;
 var xlDialogPlacement = 300;
 var xlDialogPrint = 8;
 var xlDialogPrinterSetup = 9;
 var xlDialogPrintPreview = 222;
 var xlDialogPromote = 202;
 var xlDialogProperties = 474;
 var xlDialogPropertyFields = 754;
 var xlDialogProtectDocument = 28;
 var xlDialogProtectSharing = 620;
 var xlDialogPublishAsWebPage = 653;
 var xlDialogPushbuttonProperties = 445;
 var xlDialogReplaceFont = 134;
 var xlDialogRoutingSlip = 336;
 var xlDialogRowHeight = 127;
 var xlDialogRun = 17;
 var xlDialogSaveAs = 5;
 var xlDialogSaveCopyAs = 456;
 var xlDialogSaveNewObject = 208;
 var xlDialogSaveWorkbook = 145;
 var xlDialogSaveWorkspace = 285;
 var xlDialogScale = 87;
 var xlDialogScenarioAdd = 307;
 var xlDialogScenarioCells = 305;
 var xlDialogScenarioEdit = 308;
 var xlDialogScenarioMerge = 473;
 var xlDialogScenarioSummary = 311;
 var xlDialogScrollbarProperties = 420;
 var xlDialogSearch = 731;
 var xlDialogSelectSpecial = 132;
 var xlDialogSendMail = 189;
 var xlDialogSeriesAxes = 460;
 var xlDialogSeriesOptions = 557;
 var xlDialogSeriesOrder = 466;
 var xlDialogSeriesShape = 504;
 var xlDialogSeriesX = 461;
 var xlDialogSeriesY = 462;
 var xlDialogSetBackgroundPicture = 509;
 var xlDialogSetPrintTitles = 23;
 var xlDialogSetUpdateStatus = 159;
 var xlDialogShowDetail = 204;
 var xlDialogShowToolbar = 220;
 var xlDialogSize = 261;
 var xlDialogSort = 39;
 var xlDialogSortSpecial = 192;
 var xlDialogSplit = 137;
 var xlDialogStandardFont = 190;
 var xlDialogStandardWidth = 472;
 var xlDialogStyle = 44;
 var xlDialogSubscribeTo = 218;
 var xlDialogSubtotalCreate = 398;
 var xlDialogSummaryInfo = 474;
 var xlDialogTable = 41;
 var xlDialogTabOrder = 394;
 var xlDialogTextToColumns = 422;
 var xlDialogUnhide = 94;
 var xlDialogUpdateLink = 201;
 var xlDialogVbaInsertFile = 328;
 var xlDialogVbaMakeAddin = 478;
 var xlDialogVbaProcedureDefinition = 330;
 var xlDialogView3d = 197;
 var xlDialogWebOptionsBrowsers = 773;
 var xlDialogWebOptionsEncoding = 686;
 var xlDialogWebOptionsFiles = 684;
 var xlDialogWebOptionsFonts = 687;
 var xlDialogWebOptionsGeneral = 683;
 var xlDialogWebOptionsPictures = 685;
 var xlDialogWindowMove = 14;
 var xlDialogWindowSize = 13;
 var xlDialogWorkbookAdd = 281;
 var xlDialogWorkbookCopy = 283;
 var xlDialogWorkbookInsert = 354;
 var xlDialogWorkbookMove = 282;
 var xlDialogWorkbookName = 386;
 var xlDialogWorkbookNew = 302;
 var xlDialogWorkbookOptions = 284;
 var xlDialogWorkbookProtect = 417;
 var xlDialogWorkbookTabSplit = 415;
 var xlDialogWorkbookUnhide = 384;
 var xlDialogWorkgroup = 199;
 var xlDialogWorkspace = 95;
 var xlDialogZoom = 256;
 
// XlCalculatedMemberType  
 var xlCalculatedMember = 0;
 var xlCalculatedSet = 1;
 
// XlCalculation  
 var xlCalculationAutomatic = -4105;
 var xlCalculationManual = -4135;
 var xlCalculationSemiautomatic = 2;
 
// XlCalculationInterruptKey  
 var xlAnyKey = 2;
 var xlEscKey = 1;
 var xlNoKey = 0;
 
// XlCalculationState  
 var xlCalculating = 1;
 var xlDone = 0;
 var xlPending = 2;
 
// XlCategoryType  
 var xlAutomaticScale = -4105;
 var xlCategoryScale = 2;
 var xlTimeScale = 3;
 
// XlCellInsertionMode  
 var xlInsertDeleteCells = 1;
 var xlInsertEntireRows = 2;
 var xlOverwriteCells = 0;
 
// XlCellType  
 var xlCellTypeAllFormatConditions = -4172;
 var xlCellTypeAllValidation = -4174;
 var xlCellTypeBlanks = 4;
 var xlCellTypeComments = -4144;
 var xlCellTypeConstants = 2;
 var xlCellTypeFormulas = -4123;
 var xlCellTypeLastCell = 11;
 var xlCellTypeSameFormatConditions = -4173;
 var xlCellTypeSameValidation = -4175;
 var xlCellTypeVisible = 12;
 
// XlChartGallery  
 var xlAnyGallery = 23;
 var xlBuiltIn = 21;
 var xlUserDefined = 22;
 
// XlChartItem  
 var xlAxis = 21;
 var xlAxisTitle = 17;
 var xlChartArea = 2;
 var xlChartTitle = 4;
 var xlCorners = 6;
 var xlDataLabel = 0;
 var xlDataTable = 7;
 var xlDisplayUnitLabel = 30;
 var xlDownBars = 20;
 var xlDropLines = 26;
 var xlErrorBars = 9;
 var xlFloor = 23;
 var xlHiLoLines = 25;
 var xlLeaderLines = 29;
 var xlLegend = 24;
 var xlLegendEntry = 12;
 var xlLegendKey = 13;
 var xlMajorGridlines = 15;
 var xlMinorGridlines = 16;
 var xlNothing = 28;
 var xlPivotChartDropZone = 32;
 var xlPivotChartFieldButton = 31;
 var xlPlotArea = 19;
 var xlRadarAxisLabels = 27;
 var xlSeries = 3;
 var xlSeriesLines = 22;
 var xlShape = 14;
 var xlTrendline = 8;
 var xlUpBars = 18;
 var xlWalls = 5;
 var xlXErrorBars = 10;
 var xlYErrorBars = 11;
 
// XlChartLocation  
 var xlLocationAsNewSheet = 1;
 var xlLocationAsObject = 2;
 var xlLocationAutomatic = 3;
 
// XlChartPicturePlacement  
 var xlAllFaces = 7;
 var xlEnd = 2;
 var xlEndSides = 3;
 var xlFront = 4;
 var xlFrontEnd = 6;
 var xlFrontSides = 5;
 var xlSides = 1;
 
// XlChartPictureType  
 var xlStack = 2;
 var xlStackScale = 3;
 var xlStretch = 1;
 
// XlChartSplitType  
 var xlSplitByCustomSplit = 4;
 var xlSplitByPercentValue = 3;
 var xlSplitByPosition = 1;
 var xlSplitByValue = 2;
 
// XlChartType  
 var xl3DArea = -4098;
 var xl3DAreaStacked = 78;
 var xl3DAreaStacked100 = 79;
 var xl3DBarClustered = 60;
 var xl3DBarStacked = 61;
 var xl3DBarStacked100 = 62;
 var xl3DColumn = -4100;
 var xl3DColumnClustered = 54;
 var xl3DColumnStacked = 55;
 var xl3DColumnStacked100 = 56;
 var xl3DLine = -4101;
 var xl3DPie = -4102;
 var xl3DPieExploded = 70;
 var xlArea = 1;
 var xlAreaStacked = 76;
 var xlAreaStacked100 = 77;
 var xlBarClustered = 57;
 var xlBarOfPie = 71;
 var xlBarStacked = 58;
 var xlBarStacked100 = 59;
 var xlBubble = 15;
 var xlBubble3DEffect = 87;
 var xlColumnClustered = 51;
 var xlColumnStacked = 52;
 var xlColumnStacked100 = 53;
 var xlConeBarClustered = 102;
 var xlConeBarStacked = 103;
 var xlConeBarStacked100 = 104;
 var xlConeCol = 105;
 var xlConeColClustered = 99;
 var xlConeColStacked = 100;
 var xlConeColStacked100 = 101;
 var xlCylinderBarClustered = 95;
 var xlCylinderBarStacked = 96;
 var xlCylinderBarStacked100 = 97;
 var xlCylinderCol = 98;
 var xlCylinderColClustered = 92;
 var xlCylinderColStacked = 93;
 var xlCylinderColStacked100 = 94;
 var xlDoughnut = -4120;
 var xlDoughnutExploded = 80;
 var xlLine = 4;
 var xlLineMarkers = 65;
 var xlLineMarkersStacked = 66;
 var xlLineMarkersStacked100 = 67;
 var xlLineStacked = 63;
 var xlLineStacked100 = 64;
 var xlPie = 5;
 var xlPieExploded = 69;
 var xlPieOfPie = 68;
 var xlPyramidBarClustered = 109;
 var xlPyramidBarStacked = 110;
 var xlPyramidBarStacked100 = 111;
 var xlPyramidCol = 112;
 var xlPyramidColClustered = 106;
 var xlPyramidColStacked = 107;
 var xlPyramidColStacked100 = 108;
 var xlRadar = -4151;
 var xlRadarFilled = 82;
 var xlRadarMarkers = 81;
 var xlStockHLC = 88;
 var xlStockOHLC = 89;
 var xlStockVHLC = 90;
 var xlStockVOHLC = 91;
 var xlSurface = 83;
 var xlSurfaceTopView = 85;
 var xlSurfaceTopViewWireframe = 86;
 var xlSurfaceWireframe = 84;
 var xlXYScatter = -4169;
 var xlXYScatterLines = 74;
 var xlXYScatterLinesNoMarkers = 75;
 var xlXYScatterSmooth = 72;
 var xlXYScatterSmoothNoMarkers = 73;
 
// XlClipboardFormat  
 var xlClipboardFormatBIFF = 8;
 var xlClipboardFormatBIFF2 = 18;
 var xlClipboardFormatBIFF3 = 20;
 var xlClipboardFormatBIFF4 = 30;
 var xlClipboardFormatBinary = 15;
 var xlClipboardFormatBitmap = 9;
 var xlClipboardFormatCGM = 13;
 var xlClipboardFormatCSV = 5;
 var xlClipboardFormatDIF = 4;
 var xlClipboardFormatDspText = 12;
 var xlClipboardFormatEmbeddedObject = 21;
 var xlClipboardFormatEmbedSource = 22;
 var xlClipboardFormatLink = 11;
 var xlClipboardFormatLinkSource = 23;
 var xlClipboardFormatLinkSourceDesc = 32;
 var xlClipboardFormatMovie = 24;
 var xlClipboardFormatNative = 14;
 var xlClipboardFormatObjectDesc = 31;
 var xlClipboardFormatObjectLink = 19;
 var xlClipboardFormatOwnerLink = 17;
 var xlClipboardFormatPICT = 2;
 var xlClipboardFormatPrintPICT = 3;
 var xlClipboardFormatRTF = 7;
 var xlClipboardFormatScreenPICT = 29;
 var xlClipboardFormatStandardFont = 28;
 var xlClipboardFormatStandardScale = 27;
 var xlClipboardFormatSYLK = 6;
 var xlClipboardFormatTable = 16;
 var xlClipboardFormatText = 0;
 var xlClipboardFormatToolFace = 25;
 var xlClipboardFormatToolFacePICT = 26;
 var xlClipboardFormatVALU = 1;
 var xlClipboardFormatWK1 = 10;
 
// XlCmdType  
 var xlCmdCube = 1;
 var xlCmdDefault = 4;
 var xlCmdList = 5;
 var xlCmdSql = 2;
 var xlCmdTable = 3;
 
// XlColorIndex  
 var xlColorIndexAutomatic = -4105;
 var xlColorIndexNone = -4142;
 
// XlColumnDataType  
 var xlDMYFormat = 4;
 var xlDYMFormat = 7;
 var xlEMDFormat = 10;
 var xlGeneralFormat = 1;
 var xlMDYFormat = 3;
 var xlMYDFormat = 6;
 var xlSkipColumn = 9;
 var xlTextFormat = 2;
 var xlYDMFormat = 8;
 var xlYMDFormat = 5;
 
// XlCommandUnderlines  
 var xlCommandUnderlinesAutomatic = -4105;
 var xlCommandUnderlinesOff = -4146;
 var xlCommandUnderlinesOn = 1;
 
// XlCommentDisplayMode  
 var xlCommentAndIndicator = 1;
 var xlCommentIndicatorOnly = -1;
 var xlNoIndicator = 0;
 
// XlConsolidationFunction  
 var xlAverage = -4106;
 var xlCount = -4112;
 var xlCountNums = -4113;
 var xlMax = -4136;
 var xlMin = -4139;
 var xlProduct = -4149;
 var xlStDev = -4155;
 var xlStDevP = -4156;
 var xlSum = -4157;
 var xlUnknown = 1000;
 var xlVar = -4164;
 var xlVarP = -4165;
 
// XlCopyPictureFormat  
 var xlBitmap = 2;
 var xlPicture = -4147;
 
// XlCorruptLoad  
 var xlExtractData = 2;
 var xlNormalLoad = 0;
 var xlRepairFile = 1;
 
// XlCreator  
 var xlCreatorCode = 1480803660;
 
// XlCubeFieldType  
 var xlHierarchy = 1;
 var xlMeasure = 2;
 var xlSet = 3;
 
// XlCutCopyMode  
 var xlCopy = 1;
 var xlCut = 2;
 
// XlCVError  
 var xlErrDiv0 = 2007;
 var xlErrNA = 2042;
 var xlErrName = 2029;
 var xlErrNull = 2000;
 var xlErrNum = 2036;
 var xlErrRef = 2023;
 var xlErrValue = 2015;
 
// XlDataLabelPosition  
 var xlLabelPositionAbove = 0;
 var xlLabelPositionBelow = 1;
 var xlLabelPositionBestFit = 5;
 var xlLabelPositionCenter = -4108;
 var xlLabelPositionCustom = 7;
 var xlLabelPositionInsideBase = 4;
 var xlLabelPositionInsideEnd = 3;
 var xlLabelPositionLeft = -4131;
 var xlLabelPositionMixed = 6;
 var xlLabelPositionOutsideEnd = 2;
 var xlLabelPositionRight = -4152;
 
// XlDataLabelSeparator  
 var xlDataLabelSeparatorDefault = 1;
 
// XlDataLabelsType  
 var xlDataLabelsShowBubbleSizes = 6;
 var xlDataLabelsShowLabel = 4;
 var xlDataLabelsShowLabelAndPercent = 5;
 var xlDataLabelsShowNone = -4142;
 var xlDataLabelsShowPercent = 3;
 var xlDataLabelsShowValue = 2;
 
// XlDataSeriesDate  
 var xlDay = 1;
 var xlMonth = 3;
 var xlWeekday = 2;
 var xlYear = 4;
 
// XlDataSeriesType  
 var xlAutoFill = 4;
 var xlChronological = 3;
 var xlDataSeriesLinear = -4132;
 var xlGrowth = 2;
 
// XlDeleteShiftDirection  
 var xlShiftToLeft = -4159;
 var xlShiftUp = -4162;
 
// XlDirection  
 var xlDown = -4121;
 var xlToLeft = -4159;
 var xlToRight = -4161;
 var xlUp = -4162;
 
// XlDisplayBlanksAs  
 var xlInterpolated = 3;
 var xlNotPlotted = 1;
 var xlZero = 2;
 
// XlDisplayDrawingObjects  
 var xlDisplayShapes = -4104;
 var xlHide = 3;
 var xlPlaceholders = 2;
 
// XlDisplayUnit  
 var xlHundredMillions = -8;
 var xlHundreds = -2;
 var xlHundredThousands = -5;
 var xlMillionMillions = -10;
 var xlMillions = -6;
 var xlTenMillions = -7;
 var xlTenThousands = -4;
 var xlThousandMillions = -9;
 var xlThousands = -3;
 
// XlDVAlertStyle  
 var xlValidAlertInformation = 3;
 var xlValidAlertStop = 1;
 var xlValidAlertWarning = 2;
 
// XlDVType  
 var xlValidateCustom = 7;
 var xlValidateDate = 4;
 var xlValidateDecimal = 2;
 var xlValidateInputOnly = 0;
 var xlValidateList = 3;
 var xlValidateTextLength = 6;
 var xlValidateTime = 5;
 var xlValidateWholeNumber = 1;
 
// XlEditionFormat  
 var xlBIFF = 2;
 var xlPICT = 1;
 var xlRTF = 4;
 var xlVALU = 8;
 
// XlEditionOptionsOption  
 var xlAutomaticUpdate = 4;
 var xlCancel = 1;
 var xlChangeAttributes = 6;
 var xlManualUpdate = 5;
 var xlOpenSource = 3;
 var xlSelect = 3;
 var xlSendPublisher = 2;
 var xlUpdateSubscriber = 2;
 
// XlEditionType  
 var xlPublisher = 1;
 var xlSubscriber = 2;
 
// XlEnableCancelKey  
 var xlDisabled = 0;
 var xlErrorHandler = 2;
 var xlInterrupt = 1;
 
// XlEnableSelection  
 var xlNoRestrictions = 0;
 var xlNoSelection = -4142;
 var xlUnlockedCells = 1;
 
// XlEndStyleCap  
 var xlCap = 1;
 var xlNoCap = 2;
 
// XlErrorBarDirection  
 var xlX = -4168;
 var xlY = 1;
 
// XlErrorBarInclude  
 var xlErrorBarIncludeBoth = 1;
 var xlErrorBarIncludeMinusValues = 3;
 var xlErrorBarIncludeNone = -4142;
 var xlErrorBarIncludePlusValues = 2;
 
// XlErrorBarType  
 var xlErrorBarTypeCustom = -4114;
 var xlErrorBarTypeFixedValue = 1;
 var xlErrorBarTypePercent = 2;
 var xlErrorBarTypeStDev = -4155;
 var xlErrorBarTypeStError = 4;
 
// XlErrorChecks  
 var xlEmptyCellReferences = 7;
 var xlEvaluateToError = 1;
 var xlInconsistentFormula = 4;
 var xlListDataValidation = 8;
 var xlNumberAsText = 3;
 var xlOmittedCells = 5;
 var xlTextDate = 2;
 var xlUnlockedFormulaCells = 6;
 
// XlFileAccess  
 var xlReadOnly = 3;
 var xlReadWrite = 2;
 
// XlFileFormat  
 var xlAddIn = 18;
 var xlCSV = 6;
 var xlCSVMac = 22;
 var xlCSVMSDOS = 24;
 var xlCSVWindows = 23;
 var xlCurrentPlatformText = -4158;
 var xlDBF2 = 7;
 var xlDBF3 = 8;
 var xlDBF4 = 11;
 var xlDIF = 9;
 var xlExcel2 = 16;
 var xlExcel2FarEast = 27;
 var xlExcel3 = 29;
 var xlExcel4 = 33;
 var xlExcel4Workbook = 35;
 var xlExcel5 = 39;
 var xlExcel7 = 39;
 var xlExcel9795 = 43;
 var xlHtml = 44;
 var xlIntlAddIn = 26;
 var xlIntlMacro = 25;
 var xlSYLK = 2;
 var xlTemplate = 17;
 var xlTextMac = 19;
 var xlTextMSDOS = 21;
 var xlTextPrinter = 36;
 var xlTextWindows = 20;
 var xlUnicodeText = 42;
 var xlWebArchive = 45;
 var xlWJ2WD1 = 14;
 var xlWJ3 = 40;
 var xlWJ3FJ3 = 41;
 var xlWK1 = 5;
 var xlWK1ALL = 31;
 var xlWK1FMT = 30;
 var xlWK3 = 15;
 var xlWK3FM3 = 32;
 var xlWK4 = 38;
 var xlWKS = 4;
 var xlWorkbookNormal = -4143;
 var xlWorks2FarEast = 28;
 var xlWQ1 = 34;
 var xlXMLData = 47;
 var xlXMLSpreadsheet = 46;
 
// XlFillWith  
 var xlFillWithAll = -4104;
 var xlFillWithContents = 2;
 var xlFillWithFormats = -4122;
 
// XlFilterAction  
 var xlFilterCopy = 2;
 var xlFilterInPlace = 1;
 
// XlFindLookIn  
 var xlComments = -4144;
 var xlFormulas = -4123;
 var xlValues = -4163;
 
// XlFormatConditionOperator  
 var xlBetween = 1;
 var xlEqual = 3;
 var xlGreater = 5;
 var xlGreaterEqual = 7;
 var xlLess = 6;
 var xlLessEqual = 8;
 var xlNotBetween = 2;
 var xlNotEqual = 4;
 
// XlFormatConditionType  
 var xlCellValue = 1;
 var xlExpression = 2;
 
// XlFormControl  
 var xlButtonControl = 0;
 var xlCheckBox = 1;
 var xlDropDown = 2;
 var xlEditBox = 3;
 var xlGroupBox = 4;
 var xlLabel = 5;
 var xlListBox = 6;
 var xlOptionButton = 7;
 var xlScrollBar = 8;
 var xlSpinner = 9;
 
// XlFormulaLabel  
 var xlColumnLabels = 2;
 var xlMixedLabels = 3;
 var xlNoLabels = -4142;
 var xlRowLabels = 1;
 
// XlHAlign  
 var xlHAlignCenter = -4108;
 var xlHAlignCenterAcrossSelection = 7;
 var xlHAlignDistributed = -4117;
 var xlHAlignFill = 5;
 var xlHAlignGeneral = 1;
 var xlHAlignJustify = -4130;
 var xlHAlignLeft = -4131;
 var xlHAlignRight = -4152;
 
// XlHebrewModes  
 var xlHebrewFullScript = 0;
 var xlHebrewMixedAuthorizedScript = 3;
 var xlHebrewMixedScript = 2;
 var xlHebrewPartialScript = 1;
 
// XlHighlightChangesTime  
 var xlAllChanges = 2;
 var xlNotYetReviewed = 3;
 var xlSinceMyLastSave = 1;
 
// XlHtmlType  
 var xlHtmlCalc = 1;
 var xlHtmlChart = 3;
 var xlHtmlList = 2;
 var xlHtmlStatic = 0;
 
// XlIMEMode  
 var xlIMEModeAlpha = 8;
 var xlIMEModeAlphaFull = 7;
 var xlIMEModeDisable = 3;
 var xlIMEModeHangul = 10;
 var xlIMEModeHangulFull = 9;
 var xlIMEModeHiragana = 4;
 var xlIMEModeKatakana = 5;
 var xlIMEModeKatakanaHalf = 6;
 var xlIMEModeNoControl = 0;
 var xlIMEModeOff = 2;
 var xlIMEModeOn = 1;
 
// XlImportDataAs  
 var xlPivotTableReport = 1;
 var xlQueryTable = 0;
 
// XlInsertFormatOrigin  
 var xlFormatFromLeftOrAbove = 0;
 var xlFormatFromRightOrBelow = 1;
 
// XlInsertShiftDirection  
 var xlShiftDown = -4121;
 var xlShiftToRight = -4161;
 
// XlLayoutFormType  
 var xlOutline = 1;
 var xlTabular = 0;
 
// XlLegendPosition  
 var xlLegendPositionBottom = -4107;
 var xlLegendPositionCorner = 2;
 var xlLegendPositionLeft = -4131;
 var xlLegendPositionRight = -4152;
 var xlLegendPositionTop = -4160;
 
// XlLineStyle  
 var xlContinuous = 1;
 var xlDash = -4115;
 var xlDashDot = 4;
 var xlDashDotDot = 5;
 var xlDot = -4118;
 var xlDouble = -4119;
 var xlLineStyleNone = -4142;
 var xlSlantDashDot = 13;
 
// XlLink  
 var xlExcelLinks = 1;
 var xlOLELinks = 2;
 var xlPublishers = 5;
 var xlSubscribers = 6;
 
// XlLinkInfo  
 var xlEditionDate = 2;
 var xlLinkInfoStatus = 3;
 var xlUpdateState = 1;
 
// XlLinkInfoType  
 var xlLinkInfoOLELinks = 2;
 var xlLinkInfoPublishers = 5;
 var xlLinkInfoSubscribers = 6;
 
// XlLinkStatus  
 var xlLinkStatusCopiedValues = 10;
 var xlLinkStatusIndeterminate = 5;
 var xlLinkStatusInvalidName = 7;
 var xlLinkStatusMissingFile = 1;
 var xlLinkStatusMissingSheet = 2;
 var xlLinkStatusNotStarted = 6;
 var xlLinkStatusOK = 0;
 var xlLinkStatusOld = 3;
 var xlLinkStatusSourceNotCalculated = 4;
 var xlLinkStatusSourceNotOpen = 8;
 var xlLinkStatusSourceOpen = 9;
 
// XlLinkType  
 var xlLinkTypeExcelLinks = 1;
 var xlLinkTypeOLELinks = 2;
 
// XlListConflict  
 var xlListConflictDialog = 0;
 var xlListConflictDiscardAllConflicts = 2;
 var xlListConflictError = 3;
 var xlListConflictRetryAllConflicts = 1;
 
// XlListDataType  
 var xlListDataTypeCheckbox = 9;
 var xlListDataTypeChoice = 6;
 var xlListDataTypeChoiceMulti = 7;
 var xlListDataTypeCounter = 11;
 var xlListDataTypeCurrency = 4;
 var xlListDataTypeDateTime = 5;
 var xlListDataTypeHyperLink = 10;
 var xlListDataTypeListLookup = 8;
 var xlListDataTypeMultiLineRichText = 12;
 var xlListDataTypeMultiLineText = 2;
 var xlListDataTypeNone = 0;
 var xlListDataTypeNumber = 3;
 var xlListDataTypeText = 1;
 
// XlListObjectSourceType  
 var xlSrcExternal = 0;
 var xlSrcRange = 1;
 var xlSrcXml = 2;
 
// XlLocationInTable  
 var xlColumnHeader = -4110;
 var xlColumnItem = 5;
 var xlDataHeader = 3;
 var xlDataItem = 7;
 var xlPageHeader = 2;
 var xlPageItem = 6;
 var xlRowHeader = -4153;
 var xlRowItem = 4;
 var xlTableBody = 8;
 
// XlLookAt  
 var xlPart = 2;
 var xlWhole = 1;
 
// XlMailSystem  
 var xlMAPI = 1;
 var xlNoMailSystem = 0;
 var xlPowerTalk = 2;
 
// XlMarkerStyle  
 var xlMarkerStyleAutomatic = -4105;
 var xlMarkerStyleCircle = 8;
 var xlMarkerStyleDash = -4115;
 var xlMarkerStyleDiamond = 2;
 var xlMarkerStyleDot = -4118;
 var xlMarkerStyleNone = -4142;
 var xlMarkerStylePicture = -4147;
 var xlMarkerStylePlus = 9;
 var xlMarkerStyleSquare = 1;
 var xlMarkerStyleStar = 5;
 var xlMarkerStyleTriangle = 3;
 var xlMarkerStyleX = -4168;
 
// XlMouseButton  
 var xlNoButton = 0;
 var xlPrimaryButton = 1;
 var xlSecondaryButton = 2;
 
// XlMousePointer  
 var xlDefault = -4143;
 var xlIBeam = 3;
 var xlNorthwestArrow = 1;
 var xlWait = 2;
 
// XlMSApplication  
 var xlMicrosoftAccess = 4;
 var xlMicrosoftFoxPro = 5;
 var xlMicrosoftMail = 3;
 var xlMicrosoftPowerPoint = 2;
 var xlMicrosoftProject = 6;
 var xlMicrosoftSchedulePlus = 7;
 var xlMicrosoftWord = 1;
 
// XlObjectSize  
 var xlFitToPage = 2;
 var xlFullPage = 3;
 var xlScreenSize = 1;
 
// XlOLEType  
 var xlOLEControl = 2;
 var xlOLEEmbed = 1;
 var xlOLELink = 0;
 
// XlOLEVerb  
 var xlVerbOpen = 2;
 var xlVerbPrimary = 1;
 
// XlOrder  
 var xlDownThenOver = 1;
 var xlOverThenDown = 2;
 
// XlOrientation  
 var xlDownward = -4170;
 var xlHorizontal = -4128;
 var xlUpward = -4171;
 var xlVertical = -4166;
 
// XlPageBreak  
 var xlPageBreakAutomatic = -4105;
 var xlPageBreakManual = -4135;
 var xlPageBreakNone = -4142;
 
// XlPageBreakExtent  
 var xlPageBreakFull = 1;
 var xlPageBreakPartial = 2;
 
// XlPageOrientation  
 var xlLandscape = 2;
 var xlPortrait = 1;
 
// XlPaperSize  
 var xlPaper10x14 = 16;
 var xlPaper11x17 = 17;
 var xlPaperA3 = 8;
 var xlPaperA4 = 9;
 var xlPaperA4Small = 10;
 var xlPaperA5 = 11;
 var xlPaperB4 = 12;
 var xlPaperB5 = 13;
 var xlPaperCsheet = 24;
 var xlPaperDsheet = 25;
 var xlPaperEnvelope10 = 20;
 var xlPaperEnvelope11 = 21;
 var xlPaperEnvelope12 = 22;
 var xlPaperEnvelope14 = 23;
 var xlPaperEnvelope9 = 19;
 var xlPaperEnvelopeB4 = 33;
 var xlPaperEnvelopeB5 = 34;
 var xlPaperEnvelopeB6 = 35;
 var xlPaperEnvelopeC3 = 29;
 var xlPaperEnvelopeC4 = 30;
 var xlPaperEnvelopeC5 = 28;
 var xlPaperEnvelopeC6 = 31;
 var xlPaperEnvelopeC65 = 32;
 var xlPaperEnvelopeDL = 27;
 var xlPaperEnvelopeItaly = 36;
 var xlPaperEnvelopeMonarch = 37;
 var xlPaperEnvelopePersonal = 38;
 var xlPaperEsheet = 26;
 var xlPaperExecutive = 7;
 var xlPaperFanfoldLegalGerman = 41;
 var xlPaperFanfoldStdGerman = 40;
 var xlPaperFanfoldUS = 39;
 var xlPaperFolio = 14;
 var xlPaperLedger = 4;
 var xlPaperLegal = 5;
 var xlPaperLetter = 1;
 var xlPaperLetterSmall = 2;
 var xlPaperNote = 18;
 var xlPaperQuarto = 15;
 var xlPaperStatement = 6;
 var xlPaperTabloid = 3;
 var xlPaperUser = 256;
 
// XlParameterDataType  
 var xlParamTypeBigInt = -5;
 var xlParamTypeBinary = -2;
 var xlParamTypeBit = -7;
 var xlParamTypeChar = 1;
 var xlParamTypeDate = 9;
 var xlParamTypeDecimal = 3;
 var xlParamTypeDouble = 8;
 var xlParamTypeFloat = 6;
 var xlParamTypeInteger = 4;
 var xlParamTypeLongVarBinary = -4;
 var xlParamTypeLongVarChar = -1;
 var xlParamTypeNumeric = 2;
 var xlParamTypeReal = 7;
 var xlParamTypeSmallInt = 5;
 var xlParamTypeTime = 10;
 var xlParamTypeTimestamp = 11;
 var xlParamTypeTinyInt = -6;
 var xlParamTypeUnknown = 0;
 var xlParamTypeVarBinary = -3;
 var xlParamTypeVarChar = 12;
 var xlParamTypeWChar = -8;
 
// XlParameterType  
 var xlConstant = 1;
 var xlPrompt = 0;
 var xlRange = 2;
 
// XlPasteSpecialOperation  
 var xlPasteSpecialOperationAdd = 2;
 var xlPasteSpecialOperationDivide = 5;
 var xlPasteSpecialOperationMultiply = 4;
 var xlPasteSpecialOperationNone = -4142;
 var xlPasteSpecialOperationSubtract = 3;
 
// XlPasteType  
 var xlPasteAll = -4104;
 var xlPasteAllExceptBorders = 7;
 var xlPasteColumnWidths = 8;
 var xlPasteComments = -4144;
 var xlPasteFormats = -4122;
 var xlPasteFormulas = -4123;
 var xlPasteFormulasAndNumberFormats = 11;
 var xlPasteValidation = 6;
 var xlPasteValues = -4163;
 var xlPasteValuesAndNumberFormats = 12;
 
// XlPattern  
 var xlPatternAutomatic = -4105;
 var xlPatternChecker = 9;
 var xlPatternCrissCross = 16;
 var xlPatternDown = -4121;
 var xlPatternGray16 = 17;
 var xlPatternGray25 = -4124;
 var xlPatternGray50 = -4125;
 var xlPatternGray75 = -4126;
 var xlPatternGray8 = 18;
 var xlPatternGrid = 15;
 var xlPatternHorizontal = -4128;
 var xlPatternLightDown = 13;
 var xlPatternLightHorizontal = 11;
 var xlPatternLightUp = 14;
 var xlPatternLightVertical = 12;
 var xlPatternNone = -4142;
 var xlPatternSemiGray75 = 10;
 var xlPatternSolid = 1;
 var xlPatternUp = -4162;
 var xlPatternVertical = -4166;
 
// XlPhoneticAlignment  
 var xlPhoneticAlignCenter = 2;
 var xlPhoneticAlignDistributed = 3;
 var xlPhoneticAlignLeft = 1;
 var xlPhoneticAlignNoControl = 0;
 
// XlPhoneticCharacterType  
 var xlHiragana = 2;
 var xlKatakana = 1;
 var xlKatakanaHalf = 0;
 var xlNoConversion = 3;
 
// XlPictureAppearance  
 var xlPrinter = 2;
 var xlScreen = 1;
 
// XlPictureConvertorType  
 var xlBMP = 1;
 var xlCGM = 7;
 var xlDRW = 4;
 var xlDXF = 5;
 var xlEPS = 8;
 var xlHGL = 6;
 var xlPCT = 13;
 var xlPCX = 10;
 var xlPIC = 11;
 var xlPLT = 12;
 var xlTIF = 9;
 var xlWMF = 2;
 var xlWPG = 3;
 
// XlPivotCellType  
 var xlPivotCellBlankCell = 9;
 var xlPivotCellCustomSubtotal = 7;
 var xlPivotCellDataField = 4;
 var xlPivotCellDataPivotField = 8;
 var xlPivotCellGrandTotal = 3;
 var xlPivotCellPageFieldItem = 6;
 var xlPivotCellPivotField = 5;
 var xlPivotCellPivotItem = 1;
 var xlPivotCellSubtotal = 2;
 var xlPivotCellValue = 0;
 
// XlPivotFieldCalculation  
 var xlDifferenceFrom = 2;
 var xlIndex = 9;
 var xlNoAdditionalCalculation = -4143;
 var xlPercentDifferenceFrom = 4;
 var xlPercentOf = 3;
 var xlPercentOfColumn = 7;
 var xlPercentOfRow = 6;
 var xlPercentOfTotal = 8;
 var xlRunningTotal = 5;
 
// XlPivotFieldDataType  
 var xlDate = 2;
 var xlNumber = -4145;
 var xlText = -4158;
 
// XlPivotFieldOrientation  
 var xlColumnField = 2;
 var xlDataField = 4;
 var xlHidden = 0;
 var xlPageField = 3;
 var xlRowField = 1;
 
// XlPivotFormatType  
 var xlPTClassic = 20;
 var xlPTNone = 21;
 var xlReport1 = 0;
 var xlReport10 = 9;
 var xlReport2 = 1;
 var xlReport3 = 2;
 var xlReport4 = 3;
 var xlReport5 = 4;
 var xlReport6 = 5;
 var xlReport7 = 6;
 var xlReport8 = 7;
 var xlReport9 = 8;
 var xlTable1 = 10;
 var xlTable10 = 19;
 var xlTable2 = 11;
 var xlTable3 = 12;
 var xlTable4 = 13;
 var xlTable5 = 14;
 var xlTable6 = 15;
 var xlTable7 = 16;
 var xlTable8 = 17;
 var xlTable9 = 18;
 
// XlPivotTableMissingItems  
 var xlMissingItemsDefault = -1;
 var xlMissingItemsMax = 32500;
 var xlMissingItemsNone = 0;
 
// XlPivotTableSourceType  
 var xlConsolidation = 3;
 var xlDatabase = 1;
 var xlExternal = 2;
 var xlPivotTable = -4148;
 var xlScenario = 4;
 
// XlPivotTableVersionList  
 var xlPivotTableVersion10 = 1;
 var xlPivotTableVersion2000 = 0;
 var xlPivotTableVersionCurrent = -1;
 
// XlPlacement  
 var xlFreeFloating = 3;
 var xlMove = 2;
 var xlMoveAndSize = 1;
 
// XlPlatform  
 var xlMacintosh = 1;
 var xlMSDOS = 3;
 var xlWindows = 2;
 
// XlPrintErrors  
 var xlPrintErrorsBlank = 1;
 var xlPrintErrorsDash = 2;
 var xlPrintErrorsDisplayed = 0;
 var xlPrintErrorsNA = 3;
 
// XlPrintLocation  
 var xlPrintInPlace = 16;
 var xlPrintNoComments = -4142;
 var xlPrintSheetEnd = 1;
 
// XlPriority  
 var xlPriorityHigh = -4127;
 var xlPriorityLow = -4134;
 var xlPriorityNormal = -4143;
 
// XlPTSelectionMode  
 var xlBlanks = 4;
 var xlButton = 15;
 var xlDataAndLabel = 0;
 var xlDataOnly = 2;
 var xlFirstRow = 256;
 var xlLabelOnly = 1;
 var xlOrigin = 3;
 
// XlQueryType  
 var xlADORecordset = 7;
 var xlDAORecordset = 2;
 var xlODBCQuery = 1;
 var xlOLEDBQuery = 5;
 var xlTextImport = 6;
 var xlWebQuery = 4;
 
// XlRangeAutoFormat  
 var xlRangeAutoFormat3DEffects1 = 13;
 var xlRangeAutoFormat3DEffects2 = 14;
 var xlRangeAutoFormatAccounting1 = 4;
 var xlRangeAutoFormatAccounting2 = 5;
 var xlRangeAutoFormatAccounting3 = 6;
 var xlRangeAutoFormatAccounting4 = 17;
 var xlRangeAutoFormatClassic1 = 1;
 var xlRangeAutoFormatClassic2 = 2;
 var xlRangeAutoFormatClassic3 = 3;
 var xlRangeAutoFormatClassicPivotTable = 31;
 var xlRangeAutoFormatColor1 = 7;
 var xlRangeAutoFormatColor2 = 8;
 var xlRangeAutoFormatColor3 = 9;
 var xlRangeAutoFormatList1 = 10;
 var xlRangeAutoFormatList2 = 11;
 var xlRangeAutoFormatList3 = 12;
 var xlRangeAutoFormatLocalFormat1 = 15;
 var xlRangeAutoFormatLocalFormat2 = 16;
 var xlRangeAutoFormatLocalFormat3 = 19;
 var xlRangeAutoFormatLocalFormat4 = 20;
 var xlRangeAutoFormatNone = -4142;
 var xlRangeAutoFormatPTNone = 42;
 var xlRangeAutoFormatReport1 = 21;
 var xlRangeAutoFormatReport10 = 30;
 var xlRangeAutoFormatReport2 = 22;
 var xlRangeAutoFormatReport3 = 23;
 var xlRangeAutoFormatReport4 = 24;
 var xlRangeAutoFormatReport5 = 25;
 var xlRangeAutoFormatReport6 = 26;
 var xlRangeAutoFormatReport7 = 27;
 var xlRangeAutoFormatReport8 = 28;
 var xlRangeAutoFormatReport9 = 29;
 var xlRangeAutoFormatSimple = -4154;
 var xlRangeAutoFormatTable1 = 32;
 var xlRangeAutoFormatTable10 = 41;
 var xlRangeAutoFormatTable2 = 33;
 var xlRangeAutoFormatTable3 = 34;
 var xlRangeAutoFormatTable4 = 35;
 var xlRangeAutoFormatTable5 = 36;
 var xlRangeAutoFormatTable6 = 37;
 var xlRangeAutoFormatTable7 = 38;
 var xlRangeAutoFormatTable8 = 39;
 var xlRangeAutoFormatTable9 = 40;
 
// XlRangeValueDataType  
 var xlRangeValueDefault = 10;
 var xlRangeValueMSPersistXML = 12;
 var xlRangeValueXMLSpreadsheet = 11;
 
// XlReferenceStyle  
 var xlA1 = 1;
 var xlR1C1 = -4150;
 
// XlReferenceType  
 var xlAbsolute = 1;
 var xlAbsRowRelColumn = 2;
 var xlRelative = 4;
 var xlRelRowAbsColumn = 3;
 
// XlRobustConnect  
 var xlAlways = 1;
 var xlAsRequired = 0;
 var xlNever = 2;
 
// XlRoutingSlipDelivery  
 var xlAllAtOnce = 2;
 var xlOneAfterAnother = 1;
 
// XlRoutingSlipStatus  
 var xlNotYetRouted = 0;
 var xlRoutingComplete = 2;
 var xlRoutingInProgress = 1;
 
// XlRowCol  
 var xlColumns = 2;
 var xlRows = 1;
 
// XlRunAutoMacro  
 var xlAutoActivate = 3;
 var xlAutoClose = 2;
 var xlAutoDeactivate = 4;
 var xlAutoOpen = 1;
 
// XlSaveAction  
 var xlDoNotSaveChanges = 2;
 var xlSaveChanges = 1;
 
// XlSaveAsAccessMode  
 var xlExclusive = 3;
 var xlNoChange = 1;
 var xlShared = 2;
 
// XlSaveConflictResolution  
 var xlLocalSessionChanges = 2;
 var xlOtherSessionChanges = 3;
 var xlUserResolution = 1;
 
// XlScaleType  
 var xlScaleLinear = -4132;
 var xlScaleLogarithmic = -4133;
 
// XlSearchDirection  
 var xlNext = 1;
 var xlPrevious = 2;
 
// XlSearchOrder  
 var xlByColumns = 2;
 var xlByRows = 1;
 
// XlSearchWithin  
 var xlWithinSheet = 1;
 var xlWithinWorkbook = 2;
 
// XlSheetType  
 var xlChart = -4109;
 var xlDialogSheet = -4116;
 var xlExcel4IntlMacroSheet = 4;
 var xlExcel4MacroSheet = 3;
 var xlWorksheet = -4167;
 
// XlSheetVisibility  
 var xlSheetHidden = 0;
 var xlSheetVeryHidden = 2;
 var xlSheetVisible = -1;
 
// XlSizeRepresents  
 var xlSizeIsArea = 1;
 var xlSizeIsWidth = 2;
 
// XlSmartTagControlType  
 var xlSmartTagControlActiveX = 13;
 var xlSmartTagControlButton = 6;
 var xlSmartTagControlCheckbox = 9;
 var xlSmartTagControlCombo = 12;
 var xlSmartTagControlHelp = 3;
 var xlSmartTagControlHelpURL = 4;
 var xlSmartTagControlImage = 8;
 var xlSmartTagControlLabel = 7;
 var xlSmartTagControlLink = 2;
 var xlSmartTagControlListbox = 11;
 var xlSmartTagControlRadioGroup = 14;
 var xlSmartTagControlSeparator = 5;
 var xlSmartTagControlSmartTag = 1;
 var xlSmartTagControlTextbox = 10;
 
// XlSmartTagDisplayMode  
 var xlButtonOnly = 2;
 var xlDisplayNone = 1;
 var xlIndicatorAndButton = 0;
 
// XlSortDataOption  
 var xlSortNormal = 0;
 var xlSortTextAsNumbers = 1;
 
// XlSortMethod  
 var xlPinYin = 1;
 var xlStroke = 2;
 
// XlSortMethodOld  
 var xlCodePage = 2;
 var xlSyllabary = 1;
 
// XlSortOrder  
 var xlAscending = 1;
 var xlDescending = 2;
 
// XlSortOrientation  
 var xlSortColumns = 1;
 var xlSortRows = 2;
 
// XlSortType  
 var xlSortLabels = 2;
 var xlSortValues = 1;
 
// XlSourceType  
 var xlSourceAutoFilter = 3;
 var xlSourceChart = 5;
 var xlSourcePivotTable = 6;
 var xlSourcePrintArea = 2;
 var xlSourceQuery = 7;
 var xlSourceRange = 4;
 var xlSourceSheet = 1;
 var xlSourceWorkbook = 0;
 
// XlSpeakDirection  
 var xlSpeakByColumns = 1;
 var xlSpeakByRows = 0;
 
// XlSpecialCellsValue  
 var xlErrors = 16;
 var xlLogical = 4;
 var xlNumbers = 1;
 var xlTextValues = 2;
 
// XlSubscribeToFormat  
 var xlSubscribeToPicture = -4147;
 var xlSubscribeToText = -4158;
 
// XlSubtototalLocationType  
 var xlAtBottom = 2;
 var xlAtTop = 1;
 
// XlSummaryColumn  
 var xlSummaryOnLeft = -4131;
 var xlSummaryOnRight = -4152;
 
// XlSummaryReportType  
 var xlStandardSummary = 1;
 var xlSummaryPivotTable = -4148;
 
// XlSummaryRow  
 var xlSummaryAbove = 0;
 var xlSummaryBelow = 1;
 
// XlTabPosition  
 var xlTabPositionFirst = 0;
 var xlTabPositionLast = 1;
 
// XlTextParsingType  
 var xlDelimited = 1;
 var xlFixedWidth = 2;
 
// XlTextQualifier  
 var xlTextQualifierDoubleQuote = 1;
 var xlTextQualifierNone = -4142;
 var xlTextQualifierSingleQuote = 2;
 
// XlTextVisualLayoutType  
 var xlTextVisualLTR = 1;
 var xlTextVisualRTL = 2;
 
// XlTickLabelOrientation  
 var xlTickLabelOrientationAutomatic = -4105;
 var xlTickLabelOrientationDownward = -4170;
 var xlTickLabelOrientationHorizontal = -4128;
 var xlTickLabelOrientationUpward = -4171;
 var xlTickLabelOrientationVertical = -4166;
 
// XlTickLabelPosition  
 var xlTickLabelPositionHigh = -4127;
 var xlTickLabelPositionLow = -4134;
 var xlTickLabelPositionNextToAxis = 4;
 var xlTickLabelPositionNone = -4142;
 
// XlTickMark  
 var xlTickMarkCross = 4;
 var xlTickMarkInside = 2;
 var xlTickMarkNone = -4142;
 var xlTickMarkOutside = 3;
 
// XlTimeUnit  
 var xlDays = 0;
 var xlMonths = 1;
 var xlYears = 2;
 
// XlToolbarProtection  
 var xlNoButtonChanges = 1;
 var xlNoChanges = 4;
 var xlNoDockingChanges = 3;
 var xlNoShapeChanges = 2;
 var xlToolbarProtectionNone = -4143;
 
// XlTotalsCalculation  
 var xlTotalsCalculationAverage = 2;
 var xlTotalsCalculationCount = 3;
 var xlTotalsCalculationCountNums = 4;
 var xlTotalsCalculationMax = 6;
 var xlTotalsCalculationMin = 5;
 var xlTotalsCalculationNone = 0;
 var xlTotalsCalculationStdDev = 7;
 var xlTotalsCalculationSum = 1;
 var xlTotalsCalculationVar = 8;
 
// XlTrendlineType  
 var xlExponential = 5;
 var xlLinear = -4132;
 var xlLogarithmic = -4133;
 var xlMovingAvg = 6;
 var xlPolynomial = 3;
 var xlPower = 4;
 
// XlUnderlineStyle  
 var xlUnderlineStyleDouble = -4119;
 var xlUnderlineStyleDoubleAccounting = 5;
 var xlUnderlineStyleNone = -4142;
 var xlUnderlineStyleSingle = 2;
 var xlUnderlineStyleSingleAccounting = 4;
 
// XlUpdateLinks  
 var xlUpdateLinksAlways = 3;
 var xlUpdateLinksNever = 2;
 var xlUpdateLinksUserSetting = 1;
 
// XlVAlign  
 var xlVAlignBottom = -4107;
 var xlVAlignCenter = -4108;
 var xlVAlignDistributed = -4117;
 var xlVAlignJustify = -4130;
 var xlVAlignTop = -4160;
 
// XlWBATemplate  
 var xlWBATChart = -4109;
 var xlWBATExcel4IntlMacroSheet = 4;
 var xlWBATExcel4MacroSheet = 3;
 var xlWBATWorksheet = -4167;
 
// XlWebFormatting  
 var xlWebFormattingAll = 1;
 var xlWebFormattingNone = 3;
 var xlWebFormattingRTF = 2;
 
// XlWebSelectionType  
 var xlAllTables = 2;
 var xlEntirePage = 1;
 var xlSpecifiedTables = 3;
 
// XlWindowState  
 var xlMaximized = -4137;
 var xlMinimized = -4140;
 var xlNormal = -4143;
 
// XlWindowType  
 var xlChartAsWindow = 5;
 var xlChartInPlace = 4;
 var xlClipboard = 3;
 var xlInfo = -4129;
 var xlWorkbook = 1;
 
// XlWindowView  
 var xlNormalView = 1;
 var xlPageBreakPreview = 2;
 
// XlXLMMacroType  
 var xlCommand = 2;
 var xlFunction = 1;
 var xlNotXLM = 3;
 
// XlXmlExportResult  
 var xlXmlExportSuccess = 0;
 var xlXmlExportValidationFailed = 1;
 
// XlXmlImportResult  
 var xlXmlImportElementsTruncated = 1;
 var xlXmlImportSuccess = 0;
 var xlXmlImportValidationFailed = 2;
 
// XlXmlLoadOption  
 var xlXmlLoadImportToList = 2;
 var xlXmlLoadMapXml = 3;
 var xlXmlLoadOpenXml = 1;
 var xlXmlLoadPromptUser = 0;
 
// XlYesNoGuess  
 var xlGuess = 0;
 var xlNo = 2;
 var xlYes = 1;


Aller à :
Ajouter une réponse
  FORUM HardWare.fr
  Programmation
  API Win32

  Excel OLE Automation : comment acceder aux constantes ?

 

Sujets relatifs
Excel : ajuster hauteur de la celulle par VBARecherche dans tableau multi dimension Excel
mettre des valeurs booléennes vba excelRegrouper des fichiers excel en un seul par bouton vba
Acceder à un tableau via une seule variable via un pointeur?Sauvegarder un seul onglet (VBA) Excel
Aquerir dans Excel des données venant de fichiers txtJasper Reporting Excel
Copier / Coller ligne entre fichiers excel[VBAExcel Résolu] Copier coller de excel dans word
Plus de sujets relatifs à : Excel OLE Automation : comment acceder aux constantes ?


Copyright © 1997-2022 Hardware.fr SARL (Signaler un contenu illicite / Données personnelles) / Groupe LDLC / Shop HFR