搜索
12
返回列表 发新帖
楼主: quickerfans

EXCEL自动化操作 教程、示例代码收集贴

  [复制链接]

3

主题

58

帖子

585

积分

荣誉会员

Rank: 8Rank: 8

积分
585
发表于 2011-8-18 15:19:12 | 显示全部楼层

如果没有记错的话,xlToRight和xlDown这两个方法是有一点局限性的,好像是”数据单元格必须连续,就是中间必须每个格子都要有数据“,否则count到的列

如果没有记错的话,xlToRight和xlDown这两个方法是有一点局限性的,好像是”数据单元格必须连续,就是中间必须每个格子都要有数据“,否则count到的列数或行数会只统计到空格前。
建议用xlToleft和xlUp。
一般这样用:
asheet.cells(65536,aCol).end(xlup).row
asheet.cells(aRow,256).end(xltoleft).row
……
xlToleft和xlUp的值不记得了。
xl2003中的最大行是65536,列是256,xl2007要大得多,不记得了。

点评

同意: 5.0
同意: 5
xlLeft 1 xlright 2 xlup 3 xldown 4  发表于 2011-8-18 19:58
回复

使用道具 举报

1

主题

51

帖子

636

积分

三级会员

Rank: 4

积分
636
发表于 2011-8-18 15:21:30 | 显示全部楼层

对于不连续的区域一般在输出时进行处理,或者利用specialcells先定位到常量单元格,再循环各个area进行处理,我的个人经验是这样的,仅供参考。

对于不连续的区域一般在输出时进行处理,或者利用specialcells先定位到常量单元格,再循环各个area进行处理,我的个人经验是这样的,仅供参考。
回复

使用道具 举报

6

主题

167

帖子

903

积分

荣誉会员

爱生活,爱拉芳。

Rank: 8Rank: 8

积分
903
 楼主| 发表于 2011-8-28 15:18:29 | 显示全部楼层

[i=s] 本帖最后由 quickerfans 于 2011-8-28 15:19 编辑 [/i] EXCEL 查找替换示例代码 replace是一个过程(

本帖最后由 quickerfans 于 2011-8-28 15:19 编辑

EXCEL 查找替换示例代码
replace是一个过程(函数)后面是所需的参数。参数的具体含义可以查找EXCEL VBA参考,
与录制的宏有所区别。
sheet.Columns(5).Replace("null","",2,1,False,False,False);

+++++++++++++++++++++
        //从sheet(1)中的数据整理到sheet(2)作为报表,打印;
++++++++++++++++++++++++++++++

  1.          excel = com.CreateObject("Excel.Application");        
  2.                //var book = excel.Workbooks.Add();
  3.         //var sheet = book.Worksheets(2);
  4.         //打开工作薄
  5.         var book=excel.Workbooks.open("c:"++winform.editzyh.text++".xls");
  6.         //创建sheet2对象
  7.         var sheet2=book.Worksheets(2);
  8.         var sheet1=book.Worksheets(1);
  9.         //让sheet2做为当前表显示出来
  10.         sheet2.Activate()
  11.         //设定字体
  12.         sheet2.Cells.font.size=9
  13.         //自动适应行列宽        
  14.         sheet2.Cells.Columns.AutoFit()
  15.         sheet2.Cells.Rows.AutoFit()
  16.         excel.Visible = true;
  17.         //获取表1总行数;
  18.         k1=sheet1.cells(1,1).end(-4121).row;
  19.         //1到总行数计数
  20.         for(j=1;k1;1){
  21.         //取表1第4列到每9列的数据
  22.                 for(i=4;9;1){
  23.         //表2第一行已填充列名,取表1第一行第4列数据填充到从第二行第一列..依次循环
  24.                 sheet2.Cells(j+1,i-3).value2=sheet1.Cells(j,i).value2            
  25.         
  26.                        };               
  27.         };

  28.         //取表2总行数,汇总F列第二行到最后一行的数据到最下面的单元格。
  29.         k2=sheet2.cells(1,1).end(-4121).row;
  30.         sheet2.Range("F"++k2+1).value2="=sum(F"+2+":"+"F"+k2+")"
  31.         //设置边框
  32.         sheet2.Range("A1:F"++k2+1).borders.LineStyle=1;
  33.         sheet2.Range("A1:F"++k2+1).borders.Weight = 2/*xlThin*/

  34.         //设定每一列列宽
  35.         sheet2.Columns.ColumnWidth = 8;
  36.         //单独设定第一列列宽
  37.         sheet2.Columns(1).ColumnWidth = 18;
复制代码

专注、深入。
回复

使用道具 举报

6

主题

167

帖子

903

积分

荣誉会员

爱生活,爱拉芳。

Rank: 8Rank: 8

积分
903
 楼主| 发表于 2011-8-28 15:49:35 | 显示全部楼层

[i=s] 本帖最后由 quickerfans 于 2011-8-28 16:17 编辑 [/i] 单元格有三个类似的 [color=red]属性 值[/co

本帖最后由 quickerfans 于 2011-8-28 16:17 编辑

单元格有三个类似的 属性 值

VALUE  是返回单元格的值,Variant 型,只读
VALUE2 也是返回或设置单元格的值,Variant 型,可读可写
TEXT:返回单元格的文本。String 型,只读

Value2 属性和 Value 属性的唯一区别在于 Value2 属性不使用 Currency 和 Date 数据类型。通过使用 Double 数据类型,可将用这些数据类型设置格式的数据按浮点数字返回
Value和Value2其实没有本质区别,用.NET的行话说其实就是一种重载,用VB的来说其实是一种或选参数   

Value可带一参数,把定值的数据类型   
Value2 不带参数   

专注、深入。
回复

使用道具 举报

1

主题

51

帖子

636

积分

三级会员

Rank: 4

积分
636
发表于 2011-8-28 21:19:02 | 显示全部楼层

[i=s] 本帖最后由 Kevinch 于 2011-8-28 21:21 编辑 [/i] 单元格值一共四个属性: formula 真实内容 valu

本帖最后由 Kevinch 于 2011-8-28 21:21 编辑

单元格值一共四个属性:
formula   真实内容
value       可能是实际值或公式结果
value2     日期值的单元格用这个可以取得对应的数值
text         受单元格格式影响,取得的结果为实际显示内容
回复

使用道具 举报

185

主题

2541

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
13973
发表于 2011-9-17 10:43:29 | 显示全部楼层

[quote][size=2][color=#999999]vqimwr 发表于 2011-8-18 15:19[/color] [url=forum.php?

vqimwr 发表于 2011-8-18 15:19
如果没有记错的话,xlToRight和xlDown这两个方法是有一点局限性的,好像是”数据单元格必须连续,就是中间必 ...

在工具里有个com对象常量导出工具,输入"Excel.Application",然后点导出就可以了

//枚举定义开始 Excel.Application;

XlParameterType={
xlPrompt=0;
xlRange=2;
xlConstant=1
};

XlErrorBarInclude={
xlErrorBarIncludeBoth=1;
xlErrorBarIncludeNone=-4142;
xlErrorBarIncludeMinusValues=3;
xlErrorBarIncludePlusValues=2
};

XlErrorChecks={
xlListDataValidation=8;
xlInconsistentFormula=4;
xlEmptyCellReferences=7;
xlOmittedCells=5;
xlEvaluateToError=1;
xlUnlockedFormulaCells=6;
xlInconsistentListFormula=9;
xlTextDate=2;
xlNumberAsText=3
};

XlReferenceStyle={
xlR1C1=-4150;
xlA1=1
};

XlFileFormat={
xlCurrentPlatformText=-4158;
xlAddIn=18;
xlWorks2FarEast=28;
xlWorkbookNormal=-4143;
xlOpenDocumentSpreadsheet=60;
xlTextMac=19;
xlTextWindows=20;
xlIntlAddIn=26;
xlWorkbookDefault=51;
xlWJ2WD1=14;
xlTemplate=17;
xlExcel2=16;
xlWebArchive=45;
xlDBF4=11;
xlCSVWindows=23;
xlCSVMac=22;
xlOpenXMLTemplate=54;
xlWQ1=34;
xlCSVMSDOS=24;
xlWK1FMT=30;
xlExcel7=39;
xlUnicodeText=42;
xlExcel4Workbook=35;
xlCSV=6;
xlExcel4=33;
xlWK1=5;
xlWK3FM3=32;
xlDBF2=7;
xlSYLK=2;
xlDIF=9;
xlHtml=44;
xlWK3=15;
xlWJ3=40;
xlExcel2FarEast=27;
xlWKS=4;
xlExcel3=29;
xlExcel5=39;
xlOpenXMLTemplateMacroEnabled=53;
xlWK1ALL=31;
xlExcel9795=43;
xlIntlMacro=25;
xlDBF3=8;
xlXMLSpreadsheet=46;
xlOpenXMLWorkbook=51;
xlTextPrinter=36;
xlTemplate8=17;
xlOpenXMLWorkbookMacroEnabled=52;
xlAddIn8=18;
xlTextMSDOS=21;
xlExcel12=50;
xlOpenXMLAddIn=55;
xlWJ3FJ3=41;
xlWK4=38;
xlExcel8=56
};

XlSmartTagControlType={
xlSmartTagControlCheckbox=9;
xlSmartTagControlListbox=11;
xlSmartTagControlTextbox=10;
xlSmartTagControlImage=8;
xlSmartTagControlSmartTag=1;
xlSmartTagControlCombo=12;
xlSmartTagControlHelp=3;
xlSmartTagControlLink=2;
xlSmartTagControlHelpURL=4;
xlSmartTagControlActiveX=13;
xlSmartTagControlSeparator=5;
xlSmartTagControlRadioGroup=14;
xlSmartTagControlButton=6;
xlSmartTagControlLabel=7
};

XlErrorBarType={
xlErrorBarTypeStError=4;
xlErrorBarTypeCustom=-4114;
xlErrorBarTypeFixedValue=1;
xlErrorBarTypePercent=2;
xlErrorBarTypeStDev=-4155
};

XlUpdateLinks={
xlUpdateLinksNever=2;
xlUpdateLinksAlways=3;
xlUpdateLinksUserSetting=1
};

XlUnderlineStyle={
xlUnderlineStyleNone=-4142;
xlUnderlineStyleSingle=2;
xlUnderlineStyleSingleAccounting=4;
xlUnderlineStyleDouble=-4119;
xlUnderlineStyleDoubleAccounting=5
};

XlEditionOptionsOption={
xlAutomaticUpdate=4;
xlCancel=1;
xlSendPublisher=2;
xlOpenSource=3;
xlChangeAttributes=6;
xlUpdateSubscriber=2;
xlManualUpdate=5;
xlSelect=3
};

XlPivotTableVersionList={
xlPivotTableVersionCurrent=-1;
xlPivotTableVersion11=2;
xlPivotTableVersion10=1;
xlPivotTableVersion2000=0;
xlPivotTableVersion12=3
};

XlTickLabelOrientation={
xlTickLabelOrientationDownward=-4170;
xlTickLabelOrientationHorizontal=-4128;
xlTickLabelOrientationAutomatic=-4105;
xlTickLabelOrientationUpward=-4171;
xlTickLabelOrientationVertical=-4166
};

XlSummaryReportType={
xlSummaryPivotTable=-4148;
xlStandardSummary=1
};

XlClipboardFormat={
xlClipboardFormatBinary=15;
xlClipboardFormatVALU=1;
xlClipboardFormatLink=11;
xlClipboardFormatEmbedSource=22;
xlClipboardFormatLinkSourceDesc=32;
xlClipboardFormatBIFF=8;
xlClipboardFormatToolFacePICT=26;
xlClipboardFormatRTF=7;
xlClipboardFormatStandardScale=27;
xlClipboardFormatSYLK=6;
xlClipboardFormatScreenPICT=29;
xlClipboardFormatDIF=4;
xlClipboardFormatBitmap=9;
xlClipboardFormatWK1=10;
xlClipboardFormatBIFF3=20;
xlClipboardFormatOwnerLink=17;
xlClipboardFormatTable=16;
xlClipboardFormatPrintPICT=3;
xlClipboardFormatCSV=5;
xlClipboardFormatBIFF2=18;
xlClipboardFormatLinkSource=23;
xlClipboardFormatStandardFont=28;
xlClipboardFormatText=0;
xlClipboardFormatBIFF12=63;
xlClipboardFormatEmbeddedObject=21;
xlClipboardFormatObjectLink=19;
xlClipboardFormatBIFF4=30;
xlClipboardFormatToolFace=25;
xlClipboardFormatCGM=13;
xlClipboardFormatMovie=24;
xlClipboardFormatPICT=2;
xlClipboardFormatDspText=12;
xlClipboardFormatObjectDesc=31;
xlClipboardFormatNative=14
};

XlMSApplication={
xlMicrosoftWord=1;
xlMicrosoftPowerPoint=2;
xlMicrosoftProject=6;
xlMicrosoftMail=3;
xlMicrosoftFoxPro=5;
xlMicrosoftSchedulePlus=7;
xlMicrosoftAccess=4
};

XlToolbarProtection={
xlNoShapeChanges=2;
xlToolbarProtectionNone=-4143;
xlNoChanges=4;
xlNoButtonChanges=1;
xlNoDockingChanges=3
};

XlPivotTableMissingItems={
xlMissingItemsDefault=-1;
xlMissingItemsMax2=1048576;
xlMissingItemsMax=32500;
xlMissingItemsNone=0
};

XlHAlign={
xlHAlignFill=5;
xlHAlignJustify=-4130;
xlHAlignCenterAcrossSelection=7;
xlHAlignRight=-4152;
xlHAlignGeneral=1;
xlHAlignCenter=-4108;
xlHAlignDistributed=-4117;
xlHAlignLeft=-4131
};

XlInsertFormatOrigin={
xlFormatFromRightOrBelow=1;
xlFormatFromLeftOrAbove=0
};

XlTabPosition={
xlTabPositionFirst=0;
xlTabPositionLast=1
};

XlBuiltInDialog={
xlDialogCalculation=32;
xlDialogDataValidation=525;
xlDialogAutoCorrect=485;
xlDialogOverlay=86;
xlDialogNameManager=977;
xlDialogZoom=256;
xlDialogSetBackgroundPicture=509;
xlDialogSubtotalCreate=398;
xlDialogMyPermission=834;
xlDialogInsertHyperlink=596;
xlDialogFormatText=89;
xlDialogPivotCalculatedItem=572;
xlDialogNewName=978;
xlDialogImportTextFile=666;
xlDialogWebOptionsBrowsers=773;
xlDialogApplyStyle=212;
xlDialogAlignment=43;
xlDialogOverlayChartType=186;
xlDialogEditionOptions=251;
xlDialogProtectSharing=620;
xlDialogFileDelete=6;
xlDialogStandardWidth=472;
xlDialogWebOptionsPictures=685;
xlDialogDefineName=61;
xlDialogPrinterSetup=9;
xlDialogMenuEditor=322;
xlDialogPivotTableOptions=567;
xlDialogDataLabel=379;
xlDialogScale=87;
xlDialogWebOptionsFiles=684;
xlDialogArrangeAll=12;
xlDialogWindowSize=13;
xlDialogWindowMove=14;
xlDialogRun=17;
xlDialogSetPrintTitles=23;
xlDialogFormatMove=128;
xlDialogFormatFont=150;
xlDialogSummaryInfo=474;
xlDialogChartOptionsDataLabels=505;
xlDialogGallery3dArea=193;
xlDialogDisplay=27;
xlDialogWebOptionsEncoding=686;
xlDialogGalleryArea=67;
xlDialogProtectDocument=28;
xlDialogWorkbookProtect=417;
xlDialogClear=52;
xlDialogOptionsGeneral=356;
xlDialogWorkbookName=386;
xlDialogExtract=35;
xlDialogDeleteFormat=111;
xlDialogDataDelete=36;
xlDialogSort=39;
xlDialogDataSeries=40;
xlDialogGalleryBar=68;
xlDialogSeriesY=462;
xlDialogVbaInsertFile=328;
xlDialogFormatNumber=42;
xlDialogPropertyFields=754;
xlDialogFormulaFind=64;
xlDialogInsertNameLabel=496;
xlDialogUpdateLink=201;
xlDialogWorkgroup=199;
xlDialogColumnWidth=47;
xlDialogFilterAdvanced=370;
xlDialogAddinManager=321;
xlDialogPasteSpecial=53;
xlDialogOptionsTransition=355;
xlDialogSearch=731;
xlDialogPivotFieldGroup=433;
xlDialogAddChartAutoformat=390;
xlDialogEditDelete=54;
xlDialogInsert=55;
xlDialogFileSharing=481;
xlDialogVbaMakeAddin=478;
xlDialogGalleryScatter=72;
xlDialogPasteNames=58;
xlDialogListboxProperties=437;
xlDialogSendMail=189;
xlDialogDataLabelMultiple=723;
xlDialogPrint=8;
xlDialogGridlines=76;
xlDialogAttachToolbars=323;
xlDialogCreateNames=62;
xlDialogSeriesOptions=557;
xlDialogFormulaGoto=63;
xlDialogBorder=45;
xlDialogFormatCharttype=423;
xlDialogTable=41;
xlDialogApplyNames=133;
xlDialogGalleryColumn=69;
xlDialogGalleryLine=70;
xlDialogPermission=832;
xlDialogTextToColumns=422;
xlDialogChangeLink=166;
xlDialogVbaProcedureDefinition=330;
xlDialogMailNextLetter=378;
xlDialogGalleryCustom=388;
xlDialogGalleryDoughnut=344;
xlDialogSeriesX=461;
xlDialogGalleryPie=71;
xlDialogWorkbookUnhide=384;
xlDialogScenarioMerge=473;
xlDialogChartAddData=392;
xlDialogFormulaReplace=130;
xlDialogFilter=447;
xlDialogAttachText=80;
xlDialogCreatePublisher=217;
xlDialogMainChart=85;
xlDialogDeleteName=110;
xlDialogConditionalFormatting=583;
xlDialogShowToolbar=220;
xlDialogErrorbarX=463;
xlDialogFillWorkgroup=301;
xlDialogEditboxProperties=438;
xlDialogAssignToTool=293;
xlDialogMailLogon=339;
xlDialogGallery3dLine=195;
xlDialogParse=91;
xlDialogEditSeries=228;
xlDialogPushbuttonProperties=445;
xlDialogUnhide=94;
xlDialogOpenText=441;
xlDialogWorkspace=95;
xlDialogCreateList=796;
xlDialogChartLocation=527;
xlDialogMove=262;
xlDialogActivate=103;
xlDialogDocumentInspector=862;
xlDialogGallery3dSurface=273;
xlDialogCopyPicture=108;
xlDialogPivotClientServerSet=689;
xlDialogFormatChart=465;
xlDialogWorkbookOptions=284;
xlDialogErrorbarY=464;
xlDialogNew=119;
xlDialogScrollbarProperties=420;
xlDialogCustomizeToolbar=276;
xlDialogFont=26;
xlDialogOptionsView=320;
xlDialogFormatSize=129;
xlDialogPivotFieldUngroup=434;
xlDialogCombination=73;
xlDialogSelectSpecial=132;
xlDialogObjectProperties=207;
xlDialogWorkbookTabSplit=415;
xlDialogFindFile=475;
_xlDialogChartSourceData=541;
xlDialogReplaceFont=134;
xlDialogSplit=137;
xlDialogGoalSeek=198;
xlDialogOutline=142;
xlDialogEditColor=223;
xlDialogSaveWorkbook=145;
xlDialogPhonetic=656;
xlDialogStandardFont=190;
xlDialogOptionsCalculation=318;
xlDialogAxes=78;
xlDialogSetUpdateStatus=159;
xlDialogInsertObject=259;
xlDialogColorPalette=161;
xlDialogWebOptionsFonts=687;
xlDialogEvaluateFormula=709;
xlDialogAppSize=171;
xlDialogFormatLegend=88;
xlDialogPrintPreview=222;
xlDialogChartOptionsDataTable=506;
xlDialogSortSpecial=192;
xlDialogPlacement=300;
xlDialogChartOptionsDataLabelMultiple=724;
xlDialogGallery3dColumn=194;
xlDialogGallery3dPie=196;
xlDialogPivotFieldProperties=313;
xlDialogWorkbookMove=282;
xlDialogProperties=474;
xlDialogDefineStyle=229;
xlDialogPromote=202;
xlDialogCellProtection=46;
xlDialogInsertPicture=342;
xlDialogFillGroup=200;
xlDialogPivotCalculatedField=570;
xlDialogView3d=197;
xlDialogDemote=203;
xlDialogShowDetail=204;
xlDialogSaveNewObject=208;
xlDialogChartType=526;
xlDialogCheckboxProperties=435;
xlDialogFunctionWizard=450;
xlDialogOpenLinks=2;
xlDialogOptionsListsAdd=458;
xlDialogAssignToObject=213;
xlDialogObjectProtection=214;
xlDialogPatterns=84;
xlDialogSubscribeTo=218;
_xlDialogPhonetic=538;
xlDialogOpenMail=188;
xlDialogFormatMain=225;
xlDialogFormatOverlay=226;
xlDialogScenarioAdd=307;
xlDialogGalleryRadar=249;
xlDialogNewWebQuery=667;
xlDialogSaveAs=5;
xlDialogConsolidate=191;
xlDialogFormatAuto=269;
xlDialogGallery3dBar=272;
xlDialogNote=154;
xlDialogRowHeight=127;
xlDialogTabOrder=394;
xlDialogWorkbookAdd=281;
xlDialogSeriesShape=504;
xlDialogWebOptionsGeneral=683;
xlDialogAppMove=170;
xlDialogSaveWorkspace=285;
xlDialogExternalDataProperties=530;
xlDialogSeriesAxes=460;
xlDialogChartWizard=288;
xlDialogInsertTitle=380;
xlDialogPivotTableWizard=312;
xlDialogCustomViews=493;
xlDialogWorkbookInsert=354;
xlDialogScenarioSummary=311;
xlDialogOptionsEdit=319;
xlDialogPivotSolveOrder=568;
xlDialogScenarioCells=305;
xlDialogScenarioEdit=308;
xlDialogFontProperties=381;
xlDialogCopyChart=147;
xlDialogOpen=1;
xlDialogActiveCellFont=476;
xlDialogWorkbookNew=302;
xlDialogSaveCopyAs=456;
xlDialogOptionsME=647;
xlDialogChartTrend=350;
xlDialogMacroOptions=382;
xlDialogOptionsChart=325;
xlDialogRoutingSlip=336;
xlDialogPublishAsWebPage=653;
xlDialogPivotShowPages=421;
xlDialogWorkbookCopy=283;
xlDialogMainChartType=185;
xlDialogSize=261;
xlDialogChartSourceData=540;
xlDialogStyle=44;
xlDialogSeriesOrder=466;
xlDialogErrorChecking=732;
xlDialogLabelProperties=436;
xlDialogMailEditMailer=470;
xlDialogPageSetup=7
};

XlCalculationState={
xlCalculating=1;
xlDone=0;
xlPending=2
};

XlThemeColor={
xlThemeColorAccent1=5;
xlThemeColorAccent4=8;
xlThemeColorDark1=1;
xlThemeColorHyperlink=11;
xlThemeColorLight1=2;
xlThemeColorAccent2=6;
xlThemeColorAccent6=10;
xlThemeColorAccent3=7;
xlThemeColorAccent5=9;
xlThemeColorLight2=4;
xlThemeColorFollowedHyperlink=12;
xlThemeColorDark2=3
};

XlDisplayDrawingObjects={
xlDisplayShapes=-4104;
xlHide=3;
xlPlaceholders=2
};

XlFixedFormatType={
xlTypePDF=0;
xlTypeXPS=1
};

XlTopBottom={
xlTop10Top=1;
xlTop10Bottom=0
};

XlPivotConditionScope={
xlFieldsScope=1;
xlSelectionScope=0;
xlDataFieldScope=2
};

Constants={
xlDirect=1;
xlDesktop=9;
xlTiled=1;
xlMixedScript=3;
xlAbove=0;
xlExtended=3;
xlMacrosheetCell=7;
xlColor1=7;
xlShort=1;
xlList2=11;
xlFill=5;
xlLeft=-4131;
xlFixedValue=1;
xlFloating=5;
xlBelow=1;
xlContext=-5002;
xlOutside=3;
xlOn=1;
xlHindiNumerals=3;
xlPlus=9;
xlCascade=7;
xlExcelMenus=1;
xlDoubleOpen=4;
xlOpen=2;
xlStrict=2;
xlCrissCross=16;
xl3DEffects1=13;
xlVisualCursor=2;
xlLotusHelp=2;
xlColumn=3;
xlNoDocuments=3;
xlAccounting2=5;
xlTextBox=16;
xlSimple=-4154;
xlTitleBar=8;
xlLeftToRight=2;
xl3DSurface=-4103;
xlNarrow=1;
xlLightDown=13;
xlRTL=-5004;
xlBidiCalendar=3;
xlNone=-4142;
xl3DBar=-4099;
xlGray50=-4125;
xlLocalFormat1=15;
xlDoubleQuote=1;
xlCorner=2;
xlAccounting4=17;
xlMixed=2;
xlGray8=18;
xlGregorian=2;
xlInside=2;
xlPartial=3;
xlMinimum=4;
xlChartShort=6;
xlLastCell=11;
xlPartialScript=2;
xlFormats=-4122;
xlReference=4;
xlBar=2;
xl3DEffects2=14;
xlInteger=2;
xlClassic2=2;
xlWide=3;
xlOff=-4146;
xlSystem=1;
xlChartTitles=18;
xlLightHorizontal=11;
xlClassic1=1;
xlAccounting1=4;
xlVeryHidden=2;
xlMinusValues=3;
xlJustify=-4130;
xlSemiautomatic=2;
xlAccounting3=6;
xlSolid=1;
xlNotes=-4144;
xlChartSeries=17;
xlSemiGray75=10;
xlClosed=3;
xlAllExceptBorders=7;
xlLatin=-5001;
xlCenterAcrossSelection=7;
xlShowLabelAndPercent=5;
xlGrid=15;
xlPlusValues=2;
xlCross=4;
xlStError=4;
xlList1=10;
xlColor2=8;
xlCustom=-4114;
xlTransparent=2;
xlGridline=22;
xlFirst=0;
xlEntireChart=20;
xlOpaque=3;
xlAutomatic=-4105;
xlLast=1;
xlToolbar=1;
xlMixedAuthorizedScript=4;
xlCenter=-4108;
xlWorksheetCell=3;
xlCircle=8;
xlDiamond=2;
xlLong=3;
xlDebugCodePane=13;
xlDistributed=-4117;
xlDivide=5;
xlGray25=-4124;
xlSquare=1;
xlGray16=17;
xlHigh=-4127;
xlAdd=2;
xlLightUp=14;
xlAll=-4104;
xlColor3=9;
xlLow=-4134;
xlManual=-4135;
xlFullScript=1;
xlMultiply=4;
xlPercent=2;
xlList3=12;
xlContents=2;
xlCombination=-4111;
xlShowLabel=4;
xlDrawingObject=14;
xlShowPercent=3;
xlLTR=-5003;
xlShowValue=2;
xlImmediatePane=12;
xlLightVertical=12;
xlSingle=2;
xlSingleAccounting=4;
xlSingleQuote=2;
xlFormula=5;
xlConstants=2;
xlBoth=1;
xlToolbarButton=2;
xlTriangle=3;
xlVisible=12;
xlChecker=9;
xlDoubleAccounting=5;
xlChart4=2;
xlGray75=-4126;
xlComplete=4;
xlBottom=-4107;
xlRight=-4152;
xlTop=-4160;
xlWorkbookTab=6;
xlStar=5;
xlWatchPane=11;
xlNextToAxis=4;
xlWorksheet4=1;
xlLogicalCursor=1;
xlMaximum=2;
xlTopToBottom=1;
xlSubtract=3;
xlModule=-4141;
xlDoubleClosed=5;
xlGeneral=1;
xlIcons=1;
xlDefaultAutoFormat=-1;
xlBidi=-5000;
xlWorksheetShort=5;
xlScale=3;
xlClassic3=3;
xlLocalFormat2=16
};

XlConditionValueTypes={
xlConditionValueHighestValue=2;
xlConditionValueLowestValue=1;
xlConditionValueNone=-1;
xlConditionValuePercent=3;
xlConditionValueNumber=0;
xlConditionValuePercentile=5;
xlConditionValueFormula=4
};

XlSummaryRow={
xlSummaryAbove=0;
xlSummaryBelow=1
};

XlFormulaLabel={
xlMixedLabels=3;
xlNoLabels=-4142;
xlRowLabels=1;
xlColumnLabels=2
};

XlSortMethod={
xlPinYin=1;
xlStroke=2
};

XlSaveConflictResolution={
xlOtherSessionChanges=3;
xlUserResolution=1;
xlLocalSessionChanges=2
};

XlSmartTagDisplayMode={
xlDisplayNone=1;
xlIndicatorAndButton=0;
xlButtonOnly=2
};

XlCubeFieldSubType={
xlCubeSet=3;
xlCubeKPIValue=6;
xlCubeHierarchy=1;
xlCubeMeasure=2;
xlCubeKPIWeight=10;
xlCubeAttribute=4;
xlCubeKPIStatus=8;
xlCubeKPITrend=9;
xlCubeKPIGoal=7;
xlCubeCalculatedMeasure=5
};

XlCreator={
xlCreatorCode=1480803660
};

XlChartGallery={
xlAnyGallery=23;
xlUserDefined=22;
xlBuiltIn=21
};

XlSpecialCellsValue={
xlTextValues=2;
xlErrors=16;
xlNumbers=1;
xlLogical=4
};

XlColorIndex={
xlColorIndexNone=-4142;
xlColorIndexAutomatic=-4105
};

XlFormControl={
xlDropDown=2;
xlLabel=5;
xlListBox=6;
xlEditBox=3;
xlButtonControl=0;
xlCheckBox=1;
xlGroupBox=4;
xlScrollBar=8;
xlOptionButton=7;
xlSpinner=9
};

XlLegendPosition={
xlLegendPositionCustom=-4161;
xlLegendPositionRight=-4152;
xlLegendPositionLeft=-4131;
xlLegendPositionCorner=2;
xlLegendPositionBottom=-4107;
xlLegendPositionTop=-4160
};

XlRoutingSlipDelivery={
xlAllAtOnce=2;
xlOneAfterAnother=1
};

XlAutoFillType={
xlFillWeekdays=6;
xlFillValues=4;
xlGrowthTrend=10;
xlFillSeries=2;
xlFillMonths=7;
xlFillFormats=3;
xlFillDays=5;
xlFillCopy=1;
xlLinearTrend=9;
xlFillDefault=0;
xlFillYears=8
};

XlRowCol={
xlRows=1;
xlColumns=2
};

XlCategoryType={
xlCategoryScale=2;
xlTimeScale=3;
xlAutomaticScale=-4105
};

XlScaleType={
xlScaleLogarithmic=-4133;
xlScaleLinear=-4132
};

XlPasteType={
xlPasteComments=-4144;
xlPasteValidation=6;
xlPasteFormulasAndNumberFormats=11;
xlPasteValues=-4163;
xlPasteAll=-4104;
xlPasteFormats=-4122;
xlPasteAllExceptBorders=7;
xlPasteColumnWidths=8;
xlPasteAllUsingSourceTheme=13;
xlPasteFormulas=-4123;
xlPasteValuesAndNumberFormats=12
};

XlLookAt={
xlPart=2;
xlWhole=1
};

XlWindowType={
xlClipboard=3;
xlChartAsWindow=5;
xlChartInPlace=4;
xlInfo=-4129;
xlWorkbook=1
};

XlWindowView={
xlPageBreakPreview=2;
xlPageLayoutView=3;
xlNormalView=1
};

XlMarkerStyle={
xlMarkerStyleDiamond=2;
xlMarkerStyleStar=5;
xlMarkerStyleDash=-4115;
xlMarkerStyleCircle=8;
xlMarkerStyleNone=-4142;
xlMarkerStyleDot=-4118;
xlMarkerStyleAutomatic=-4105;
xlMarkerStyleTriangle=3;
xlMarkerStylePlus=9;
xlMarkerStyleSquare=1;
xlMarkerStylePicture=-4147;
xlMarkerStyleX=-4168
};

XlAxisCrosses={
xlAxisCrossesAutomatic=-4105;
xlAxisCrossesCustom=-4114;
xlAxisCrossesMinimum=4;
xlAxisCrossesMaximum=2
};

XlDisplayUnit={
xlThousands=-3;
xlTenThousands=-4;
xlHundredMillions=-8;
xlHundredThousands=-5;
xlMillions=-6;
xlThousandMillions=-9;
xlHundreds=-2;
xlTenMillions=-7;
xlMillionMillions=-10
};

XlWBATemplate={
xlWBATWorksheet=-4167;
xlWBATExcel4IntlMacroSheet=4;
xlWBATExcel4MacroSheet=3;
xlWBATChart=-4109
};

XlLinkInfo={
xlLinkInfoStatus=3;
xlUpdateState=1;
xlEditionDate=2
};

XlOLEType={
xlOLELink=0;
xlOLEControl=2;
xlOLEEmbed=1
};

XlEditionType={
xlPublisher=1;
xlSubscriber=2
};

XlAxisGroup={
xlSecondary=2;
xlPrimary=1
};

XlSortOn={
xlSortOnValues=0;
xlSortOnIcon=3;
xlSortOnFontColor=2;
xlSortOnCellColor=1
};

XlCalculatedMemberType={
xlCalculatedMember=0;
xlCalculatedSet=1
};

XlArabicModes={
xlArabicBothStrict=3;
xlArabicStrictAlefHamza=1;
xlArabicNone=0;
xlArabicStrictFinalYaa=2
};

XlDynamicFilterCriteria={
xlFilterLastQuarter=11;
xlFilterAllDatesInPeriodQuarter1=17;
xlFilterBelowAverage=34;
xlFilterAllDatesInPeriodApril=24;
xlFilterAllDatesInPeriodOctober=30;
xlFilterAllDatesInPeriodQuarter2=18;
xlFilterAllDatesInPeriodFebruray=22;
xlFilterAllDatesInPeriodSeptember=29;
xlFilterAllDatesInPeriodQuarter4=20;
xlFilterAllDatesInPeriodMay=25;
xlFilterLastYear=14;
xlFilterTomorrow=3;
xlFilterAllDatesInPeriodQuarter3=19;
xlFilterNextMonth=9;
xlFilterThisWeek=4;
xlFilterAllDatesInPeriodAugust=28;
xlFilterLastMonth=8;
xlFilterNextQuarter=12;
xlFilterAllDatesInPeriodNovember=31;
xlFilterAllDatesInPeriodMarch=23;
xlFilterLastWeek=5;
xlFilterToday=1;
xlFilterAllDatesInPeriodJune=26;
xlFilterAboveAverage=33;
xlFilterAllDatesInPeriodJanuary=21;
xlFilterNextYear=15;
xlFilterYesterday=2;
xlFilterThisMonth=7;
xlFilterAllDatesInPeriodJuly=27;
xlFilterThisQuarter=10;
xlFilterNextWeek=6;
xlFilterYearToDate=16;
xlFilterAllDatesInPeriodDecember=32;
xlFilterThisYear=13
};

XlCubeFieldType={
xlSet=3;
xlMeasure=2;
xlHierarchy=1
};

XlLocationInTable={
xlDataItem=7;
xlRowItem=4;
xlRowHeader=-4153;
xlPageHeader=2;
xlDataHeader=3;
xlColumnHeader=-4110;
xlColumnItem=5;
xlTableBody=8;
xlPageItem=6
};

XlSaveAsAccessMode={
xlNoChange=1;
xlExclusive=3;
xlShared=2
};

XlWindowState={
xlMinimized=-4140;
xlNormal=-4143;
xlMaximized=-4137
};

XlPrintErrors={
xlPrintErrorsDisplayed=0;
xlPrintErrorsNA=3;
xlPrintErrorsDash=2;
xlPrintErrorsBlank=1
};

XlRgbColor={
rgbLightSeaGreen=11186720;
rgbFireBrick=2237106;
rgbLightSlateGrey=10061943;
rgbMediumSpringGreen=10156544;
rgbDimGrey=6908265;
rgbDarkTurquoise=13749760;
rgbMoccasin=11920639;
rgbLimeGreen=3329330;
rgbDarkGoldenrod=755384;
rgbDarkCyan=9145088;
rgbRosyBrown=9408444;
rgbBeige=14480885;
rgbPaleGoldenrod=7071982;
rgbBrown=2763429;
rgbSlateGray=9470064;
rgbWheat=11788021;
rgbLightBlue=15128749;
rgbLinen=15134970;
rgbCornflowerBlue=15570276;
rgbDarkRed=139;
rgbOliveDrab=2330219;
rgbPapayaWhip=14020607;
rgbLightGray=13882323;
rgbMintCream=16449525;
rgbHoneydew=15794160;
rgbLightGoldenrodYellow=13826810;
rgbViolet=15631086;
rgbBisque=12903679;
rgbDarkViolet=13828244;
rgbSnow=16448255;
rgbLightPink=12695295;
rgbSeashell=15660543;
rgbGray=8421504;
rgbLightCoral=8421616;
rgbIndianRed=6053069;
rgbSteelBlue=11829830;
rgbIndigo=8519755;
rgbSienna=2970272;
rgbDarkOliveGreen=3107669;
rgbFloralWhite=15792895;
rgbGainsboro=14474460;
rgbAquamarine=13959039;
rgbLime=65280;
rgbLightSteelBlue=14599344;
rgbPlum=14524637;
rgbNavy=8388608;
rgbBlanchedAlmond=13495295;
rgbAliceBlue=16775408;
rgbTeal=8421376;
rgbOrangeRed=17919;
rgbBlack=0;
rgbSandyBrown=6333684;
rgbDarkKhaki=7059389;
rgbYellow=65535;
rgbRoyalBlue=14772545;
rgbCornsilk=14481663;
rgbDimGray=6908265;
rgbLightCyan=9145088;
rgbThistle=14204888;
rgbForestGreen=2263842;
rgbGreen=32768;
rgbMediumAquamarine=11206502;
rgbSeaGreen=5737262;
rgbTurquoise=13688896;
rgbBurlyWood=8894686;
rgbAzure=16777200;
rgbIvory=15794175;
rgbTomato=4678655;
rgbDarkSalmon=8034025;
rgbDeepSkyBlue=16760576;
rgbPeachPuff=12180223;
rgbChartreuse=65407;
rgbOrchid=14053594;
rgbWhite=16777215;
rgbCoral=5275647;
rgbMidnightBlue=7346457;
rgbDodgerBlue=16748574;
rgbPaleTurquoise=15658671;
rgbTan=9221330;
rgbGrey=8421504;
rgbMistyRose=14804223;
rgbGreenYellow=3145645;
rgbLemonChiffon=13499135;
rgbNavajoWhite=11394815;
rgbMediumPurple=14381203;
rgbSkyBlue=15453831;
rgbPeru=4163021;
rgbDarkMagenta=9109643;
rgbAqua=16776960;
rgbDeepPink=9639167;
rgbNavyBlue=8388608;
rgbLavenderBlush=16118015;
rgbBlue=16711680;
rgbBlueViolet=14822282;
rgbCadetBlue=10526303;
rgbDarkGrey=11119017;
rgbWhiteSmoke=16119285;
rgbPurple=8388736;
rgbDarkBlue=9109504;
rgbOldLace=15136253;
rgbLightGrey=13882323;
rgbCrimson=3937500;
rgbPaleGreen=10025880;
rgbMediumOrchid=13850042;
rgbOlive=32896;
rgbDarkGray=11119017;
rgbAntiqueWhite=14150650;
rgbMediumBlue=13434880;
rgbSpringGreen=8388352;
rgbGold=55295;
rgbLightYellow=14745599;
rgbRed=255;
rgbLightSalmon=8036607;
rgbPowderBlue=15130800;
rgbDarkOrange=36095;
rgbSalmon=7504122;
rgbGoldenrod=2139610;
rgbMediumSeaGreen=7451452;
rgbLightSlateGray=10061943;
rgbDarkSeaGreen=9419919;
rgbDarkOrchid=13382297;
rgbYellowGreen=3329434;
rgbDarkSlateGrey=5197615;
rgbLawnGreen=64636;
rgbMediumSlateBlue=15624315;
rgbDarkSlateGray=5197615;
rgbPink=13353215;
rgbLightGreen=9498256;
rgbMaroon=128;
rgbDarkSlateBlue=9125192;
rgbMediumVioletRed=8721863;
rgbGhostWhite=16775416;
rgbLavender=16443110;
rgbMediumTurquoise=13422920;
rgbOrange=42495;
rgbPaleVioletRed=9662683;
rgbLightSkyBlue=16436871;
rgbKhaki=9234160;
rgbDarkGreen=25600;
rgbSilver=12632256;
rgbFuchsia=16711935;
rgbHotPink=11823615;
rgbSlateBlue=13458026;
rgbSlateGrey=9470064
};

XlDVType={
xlValidateTime=5;
xlValidateInputOnly=0;
xlValidateDate=4;
xlValidateTextLength=6;
xlValidateWholeNumber=1;
xlValidateCustom=7;
xlValidateList=3;
xlValidateDecimal=2
};

XlPhoneticAlignment={
xlPhoneticAlignNoControl=0;
xlPhoneticAlignDistributed=3;
xlPhoneticAlignCenter=2;
xlPhoneticAlignLeft=1
};

XlAxisType={
xlCategory=1;
xlValue=2;
xlSeriesAxis=3
};

XlSpeakDirection={
xlSpeakByRows=0;
xlSpeakByColumns=1
};

XlChartElementPosition={
xlChartElementPositionCustom=-4114;
xlChartElementPositionAutomatic=-4105
};

XlLayoutFormType={
xlOutline=1;
xlTabular=0
};

XlSheetVisibility={
xlSheetVisible=-1;
xlSheetHidden=0;
xlSheetVeryHidden=2
};

XlSubscribeToFormat={
xlSubscribeToText=-4158;
xlSubscribeToPicture=-4147
};

XlTickMark={
xlTickMarkNone=-4142;
xlTickMarkCross=4;
xlTickMarkOutside=3;
xlTickMarkInside=2
};

XlDataLabelPosition={
xlLabelPositionMixed=6;
xlLabelPositionLeft=-4131;
xlLabelPositionInsideEnd=3;
xlLabelPositionOutsideEnd=2;
xlLabelPositionBelow=1;
xlLabelPositionInsideBase=4;
xlLabelPositionCustom=7;
xlLabelPositionAbove=0;
xlLabelPositionBestFit=5;
xlLabelPositionCenter=-4108;
xlLabelPositionRight=-4152
};

XlPivotFieldDataType={
xlText=-4158;
xlDate=2;
xlNumber=-4145
};

XlDisplayBlanksAs={
xlNotPlotted=1;
xlZero=2;
xlInterpolated=3
};

XlWebFormatting={
xlWebFormattingNone=3;
xlWebFormattingAll=1;
xlWebFormattingRTF=2
};

XlChartPictureType={
xlStack=2;
xlStretch=1;
xlStackScale=3
};

XlRunAutoMacro={
xlAutoActivate=3;
xlAutoDeactivate=4;
xlAutoClose=2;
xlAutoOpen=1
};

XlArrowHeadStyle={
xlArrowHeadStyleDoubleOpen=4;
xlArrowHeadStyleDoubleClosed=5;
xlArrowHeadStyleOpen=2;
xlArrowHeadStyleClosed=3;
xlArrowHeadStyleNone=-4142
};

XlArrowHeadWidth={
xlArrowHeadWidthWide=3;
xlArrowHeadWidthNarrow=1;
xlArrowHeadWidthMedium=-4138
};

XlPivotFieldCalculation={
xlPercentOfColumn=7;
xlIndex=9;
xlPercentOfTotal=8;
xlPercentDifferenceFrom=4;
xlNoAdditionalCalculation=-4143;
xlPercentOf=3;
xlRunningTotal=5;
xlPercentOfRow=6;
xlDifferenceFrom=2
};

XlRangeAutoFormat={
xlRangeAutoFormatTable7=38;
xlRangeAutoFormatAccounting2=5;
xlRangeAutoFormatNone=-4142;
xlRangeAutoFormat3DEffects2=14;
xlRangeAutoFormatReport4=24;
xlRangeAutoFormatAccounting3=6;
xlRangeAutoFormatTable1=32;
xlRangeAutoFormatAccounting1=4;
xlRangeAutoFormatColor2=8;
xlRangeAutoFormatTable2=33;
xlRangeAutoFormatLocalFormat1=15;
xlRangeAutoFormatPTNone=42;
xlRangeAutoFormatReport8=28;
xlRangeAutoFormatTable6=37;
xlRangeAutoFormatTable3=34;
xlRangeAutoFormatClassic2=2;
xlRangeAutoFormatReport1=21;
xlRangeAutoFormatReport10=30;
xlRangeAutoFormatReport5=25;
xlRangeAutoFormatLocalFormat3=19;
xlRangeAutoFormatSimple=-4154;
xlRangeAutoFormatLocalFormat4=20;
xlRangeAutoFormatTable4=35;
xlRangeAutoFormatColor1=7;
xlRangeAutoFormatReport7=27;
xlRangeAutoFormatReport3=23;
xlRangeAutoFormatTable9=40;
xlRangeAutoFormatList2=11;
xlRangeAutoFormat3DEffects1=13;
xlRangeAutoFormatTable5=36;
xlRangeAutoFormatReport9=29;
xlRangeAutoFormatClassic1=1;
xlRangeAutoFormatClassic3=3;
xlRangeAutoFormatReport2=22;
xlRangeAutoFormatColor3=9;
xlRangeAutoFormatClassicPivotTable=31;
xlRangeAutoFormatTable8=39;
xlRangeAutoFormatList1=10;
xlRangeAutoFormatList3=12;
xlRangeAutoFormatReport6=26;
xlRangeAutoFormatTable10=41;
xlRangeAutoFormatAccounting4=17;
xlRangeAutoFormatLocalFormat2=16
};

XlPlatform={
xlMSDOS=3;
xlWindows=2;
xlMacintosh=1
};

XlAutoFilterOperator={
xlFilterFontColor=9;
xlFilterIcon=10;
xlAnd=1;
xlFilterAutomaticFontColor=13;
xlTop10Items=3;
xlFilterNoFill=12;
xlOr=2;
xlBottom10Items=4;
xlFilterValues=7;
xlFilterCellColor=8;
xlTop10Percent=5;
xlFilterNoIcon=14;
xlFilterDynamic=11;
xlBottom10Percent=6
};

XlBarShape={
xlCylinder=3;
xlBox=0;
xlPyramidToPoint=1;
xlConeToMax=5;
xlConeToPoint=4;
xlPyramidToMax=2
};

XlSearchWithin={
xlWithinSheet=1;
xlWithinWorkbook=2
};

XlWebSelectionType={
xlSpecifiedTables=3;
xlAllTables=2;
xlEntirePage=1
};

XlDupeUnique={
xlDuplicate=1;
xlUnique=0
};

XlXmlImportResult={
xlXmlImportSuccess=0;
xlXmlImportElementsTruncated=1;
xlXmlImportValidationFailed=2
};

XlEndStyleCap={
xlCap=1;
xlNoCap=2
};

XlPattern={
xlPatternLightUp=14;
xlPatternLightVertical=12;
xlPatternRectangularGradient=4001;
xlPatternDown=-4121;
xlPatternLightDown=13;
xlPatternVertical=-4166;
xlPatternSemiGray75=10;
xlPatternChecker=9;
xlPatternGray8=18;
xlPatternSolid=1;
xlPatternGrid=15;
xlPatternHorizontal=-4128;
xlPatternAutomatic=-4105;
xlPatternUp=-4162;
xlPatternCrissCross=16;
xlPatternGray50=-4125;
xlPatternLinearGradient=4000;
xlPatternGray25=-4124;
xlPatternNone=-4142;
xlPatternGray16=17;
xlPatternGray75=-4126;
xlPatternLightHorizontal=11
};

XlOrientation={
xlDownward=-4170;
xlHorizontal=-4128;
xlUpward=-4171;
xlVertical=-4166
};

XlCVError={
xlErrDiv0=2007;
xlErrNull=2000;
xlErrName=2029;
xlErrRef=2023;
xlErrNA=2042;
xlErrNum=2036;
xlErrValue=2015
};

XlTimeUnit={
xlYears=2;
xlMonths=1;
xlDays=0
};

XlChartItem={
xlSeriesLines=22;
xlHiLoLines=25;
xlRadarAxisLabels=27;
xlDataLabel=0;
xlFloor=23;
xlDisplayUnitLabel=30;
xlPlotArea=19;
xlPivotChartFieldButton=31;
xlDownBars=20;
xlLegend=24;
xlChartArea=2;
xlLeaderLines=29;
xlSeries=3;
xlDataTable=7;
xlNothing=28;
xlChartTitle=4;
xlMajorGridlines=15;
xlUpBars=18;
xlPivotChartDropZone=32;
xlDropLines=26;
xlWalls=5;
xlCorners=6;
xlLegendKey=13;
xlErrorBars=9;
xlXErrorBars=10;
xlYErrorBars=11;
xlShape=14;
xlAxis=21;
xlTrendline=8;
xlLegendEntry=12;
xlMinorGridlines=16;
xlAxisTitle=17
};

XlDataSeriesDate={
xlWeekday=2;
xlMonth=3;
xlDay=1;
xlYear=4
};

XlTrendlineType={
xlPower=4;
xlMovingAvg=6;
xlPolynomial=3;
xlExponential=5;
xlLogarithmic=-4133;
xlLinear=-4132
};

XlTickLabelPosition={
xlTickLabelPositionNextToAxis=4;
xlTickLabelPositionNone=-4142;
xlTickLabelPositionLow=-4134;
xlTickLabelPositionHigh=-4127
};

XlIMEMode={
xlIMEModeNoControl=0;
xlIMEModeOff=2;
xlIMEModeAlphaFull=7;
xlIMEModeOn=1;
xlIMEModeDisable=3;
xlIMEModeKatakanaHalf=6;
xlIMEModeKatakana=5;
xlIMEModeHangul=10;
xlIMEModeAlpha=8;
xlIMEModeHangulFull=9;
xlIMEModeHiragana=4
};

XlSizeRepresents={
xlSizeIsWidth=2;
xlSizeIsArea=1
};

XlSortType={
xlSortValues=1;
xlSortLabels=2
};

XlChartSplitType={
xlSplitByPosition=1;
xlSplitByCustomSplit=4;
xlSplitByValue=2;
xlSplitByPercentValue=3
};

XlPictureAppearance={
xlPrinter=2;
xlScreen=1
};

XlHtmlType={
xlHtmlList=2;
xlHtmlChart=3;
xlHtmlCalc=1;
xlHtmlStatic=0
};

XlCalculation={
xlCalculationManual=-4135;
xlCalculationSemiautomatic=2;
xlCalculationAutomatic=-4105
};

XlPictureConvertorType={
xlPCT=13;
xlWPG=3;
xlHGL=6;
xlPCX=10;
xlCGM=7;
xlBMP=1;
xlPIC=11;
xlWMF=2;
xlDRW=4;
xlDXF=5;
xlEPS=8;
xlPLT=12;
xlTIF=9
};

XlChartPicturePlacement={
xlFrontEnd=6;
xlEnd=2;
xlSides=1;
xlEndSides=3;
xlFrontSides=5;
xlFront=4;
xlAllFaces=7
};

XlErrorBarDirection={
xlY=1;
xlX=-4168
};

XlBorderWeight={
xlThick=4;
xlHairline=1;
xlThin=2;
xlMedium=-4138
};

XlSubtototalLocationType={
xlAtBottom=2;
xlAtTop=1
};

XlChartType={
xlPyramidBarClustered=109;
xlAreaStacked=76;
xl3DBarClustered=60;
xlCylinderColStacked=93;
xl3DPie=-4102;
xlStockHLC=88;
xlLine=4;
xlSurfaceTopViewWireframe=86;
xlPyramidCol=112;
xlLineMarkersStacked100=67;
xlBubble=15;
xlConeBarStacked=103;
xlPieExploded=69;
xlDoughnutExploded=80;
xlRadarFilled=82;
xlRadar=-4151;
xlXYScatterLinesNoMarkers=75;
xlColumnStacked=52;
xl3DLine=-4101;
xlSurfaceTopView=85;
xlColumnClustered=51;
xl3DAreaStacked100=79;
xlPyramidColStacked100=108;
xlConeCol=105;
xlPyramidBarStacked=110;
xlBubble3DEffect=87;
xlLineStacked100=64;
xlDoughnut=-4120;
xlConeColStacked=100;
xlStockOHLC=89;
xlConeColStacked100=101;
xl3DColumnStacked=55;
xlStockVHLC=90;
xlXYScatter=-4169;
xlBarStacked=58;
xl3DColumnClustered=54;
xl3DBarStacked100=62;
xlPieOfPie=68;
xlBarOfPie=71;
xlCylinderCol=98;
xlArea=1;
xlXYScatterSmooth=72;
xlSurfaceWireframe=84;
xlSurface=83;
xl3DAreaStacked=78;
xl3DArea=-4098;
xlLineMarkersStacked=66;
xlRadarMarkers=81;
xlConeBarStacked100=104;
xlCylinderColStacked100=94;
xlColumnStacked100=53;
xlBarClustered=57;
xlBarStacked100=59;
xlPie=5;
xl3DBarStacked=61;
xlPyramidColClustered=106;
xlLineMarkers=65;
xlLineStacked=63;
xlConeColClustered=99;
xlStockVOHLC=91;
xlCylinderColClustered=92;
xlCylinderBarStacked100=97;
xlPyramidBarStacked100=111;
xl3DColumn=-4100;
xl3DPieExploded=70;
xlConeBarClustered=102;
xlXYScatterSmoothNoMarkers=73;
xlAreaStacked100=77;
xl3DColumnStacked100=56;
xlXYScatterLines=74;
xlCylinderBarStacked=96;
xlCylinderBarClustered=95;
xlPyramidColStacked=107
};

XlPriority={
xlPriorityNormal=-4143;
xlPriorityLow=-4134;
xlPriorityHigh=-4127
};

XlDataLabelsType={
xlDataLabelsShowNone=-4142;
xlDataLabelsShowPercent=3;
xlDataLabelsShowBubbleSizes=6;
xlDataLabelsShowLabelAndPercent=5;
xlDataLabelsShowLabel=4;
xlDataLabelsShowValue=2
};

XlRangeValueDataType={
xlRangeValueXMLSpreadsheet=11;
xlRangeValueDefault=10;
xlRangeValueMSPersistXML=12
};

XlInsertShiftDirection={
xlShiftToRight=-4161;
xlShiftDown=-4121
};

XlDeleteShiftDirection={
xlShiftUp=-4162;
xlShiftToLeft=-4159
};

XlDirection={
xlToRight=-4161;
xlDown=-4121;
xlUp=-4162;
xlToLeft=-4159
};

XlMousePointer={
xlWait=2;
xlNorthwestArrow=1;
xlDefault=-4143;
xlIBeam=3
};

XlSheetType={
xlWorksheet=-4167;
xlChart=-4109;
xlDialogSheet=-4116;
xlExcel4MacroSheet=3;
xlExcel4IntlMacroSheet=4
};

XlFindLookIn={
xlFormulas=-4123;
xlComments=-4144;
xlValues=-4163
};

XlCopyPictureFormat={
xlPicture=-4147;
xlBitmap=2
};

XlCutCopyMode={
xlCopy=1;
xlCut=2
};

XlGradientFillType={
xlGradientFillPath=1;
xlGradientFillLinear=0
};

XlPhoneticCharacterType={
xlKatakana=1;
xlNoConversion=3;
xlKatakanaHalf=0;
xlHiragana=2
};

XlTextQualifier={
xlTextQualifierDoubleQuote=1;
xlTextQualifierSingleQuote=2;
xlTextQualifierNone=-4142
};

XlCalculationInterruptKey={
xlEscKey=1;
xlAnyKey=2;
xlNoKey=0
};

XlCmdType={
xlCmdTable=3;
xlCmdCube=1;
xlCmdList=5;
xlCmdDefault=4;
xlCmdSql=2
};

XlMouseButton={
xlPrimaryButton=1;
xlSecondaryButton=2;
xlNoButton=0
};

XlPivotTableSourceType={
xlScenario=4;
xlPivotTable=-4148;
xlExternal=2;
xlConsolidation=3;
xlDatabase=1
};

XlFillWith={
xlFillWithFormats=-4122;
xlFillWithContents=2;
xlFillWithAll=-4104
};

XlFilterAction={
xlFilterCopy=2;
xlFilterInPlace=1
};

XlCorruptLoad={
xlRepairFile=1;
xlExtractData=2;
xlNormalLoad=0
};

XlOrder={
xlDownThenOver=1;
xlOverThenDown=2
};

XlLinkType={
xlLinkTypeExcelLinks=1;
xlLinkTypeOLELinks=2
};

XlBordersIndex={
xlDiagonalUp=6;
xlInsideHorizontal=12;
xlEdgeRight=10;
xlInsideVertical=11;
xlDiagonalDown=5;
xlEdgeBottom=9;
xlEdgeTop=8;
xlEdgeLeft=7
};

XlApplicationInternational={
xl4DigitYears=43;
xlCurrencyLeadingZeros=40;
xlCurrencyDigits=27;
xlMetric=35;
xlCurrencyCode=25;
xlDateOrder=32;
xlCurrencyMinusSign=38;
xlRowSeparator=15;
xlDateSeparator=17;
xlAlternateArraySeparator=16;
xlWeekdayNameChars=31;
xlColumnSeparator=14;
xlNoncurrencyDigits=29;
xlNonEnglishFunctions=34;
xlDecimalSeparator=3;
xlHourCode=22;
xlMonthCode=20;
xlLeftBracket=10;
xlTimeSeparator=18;
xlRightBracket=11;
xlListSeparator=5;
xlMinuteCode=23;
xlLowerCaseColumnLetter=9;
xlThousandsSeparator=4;
xlUpperCaseColumnLetter=7;
xlCountrySetting=2;
xlLeftBrace=12;
xlMDY=44;
xlRightBrace=13;
xlUpperCaseRowLetter=6;
xlMonthLeadingZero=41;
xlYearCode=19;
xlDayCode=21;
xl24HourClock=33;
xlCurrencyNegative=28;
xlCountryCode=1;
xlCurrencyBefore=37;
xlCurrencySpaceBefore=36;
xlCurrencyTrailingZeros=39;
xlDayLeadingZero=42;
xlLowerCaseRowLetter=8;
xlSecondCode=24;
xlGeneralFormatName=26;
xlMonthNameChars=30;
xlTimeLeadingZero=45
};

XlEnableCancelKey={
xlDisabled=0;
xlErrorHandler=2;
xlInterrupt=1
};

XlColumnDataType={
xlMDYFormat=3;
xlDMYFormat=4;
xlYDMFormat=8;
xlYMDFormat=5;
xlMYDFormat=6;
xlTextFormat=2;
xlDYMFormat=7;
xlGeneralFormat=1;
xlSkipColumn=9;
xlEMDFormat=10
};

XlPageBreak={
xlPageBreakManual=-4135;
xlPageBreakAutomatic=-4105;
xlPageBreakNone=-4142
};

XlPageOrientation={
xlPortrait=1;
xlLandscape=2
};

XlSortOrientation={
xlSortRows=2;
xlSortColumns=1
};

XlCommandUnderlines={
xlCommandUnderlinesOff=-4146;
xlCommandUnderlinesOn=1;
xlCommandUnderlinesAutomatic=-4105
};

XlFormatConditionOperator={
xlBetween=1;
xlGreater=5;
xlNotBetween=2;
xlLessEqual=8;
xlEqual=3;
xlNotEqual=4;
xlGreaterEqual=7;
xlLess=6
};

XlPageBreakExtent={
xlPageBreakPartial=2;
xlPageBreakFull=1
};

XlIconSet={
xl3Flags=3;
xl4TrafficLights=13;
xl3Arrows=1;
xl3ArrowsGray=2;
xl5CRV=16;
xl4RedToBlack=11;
xl4CRV=12;
xl5ArrowsGray=15;
xl3Symbols2=8;
xl3Symbols=7;
xl3Signs=6;
xl5Quarters=17;
xl4Arrows=9;
xl5Arrows=14;
xl3TrafficLights1=4;
xl4ArrowsGray=10;
xl3TrafficLights2=5
};

XlObjectSize={
xlFitToPage=2;
xlFullPage=3;
xlScreenSize=1
};

XlDataSeriesType={
xlGrowth=2;
xlDataSeriesLinear=-4132;
xlChronological=3;
xlAutoFill=4
};

XlSortDataOption={
xlSortNormal=0;
xlSortTextAsNumbers=1
};

XlApplyNamesOrder={
xlColumnThenRow=2;
xlRowThenColumn=1
};

XlEditionFormat={
xlRTF=4;
xlVALU=8;
xlBIFF=2;
xlPICT=1
};

XlListDataType={
xlListDataTypeCurrency=4;
xlListDataTypeHyperLink=10;
xlListDataTypeCheckbox=9;
xlListDataTypeChoice=6;
xlListDataTypeDateTime=5;
xlListDataTypeNone=0;
xlListDataTypeText=1;
xlListDataTypeCounter=11;
xlListDataTypeMultiLineText=2;
xlListDataTypeChoiceMulti=7;
xlListDataTypeNumber=3;
xlListDataTypeMultiLineRichText=12;
xlListDataTypeListLookup=8
};

XlLink={
xlExcelLinks=1;
xlOLELinks=2;
xlPublishers=5;
xlSubscribers=6
};

XlCellType={
xlCellTypeComments=-4144;
xlCellTypeVisible=12;
xlCellTypeAllValidation=-4174;
xlCellTypeSameValidation=-4175;
xlCellTypeSameFormatConditions=-4173;
xlCellTypeFormulas=-4123;
xlCellTypeAllFormatConditions=-4172;
xlCellTypeLastCell=11;
xlCellTypeConstants=2;
xlCellTypeBlanks=4
};

XlArrangeStyle={
xlArrangeStyleCascade=7;
xlArrangeStyleHorizontal=-4128;
xlArrangeStyleTiled=1;
xlArrangeStyleVertical=-4166
};

XlContainsOperator={
xlBeginsWith=2;
xlContains=0;
xlEndsWith=3;
xlDoesNotContain=1
};

XlGenerateTableRefs={
xlGenerateTableRefStruct=1;
xlGenerateTableRefA1=0
};

XlFormatFilterTypes={
xlFilterTop=1;
xlFilterBottomPercent=2;
xlFilterTopPercent=3;
xlFilterBottom=0
};

XlConsolidationFunction={
xlSum=-4157;
xlCountNums=-4113;
xlCount=-4112;
xlProduct=-4149;
xlMax=-4136;
xlStDevP=-4156;
xlUnknown=1000;
xlStDev=-4155;
xlAverage=-4106;
xlVarP=-4165;
xlVar=-4164;
xlMin=-4139
};

XlLinkInfoType={
xlLinkInfoSubscribers=6;
xlLinkInfoPublishers=5;
xlLinkInfoOLELinks=2
};

XlXLMMacroType={
xlCommand=2;
xlFunction=1;
xlNotXLM=3
};

XlHighlightChangesTime={
xlAllChanges=2;
xlSinceMyLastSave=1;
xlNotYetReviewed=3
};

XlPivotFormatType={
xlTable9=18;
xlReport2=1;
xlTable3=12;
xlPTNone=21;
xlReport7=6;
xlTable10=19;
xlTable7=16;
xlTable2=11;
xlTable5=14;
xlReport3=2;
xlTable4=13;
xlReport1=0;
xlTable6=15;
xlTable1=10;
xlReport10=9;
xlTable8=17;
xlPTClassic=20;
xlReport9=8;
xlReport4=3;
xlReport5=4;
xlReport6=5;
xlReport8=7
};

XlSummaryColumn={
xlSummaryOnRight=-4152;
xlSummaryOnLeft=-4131
};

XlThreadMode={
xlThreadModeManual=1;
xlThreadModeAutomatic=0
};

XlSearchDirection={
xlNext=1;
xlPrevious=2
};

XlListConflict={
xlListConflictDialog=0;
xlListConflictRetryAllConflicts=1;
xlListConflictDiscardAllConflicts=2;
xlListConflictError=3
};

XlLinkStatus={
xlLinkStatusIndeterminate=5;
xlLinkStatusInvalidName=7;
xlLinkStatusOK=0;
xlLinkStatusNotStarted=6;
xlLinkStatusSourceOpen=9;
xlLinkStatusCopiedValues=10;
xlLinkStatusSourceNotOpen=8;
xlLinkStatusMissingFile=1;
xlLinkStatusMissingSheet=2;
xlLinkStatusOld=3;
xlLinkStatusSourceNotCalculated=4
};

XlCommentDisplayMode={
xlNoIndicator=0;
xlCommentIndicatorOnly=-1;
xlCommentAndIndicator=1
};

XlFormatConditionType={
xlDatabar=4;
xlColorScale=3;
xlUniqueValues=8;
xlIconSets=6;
xlCellValue=1;
xlExpression=2;
xlTextString=9;
xlTop10=5;
xlNoBlanksCondition=13;
xlErrorsCondition=16;
xlAboveAverageCondition=12;
xlNoErrorsCondition=17;
xlBlanksCondition=10;
xlTimePeriod=11
};

XlLookFor={
xlLookForFormulas=2;
xlLookForErrors=1;
xlLookForBlanks=0
};

XlSearchOrder={
xlByRows=1;
xlByColumns=2
};

XlOLEVerb={
xlVerbOpen=2;
xlVerbPrimary=1
};

XlEnableSelection={
xlUnlockedCells=1;
xlNoRestrictions=0;
xlNoSelection=-4142
};

XlXmlExportResult={
xlXmlExportValidationFailed=1;
xlXmlExportSuccess=0
};

XlPrintLocation={
xlPrintSheetEnd=1;
xlPrintInPlace=16;
xlPrintNoComments=-4142
};

XlDVAlertStyle={
xlValidAlertWarning=2;
xlValidAlertInformation=3;
xlValidAlertStop=1
};

XlTimePeriods={
xlLastMonth=5;
xlNextMonth=8;
xlToday=0;
xlThisMonth=9;
xlLastWeek=4;
xlYesterday=1;
xlLast7Days=2;
xlTomorrow=6;
xlThisWeek=3;
xlNextWeek=7
};

XlConnectionType={
xlConnectionTypeODBC=2;
xlConnectionTypeOLEDB=1;
xlConnectionTypeXMLMAP=3;
xlConnectionTypeWEB=5;
xlConnectionTypeTEXT=4
};

XlTableStyleElementType={
xlSubtotalColumn3=15;
xlRowSubheading1=23;
xlColumnStripe2=8;
xlRowStripe2=6;
xlHeaderRow=1;
xlTotalRow=2;
xlGrandTotalRow=2;
xlRowSubheading2=24;
xlRowSubheading3=25;
xlFirstTotalCell=11;
xlLastColumn=4;
xlGrandTotalColumn=4;
xlSubtotalColumn2=14;
xlBlankRow=19;
xlRowStripe1=5;
xlPageFieldLabels=26;
xlPageFieldValues=27;
xlSubtotalRow3=18;
xlWholeTable=0;
xlColumnSubheading2=21;
xlSubtotalRow1=16;
xlColumnStripe1=7;
xlColumnSubheading1=20;
xlFirstColumn=3;
xlSubtotalRow2=17;
xlLastHeaderCell=10;
xlSubtotalColumn1=13;
xlFirstHeaderCell=9;
xlColumnSubheading3=22;
xlLastTotalCell=12
};

XlTextVisualLayoutType={
xlTextVisualRTL=2;
xlTextVisualLTR=1
};

XlLineStyle={
xlDouble=-4119;
xlDashDotDot=5;
xlSlantDashDot=13;
xlDash=-4115;
xlContinuous=1;
xlLineStyleNone=-4142;
xlDot=-4118;
xlDashDot=4
};

XlRoutingSlipStatus={
xlRoutingInProgress=1;
xlRoutingComplete=2;
xlNotYetRouted=0
};

XlChartLocation={
xlLocationAsNewSheet=1;
xlLocationAutomatic=3;
xlLocationAsObject=2
};

XlPivotCellType={
xlPivotCellSubtotal=2;
xlPivotCellPivotField=5;
xlPivotCellPageFieldItem=6;
xlPivotCellBlankCell=9;
xlPivotCellValue=0;
xlPivotCellPivotItem=1;
xlPivotCellCustomSubtotal=7;
xlPivotCellDataPivotField=8;
xlPivotCellDataField=4;
xlPivotCellGrandTotal=3
};

XlMailSystem={
xlPowerTalk=2;
xlMAPI=1;
xlNoMailSystem=0
};

XlPasteSpecialOperation={
xlPasteSpecialOperationAdd=2;
xlPasteSpecialOperationNone=-4142;
xlPasteSpecialOperationDivide=5;
xlPasteSpecialOperationMultiply=4;
xlPasteSpecialOperationSubtract=3
};

XlDataLabelSeparator={
xlDataLabelSeparatorDefault=1
};

XlSourceType={
xlSourceQuery=7;
xlSourceRange=4;
xlSourcePivotTable=6;
xlSourceWorkbook=0;
xlSourceAutoFilter=3;
xlSourcePrintArea=2;
xlSourceSheet=1;
xlSourceChart=5
};

XlXmlLoadOption={
xlXmlLoadPromptUser=0;
xlXmlLoadMapXml=3;
xlXmlLoadOpenXml=1;
xlXmlLoadImportToList=2
};

XlStdColorScale={
xlColorScaleBlackWhite=3;
xlColorScaleWhiteBlack=4;
xlColorScaleRYG=1;
xlColorScaleGYR=2
};

XlArrowHeadLength={
xlArrowHeadLengthLong=3;
xlArrowHeadLengthMedium=-4138;
xlArrowHeadLengthShort=1
};

XlPivotFieldOrientation={
xlPageField=3;
xlDataField=4;
xlHidden=0;
xlRowField=1;
xlColumnField=2
};

XlActionType={
xlActionTypeUrl=1;
xlActionTypeRowset=16;
xlActionTypeReport=128;
xlActionTypeDrillthrough=256
};

XlFileAccess={
xlReadWrite=2;
xlReadOnly=3
};

XlHebrewModes={
xlHebrewMixedScript=2;
xlHebrewMixedAuthorizedScript=3;
xlHebrewPartialScript=1;
xlHebrewFullScript=0
};

XlCalcFor={
xlColGroups=2;
xlAllValues=0;
xlRowGroups=1
};

XlSaveAction={
xlSaveChanges=1;
xlDoNotSaveChanges=2
};

XlCredentialsMethod={
xlCredentialsMethodIntegrated=0;
xlCredentialsMethodNone=1;
xlCredentialsMethodStored=2
};

XlThemeFont={
xlThemeFontMinor=2;
xlThemeFontMajor=1;
xlThemeFontNone=0
};

XlFilterAllDatesInPeriod={
xlFilterAllDatesInPeriodSecond=5;
xlFilterAllDatesInPeriodDay=2;
xlFilterAllDatesInPeriodYear=0;
xlFilterAllDatesInPeriodHour=3;
xlFilterAllDatesInPeriodMonth=1;
xlFilterAllDatesInPeriodMinute=4
};

XlPropertyDisplayedIn={
xlDisplayPropertyInPivotTableAndTooltip=3;
xlDisplayPropertyInPivotTable=1;
xlDisplayPropertyInTooltip=2
};

XlQueryType={
xlODBCQuery=1;
xlADORecordset=7;
xlWebQuery=4;
xlDAORecordset=2;
xlOLEDBQuery=5;
xlTextImport=6
};

XlTextParsingType={
xlDelimited=1;
xlFixedWidth=2
};

XlPaperSize={
xlPaperStatement=6;
xlPaperEnvelopePersonal=38;
xlPaperTabloid=3;
xlPaperDsheet=25;
xlPaperEnvelopeB6=35;
xlPaperEnvelopeC65=32;
xlPaperQuarto=15;
xlPaperEnvelope9=19;
xlPaperEnvelopeC4=30;
xlPaperEnvelopeC6=31;
xlPaperEnvelope11=21;
xlPaperA4=9;
xlPaperLetter=1;
xlPaperLedger=4;
xlPaperEnvelopeMonarch=37;
xlPaperFanfoldStdGerman=40;
xlPaperEnvelope14=23;
xlPaperEnvelope10=20;
xlPaper10x14=16;
xlPaper11x17=17;
xlPaperFanfoldLegalGerman=41;
xlPaperA5=11;
xlPaperLetterSmall=2;
xlPaperA4Small=10;
xlPaperA3=8;
xlPaperEsheet=26;
xlPaperEnvelopeC5=28;
xlPaperFanfoldUS=39;
xlPaperB4=12;
xlPaperB5=13;
xlPaperNote=18;
xlPaperLegal=5;
xlPaperFolio=14;
xlPaperCsheet=24;
xlPaperEnvelope12=22;
xlPaperEnvelopeB4=33;
xlPaperEnvelopeDL=27;
xlPaperEnvelopeB5=34;
xlPaperExecutive=7;
xlPaperEnvelopeC3=29;
xlPaperEnvelopeItaly=36;
xlPaperUser=256
};

XlImportDataAs={
xlPivotTableReport=1;
xlTable=2;
xlQueryTable=0
};

XlListObjectSourceType={
xlSrcExternal=0;
xlSrcQuery=3;
xlSrcRange=1;
xlSrcXml=2
};

XlPTSelectionMode={
xlFirstRow=256;
xlDataAndLabel=0;
xlBlanks=4;
xlLabelOnly=1;
xlDataOnly=2;
xlOrigin=3;
xlButton=15
};

XlRobustConnect={
xlNever=2;
xlAsRequired=0;
xlAlways=1
};

XlReferenceType={
xlAbsRowRelColumn=2;
xlAbsolute=1;
xlRelative=4;
xlRelRowAbsColumn=3
};

XlPlacement={
xlMove=2;
xlFreeFloating=3;
xlMoveAndSize=1
};

XlFixedFormatQuality={
xlQualityStandard=0;
xlQualityMinimum=1
};

XlTotalsCalculation={
xlTotalsCalculationCustom=9;
xlTotalsCalculationCount=3;
xlTotalsCalculationStdDev=7;
xlTotalsCalculationCountNums=4;
xlTotalsCalculationAverage=2;
xlTotalsCalculationVar=8;
xlTotalsCalculationMin=5;
xlTotalsCalculationSum=1;
xlTotalsCalculationNone=0;
xlTotalsCalculationMax=6
};

XlSortMethodOld={
xlCodePage=2;
xlSyllabary=1
};

XlSortOrder={
xlDescending=2;
xlAscending=1
};

XlRemoveDocInfoType={
xlRDIPublishInfo=13;
xlRDISendForReview=7;
xlRDIRoutingSlip=6;
xlRDIRemovePersonalInformation=4;
xlRDIDocumentProperties=8;
xlRDIInactiveDataConnections=19;
xlRDIContentType=16;
xlRDIInkAnnotations=11;
xlRDIDocumentWorkspace=10;
xlRDIPrinterPath=20;
xlRDIComments=1;
xlRDIAll=99;
xlRDIScenarioComments=12;
xlRDIDocumentManagementPolicy=15;
xlRDIEmailHeader=5;
xlRDIDefinedNameComments=18;
xlRDIDocumentServerProperties=14
};

XlVAlign={
xlVAlignTop=-4160;
xlVAlignBottom=-4107;
xlVAlignDistributed=-4117;
xlVAlignCenter=-4108;
xlVAlignJustify=-4130
};

XlLayoutRowType={
xlTabularRow=1;
xlOutlineRow=2;
xlCompactRow=0
};

XlCellInsertionMode={
xlInsertDeleteCells=1;
xlOverwriteCells=0;
xlInsertEntireRows=2
};

XlParameterDataType={
xlParamTypeBigInt=-5;
xlParamTypeInteger=4;
xlParamTypeDouble=8;
xlParamTypeChar=1;
xlParamTypeVarChar=12;
xlParamTypeBinary=-2;
xlParamTypeDecimal=3;
xlParamTypeTinyInt=-6;
xlParamTypeLongVarChar=-1;
xlParamTypeSmallInt=5;
xlParamTypeUnknown=0;
xlParamTypeTime=10;
xlParamTypeReal=7;
xlParamTypeWChar=-8;
xlParamTypeNumeric=2;
xlParamTypeFloat=6;
xlParamTypeVarBinary=-3;
xlParamTypeTimestamp=11;
xlParamTypeLongVarBinary=-4;
xlParamTypeBit=-7;
xlParamTypeDate=9
};

XlPivotLineType={
xlPivotLineSubtotal=1;
xlPivotLineBlank=3;
xlPivotLineRegular=0;
xlPivotLineGrandTotal=2
};

XlCheckInVersionType={
xlCheckInMajorVersion=1;
xlCheckInOverwriteVersion=2;
xlCheckInMinorVersion=0
};

XlYesNoGuess={
xlNo=2;
xlGuess=0;
xlYes=1
};

XlBackground={
xlBackgroundTransparent=2;
xlBackgroundAutomatic=-4105;
xlBackgroundOpaque=3
};

XlAboveBelow={
xlBelowStdDev=5;
xlAboveStdDev=4;
xlAboveAverage=0;
xlBelowAverage=1;
xlEqualBelowAverage=3;
xlEqualAboveAverage=2
};

XlMeasurementUnits={
xlCentimeters=1;
xlMillimeters=2;
xlInches=0
};

XlPivotFilterType={
xlDateNotBetween=36;
xlDateLastYear=51;
xlCaptionIsNotBetween=28;
xlAllDatesInPeriodQuarter2=54;
xlBottomCount=2;
xlValueIsGreaterThanOrEqualTo=10;
xlSpecificDate=29;
xlCaptionEndsWith=19;
xlBeforeOrEqualTo=32;
xlDateLastMonth=45;
xlValueIsBetween=13;
xlValueIsLessThan=11;
xlAllDatesInPeriodApril=60;
xlDateThisQuarter=47;
xlValueIsNotBetween=14;
xlAllDatesInPeriodOctober=66;
xlYearToDate=52;
xlCaptionDoesNotBeginWith=18;
xlDateNextQuarter=46;
xlDateToday=38;
xlAllDatesInPeriodJuly=63;
xlCaptionIsGreaterThan=23;
xlAfterOrEqualTo=34;
xlCaptionDoesNotContain=22;
xlAllDatesInPeriodQuarter1=53;
xlAllDatesInPeriodSeptember=65;
xlNotSpecificDate=30;
xlAllDatesInPeriodAugust=64;
xlValueDoesNotEqual=8;
xlDateNextYear=49;
xlCaptionIsLessThanOrEqualTo=26;
xlDateYesterday=39;
xlDateLastQuarter=48;
xlDateNextMonth=43;
xlCaptionIsGreaterThanOrEqualTo=24;
xlAllDatesInPeriodMay=61;
xlAllDatesInPeriodDecember=68;
xlBottomSum=6;
xlAllDatesInPeriodNovember=67;
xlAllDatesInPeriodQuarter3=55;
xlDateBetween=35;
xlBefore=31;
xlAllDatesInPeriodJanuary=57;
xlTopCount=1;
xlTopPercent=3;
xlValueIsGreaterThan=9;
xlDateLastWeek=42;
xlCaptionIsBetween=27;
xlAllDatesInPeriodJune=62;
xlAllDatesInPeriodMarch=59;
xlTopSum=5;
xlDateThisWeek=41;
xlDateTomorrow=37;
xlValueEquals=7;
xlAllDatesInPeriodFebruary=58;
xlBottomPercent=4;
xlDateThisYear=50;
xlAfter=33;
xlDateNextWeek=40;
xlValueIsLessThanOrEqualTo=12;
xlAllDatesInPeriodQuarter4=56;
xlCaptionBeginsWith=17;
xlCaptionDoesNotEqual=16;
xlCaptionContains=21;
xlCaptionEquals=15;
xlDateThisMonth=44;
xlCaptionDoesNotEndWith=20;
xlCaptionIsLessThan=25
}

//枚举定义结束 Excel.Application;
回复

使用道具 举报

185

主题

2541

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
13973
发表于 2011-9-17 10:43:57 | 显示全部楼层

[color=#008000]//常量定义开始 Excel.Application; [/color][color=#000000]xl3DPieExplo

//常量定义开始 Excel.Application;
xl3DPieExploded=70;
xlSmartTagControlCheckbox=9;
rgbDarkOrange=36095;
xlBottomCount=2;
xlMixedScript=3;
xlLinkStatusCopiedValues=10;
xlAllDatesInPeriodMarch=59;
xlAllDatesInPeriodFebruary=58;
xlDialogNameManager=977;
xlMixedLabels=3;
xlIMEModeAlpha=8;
xlPivotCellGrandTotal=3;
xlSpecifiedTables=3;
xlInconsistentFormula=4;
xlThemeColorLight1=2;
xlPivotCellPageFieldItem=6;
xlTickMarkOutside=3;
xlDialogWebOptionsBrowsers=773;
xlFilterAllDatesInPeriodMay=25;
rgbPowderBlue=15130800;
xlTable=2;
xlMarkerStyleTriangle=3;
xlCubeKPITrend=9;
xlErrorBars=9;
xlBelowAverage=1;
rgbAqua=16776960;
xlDialogMenuEditor=322;
xlDialogDataLabel=379;
xlDialogScale=87;
xlDialogWebOptionsFiles=684;
xlGrandTotalColumn=4;
xlDialogShowDetail=204;
xlSummaryBelow=1;
xlDialogGallery3dArea=193;
xlPivotTableReport=1;
xlDialogOptionsCalculation=318;
xlStandardSummary=1;
xlDialogOptionsGeneral=356;
xl3Symbols=7;
xlPaperEnvelopeB4=33;
xlShowValue=2;
xlDiagonalDown=5;
xlPaperEnvelopeC3=29;
xlNextWeek=7;
xlAll=-4104;
xlFilterAllDatesInPeriodApril=24;
xlAutomatic=-4105;
xlCurrencyCode=25;
xlDialogFilterAdvanced=370;
rgbLightCoral=8421616;
xlNotBetween=2;
xlSlantDashDot=13;
xlArabicBothStrict=3;
xlCenter=-4108;
xlConditionValueNone=-1;
xlSortColumns=1;
xlChecker=9;
xlWebFormattingAll=1;
xlDropDown=2;
xlPrevious=2;
xlCircle=8;
xlCorner=2;
xlValue=2;
xlLinkStatusOld=3;
xlFilterNextMonth=9;
xlGray8=18;
xlOLELinks=2;
xlErrorsCondition=16;
xlGregorian=2;
rgbGainsboro=14474460;
xl4ArrowsGray=10;
xlDialogInsert=55;
xlPCT=13;
xlCross=4;
xlTable9=18;
xlDiamond=2;
xlDialogMailLogon=339;
xlChartShort=6;
xlDistributed=-4117;
xlDialogVbaProcedureDefinition=330;
xlCylinderColStacked100=94;
xlDoubleAccounting=5;
xlArrowHeadLengthShort=1;
xlFilterNextQuarter=12;
xlFixedValue=1;
xlPivotLineSubtotal=1;
xlIMEModeKatakana=5;
xlAllValues=0;
xlValidAlertStop=1;
xlReference=4;
xlCommandUnderlinesAutomatic=-4105;
xlFilterAboveAverage=33;
xlCheckInMajorVersion=1;
xlHigh=-4127;
xlDialogActivate=103;
xlValueIsLessThanOrEqualTo=12;
rgbSandyBrown=6333684;
xlJustify=-4130;
xlDialogEditboxProperties=438;
xlMillions=-6;
xlArrowHeadStyleDoubleClosed=5;
xlRangeValueXMLSpreadsheet=11;
xlLightHorizontal=11;
xlTimeLeadingZero=45;
xlListDataValidation=8;
xlArrangeStyleHorizontal=-4128;
xlRangeAutoFormatLocalFormat3=19;
xlIndex=9;
rgbGreen=32768;
xlPyramidColClustered=106;
xlFilterAllDatesInPeriodOctober=30;
xlDateToday=38;
xlManual=-4135;
xl4RedToBlack=11;
xlListConflictRetryAllConflicts=1;
xlStDev=-4155;
xlMinusValues=3;
xlPaperEnvelopeB6=35;
xlChartArea=2;
xlNextToAxis=4;
xlDialogScrollbarProperties=420;
xlOLEControl=2;
xlIMEModeOff=2;
xlLastHeaderCell=10;
rgbSeaGreen=5737262;
xlDialogGallery3dBar=272;
xlNone=-4142;
xlNotes=-4144;
xlLast=1;
xlMarkerStyleStar=5;
xlDialogCustomizeToolbar=276;
xlListConflictError=3;
xlTextValues=2;
xlOn=1;
xlRange=2;
xlPercent=2;
xlDialogSaveNewObject=208;
xlPlus=9;
xlFilterAllDatesInPeriodAugust=28;
xlParamTypeLongVarBinary=-4;
xlDialogRoutingSlip=336;
xlWBATExcel4IntlMacroSheet=4;
xlShowLabel=4;
xlShowLabelAndPercent=5;
xlColor3=9;
xlSimple=-4154;
xlSingle=2;
xlHAlignLeft=-4131;
rgbPurple=8388736;
xlRangeAutoFormatReport3=23;
xlPrintErrorsDash=2;
xlCaptionIsLessThan=25;
xlClipboard=3;
xl4CRV=12;
xlSingleAccounting=4;
xlSolid=1;
xlDialogPivotFieldProperties=313;
rgbDarkGray=11119017;
xlSplitByPercentValue=3;
rgbGreenYellow=3145645;
xlThemeFontMinor=2;
xlThisMonth=9;
xlPatternLinearGradient=4000;
xlAxis=21;
xlDialogPivotCalculatedField=570;
xlDialogFormatSize=129;
xlMonthNameChars=30;
xlSourceChart=5;
xlByRows=1;
xlDialogChartType=526;
xlRDIPrinterPath=20;
xlPivotCellDataField=4;
xlDialogOpenLinks=2;
xlDialogOptionsListsAdd=458;
xlSquare=1;
xlStError=4;
xlHundredMillions=-8;
xlPatternGray25=-4124;
xlRowSubheading3=25;
xlTriangle=3;
xlGray25=-4124;
xlGray50=-4125;
xlRangeAutoFormatTable2=33;
xlGray75=-4126;
xlBottom=-4107;
xlLeft=-4131;
xlTable1=10;
xlMonthLeadingZero=41;
xlTop=-4160;
xlDialogNote=154;
xlPrintErrorsDisplayed=0;
xl3DAreaStacked=78;
xlTotalsCalculationCountNums=4;
xlKatakanaHalf=0;
xlArrowHeadStyleClosed=3;
xlPasteAll=-4104;
xlBar=2;
xlCredentialsMethodNone=1;
rgbLightYellow=14745599;
xlWorkbook=1;
xlDownward=-4170;
xlColumn=3;
xlErrDiv0=2007;
xlCustom=-4114;
xlParamTypeDouble=8;
rgbMediumSeaGreen=7451452;
xlConditionValuePercentile=5;
xlDefaultAutoFormat=-1;
xlTabularRow=1;
xlWK3FM3=32;
xlDownThenOver=1;
xlClipboardFormatBIFF2=18;
xlMinimum=4;
xlGrandTotalRow=2;
xlStar=5;
xlDialogOptionsME=647;
xlDataTable=7;
xlValueEquals=7;
xlLatin=-5001;
xlCategory=1;
xlErrNull=2000;
rgbGhostWhite=16775416;
xlSortOnFontColor=2;
xlDoubleClosed=5;
xlFullScript=1;
xlLegendPositionRight=-4152;
xlFirst=0;
xlSmartTagControlSmartTag=1;
xl5Arrows=14;
xl3TrafficLights1=4;
xlOptionButton=7;
xlDialogPageSetup=7;
xlClassic1=1;
xlShape=14;
xlLogicalCursor=1;
xlLabelPositionMixed=6;
xlShared=2;
xlSystem=1;
xlPaperTabloid=3;
xlCalculationAutomatic=-4105;
xlRoutingInProgress=1;
xlCurrencyMinusSign=38;
xlCellTypeFormulas=-4123;
xlFirstTotalCell=11;
xlHindiNumerals=3;
xlBidiCalendar=3;
xlAlternateArraySeparator=16;
xlComplete=4;
xlDialogMyPermission=834;
xlDialogInsertHyperlink=596;
xlScale=3;
xlClosed=3;
xlKatakana=1;
xlIconSets=6;
xlColor1=7;
xlMedium=-4138;
xlFloating=5;
xlShowPercent=3;
xl5Quarters=17;
xlParamTypeBit=-7;
xlDYMFormat=7;
xlLabelPositionBestFit=5;
xlDialogCalculation=32;
xlFunction=1;
xlLineStacked=63;
xlContinuous=1;
xlDialogGalleryRadar=249;
xlDialogPivotTableOptions=567;
xlBelow=1;
xlDialogEditDelete=54;
xlRangeAutoFormatLocalFormat2=16;
xlListSeparator=5;
xlCenterAcrossSelection=7;
rgbCornflowerBlue=15570276;
xlUnderlineStyleDouble=-4119;
xlHAlignRight=-4152;
xlChart4=2;
xlStrict=2;
xlChartSeries=17;
xlTable4=13;
xlLastCell=11;
xlPasteComments=-4144;
xlSmartTagControlLabel=7;
xlUnique=0;
xlVisualCursor=2;
xlSmartTagControlImage=8;
xlLocalSessionChanges=2;
xlPercentDifferenceFrom=4;
xlCodePage=2;
xlPatternGray50=-4125;
xlDialogDeleteFormat=111;
xlClassic3=3;
xl3TrafficLights2=5;
xlRangeAutoFormatList3=12;
xlPageBreakNone=-4142;
xlDialogFormatMove=128;
xlCentimeters=1;
xlDataOnly=2;
xl3DEffects1=13;
xlSortLabels=2;
xlHAlignGeneral=1;
xl24HourClock=33;
xl3DEffects2=14;
xlDateNextMonth=43;
xlWeekday=2;
xlAbove=0;
xlLocalFormat1=15;
rgbOrange=42495;
xlDialogSearch=731;
rgbDarkSeaGreen=9419919;
xlDialogAddChartAutoformat=390;
xlNotXLM=3;
xlAccounting2=5;
xlDialogWorkgroup=199;
xlAccounting3=6;
xlNotYetReviewed=3;
xlClipboardFormatTable=16;
xlYMDFormat=5;
xlPTClassic=20;
xlDialogNew=119;
xlDialogPrint=8;
xlAdd=2;
xlDebugCodePane=13;
xlDesktop=9;
xlUpdateLinksNever=2;
xlDirect=1;
xlDialogBorder=45;
xlDialogFormatCharttype=423;
xlDivide=5;
xlDoubleOpen=4;
xlDoubleQuote=1;
xlVerbOpen=2;
xlDialogMacroOptions=382;
xlDialogTextToColumns=422;
xlExcelMenus=1;
xlExtended=3;
xlDialogGalleryColumn=69;
xlFill=5;
xlPartialScript=2;
xlDialogFillGroup=200;
xlDot=-4118;
xlConditionValueNumber=0;
xlDayLeadingZero=42;
xlDateThisWeek=41;
xlXMLSpreadsheet=46;
xlMarkerStyleCircle=8;
rgbBlanchedAlmond=13495295;
xlGridline=22;
xlLabelPositionLeft=-4131;
xlLinkStatusNotStarted=6;
xlButtonControl=0;
xlDialogShowToolbar=220;
xlDialogOptionsEdit=319;
xlDialogFillWorkgroup=301;
xlEndsWith=3;
rgbYellow=65535;
xlWide=3;
xlOff=-4146;
xlInteger=2;
xlChartTitles=18;
xlList1=10;
xlHiLoLines=25;
rgbLightSalmon=8036607;
xlList2=11;
xlList3=12;
xlDialogChartLocation=527;
xlNext=1;
xlNoRestrictions=0;
xlDateOrder=32;
xlAccounting1=4;
xlPaperDsheet=25;
xlLocalFormat2=16;
xlUp=-4162;
xlLong=3;
xlLotusHelp=2;
xlMacrosheetCell=7;
xlMixed=2;
xlColorScale=3;
xlVAlignTop=-4160;
xlLessEqual=8;
xlYears=2;
xl3DColumn=-4100;
xlInterpolated=3;
xlSourceSheet=1;
xlNoDocuments=3;
xlWhole=1;
xlDialogGallery3dLine=195;
xlErrorBarIncludeMinusValues=3;
xlOutside=3;
xlPaper11x17=17;
xlComments=-4144;
xlGrid=15;
xlPercentOfColumn=7;
xlThousands=-3;
xlListDataTypeCurrency=4;
xlPlusValues=2;
xlToRight=-4161;
xlLabelPositionInsideEnd=3;
xlFillYears=8;
xlSingleQuote=2;
xlSubtract=3;
xlTextBox=16;
xlLastWeek=4;
xlTiled=1;
xlTitleBar=8;
xl3ArrowsGray=2;
xlPyramidToPoint=1;
xlTextString=9;
xlInches=0;
xlAllTables=2;
xlWatchPane=11;
xlNoErrorsCondition=17;
xlWholeTable=0;
rgbGrey=8421504;
xlErrNum=2036;
xlScrollBar=8;
xlFilterYesterday=2;
xlWorksheet4=1;
xlWorksheetCell=3;
rgbLemonChiffon=13499135;
xlCSV=6;
xlWorksheetShort=5;
xlOverThenDown=2;
xlPaperA4Small=10;
xlPaperStatement=6;
xlLeftToRight=2;
xlWindows=2;
xlTopToBottom=1;
xlSourceAutoFilter=3;
xlVar=-4164;
xlVeryHidden=2;
xlLinear=-4132;
xlTextMac=19;
xlTotalsCalculationNone=0;
xlDialogScenarioCells=305;
xlDrawingObject=14;
xlClipboardFormatEmbedSource=22;
xlConeBarStacked100=104;
xlDialogScenarioAdd=307;
rgbDarkGrey=11119017;
xlRangeAutoFormatClassic3=3;
xlPageFieldLabels=26;
xlFilterTopPercent=3;
xlDXF=5;
xlBuiltIn=21;
xlCommandUnderlinesOn=1;
xlPaperEnvelopeC4=30;
xlHidden=0;
xlThreadModeManual=1;
xlAnyGallery=23;
rgbAntiqueWhite=14150650;
xlColorIndexAutomatic=-4105;
xlColorIndexNone=-4142;
xlAbsRowRelColumn=2;
xlLegendPositionTop=-4160;
xlNoCap=2;
xlFilterTop=1;
xlDialogPivotTableWizard=312;
xlCylinderBarStacked=96;
rgbSalmon=7504122;
xlDialogScenarioSummary=311;
xlUpdateLinksAlways=3;
xlGradientFillLinear=0;
xlMinorGridlines=16;
xlRows=1;
xlGreater=5;
rgbDarkSlateGrey=5197615;
rgbLawnGreen=64636;
xlDialogSetUpdateStatus=159;
xlScaleLinear=-4132;
xlBottom10Items=4;
xlArabicStrictFinalYaa=2;
xlDialogChartTrend=350;
xlDatabar=4;
xlAddIn8=18;
xlDialogSetPrintTitles=23;
xlAutoActivate=3;
xlGrowth=2;
xlDialogWorkbookCopy=283;
xlFilterNextYear=15;
xlAllDatesInPeriodQuarter4=56;
xlWPG=3;
xlWMF=2;
xlSeriesAxis=3;
rgbFuchsia=16711935;
xl3DBarStacked100=62;
xlColumnItem=5;
xlArrowHeadStyleNone=-4142;
xlQualityStandard=0;
xlAxisCrossesMaximum=2;
xlPaperEnvelopePersonal=38;
xlCurrencyLeadingZeros=40;
xlAxisCrossesMinimum=4;
xlThreadModeAutomatic=0;
xlListDataTypeChoice=6;
xlDialogSetBackgroundPicture=509;
xlPieOfPie=68;
xlPivotCellValue=0;
xlTextVisualRTL=2;
xlFillWeekdays=6;
xlStretch=1;
xlExpression=2;
xlBIFF=2;
xlThemeColorDark2=3;
xlReport1=0;
xlDateLastMonth=45;
rgbLimeGreen=3329330;
rgbDarkGoldenrod=755384;
xlDialogWorkbookInsert=354;
xlArrowHeadWidthNarrow=1;
xlMaximized=-4137;
xlMinimized=-4140;
xlColorScaleRYG=1;
xlNormal=-4143;
xlContext=-5002;
xlFilterTomorrow=3;
xlDialogProtectSharing=620;
xlClipboardFormatDIF=4;
xlPrintInPlace=16;
xlRadar=-4151;
xl3Flags=3;
xlArrowHeadLengthLong=3;
xlArrowHeadLengthMedium=-4138;
xlConnectionTypeODBC=2;
xlReport4=3;
xlVAlignBottom=-4107;
xlVAlignCenter=-4108;
rgbLinen=15134970;
xlRadarAxisLabels=27;
xlMarkerStyleDot=-4118;
xlVAlignJustify=-4130;
xlSummaryPivotTable=-4148;
xlConeCol=105;
xlMultiply=4;
xlValidAlertInformation=3;
xlDialogPivotCalculatedItem=572;
xlSheetVisible=-1;
xlTickMarkCross=4;
xlTickMarkInside=2;
xlArrangeStyleVertical=-4166;
rgbPapayaWhip=14020607;
xlTickMarkNone=-4142;
xlX=-4168;
xlShiftToLeft=-4159;
xlParamTypeWChar=-8;
xlFirstColumn=3;
rgbLightGoldenrodYellow=13826810;
rgbOlive=32896;
xlRowLabels=1;
rgbDarkViolet=13828244;
xlColumnSubheading3=22;
xlY=1;
xlRDIPublishInfo=13;
xlErrorBarIncludeBoth=1;
rgbLightPink=12695295;
xlExcel5=39;
xlDialogScenarioEdit=308;
xlCylinderCol=98;
xlErrorBarIncludePlusValues=2;
xlNarrow=1;
xlMYDFormat=6;
xlDialogAddinManager=321;
xlOutlineRow=2;
rgbDarkSalmon=8034025;
rgbDarkSlateGray=5197615;
xlZero=2;
xlReport3=2;
xlTemplate=17;
xlConditionValueFormula=4;
xl3DBar=-4099;
xlDialogVbaMakeAddin=478;
xlDialogGalleryScatter=72;
xlLocationAsNewSheet=1;
xlOpenXMLTemplate=54;
xlRDIAll=99;
xlArrowHeadStyleDoubleOpen=4;
xlDialogFormatNumber=42;
xlHourCode=22;
xlArrowHeadWidthMedium=-4138;
xlSmartTagControlActiveX=13;
rgbFloralWhite=15792895;
xlPaperLetter=1;
xlArrowHeadWidthWide=3;
xlHAlignCenter=-4108;
xlAllDatesInPeriodQuarter3=55;
xlHAlignCenterAcrossSelection=7;
xlMillimeters=2;
xlLinkStatusInvalidName=7;
xlExcel3=29;
xlHAlignDistributed=-4117;
xlHAlignFill=5;
xlClipboardFormatLinkSourceDesc=32;
xlTickLabelPositionHigh=-4127;
xlDialogGalleryCustom=388;
xlCategoryScale=2;
xlTickLabelPositionLow=-4134;
xlCheckInOverwriteVersion=2;
xlTickLabelPositionNextToAxis=4;
xlPaperA3=8;
xlDialogPivotSolveOrder=568;
xlTickLabelPositionNone=-4142;
xlLinkInfoOLELinks=2;
xlPivotChartDropZone=32;
xlFillCopy=1;
xlLegendPositionCorner=2;
xlVAlignDistributed=-4117;
xlDAORecordset=2;
xlPyramidToMax=2;
xlXYScatterLines=74;
xlSmartTagControlLink=2;
xlDialogSaveWorkspace=285;
xlTotalsCalculationVar=8;
xlMicrosoftFoxPro=5;
xlPrintErrorsNA=3;
xlStackScale=3;
xlXYScatterSmoothNoMarkers=73;
xlParamTypeBigInt=-5;
xlBackgroundOpaque=3;
xlSourceWorkbook=0;
xl3DBarClustered=60;
xlSides=1;
xlLinkStatusMissingFile=1;
xlParamTypeChar=1;
xlPivotTableVersion12=3;
xlDisplayShapes=-4104;
xlStockHLC=88;
xlTomorrow=6;
xlDialogPivotClientServerSet=689;
xlTotalsCalculationMin=5;
xlEnd=2;
xlEndSides=3;
xlPrompt=0;
xlSurfaceTopViewWireframe=86;
xlLabelPositionInsideBase=4;
xlTextVisualLTR=1;
xlXmlImportValidationFailed=2;
xlFrontSides=5;
xlSortOnIcon=3;
xlDialogCombination=73;
xlFrontEnd=6;
xlHtmlList=2;
xlAllFaces=7;
xlHtmlCalc=1;
xlDialogCustomViews=493;
xlDays=0;
xlHairline=1;
xlIMEModeHangulFull=9;
xlWorks2FarEast=28;
xlTickLabelOrientationAutomatic=-4105;
rgbTomato=4678655;
xlPasteValidation=6;
xlListDataTypeText=1;
xlThemeColorAccent5=9;
xlTickLabelOrientationHorizontal=-4128;
xlTickLabelOrientationUpward=-4171;
xlDialogInsertObject=259;
xlColumnClustered=51;
xlTickLabelOrientationVertical=-4166;
xlChangeAttributes=6;
xlUpward=-4171;
xlColor2=8;
xlThick=4;
xlRightBrace=13;
xlMarkerStyleX=-4168;
xlPatternVertical=-4166;
xlDay=1;
xlSmartTagControlListbox=11;
xlDelimited=1;
xlLinkStatusIndeterminate=5;
xlAnyKey=2;
xlRangeAutoFormatReport2=22;
xlAllDatesInPeriodSeptember=65;
xlFirstRow=256;
xlUnderlineStyleDoubleAccounting=5;
xlDataLabelsShowLabelAndPercent=5;
xlFilterAllDatesInPeriodDay=2;
xlUnderlineStyleSingleAccounting=4;
xlSourcePrintArea=2;
xlErrorBarTypeCustom=-4114;
xlUpdateLinksUserSetting=1;
xlErrorBarTypeFixedValue=1;
xlAsRequired=0;
xlMissingItemsNone=0;
xlErrorBarTypePercent=2;
xlValidateCustom=7;
xlThemeFontMajor=1;
xlErrors=16;
xlErrorBarTypeStError=4;
xlExponential=5;
xlLogarithmic=-4133;
xlRunningTotal=5;
xlThemeColorAccent3=7;
xlCredentialsMethodIntegrated=0;
xlMovingAvg=6;
xlPolynomial=3;
xlSinceMyLastSave=1;
xlDialogPropertyFields=754;
xlBMP=1;
xlPower=4;
xlContents=2;
xlDash=-4115;
xlPasteValues=-4163;
xlPaperEnvelopeC65=32;
xlAutoClose=2;
xl3DArea=-4098;
xlReport9=8;
xlDashDotDot=5;
rgbMediumBlue=13434880;
xlAboveAverageCondition=12;
xlTimeSeparator=18;
xlAllDatesInPeriodNovember=67;
xlFormula=5;
xlDouble=-4119;
xlBoth=1;
xlLineStyleNone=-4142;
xlActionTypeDrillthrough=256;
rgbGoldenrod=2139610;
xlDataLabelsShowNone=-4142;
xlDataLabelsShowValue=2;
xlConnectionTypeTEXT=4;
xlDataLabelsShowPercent=3;
xlThemeColorDark1=1;
xlSourcePivotTable=6;
xlDataHeader=3;
xlDataLabelsShowLabel=4;
xlDialogWorkbookNew=302;
xlChartElementPositionCustom=-4114;
xlODBCQuery=1;
xlUnderlineStyleNone=-4142;
xlDataLabelsShowBubbleSizes=6;
xlPriorityLow=-4134;
xlRangeValueMSPersistXML=12;
xlExcel4=33;
xlColumnSubheading2=21;
xlDialogDefineName=61;
xlRangeAutoFormatColor3=9;
xlGeneral=1;
xlMarkerStyleDash=-4115;
rgbDarkGreen=25600;
xlMarkerStyleDiamond=2;
xlMarkerStyleNone=-4142;
xlMarkerStylePicture=-4147;
xlHierarchy=1;
xlPaperEnvelope10=20;
xlUnlockedFormulaCells=6;
xlMarkerStyleSquare=1;
xlErrName=2029;
rgbLightGrey=13882323;
xlImmediatePane=12;
xlCGM=7;
xlDRW=4;
xlDialogSaveAs=5;
xlSpecificDate=29;
xlWorksheet=-4167;
xlMoveAndSize=1;
xlStroke=2;
xlRepairFile=1;
xlDateSeparator=17;
xlTable5=14;
xlDialogEvaluateFormula=709;
xlPCX=10;
xlPIC=11;
xlGenerateTableRefStruct=1;
xlCellTypeAllValidation=-4174;
xlMove=2;
xlValueIsLessThan=11;
xlLastColumn=4;
xlPLT=12;
xlTIF=9;
xlDataSeriesLinear=-4132;
xlSubtotalRow2=17;
xlPatternAutomatic=-4105;
xlPatternHorizontal=-4128;
xlArabicStrictAlefHamza=1;
xlDialogStandardWidth=472;
xlPatternCrissCross=16;
xlPatternDown=-4121;
xlLastMonth=5;
xlHtmlStatic=0;
xlNumber=-4145;
xlHAlignJustify=-4130;
xlListDataTypeCheckbox=9;
xlPatternGray75=-4126;
xlToday=0;
xlPatternGray8=18;
xlPatternGrid=15;
xlCountrySetting=2;
xlPatternChecker=9;
xlPatternLightDown=13;
xlCaptionIsGreaterThan=23;
xlDialogSummaryInfo=474;
xlCrissCross=16;
xlCaptionDoesNotContain=22;
xlSpeakByColumns=1;
xlPatternLightUp=14;
xlPatternLightVertical=12;
xlDialogDisplay=27;
xlPatternSemiGray75=10;
xlNormalView=1;
xlSrcXml=2;
xlPatternSolid=1;
xlPatternUp=-4162;
xlSrcRange=1;
xlWithinSheet=1;
xlThin=2;
xlVALU=8;
xlPatternRectangularGradient=4001;
xlAllDatesInPeriodAugust=64;
xlValueDoesNotEqual=8;
xlFillWithContents=2;
xlSplitByCustomSplit=4;
rgbSeashell=15660543;
xlSplitByValue=2;
xlDialogUpdateLink=201;
xlHundreds=-2;
xlTenThousands=-4;
xlHundredThousands=-5;
xlLightDown=13;
xlPageLayoutView=3;
xlDialogOptionsTransition=355;
xlTenMillions=-7;
xlAllDatesInPeriodMay=61;
xlToolbarButton=2;
xlActionTypeRowset=16;
xlNoButtonChanges=1;
xlSpeakByRows=0;
xlThousandMillions=-9;
xlMillionMillions=-10;
xlLinkStatusOK=0;
xlFilterAllDatesInPeriodSeptember=29;
xlPaperA5=11;
xlDown=-4121;
xlLabelPositionCenter=-4108;
xlLabelPositionAbove=0;
xlTextPrinter=36;
xlSyllabary=1;
xlBlanks=4;
xlLabelPositionOutsideEnd=2;
xlFront=4;
xlLabelPositionCustom=7;
xlXmlExportValidationFailed=1;
xlHorizontal=-4128;
xlMonths=1;
xlSYLK=2;
xlDialogGallery3dColumn=194;
xlPasteAllUsingSourceTheme=13;
xlValidateList=3;
xlQueryTable=0;
xlTimeScale=3;
xlColumnStacked100=53;
xlOutline=1;
xlCellTypeBlanks=4;
xlRangeAutoFormatReport7=27;
xlDialogSelectSpecial=132;
xlXmlExportSuccess=0;
xlXmlImportSuccess=0;
xlMajorGridlines=15;
xlBox=0;
xlCylinder=3;
xlPivotCellCustomSubtotal=7;
xlFilterThisYear=13;
xlDialogDeleteName=110;
xlTopPercent=3;
xlConeToPoint=4;
xlShiftUp=-4162;
rgbBlue=16711680;
xlConeToMax=5;
xlDialogAssignToTool=293;
xlColumnStacked=52;
xlNoMailSystem=0;
xlRangeAutoFormatAccounting4=17;
xlXmlImportElementsTruncated=1;
xlRangeAutoFormatTable7=38;
xlFilterLastQuarter=11;
xlFilterAllDatesInPeriodJuly=27;
rgbIndigo=8519755;
rgbThistle=14204888;
xlDialogPasteNames=58;
xlReport7=6;
xlWK3=15;
xlDialogDocumentInspector=862;
xlPasteColumnWidths=8;
xlUpdateState=1;
xlBarStacked=58;
xlDialogDataSeries=40;
xlDialogWorkbookOptions=284;
xlDialogReplaceFont=134;
xlClipboardFormatBIFF=8;
xlBarStacked100=59;
xl3DBarStacked=61;
xlLineMarkersStacked100=67;
xlClipboardFormatToolFacePICT=26;
xlBitmap=2;
xlNonEnglishFunctions=34;
xlUserResolution=1;
xlAxisCrossesAutomatic=-4105;
xlLineStacked100=64;
xlLineMarkers=65;
xlDialogFindFile=475;
xlWalls=5;
xlLineMarkersStacked=66;
xlFilterAllDatesInPeriodQuarter3=19;
xlSecondary=2;
xlPieExploded=69;
xlDialogEditColor=223;
xlMeasure=2;
xlSmartTagControlButton=6;
xlBarOfPie=71;
xlClipboardFormatBIFF4=30;
xlListDataTypeListLookup=8;
xlCaptionDoesNotBeginWith=18;
xlXYScatterSmooth=72;
xlStack=2;
xlXYScatterLinesNoMarkers=75;
xlPaperFanfoldLegalGerman=41;
xlPasteAllExceptBorders=7;
xlAreaStacked=76;
xlAreaStacked100=77;
xl3DAreaStacked100=79;
rgbCoral=5275647;
xlSourceQuery=7;
xlDoughnutExploded=80;
xlFilterIcon=10;
xlDialogPlacement=300;
xlRadarFilled=82;
xlClipboardFormatStandardScale=27;
xlDialogProperties=474;
xlListBox=6;
xlSurfaceWireframe=84;
xlSurfaceTopView=85;
xlDialogCreatePublisher=217;
xlBubble=15;
xlPaperEsheet=26;
xlFillDefault=0;
xlClipboardFormatLink=11;
xlPasteSpecialOperationAdd=2;
xlTextDate=2;
xlOpenSource=3;
xlCylinderColClustered=92;
xlReport2=1;
xlFloor=23;
xlDateLastQuarter=48;
xlCylinderColStacked=93;
xlNormalLoad=0;
xlDownBars=20;
xlCylinderBarClustered=95;
xlTextFormat=2;
xlRDIInactiveDataConnections=19;
xlCurrentPlatformText=-4158;
xlErrorBarIncludeNone=-4142;
xlSubtotalColumn2=14;
xlInsertEntireRows=2;
xlDisplayNone=1;
xlConeColClustered=99;
rgbDarkBlue=9109504;
xlContains=0;
xlConeColStacked100=101;
xlHebrewMixedAuthorizedScript=3;
xlChartTitle=4;
xlConeBarStacked=103;
xlCreatorCode=1480803660;
xlPaperLetterSmall=2;
xlPaperEnvelopeC6=31;
xlDialogAppMove=170;
xlAllChanges=2;
xlWBATWorksheet=-4167;
xlPaperLedger=4;
xlLeftBracket=10;
xlRowThenColumn=1;
xlPyramidCol=112;
xlLine=4;
xl3DLine=-4101;
xlDialogDemote=203;
rgbSlateBlue=13458026;
xlRangeAutoFormatTable8=39;
xl3DPie=-4102;
xlIMEModeOn=1;
xlTable2=11;
xlSheetHidden=0;
xlDialogOpen=1;
xlPie=5;
xlPrintErrorsBlank=1;
xlXYScatter=-4169;
xlEvaluateToError=1;
xlRangeAutoFormatList2=11;
rgbDarkSlateBlue=9125192;
xlDoughnut=-4120;
xlBottomPercent=4;
rgbLavender=16443110;
xlChartInPlace=4;
xlModule=-4141;
xlSeries=3;
xlConeBarClustered=102;
xlInsertDeleteCells=1;
xlGeneralFormat=1;
xlBidi=-5000;
xlTrendline=8;
xlLinkInfoSubscribers=6;
xlDialogMailEditMailer=470;
xlPyramidColStacked=107;
xlOtherSessionChanges=3;
xlRangeAutoFormatAccounting2=5;
xlCubeSet=3;
xlDoesNotContain=1;
xlYErrorBars=11;
xlLegendEntry=12;
xlConnectionTypeWEB=5;
xlDialogFontProperties=381;
xlPublisher=1;
xlCalculationSemiautomatic=2;
xlSmartTagControlHelpURL=4;
xlColumns=2;
xlAxisTitle=17;
xlPivotLineBlank=3;
rgbMoccasin=11920639;
xlPageBreakPreview=2;
xlCommand=2;
xlFilterInPlace=1;
xlParamTypeSmallInt=5;
xlDialogTabOrder=394;
xlCaptionIsBetween=27;
xlLegend=24;
xlPublishers=5;
xlPivotCellBlankCell=9;
xlSubscribeToText=-4158;
xlDropLines=26;
xlLegendPositionLeft=-4131;
xlNothing=28;
xlParamTypeFloat=6;
rgbBrown=2763429;
xlSkipColumn=9;
xlRangeAutoFormatList1=10;
xlDisplayUnitLabel=30;
xlDialogGalleryDoughnut=344;
xlLinkStatusMissingSheet=2;
rgbWheat=11788021;
xlPivotTableVersion10=1;
rgbLightBlue=15128749;
xlSizeIsWidth=2;
xlTop10Bottom=0;
xlSummaryOnLeft=-4131;
xlPhoneticAlignDistributed=3;
xlShiftDown=-4121;
xlShiftToRight=-4161;
xlToLeft=-4159;
xlDialogMainChart=85;
xlAddIn=18;
xlTotalsCalculationMax=6;
xlCount=-4112;
xlParamTypeLongVarChar=-1;
xlDMYFormat=4;
xlDBF3=8;
xlCountNums=-4113;
xlLabelPositionBelow=1;
xlSubtotalRow1=16;
xlThemeFontNone=0;
xlDialogWorkbookName=386;
xlClipboardFormatSYLK=6;
xlNotSpecificDate=30;
xlParamTypeVarBinary=-3;
xlStDevP=-4156;
xlSum=-4157;
xlVarP=-4165;
xlEMDFormat=10;
xlEntirePage=1;
xlUnknown=1000;
xlEditionDate=2;
xlDateYesterday=39;
xlDialogInsertNameLabel=496;
rgbMediumVioletRed=8721863;
xlWBATExcel4MacroSheet=3;
xlDisplayPropertyInTooltip=2;
xlWait=2;
xlSelectionScope=0;
xlListDataTypeCounter=11;
xlAutoDeactivate=4;
xlCellTypeLastCell=11;
xlDialogPivotFieldGroup=433;
xlDialogSheet=-4116;
xlExcel4IntlMacroSheet=4;
xlTextMSDOS=21;
xlBackgroundAutomatic=-4105;
xlTotalRow=2;
xlAllDatesInPeriodDecember=68;
xlPaperEnvelope11=21;
xlDialogListboxProperties=437;
xlMicrosoftSchedulePlus=7;
xlDoNotSaveChanges=2;
xlPageHeader=2;
xlColGroups=2;
rgbDarkOliveGreen=3107669;
xlReport5=4;
xlDialogSeriesOptions=557;
xlRowHeader=-4153;
xlDialogChartWizard=288;
xlTableBody=8;
xlPartial=3;
xlPinYin=1;
xlValues=-4163;
xlLast7Days=2;
xlDialogPermission=832;
xlDataLabel=0;
xlSaveChanges=1;
xlInfo=-4129;
xlDate=2;
xlOpenXMLWorkbookMacroEnabled=52;
xlText=-4158;
xlPicture=-4147;
xlScenario=4;
xlIBeam=3;
xlFilterAllDatesInPeriodMarch=23;
xlBlankRow=19;
xlDateTomorrow=37;
rgbNavy=8388608;
xlGuess=0;
xlParamTypeUnknown=0;
xlDatabase=1;
xlPyramidBarStacked100=111;
xlPivotTable=-4148;
xlA1=1;
xlDialogErrorbarX=463;
xlTotalsCalculationCount=3;
xlConditionValueLowestValue=1;
xlMicrosoftMail=3;
xlMicrosoftPowerPoint=2;
xlWithinWorkbook=2;
xlEqualBelowAverage=3;
xlAboveAverage=0;
xlDialogFilter=447;
xlDateLastYear=51;
rgbOldLace=15136253;
xlMicrosoftProject=6;
xlMicrosoftWord=1;
xlEqual=3;
xlMissingItemsDefault=-1;
xlFilterFontColor=9;
xl5CRV=16;
xlPrimaryButton=1;
xlAtBottom=2;
xlRangeAutoFormatColor2=8;
xlCopy=1;
xlPaper10x14=16;
xlDialogErrorbarY=464;
xlCheckBox=1;
xlCut=2;
xlTable6=15;
xlDialogFont=26;
xlFillWithAll=-4104;
xlSplitByPosition=1;
xlFillWithFormats=-4122;
xlScaleLogarithmic=-4133;
xlAllExceptBorders=7;
xlLinkTypeExcelLinks=1;
xlDialogWorkbookTabSplit=415;
xlLinkTypeOLELinks=2;
xlRangeAutoFormatReport1=21;
xlTabPositionFirst=0;
xlExternal=2;
xlConnectionTypeXMLMAP=3;
xlDisabled=0;
xlCmdList=5;
xlDataAndLabel=0;
xlAlways=1;
xlInterrupt=1;
xlPageBreakAutomatic=-4105;
xlListDataTypeMultiLineText=2;
xlPageBreakManual=-4135;
xlTable10=19;
xlHtml=44;
xlDialogDataDelete=36;
xlCubeKPIGoal=7;
xlOLEEmbed=1;
xlDuplicate=1;
xl3Symbols2=8;
xlGroupBox=4;
xlFilterLastWeek=5;
xlLandscape=2;
xlDateNotBetween=36;
xlByColumns=2;
xlLinkInfoStatus=3;
xlCommandUnderlinesOff=-4146;
xlReport6=5;
xlEntireChart=20;
xlThemeColorHyperlink=11;
xlSummaryOnRight=-4152;
xlTotalsCalculationAverage=2;
xlVerbPrimary=1;
xlCalculationManual=-4135;
xlMixedAuthorizedScript=4;
xlDialogView3d=197;
xlCurrencyTrailingZeros=39;
xlReadWrite=2;
xlSubscriber=2;
xlLegendKey=13;
xlPasteSpecialOperationSubtract=3;
xlFullPage=3;
xlScreenSize=1;
xlPTNone=21;
xlPasteValuesAndNumberFormats=12;
rgbBlueViolet=14822282;
xlFilterAllDatesInPeriodJanuary=21;
xl3DColumnClustered=54;
xlIntlMacro=25;
rgbLavenderBlush=16118015;
xlPowerTalk=2;
xlLegendPositionBottom=-4107;
xlOLEDBQuery=5;
xlSummaryAbove=0;
xlDialogNewWebQuery=667;
xlArea=1;
xlPageFieldValues=27;
xlCheckInMinorVersion=0;
xlCombination=-4111;
rgbGold=55295;
xlExcel12=50;
xlCalculatedSet=1;
xlLTR=-5003;
xlRangeAutoFormatReport6=26;
xlErrValue=2015;
xlPICT=1;
xlRTF=4;
xlPivotCellDataPivotField=8;
xlExcelLinks=1;
rgbRed=255;
xlDialogInsertTitle=380;
xlAxisCrossesCustom=-4114;
xlClipboardFormatVALU=1;
xlCellTypeComments=-4144;
xlGradientFillPath=1;
xlExclusive=3;
xlFilterValues=7;
xlPaperB5=13;
xlThousandsSeparator=4;
xlHtmlChart=3;
xlMissingItemsMax=32500;
xlLeaderLines=29;
xlCellTypeSameValidation=-4175;
xlArrangeStyleCascade=7;
xlListConflictDialog=0;
xlClipboardFormatStandardFont=28;
xlWK1ALL=31;
xlXmlLoadOpenXml=1;
xlArrangeStyleTiled=1;
xlConsolidation=3;
xlDefault=-4143;
xlUserDefined=22;
xlDateNextWeek=40;
xlAutomaticUpdate=4;
xlCmdTable=3;
xlDialogWebOptionsPictures=685;
xlCancel=1;
xlDialogSeriesOrder=466;
xlFormatFromRightOrBelow=1;
xlFreeFloating=3;
xlSecondaryButton=2;
xlFilterAllDatesInPeriodHour=3;
xlStockVOHLC=91;
xlSelect=3;
xlSendPublisher=2;
xlPivotTableVersion11=2;
xlUpdateSubscriber=2;
xlDialogAutoCorrect=485;
xlGreaterEqual=7;
xlNoAdditionalCalculation=-4143;
xlFillFormats=3;
xlFillMonths=7;
xlCaptionEndsWith=19;
xlFillSeries=2;
xlFillValues=4;
xlDialogFormatMain=225;
xlWJ2WD1=14;
xlColumnHeader=-4110;
xlShort=1;
xlGrowthTrend=10;
xlLinearTrend=9;
xlAnd=1;
xlEmptyCellReferences=7;
xlDialogNewName=978;
xlDialogArrangeAll=12;
xlEqualAboveAverage=2;
xlFilterCopy=2;
xlLinkStatusSourceOpen=9;
xlDialogOverlayChartType=186;
xlOr=2;
xlDateThisQuarter=47;
xlInconsistentListFormula=9;
xlDialogSplit=137;
xlParamTypeDate=9;
xlTop10Percent=5;
xlCellTypeVisible=12;
xlFilterCellColor=8;
xlNoButton=0;
xlCascade=7;
xlSrcQuery=3;
xlHebrewPartialScript=1;
rgbPink=13353215;
xlValidateTime=5;
xlFilterNoFill=12;
xlFilterAutomaticFontColor=13;
xlCubeKPIStatus=8;
xlParamTypeInteger=4;
xlDialogFormatFont=150;
xlClipboardFormatBIFF12=63;
xlPageItem=6;
rgbDarkRed=139;
xlUpBars=18;
xlAtTop=1;
rgbOliveDrab=2330219;
xlClipboardFormatBitmap=9;
xlDialogSaveCopyAs=456;
xlClipboardFormatCGM=13;
xlClipboardFormatCSV=5;
xlClipboardFormatDspText=12;
xlLabelOnly=1;
rgbCadetBlue=10526303;
xlStockOHLC=89;
xlDialogRun=17;
xlPatternGray16=17;
xlListDataTypeMultiLineRichText=12;
xlExcel8=56;
xlDialogPasteSpecial=53;
xlDateNextYear=49;
xlExcel2FarEast=27;
rgbMediumOrchid=13850042;
xlRangeAutoFormatReport4=24;
xlDialogChartAddData=392;
xlClipboardFormatObjectLink=19;
xlCaptionContains=21;
xlDialogChangeLink=166;
xlCaptionIsGreaterThanOrEqualTo=24;
xlClipboardFormatPICT=2;
rgbIndianRed=6053069;
xlDialogUnhide=94;
rgbLightSkyBlue=16436871;
xlIcons=1;
xlHeaderRow=1;
xlClipboardFormatRTF=7;
xlClipboardFormatScreenPICT=29;
xlFilterAllDatesInPeriodFebruray=22;
xlDataField=4;
xlSurface=83;
xlProduct=-4149;
xlDecimalSeparator=3;
xlAccounting4=17;
rgbSienna=2970272;
xlDialogGridlines=76;
xlDialogAttachToolbars=323;
xlClipboardFormatText=0;
xlClipboardFormatToolFace=25;
xlCellTypeConstants=2;
xlClipboardFormatWK1=10;
xlAverage=-4106;
xlExcel4Workbook=35;
xlSmartTagControlSeparator=5;
xlCSVMac=22;
xlSubscribeToPicture=-4147;
xlBefore=31;
xlCSVWindows=23;
xlPaperUser=256;
xlDBF4=11;
xlDialogMailNextLetter=378;
_xlDialogPhonetic=538;
xlHebrewFullScript=0;
xlAutoOpen=1;
xlClipboardFormatMovie=24;
xlMarkerStyleAutomatic=-4105;
xlExcel7=39;
xlExcel9795=43;
xlIntlAddIn=26;
xlWorkbookNormal=-4143;
xlPhoneticAlignCenter=2;
rgbAliceBlue=16775408;
xlCylinderBarStacked100=97;
xlExcel4MacroSheet=3;
rgbOrangeRed=17919;
xlMax=-4136;
xlIMEModeNoControl=0;
xlRDIInkAnnotations=11;
xlWK1FMT=30;
xl3DColumnStacked100=56;
xlCaptionEquals=15;
xlAfterOrEqualTo=34;
xlMaximum=2;
xlDialogEditSeries=228;
xlWKS=4;
xlPivotTableVersionCurrent=-1;
xlDialogOpenText=441;
xlVertical=-4166;
xlCurrencyDigits=27;
rgbForestGreen=2263842;
xlWQ1=34;
xlNumberAsText=3;
xlRDIDocumentServerProperties=14;
xlWJ3FJ3=41;
xlUnicodeText=42;
xlSheetVeryHidden=2;
xlWebArchive=45;
xlColumnThenRow=2;
xlThemeColorFollowedHyperlink=12;
xlLess=6;
xlRangeAutoFormatLocalFormat1=15;
xlThisWeek=3;
xlOpenXMLTemplateMacroEnabled=53;
xlThemeColorAccent4=8;
xlDayCode=21;
xlRangeAutoFormatTable6=37;
xlChronological=3;
xlGenerateTableRefA1=0;
xlOpenDocumentSpreadsheet=60;
xlTabPositionLast=1;
xlWorkbookDefault=51;
rgbAzure=16777200;
xlListDataTypeChoiceMulti=7;
xl4DigitYears=43;
xlFilterAllDatesInPeriodMonth=1;
xlRangeAutoFormatReport10=30;
rgbIvory=15794175;
xlCaptionDoesNotEqual=16;
xlDialogOutline=142;
xlCurrencyBefore=37;
xlCurrencyNegative=28;
xlCurrencySpaceBefore=36;
xlAbsolute=1;
xlDateNextQuarter=46;
xlTemplate8=17;
rgbPeachPuff=12180223;
xlCellValue=1;
xlLeftBrace=12;
xlAllDatesInPeriodJuly=63;
xlPyramidBarStacked=110;
xlFilterDynamic=11;
xlLowerCaseColumnLetter=9;
rgbMidnightBlue=7346457;
rgbDodgerBlue=16748574;
rgbPaleTurquoise=15658671;
xlIndicatorAndButton=0;
xlPaperNote=18;
xlDialogWorkbookMove=282;
xlAllDatesInPeriodQuarter1=53;
xlTable8=17;
xlDialogConditionalFormatting=583;
xlFilterThisMonth=7;
xlDialogMove=262;
xlMinuteCode=23;
xlParamTypeTimestamp=11;
xlGeneralFormatName=26;
xlRoutingComplete=2;
rgbMediumPurple=14381203;
xlSubtotalColumn3=15;
xlRight=-4152;
xlColumnStripe2=8;
xlNoncurrencyDigits=29;
xlArabicNone=0;
xlAutoFill=4;
xlFilterLastYear=14;
xlSecondCode=24;
xlUpperCaseColumnLetter=7;
xlUpperCaseRowLetter=6;
xlWeekdayNameChars=31;
xlYearCode=19;
xlPageBreakFull=1;
xlRDIContentType=16;
xlPageBreakPartial=2;
xlOverwriteCells=0;
xlCorners=6;
xlDialogOpenMail=188;
xlChart=-4109;
xlNoIndicator=0;
xlCommentIndicatorOnly=-1;
xlPercentOfTotal=8;
xlDialogRowHeight=127;
xlParamTypeReal=7;
xlXErrorBars=10;
xlColorScaleGYR=2;
xlBottomSum=6;
xlMonthCode=20;
xlPrintSheetEnd=1;
xlRDIEmailHeader=5;
xlRightBracket=11;
xlRangeAutoFormatReport5=25;
xlTop10=5;
xl4TrafficLights=13;
xlUniqueValues=8;
xlTextQualifierDoubleQuote=1;
xlVisible=12;
xlAllDatesInPeriodJanuary=57;
xlBlanksCondition=10;
xlTimePeriod=11;
rgbDarkOrchid=13382297;
xlParamTypeVarChar=12;
xlLinkStatusSourceNotOpen=8;
xlNoBlanksCondition=13;
xlDialogActiveCellFont=476;
xlWorkbookTab=6;
xlTop10Top=1;
xlTextImport=6;
rgbMaroon=128;
xlBetween=1;
xlNotEqual=4;
xlUnlockedCells=1;
xlDialogPublishAsWebPage=653;
rgbMediumTurquoise=13422920;
xlRelative=4;
rgbPaleVioletRed=9662683;
xlPending=2;
xlNoSelection=-4142;
xlDialogStyle=44;
xlActionTypeReport=128;
rgbLightSlateGray=10061943;
rgbHotPink=11823615;
xlValidateInputOnly=0;
xlDashDot=4;
xlThemeColorAccent1=5;
xlValidateDecimal=2;
xlValidateDate=4;
xlPivotCellPivotField=5;
xlNextMonth=8;
rgbLightSlateGrey=10061943;
xlValidateTextLength=6;
xlErrorBarTypeStDev=-4155;
rgbDimGrey=6908265;
xlRangeAutoFormatTable1=32;
xlTextWindows=20;
xlIMEModeDisable=3;
xlIMEModeHiragana=4;
xlGray16=17;
xlFormulas=-4123;
xlDialogSubtotalCreate=398;
xlIMEModeAlphaFull=7;
xlIMEModeHangul=10;
xlValidAlertWarning=2;
xlListDataTypeHyperLink=10;
xlAfter=33;
rgbDarkCyan=9145088;
xlLocationAsObject=2;
xlLocationAutomatic=3;
xlPhoneticAlignLeft=1;
rgbRosyBrown=9408444;
xlDialogFormatOverlay=226;
xlCellTypeAllFormatConditions=-4172;
xlSet=3;
xlAllDatesInPeriodOctober=66;
rgbDarkKhaki=7059389;
xlMarkerStylePlus=9;
xlDataItem=7;
xlTotalsCalculationCustom=9;
xlDBF2=7;
xlDialogFormulaReplace=130;
xlPaperEnvelope14=23;
xlPaperEnvelope9=19;
xlPaperEnvelopeB5=34;
xlCaptionDoesNotEndWith=20;
xlRDIDocumentProperties=8;
xlOpen=2;
xlSortValues=1;
xlPyramidColStacked100=108;
xlValidateWholeNumber=1;
xlPaperEnvelopeDL=27;
xlPaperEnvelopeItaly=36;
xlPaperEnvelopeMonarch=37;
xlBubble3DEffect=87;
xlPaperExecutive=7;
xlDialogWebOptionsEncoding=686;
xlDialogGalleryArea=67;
xlPaperFanfoldStdGerman=40;
xlDialogPrintPreview=222;
xlPaperFolio=14;
xlDataFieldScope=2;
xlCmdSql=2;
xlPaperLegal=5;
xlPivotCellPivotItem=1;
xlCommentAndIndicator=1;
xlPaperQuarto=15;
xlPaperEnvelope12=22;
xlRDIDefinedNameComments=18;
xlSortTextAsNumbers=1;
xlStockVHLC=90;
xlPasteSpecialOperationDivide=5;
xlPasteSpecialOperationMultiply=4;
xlRangeAutoFormat3DEffects2=14;
xlPasteSpecialOperationNone=-4142;
xlRDIRemovePersonalInformation=4;
xl3DSurface=-4103;
xlPasteFormats=-4122;
xlDialogChartOptionsDataTable=506;
xlSourceRange=4;
xlPasteFormulas=-4123;
xlBarClustered=57;
xlTypePDF=0;
xlLookForErrors=1;
xlPasteFormulasAndNumberFormats=11;
xlPart=2;
xlHiragana=2;
xlDialogFileSharing=481;
xlDialogCopyPicture=108;
xlSmartTagControlTextbox=10;
xlChartElementPositionAutomatic=-4105;
xlNoConversion=3;
xlDialogSendMail=189;
xlSmartTagControlHelp=3;
xlCompactRow=0;
rgbLightGray=13882323;
xlPaperA4=9;
xl4Arrows=9;
xlWebFormattingNone=3;
xlPrinter=2;
xlDialogErrorChecking=732;
xlColumnField=2;
xlValueIsGreaterThan=9;
rgbAquamarine=13959039;
xlDateThisMonth=44;
xlAscending=1;
xlDialogFormatAuto=269;
xlNorthwestArrow=1;
rgbLime=65280;
xlClipboardFormatPrintPICT=3;
xlRowField=1;
xlDifferenceFrom=2;
rgbLightSteelBlue=14599344;
xlFillDays=5;
xlPercentOf=3;
xlDialogWorkbookUnhide=384;
xlPercentOfRow=6;
xlSpinner=9;
xlRowSubheading2=24;
xlDialogDataValidation=525;
xlMacintosh=1;
xlThemeColorLight2=4;
xlPriorityHigh=-4127;
xlPriorityNormal=-4143;
xlClipboardFormatEmbeddedObject=21;
rgbBlack=0;
xlColumnSubheading1=20;
xl3Signs=6;
xlClassic2=2;
xlOrigin=3;
xlDiagonalUp=6;
xlLabelPositionRight=-4152;
rgbCornsilk=14481663;
xlDialogAppSize=171;
xlYear=4;
xlRangeAutoFormat3DEffects1=13;
xlRowItem=4;
xlRangeAutoFormatAccounting3=6;
xlRDIDocumentManagementPolicy=15;
xlRangeAutoFormatClassic1=1;
xlPaperCsheet=24;
xlValueIsGreaterThanOrEqualTo=10;
xl5ArrowsGray=15;
xlCellTypeSameFormatConditions=-4173;
xlLightUp=14;
xlRangeAutoFormatLocalFormat4=20;
xlErrRef=2023;
xlRangeAutoFormatReport8=28;
xlRangeAutoFormatReport9=29;
xlLastTotalCell=12;
xlPivotCellSubtotal=2;
xlColumnSeparator=14;
xlRelRowAbsColumn=3;
xlReport10=9;
xlParamTypeTime=10;
rgbTurquoise=13688896;
xlConstants=2;
xlSortOnCellColor=1;
xlDialogColumnWidth=47;
rgbLightSeaGreen=11186720;
rgbFireBrick=2237106;
xlRangeAutoFormatClassicPivotTable=31;
rgbMediumSpringGreen=10156544;
xlSmartTagControlRadioGroup=14;
xlPlaceholders=2;
xlSubscribers=6;
xlCubeKPIValue=6;
xlRangeAutoFormatTable3=34;
xlRangeAutoFormatTable4=35;
xlDialogStandardFont=190;
xlXmlLoadPromptUser=0;
xlSubtotalColumn1=13;
xlRangeAutoFormatTable5=36;
xlPivotChartFieldButton=31;
rgbDeepSkyBlue=16760576;
xlDialogWebOptionsFonts=687;
xlRangeAutoFormatTable9=40;
xlRangeAutoFormatPTNone=42;
xlNoChanges=4;
xlParamTypeBinary=-2;
rgbMintCream=16449525;
rgbHoneydew=15794160;
xlTickLabelOrientationDownward=-4170;
xlDialogChartOptionsDataLabelMultiple=724;
xlReport8=7;
xlFilterThisQuarter=10;
xlRangeAutoFormatSimple=-4154;
xlFormatFromLeftOrAbove=0;
xlDialogPrinterSetup=9;
xlCap=1;
xlConeColStacked=100;
xlThemeColorAccent2=6;
xlDialogInsertPicture=342;
xlToolbar=1;
xlEditBox=3;
xlDialogProtectDocument=28;
xl3DColumnStacked=55;
xlMin=-4139;
xlTabular=0;
xlAllAtOnce=2;
xlCaptionIsLessThanOrEqualTo=26;
xlToolbarProtectionNone=-4143;
xlWebQuery=4;
xlColorScaleWhiteBlack=4;
xlAutomaticScale=-4105;
xlListDataTypeDateTime=5;
xlSmartTagControlCombo=12;
xlOneAfterAnother=1;
xlNotYetRouted=0;
xlErrorHandler=2;
xlDialogObjectProperties=207;
xlIMEModeKatakanaHalf=6;
xlCredentialsMethodStored=2;
xlColumnLabels=2;
xlExcel2=16;
rgbPlum=14524637;
xlUnderlineStyleSingle=2;
xlNoChange=1;
xlNoDockingChanges=3;
xlArrowHeadStyleOpen=2;
xlPortrait=1;
xlFilterAllDatesInPeriodMinute=4;
xlPageField=3;
xlCSVMSDOS=24;
xlHide=3;
xlLightVertical=12;
xlFitToPage=2;
rgbLightCyan=9145088;
xlDialogApplyNames=133;
xlXmlLoadImportToList=2;
xlBelowStdDev=5;
xlTotalsCalculationStdDev=7;
xlRadarMarkers=81;
xlWK1=5;
xlDialogSubscribeTo=218;
xlTop10Items=3;
xlRowStripe2=6;
xlDescending=2;
xlMDYFormat=3;
xlNotPlotted=1;
xlWJ3=40;
rgbChartreuse=65407;
xlConnectionTypeOLEDB=1;
xlLogical=4;
xlNumbers=1;
xlMicrosoftAccess=4;
xlTextQualifierNone=-4142;
xlPaperFanfoldUS=39;
xlFilterAllDatesInPeriodJune=26;
xlSizeIsArea=1;
xlFilterBelowAverage=34;
xlOpenXMLWorkbook=51;
xlDialogChartOptionsDataLabels=505;
xlFixedWidth=2;
xlCaptionIsNotBetween=28;
xlDialogChartSourceData=540;
xlWebFormattingRTF=2;
xlDialogGalleryPie=71;
xlWBATChart=-4109;
xlMissingItemsMax2=1048576;
xlThemeColorAccent6=10;
xlClipboardFormatNative=14;
xlPyramidBarClustered=109;
xlClipboardFormatBinary=15;
xlPatternLightHorizontal=11;
rgbOrchid=14053594;
xlSortRows=2;
xlDialogAssignToObject=213;
xlPlotArea=19;
xlAllDatesInPeriodJune=62;
xlQualityMinimum=1;
xlNo=2;
xlYes=1;
xlYesterday=1;
xlDialogZoom=256;
rgbDarkTurquoise=13749760;
xlInsideVertical=11;
xlButton=15;
xlEdgeBottom=9;
xlEdgeLeft=7;
rgbSlateGrey=9470064;
xlEdgeRight=10;
xlRDIComments=1;
xlCubeHierarchy=1;
xlEdgeTop=8;
xlOmittedCells=5;
xlDataLabelSeparatorDefault=1;
xlDialogAlignment=43;
xlAllDatesInPeriodQuarter2=54;
rgbBeige=14480885;
rgbPaleGoldenrod=7071982;
xlFilterNoIcon=14;
xlNoShapeChanges=2;
xlFilterAllDatesInPeriodQuarter2=18;
xlEPS=8;
xlPrimary=1;
xlValueIsBetween=13;
xlChartAsWindow=5;
xlDialogImportTextFile=666;
xlFilterBottomPercent=2;
xlListConflictDiscardAllConflicts=2;
xlDialogWindowSize=13;
xlFilterAllDatesInPeriodSecond=5;
xlOLELink=0;
xlLinkStatusSourceNotCalculated=4;
xlDialogConsolidate=191;
xlClipboardFormatLinkSource=23;
xlMDY=44;
xlFilterAllDatesInPeriodYear=0;
xlCountryCode=1;
xlConditionValueHighestValue=2;
xlFilterToday=1;
xlPatternNone=-4142;
xlDialogExtract=35;
rgbBisque=12903679;
xlFilterNextWeek=6;
xlDialogClear=52;
xlDialogTable=41;
xlDialogSort=39;
xlCubeKPIWeight=10;
xlPhoneticAlignNoControl=0;
xlLowerCaseRowLetter=8;
xlDialogCellProtection=46;
xlRangeAutoFormatTable10=41;
xlEscKey=1;
xlTable3=12;
xlSrcExternal=0;
xlRowGroups=1;
xlDialogCreateNames=62;
xlDisplayPropertyInPivotTable=1;
xlDialogWebOptionsGeneral=683;
xlDialogFormulaGoto=63;
rgbSteelBlue=11829830;
xlConstant=1;
xlDialogFormulaFind=64;
xlFilterBottom=0;
xlRTL=-5004;
xlDialogGalleryBar=68;
xlDone=0;
xlConditionValuePercent=3;
xlDialogGalleryLine=70;
xlDialogPivotShowPages=421;
xlCubeCalculatedMeasure=5;
xlRDIDocumentWorkspace=10;
xlNoKey=0;
xlDialogAttachText=80;
xlDialogOverlay=86;
xlDialogFormatLegend=88;
xlDialogFormatText=89;
xlDialogDataLabelMultiple=723;
xlDialogParse=91;
xlXmlLoadMapXml=3;
xlRangeAutoFormatClassic2=2;
rgbRoyalBlue=14772545;
xlDialogWorkspace=95;
xlInside=2;
xlFilterAllDatesInPeriodQuarter1=17;
rgbViolet=15631086;
xlRowStripe1=5;
xlFilterThisWeek=4;
xlDialogSaveWorkbook=145;
xlDialogCopyChart=147;
xlClipboardFormatOwnerLink=17;
xlAllDatesInPeriodApril=60;
xlDialogMainChartType=185;
xlButtonOnly=2;
xlDialogWorkbookAdd=281;
xlNoLabels=-4142;
rgbKhaki=9234160;
xlDialogSeriesX=461;
xlFormats=-4122;
xlDialogWindowMove=14;
xlTopSum=5;
xlDialogSortSpecial=192;
xlPaperEnvelopeC5=28;
xlSortOnValues=0;
xlFilterLastMonth=8;
xlDialogGallery3dPie=196;
rgbTeal=8421376;
xlDialogGoalSeek=198;
rgbNavajoWhite=11394815;
rgbSnow=16448255;
rgbSkyBlue=15453831;
xlDialogObjectProtection=214;
xlCubeAttribute=4;
rgbLightGreen=9498256;
xlBeginsWith=2;
rgbNavyBlue=8388608;
xlPaperB4=12;
xlDialogScenarioMerge=473;
xlDialogEditionOptions=251;
xlMAPI=1;
xlLookForBlanks=0;
xlAboveStdDev=4;
xlColorScaleBlackWhite=3;
xlMetric=35;
xlPrintNoComments=-4142;
xlLow=-4134;
xlLookForFormulas=2;
xlDialogGallery3dSurface=273;
xlRangeAutoFormatAccounting1=4;
xlListDataTypeNumber=3;
xlDialogFormatChart=465;
xlSemiautomatic=2;
xlDialogWorkbookProtect=417;
xlDialogOptionsView=320;
xlBeforeOrEqualTo=32;
xlDialogVbaInsertFile=328;
xlValueIsNotBetween=14;
rgbMediumAquamarine=11206502;
xlInsideHorizontal=12;
xlSemiGray75=10;
rgbBurlyWood=8894686;
rgbSlateGray=9470064;
xlCubeMeasure=2;
xlADORecordset=7;
xlDialogColorPalette=161;
_xlDialogChartSourceData=541;
xlCmdDefault=4;
xlBackgroundTransparent=2;
xlDialogSeriesY=462;
xlClipboardFormatObjectDesc=31;
xlSeriesLines=22;
xlRowSubheading1=23;
xlDialogApplyStyle=212;
rgbGray=8421504;
xlRDIRoutingSlip=6;
xlDialogAxes=78;
xlLinkInfoPublishers=5;
xlDialogPivotFieldUngroup=434;
xlTable7=16;
xlDialogCheckboxProperties=435;
xlDialogLabelProperties=436;
xlDialogPushbuttonProperties=445;
xlCalculating=1;
xlParamTypeNumeric=2;
rgbWhite=16777215;
xlParamTypeTinyInt=-6;
xlTransparent=2;
xl3Arrows=1;
xlDialogSeriesAxes=460;
rgbTan=9221330;
xlFilterAllDatesInPeriodQuarter4=20;
xlCalculatedMember=0;
rgbMistyRose=14804223;
xlDialogDefineStyle=229;
xlR1C1=-4150;
xlRangeValueDefault=10;
xlDialogSeriesShape=504;
xlOpaque=3;
xlMSDOS=3;
xlFirstHeaderCell=9;
xlFilterAllDatesInPeriodDecember=32;
xlBottom10Percent=6;
xlDIF=9;
xlRDISendForReview=7;
xlRangeAutoFormatNone=-4142;
xlDialogFunctionWizard=450;
xlSortNormal=0;
xlLabel=5;
rgbPeru=4163021;
rgbDarkMagenta=9109643;
xlDialogPatterns=84;
rgbDeepPink=9639167;
xlDialogFileDelete=6;
xlRowSeparator=15;
xlActionTypeUrl=1;
rgbCrimson=3937500;
xlDialogPhonetic=656;
xlTypeXPS=1;
rgbWhiteSmoke=16119285;
xlRDIScenarioComments=12;
xlDialogExternalDataProperties=530;
xlYDMFormat=8;
xlDialogCreateList=796;
xlScreen=1;
rgbPaleGreen=10025880;
xlListDataTypeNone=0;
xlColumnStripe1=7;
xlDisplayPropertyInPivotTableAndTooltip=3;
xlPivotLineRegular=0;
xlExtractData=2;
xlParamTypeDecimal=3;
xlErrNA=2042;
rgbSilver=12632256;
xlPivotLineGrandTotal=2;
xlPivotTableVersion2000=0;
xlClipboardFormatBIFF3=20;
xlHGL=6;
rgbSpringGreen=8388352;
xlTopCount=1;
rgbYellowGreen=3329434;
xlTextQualifierSingleQuote=2;
xlCmdCube=1;
xlLegendPositionCustom=-4161;
xlRangeAutoFormatColor1=7;
xlDateThisYear=50;
xlFilterYearToDate=16;
rgbMediumSlateBlue=15624315;
xlManualUpdate=5;
xlYearToDate=52;
xlDialogOptionsChart=325;
xlFilterAllDatesInPeriodNovember=31;
xlMonth=3;
xlNever=2;
xlDateLastWeek=42;
xlSubtotalRow3=18;
xlHebrewMixedScript=2;
xlCaptionBeginsWith=17;
rgbDimGray=6908265;
xlDialogSize=261;
xlDateBetween=35;
xlReadOnly=3;
xlDialogPromote=202;
xlOpenXMLAddIn=55;
xlTotalsCalculationSum=1;
xlWK4=38;
xlFieldsScope=1
//常量定义结束 Excel.Application;
回复

使用道具 举报

2

主题

23

帖子

120

积分

一级会员

Rank: 2

积分
120
发表于 2011-10-9 15:10:58 | 显示全部楼层

好贴,先顶再慢慢研究。

好贴,先顶再慢慢研究。
回复

使用道具 举报

4

主题

11

帖子

77

积分

一级会员

Rank: 2

积分
77
发表于 2011-10-16 10:51:23 | 显示全部楼层

这个急需呢。谢谢前辈们的辛苦劳作。

这个急需呢。谢谢前辈们的辛苦劳作。
回复

使用道具 举报

7

主题

305

帖子

1912

积分

新手入门

积分
1912
QQ
发表于 2012-3-4 14:51:45 | 显示全部楼层

温故而知新,今天重新看了一遍。

温故而知新,今天重新看了一遍。
每天进步一点点......
回复

使用道具 举报

7

主题

28

帖子

292

积分

二级会员

Rank: 3Rank: 3

积分
292
发表于 2012-3-12 07:58:06 | 显示全部楼层

学习了,受益匪浅。

学习了,受益匪浅。
回复

使用道具 举报

0

主题

20

帖子

114

积分

一级会员

Rank: 2

积分
114
发表于 2012-10-25 01:29:32 | 显示全部楼层

[quote][size=2][color=#999999]qqmmcc 发表于 2011-8-13 13:45[/color] [url=forum.php?

qqmmcc 发表于 2011-8-13 13:45
上面语句,如果不放在命名空间里 你要如下面写法才能执行

import com

看懂了,谢谢!
回复

使用道具 举报

16

主题

86

帖子

499

积分

二级会员

Rank: 3Rank: 3

积分
499
QQ
发表于 2012-10-25 10:38:03 | 显示全部楼层

谢谢分享

谢谢分享
回复

使用道具 举报

5

主题

19

帖子

109

积分

一级会员

Rank: 2

积分
109
发表于 2014-4-17 22:23:34 | 显示全部楼层

很赞的帖子,对Excel操作有了长足的补充

很赞的帖子,对Excel操作有了长足的补充
回复

使用道具 举报

1

主题

5

帖子

54

积分

一级会员

Rank: 2

积分
54
发表于 2015-9-4 20:06:13 | 显示全部楼层

不错

不错
回复

使用道具 举报

8

主题

65

帖子

465

积分

二级会员

Rank: 3Rank: 3

积分
465
发表于 2016-2-2 02:21:31 | 显示全部楼层

是的,温故而知新!!!留下记号~

是的,温故而知新!!!留下记号~
回复

使用道具 举报

47

主题

177

帖子

966

积分

荣誉会员

Rank: 8Rank: 8

积分
966
发表于 2016-2-27 10:52:42 | 显示全部楼层

如何识别空行呢?当为空行丢弃如何操作

如何识别空行呢?当为空行丢弃如何操作
用了好多年,效率杠杠的
回复

使用道具 举报

0

主题

21

帖子

119

积分

一级会员

Rank: 2

积分
119
发表于 2017-5-27 10:23:51 | 显示全部楼层
我觉得可以把一个com操作excel数据的例子放到示例代码的办公自动化文件夹里头,要不老空着
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册会员

本版积分规则

手机版|未经许可严禁引用或转载本站文章|站长邮箱|aardio.com|aardio官方社区 ( 皖ICP备09012014号 )

GMT+8, 2018-10-19 19:37 , Processed in 0.093750 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表