コード例 #1
0
        // Generates content of pivotTablePart3.
        private void GeneratePivotTablePart3Content(PivotTablePart pivotTablePart3)
        {
            PivotTableDefinition pivotTableDefinition5 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)13U };
            Location location3 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields3 = new PivotFields(){ Count = (UInt32Value)7U };

            PivotField pivotField14 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items7 = new Items(){ Count = (UInt32Value)15U };
            Item item54 = new Item(){ Index = (UInt32Value)0U };
            Item item55 = new Item(){ Index = (UInt32Value)1U };
            Item item56 = new Item(){ Index = (UInt32Value)2U };
            Item item57 = new Item(){ Index = (UInt32Value)3U };
            Item item58 = new Item(){ Index = (UInt32Value)4U };
            Item item59 = new Item(){ Index = (UInt32Value)5U };
            Item item60 = new Item(){ Index = (UInt32Value)6U };
            Item item61 = new Item(){ Index = (UInt32Value)7U };
            Item item62 = new Item(){ Index = (UInt32Value)8U };
            Item item63 = new Item(){ Index = (UInt32Value)9U };
            Item item64 = new Item(){ Index = (UInt32Value)10U };
            Item item65 = new Item(){ Index = (UInt32Value)11U };
            Item item66 = new Item(){ Index = (UInt32Value)12U };
            Item item67 = new Item(){ Index = (UInt32Value)13U };
            Item item68 = new Item(){ ItemType = ItemValues.Default };

            items7.Append(item54);
            items7.Append(item55);
            items7.Append(item56);
            items7.Append(item57);
            items7.Append(item58);
            items7.Append(item59);
            items7.Append(item60);
            items7.Append(item61);
            items7.Append(item62);
            items7.Append(item63);
            items7.Append(item64);
            items7.Append(item65);
            items7.Append(item66);
            items7.Append(item67);
            items7.Append(item68);

            pivotField14.Append(items7);

            PivotField pivotField15 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items8 = new Items(){ Count = (UInt32Value)11U };
            Item item69 = new Item(){ Index = (UInt32Value)0U };
            Item item70 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item71 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item72 = new Item(){ Index = (UInt32Value)1U };
            Item item73 = new Item(){ Index = (UInt32Value)2U };
            Item item74 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item75 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item76 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item77 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item78 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item79 = new Item(){ ItemType = ItemValues.Default };

            items8.Append(item69);
            items8.Append(item70);
            items8.Append(item71);
            items8.Append(item72);
            items8.Append(item73);
            items8.Append(item74);
            items8.Append(item75);
            items8.Append(item76);
            items8.Append(item77);
            items8.Append(item78);
            items8.Append(item79);

            pivotField15.Append(items8);
            PivotField pivotField16 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField17 = new PivotField(){ ShowAll = false };

            PivotField pivotField18 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items9 = new Items(){ Count = (UInt32Value)5U };
            Item item80 = new Item(){ Index = (UInt32Value)0U };
            Item item81 = new Item(){ Index = (UInt32Value)1U };
            Item item82 = new Item(){ Index = (UInt32Value)3U };
            Item item83 = new Item(){ Index = (UInt32Value)2U };
            Item item84 = new Item(){ ItemType = ItemValues.Default };

            items9.Append(item80);
            items9.Append(item81);
            items9.Append(item82);
            items9.Append(item83);
            items9.Append(item84);

            pivotField18.Append(items9);
            PivotField pivotField19 = new PivotField(){ ShowAll = false };

            PivotField pivotField20 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };

            Items items10 = new Items(){ Count = (UInt32Value)5U };
            Item item85 = new Item(){ Index = (UInt32Value)0U };
            Item item86 = new Item(){ Index = (UInt32Value)1U };
            Item item87 = new Item(){ Index = (UInt32Value)2U };
            Item item88 = new Item(){ Index = (UInt32Value)3U };
            Item item89 = new Item(){ Index = (UInt32Value)4U };

            items10.Append(item85);
            items10.Append(item86);
            items10.Append(item87);
            items10.Append(item88);
            items10.Append(item89);

            pivotField20.Append(items10);

            pivotFields3.Append(pivotField14);
            pivotFields3.Append(pivotField15);
            pivotFields3.Append(pivotField16);
            pivotFields3.Append(pivotField17);
            pivotFields3.Append(pivotField18);
            pivotFields3.Append(pivotField19);
            pivotFields3.Append(pivotField20);

            RowFields rowFields3 = new RowFields(){ Count = (UInt32Value)1U };
            Field field3 = new Field(){ Index = 1 };

            rowFields3.Append(field3);

            RowItems rowItems3 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem11 = new RowItem();
            MemberPropertyIndex memberPropertyIndex9 = new MemberPropertyIndex();

            rowItem11.Append(memberPropertyIndex9);

            RowItem rowItem12 = new RowItem();
            MemberPropertyIndex memberPropertyIndex10 = new MemberPropertyIndex(){ Val = 3 };

            rowItem12.Append(memberPropertyIndex10);

            RowItem rowItem13 = new RowItem();
            MemberPropertyIndex memberPropertyIndex11 = new MemberPropertyIndex(){ Val = 4 };

            rowItem13.Append(memberPropertyIndex11);

            RowItem rowItem14 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex12 = new MemberPropertyIndex();

            rowItem14.Append(memberPropertyIndex12);

            rowItems3.Append(rowItem11);
            rowItems3.Append(rowItem12);
            rowItems3.Append(rowItem13);
            rowItems3.Append(rowItem14);

            ColumnItems columnItems3 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem15 = new RowItem();

            columnItems3.Append(rowItem15);

            DataFields dataFields3 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField3 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields3.Append(dataField3);

            ChartFormats chartFormats3 = new ChartFormats(){ Count = (UInt32Value)9U };

            ChartFormat chartFormat14 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea14 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences14 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference14 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem36 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference14.Append(fieldItem36);

            pivotAreaReferences14.Append(pivotAreaReference14);

            pivotArea14.Append(pivotAreaReferences14);

            chartFormat14.Append(pivotArea14);

            ChartFormat chartFormat15 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea15 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences15 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference15 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem37 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference15.Append(fieldItem37);

            pivotAreaReferences15.Append(pivotAreaReference15);

            pivotArea15.Append(pivotAreaReferences15);

            chartFormat15.Append(pivotArea15);

            ChartFormat chartFormat16 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea16 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences16 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference16 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem38 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference16.Append(fieldItem38);

            pivotAreaReferences16.Append(pivotAreaReference16);

            pivotArea16.Append(pivotAreaReferences16);

            chartFormat16.Append(pivotArea16);

            ChartFormat chartFormat17 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };

            PivotArea pivotArea17 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences17 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference17 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem39 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference17.Append(fieldItem39);

            pivotAreaReferences17.Append(pivotAreaReference17);

            pivotArea17.Append(pivotAreaReferences17);

            chartFormat17.Append(pivotArea17);

            ChartFormat chartFormat18 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };

            PivotArea pivotArea18 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences18 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference18 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem40 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference18.Append(fieldItem40);

            pivotAreaReferences18.Append(pivotAreaReference18);

            pivotArea18.Append(pivotAreaReferences18);

            chartFormat18.Append(pivotArea18);

            ChartFormat chartFormat19 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };

            PivotArea pivotArea19 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences19 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference19 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem41 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference19.Append(fieldItem41);

            pivotAreaReferences19.Append(pivotAreaReference19);

            pivotArea19.Append(pivotAreaReferences19);

            chartFormat19.Append(pivotArea19);

            ChartFormat chartFormat20 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea20 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences20 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference20 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem42 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference20.Append(fieldItem42);

            pivotAreaReferences20.Append(pivotAreaReference20);

            pivotArea20.Append(pivotAreaReferences20);

            chartFormat20.Append(pivotArea20);

            ChartFormat chartFormat21 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };

            PivotArea pivotArea21 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences21 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference21 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem43 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference21.Append(fieldItem43);

            pivotAreaReferences21.Append(pivotAreaReference21);

            pivotArea21.Append(pivotAreaReferences21);

            chartFormat21.Append(pivotArea21);

            ChartFormat chartFormat22 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };

            PivotArea pivotArea22 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences22 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference22 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem44 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference22.Append(fieldItem44);

            pivotAreaReferences22.Append(pivotAreaReference22);

            pivotArea22.Append(pivotAreaReferences22);

            chartFormat22.Append(pivotArea22);

            chartFormats3.Append(chartFormat14);
            chartFormats3.Append(chartFormat15);
            chartFormats3.Append(chartFormat16);
            chartFormats3.Append(chartFormat17);
            chartFormats3.Append(chartFormat18);
            chartFormats3.Append(chartFormat19);
            chartFormats3.Append(chartFormat20);
            chartFormats3.Append(chartFormat21);
            chartFormats3.Append(chartFormat22);
            PivotTableStyle pivotTableStyle3 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList3 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension3 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension3.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition6 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition6.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension3.Append(pivotTableDefinition6);

            pivotTableDefinitionExtensionList3.Append(pivotTableDefinitionExtension3);

            pivotTableDefinition5.Append(location3);
            pivotTableDefinition5.Append(pivotFields3);
            pivotTableDefinition5.Append(rowFields3);
            pivotTableDefinition5.Append(rowItems3);
            pivotTableDefinition5.Append(columnItems3);
            pivotTableDefinition5.Append(dataFields3);
            pivotTableDefinition5.Append(chartFormats3);
            pivotTableDefinition5.Append(pivotTableStyle3);
            pivotTableDefinition5.Append(pivotTableDefinitionExtensionList3);

            pivotTablePart3.PivotTableDefinition = pivotTableDefinition5;
        }
コード例 #2
0
        // Generates content of pivotTablePart1.
        private void GeneratePivotTablePart1Content(PivotTablePart pivotTablePart1)
        {
            PivotTableDefinition pivotTableDefinition1 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)15U };
            Location location1 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields1 = new PivotFields(){ Count = (UInt32Value)7U };

            PivotField pivotField1 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items1 = new Items(){ Count = (UInt32Value)15U };
            Item item1 = new Item(){ Index = (UInt32Value)0U };
            Item item2 = new Item(){ Index = (UInt32Value)1U };
            Item item3 = new Item(){ Index = (UInt32Value)2U };
            Item item4 = new Item(){ Index = (UInt32Value)3U };
            Item item5 = new Item(){ Index = (UInt32Value)4U };
            Item item6 = new Item(){ Index = (UInt32Value)5U };
            Item item7 = new Item(){ Index = (UInt32Value)6U };
            Item item8 = new Item(){ Index = (UInt32Value)7U };
            Item item9 = new Item(){ Index = (UInt32Value)8U };
            Item item10 = new Item(){ Index = (UInt32Value)9U };
            Item item11 = new Item(){ Index = (UInt32Value)10U };
            Item item12 = new Item(){ Index = (UInt32Value)11U };
            Item item13 = new Item(){ Index = (UInt32Value)12U };
            Item item14 = new Item(){ Index = (UInt32Value)13U };
            Item item15 = new Item(){ ItemType = ItemValues.Default };

            items1.Append(item1);
            items1.Append(item2);
            items1.Append(item3);
            items1.Append(item4);
            items1.Append(item5);
            items1.Append(item6);
            items1.Append(item7);
            items1.Append(item8);
            items1.Append(item9);
            items1.Append(item10);
            items1.Append(item11);
            items1.Append(item12);
            items1.Append(item13);
            items1.Append(item14);
            items1.Append(item15);

            pivotField1.Append(items1);

            PivotField pivotField2 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items2 = new Items(){ Count = (UInt32Value)11U };
            Item item16 = new Item(){ Index = (UInt32Value)0U };
            Item item17 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item18 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item19 = new Item(){ Index = (UInt32Value)1U };
            Item item20 = new Item(){ Index = (UInt32Value)2U };
            Item item21 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item22 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item23 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item24 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item25 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item26 = new Item(){ ItemType = ItemValues.Default };

            items2.Append(item16);
            items2.Append(item17);
            items2.Append(item18);
            items2.Append(item19);
            items2.Append(item20);
            items2.Append(item21);
            items2.Append(item22);
            items2.Append(item23);
            items2.Append(item24);
            items2.Append(item25);
            items2.Append(item26);

            pivotField2.Append(items2);
            PivotField pivotField3 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField4 = new PivotField(){ ShowAll = false };

            PivotField pivotField5 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items3 = new Items(){ Count = (UInt32Value)5U };
            Item item27 = new Item(){ Index = (UInt32Value)0U };
            Item item28 = new Item(){ Index = (UInt32Value)1U };
            Item item29 = new Item(){ Index = (UInt32Value)3U };
            Item item30 = new Item(){ Index = (UInt32Value)2U };
            Item item31 = new Item(){ ItemType = ItemValues.Default };

            items3.Append(item27);
            items3.Append(item28);
            items3.Append(item29);
            items3.Append(item30);
            items3.Append(item31);

            pivotField5.Append(items3);
            PivotField pivotField6 = new PivotField(){ ShowAll = false };

            PivotField pivotField7 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };

            Items items4 = new Items(){ Count = (UInt32Value)5U };
            Item item32 = new Item(){ Index = (UInt32Value)0U };
            Item item33 = new Item(){ Index = (UInt32Value)1U };
            Item item34 = new Item(){ Index = (UInt32Value)2U };
            Item item35 = new Item(){ Index = (UInt32Value)3U };
            Item item36 = new Item(){ Index = (UInt32Value)4U };

            items4.Append(item32);
            items4.Append(item33);
            items4.Append(item34);
            items4.Append(item35);
            items4.Append(item36);

            pivotField7.Append(items4);

            pivotFields1.Append(pivotField1);
            pivotFields1.Append(pivotField2);
            pivotFields1.Append(pivotField3);
            pivotFields1.Append(pivotField4);
            pivotFields1.Append(pivotField5);
            pivotFields1.Append(pivotField6);
            pivotFields1.Append(pivotField7);

            RowFields rowFields1 = new RowFields(){ Count = (UInt32Value)1U };
            Field field1 = new Field(){ Index = 1 };

            rowFields1.Append(field1);

            RowItems rowItems1 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem1 = new RowItem();
            MemberPropertyIndex memberPropertyIndex1 = new MemberPropertyIndex();

            rowItem1.Append(memberPropertyIndex1);

            RowItem rowItem2 = new RowItem();
            MemberPropertyIndex memberPropertyIndex2 = new MemberPropertyIndex(){ Val = 3 };

            rowItem2.Append(memberPropertyIndex2);

            RowItem rowItem3 = new RowItem();
            MemberPropertyIndex memberPropertyIndex3 = new MemberPropertyIndex(){ Val = 4 };

            rowItem3.Append(memberPropertyIndex3);

            RowItem rowItem4 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex4 = new MemberPropertyIndex();

            rowItem4.Append(memberPropertyIndex4);

            rowItems1.Append(rowItem1);
            rowItems1.Append(rowItem2);
            rowItems1.Append(rowItem3);
            rowItems1.Append(rowItem4);

            ColumnItems columnItems1 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem5 = new RowItem();

            columnItems1.Append(rowItem5);

            DataFields dataFields1 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField1 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields1.Append(dataField1);

            ChartFormats chartFormats1 = new ChartFormats(){ Count = (UInt32Value)11U };

            ChartFormat chartFormat1 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea1 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences1 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference1 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem1 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference1.Append(fieldItem1);

            pivotAreaReferences1.Append(pivotAreaReference1);

            pivotArea1.Append(pivotAreaReferences1);

            chartFormat1.Append(pivotArea1);

            ChartFormat chartFormat2 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea2 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences2 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference2 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem2 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference2.Append(fieldItem2);

            pivotAreaReferences2.Append(pivotAreaReference2);

            pivotArea2.Append(pivotAreaReferences2);

            chartFormat2.Append(pivotArea2);

            ChartFormat chartFormat3 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea3 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences3 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference3 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem3 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference3.Append(fieldItem3);

            pivotAreaReferences3.Append(pivotAreaReference3);

            pivotArea3.Append(pivotAreaReferences3);

            chartFormat3.Append(pivotArea3);

            ChartFormat chartFormat4 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };

            PivotArea pivotArea4 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences4 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference4 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem4 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference4.Append(fieldItem4);

            pivotAreaReferences4.Append(pivotAreaReference4);

            pivotArea4.Append(pivotAreaReferences4);

            chartFormat4.Append(pivotArea4);

            ChartFormat chartFormat5 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };

            PivotArea pivotArea5 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences5 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference5 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem5 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference5.Append(fieldItem5);

            pivotAreaReferences5.Append(pivotAreaReference5);

            pivotArea5.Append(pivotAreaReferences5);

            chartFormat5.Append(pivotArea5);

            ChartFormat chartFormat6 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };

            PivotArea pivotArea6 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences6 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference6 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem6 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference6.Append(fieldItem6);

            pivotAreaReferences6.Append(pivotAreaReference6);

            pivotArea6.Append(pivotAreaReferences6);

            chartFormat6.Append(pivotArea6);

            ChartFormat chartFormat7 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea7 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences7 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference7 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem7 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference7.Append(fieldItem7);

            pivotAreaReferences7.Append(pivotAreaReference7);

            pivotArea7.Append(pivotAreaReferences7);

            chartFormat7.Append(pivotArea7);

            ChartFormat chartFormat8 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };

            PivotArea pivotArea8 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences8 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference8 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem8 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference8.Append(fieldItem8);

            pivotAreaReferences8.Append(pivotAreaReference8);

            pivotArea8.Append(pivotAreaReferences8);

            chartFormat8.Append(pivotArea8);

            ChartFormat chartFormat9 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };

            PivotArea pivotArea9 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences9 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference9 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem9 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference9.Append(fieldItem9);

            pivotAreaReferences9.Append(pivotAreaReference9);

            pivotArea9.Append(pivotAreaReferences9);

            chartFormat9.Append(pivotArea9);

            ChartFormat chartFormat10 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };

            PivotArea pivotArea10 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences10 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference10 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem10 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference10.Append(fieldItem10);

            pivotAreaReferences10.Append(pivotAreaReference10);

            pivotArea10.Append(pivotAreaReferences10);

            chartFormat10.Append(pivotArea10);

            ChartFormat chartFormat11 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };

            PivotArea pivotArea11 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences11 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference11 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem11 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference11.Append(fieldItem11);

            pivotAreaReferences11.Append(pivotAreaReference11);

            pivotArea11.Append(pivotAreaReferences11);

            chartFormat11.Append(pivotArea11);

            chartFormats1.Append(chartFormat1);
            chartFormats1.Append(chartFormat2);
            chartFormats1.Append(chartFormat3);
            chartFormats1.Append(chartFormat4);
            chartFormats1.Append(chartFormat5);
            chartFormats1.Append(chartFormat6);
            chartFormats1.Append(chartFormat7);
            chartFormats1.Append(chartFormat8);
            chartFormats1.Append(chartFormat9);
            chartFormats1.Append(chartFormat10);
            chartFormats1.Append(chartFormat11);
            PivotTableStyle pivotTableStyle1 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList1 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension1 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition2 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition2.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension1.Append(pivotTableDefinition2);

            pivotTableDefinitionExtensionList1.Append(pivotTableDefinitionExtension1);

            pivotTableDefinition1.Append(location1);
            pivotTableDefinition1.Append(pivotFields1);
            pivotTableDefinition1.Append(rowFields1);
            pivotTableDefinition1.Append(rowItems1);
            pivotTableDefinition1.Append(columnItems1);
            pivotTableDefinition1.Append(dataFields1);
            pivotTableDefinition1.Append(chartFormats1);
            pivotTableDefinition1.Append(pivotTableStyle1);
            pivotTableDefinition1.Append(pivotTableDefinitionExtensionList1);

            pivotTablePart1.PivotTableDefinition = pivotTableDefinition1;
        }
コード例 #3
0
        // Generates content of pivotTablePart2.
        private void GeneratePivotTablePart2Content(PivotTablePart pivotTablePart2)
        {
            PivotTableDefinition pivotTableDefinition3 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)0U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "値", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)2U };
            Location location2 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields2 = new PivotFields(){ Count = (UInt32Value)6U };

            PivotField pivotField8 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items5 = new Items(){ Count = (UInt32Value)6U };
            Item item37 = new Item(){ Index = (UInt32Value)0U };
            Item item38 = new Item(){ Index = (UInt32Value)1U };
            Item item39 = new Item(){ Index = (UInt32Value)2U };
            Item item40 = new Item(){ Index = (UInt32Value)3U };
            Item item41 = new Item(){ Index = (UInt32Value)4U };
            Item item42 = new Item(){ ItemType = ItemValues.Default };

            items5.Append(item37);
            items5.Append(item38);
            items5.Append(item39);
            items5.Append(item40);
            items5.Append(item41);
            items5.Append(item42);

            pivotField8.Append(items5);

            PivotField pivotField9 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items6 = new Items(){ Count = (UInt32Value)11U };
            Item item43 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item44 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item45 = new Item(){ Index = (UInt32Value)2U };
            Item item46 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item47 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item48 = new Item(){ Index = (UInt32Value)0U };
            Item item49 = new Item(){ Index = (UInt32Value)1U };
            Item item50 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item51 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item52 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item53 = new Item(){ ItemType = ItemValues.Default };

            items6.Append(item43);
            items6.Append(item44);
            items6.Append(item45);
            items6.Append(item46);
            items6.Append(item47);
            items6.Append(item48);
            items6.Append(item49);
            items6.Append(item50);
            items6.Append(item51);
            items6.Append(item52);
            items6.Append(item53);

            pivotField9.Append(items6);
            PivotField pivotField10 = new PivotField(){ ShowAll = false };
            PivotField pivotField11 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField12 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };
            PivotField pivotField13 = new PivotField(){ ShowAll = false };

            pivotFields2.Append(pivotField8);
            pivotFields2.Append(pivotField9);
            pivotFields2.Append(pivotField10);
            pivotFields2.Append(pivotField11);
            pivotFields2.Append(pivotField12);
            pivotFields2.Append(pivotField13);

            RowFields rowFields2 = new RowFields(){ Count = (UInt32Value)1U };
            Field field2 = new Field(){ Index = 1 };

            rowFields2.Append(field2);

            RowItems rowItems2 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem6 = new RowItem();
            MemberPropertyIndex memberPropertyIndex5 = new MemberPropertyIndex(){ Val = 2 };

            rowItem6.Append(memberPropertyIndex5);

            RowItem rowItem7 = new RowItem();
            MemberPropertyIndex memberPropertyIndex6 = new MemberPropertyIndex(){ Val = 5 };

            rowItem7.Append(memberPropertyIndex6);

            RowItem rowItem8 = new RowItem();
            MemberPropertyIndex memberPropertyIndex7 = new MemberPropertyIndex(){ Val = 6 };

            rowItem8.Append(memberPropertyIndex7);

            RowItem rowItem9 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex8 = new MemberPropertyIndex();

            rowItem9.Append(memberPropertyIndex8);

            rowItems2.Append(rowItem6);
            rowItems2.Append(rowItem7);
            rowItems2.Append(rowItem8);
            rowItems2.Append(rowItem9);

            ColumnItems columnItems2 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem10 = new RowItem();

            columnItems2.Append(rowItem10);

            DataFields dataFields2 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField2 = new DataField(){ Name = "Toral / Price", Field = (UInt32Value)3U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields2.Append(dataField2);

            ChartFormats chartFormats2 = new ChartFormats(){ Count = (UInt32Value)2U };

            ChartFormat chartFormat12 = new ChartFormat(){ Chart = (UInt32Value)0U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea12 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences12 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference12 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem24 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference12.Append(fieldItem24);

            pivotAreaReferences12.Append(pivotAreaReference12);

            pivotArea12.Append(pivotAreaReferences12);

            chartFormat12.Append(pivotArea12);

            ChartFormat chartFormat13 = new ChartFormat(){ Chart = (UInt32Value)1U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea13 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences13 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference13 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem25 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference13.Append(fieldItem25);

            pivotAreaReferences13.Append(pivotAreaReference13);

            pivotArea13.Append(pivotAreaReferences13);

            chartFormat13.Append(pivotArea13);

            chartFormats2.Append(chartFormat12);
            chartFormats2.Append(chartFormat13);
            PivotTableStyle pivotTableStyle2 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList2 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension2 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension2.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition4 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition4.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension2.Append(pivotTableDefinition4);

            pivotTableDefinitionExtensionList2.Append(pivotTableDefinitionExtension2);

            pivotTableDefinition3.Append(location2);
            pivotTableDefinition3.Append(pivotFields2);
            pivotTableDefinition3.Append(rowFields2);
            pivotTableDefinition3.Append(rowItems2);
            pivotTableDefinition3.Append(columnItems2);
            pivotTableDefinition3.Append(dataFields2);
            pivotTableDefinition3.Append(chartFormats2);
            pivotTableDefinition3.Append(pivotTableStyle2);
            pivotTableDefinition3.Append(pivotTableDefinitionExtensionList2);

            pivotTablePart2.PivotTableDefinition = pivotTableDefinition3;
        }
コード例 #4
0
        // Generates content of pivotTablePart8.
        private void GeneratePivotTablePart8Content(PivotTablePart pivotTablePart8)
        {
            PivotTableDefinition pivotTableDefinition15 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)7U };
            Location location8 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields8 = new PivotFields(){ Count = (UInt32Value)7U };

            PivotField pivotField49 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items27 = new Items(){ Count = (UInt32Value)15U };
            Item item234 = new Item(){ Index = (UInt32Value)0U };
            Item item235 = new Item(){ Index = (UInt32Value)1U };
            Item item236 = new Item(){ Index = (UInt32Value)2U };
            Item item237 = new Item(){ Index = (UInt32Value)3U };
            Item item238 = new Item(){ Index = (UInt32Value)4U };
            Item item239 = new Item(){ Index = (UInt32Value)5U };
            Item item240 = new Item(){ Index = (UInt32Value)6U };
            Item item241 = new Item(){ Index = (UInt32Value)7U };
            Item item242 = new Item(){ Index = (UInt32Value)8U };
            Item item243 = new Item(){ Index = (UInt32Value)9U };
            Item item244 = new Item(){ Index = (UInt32Value)10U };
            Item item245 = new Item(){ Index = (UInt32Value)11U };
            Item item246 = new Item(){ Index = (UInt32Value)12U };
            Item item247 = new Item(){ Index = (UInt32Value)13U };
            Item item248 = new Item(){ ItemType = ItemValues.Default };

            items27.Append(item234);
            items27.Append(item235);
            items27.Append(item236);
            items27.Append(item237);
            items27.Append(item238);
            items27.Append(item239);
            items27.Append(item240);
            items27.Append(item241);
            items27.Append(item242);
            items27.Append(item243);
            items27.Append(item244);
            items27.Append(item245);
            items27.Append(item246);
            items27.Append(item247);
            items27.Append(item248);

            pivotField49.Append(items27);

            PivotField pivotField50 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items28 = new Items(){ Count = (UInt32Value)11U };
            Item item249 = new Item(){ Index = (UInt32Value)0U };
            Item item250 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item251 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item252 = new Item(){ Index = (UInt32Value)1U };
            Item item253 = new Item(){ Index = (UInt32Value)2U };
            Item item254 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item255 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item256 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item257 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item258 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item259 = new Item(){ ItemType = ItemValues.Default };

            items28.Append(item249);
            items28.Append(item250);
            items28.Append(item251);
            items28.Append(item252);
            items28.Append(item253);
            items28.Append(item254);
            items28.Append(item255);
            items28.Append(item256);
            items28.Append(item257);
            items28.Append(item258);
            items28.Append(item259);

            pivotField50.Append(items28);
            PivotField pivotField51 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField52 = new PivotField(){ ShowAll = false };

            PivotField pivotField53 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items29 = new Items(){ Count = (UInt32Value)5U };
            Item item260 = new Item(){ Index = (UInt32Value)0U };
            Item item261 = new Item(){ Index = (UInt32Value)1U };
            Item item262 = new Item(){ Index = (UInt32Value)3U };
            Item item263 = new Item(){ Index = (UInt32Value)2U };
            Item item264 = new Item(){ ItemType = ItemValues.Default };

            items29.Append(item260);
            items29.Append(item261);
            items29.Append(item262);
            items29.Append(item263);
            items29.Append(item264);

            pivotField53.Append(items29);
            PivotField pivotField54 = new PivotField(){ ShowAll = false };

            PivotField pivotField55 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };

            Items items30 = new Items(){ Count = (UInt32Value)5U };
            Item item265 = new Item(){ Index = (UInt32Value)0U };
            Item item266 = new Item(){ Index = (UInt32Value)1U };
            Item item267 = new Item(){ Index = (UInt32Value)2U };
            Item item268 = new Item(){ Index = (UInt32Value)3U };
            Item item269 = new Item(){ Index = (UInt32Value)4U };

            items30.Append(item265);
            items30.Append(item266);
            items30.Append(item267);
            items30.Append(item268);
            items30.Append(item269);

            pivotField55.Append(items30);

            pivotFields8.Append(pivotField49);
            pivotFields8.Append(pivotField50);
            pivotFields8.Append(pivotField51);
            pivotFields8.Append(pivotField52);
            pivotFields8.Append(pivotField53);
            pivotFields8.Append(pivotField54);
            pivotFields8.Append(pivotField55);

            RowFields rowFields8 = new RowFields(){ Count = (UInt32Value)1U };
            Field field8 = new Field(){ Index = 1 };

            rowFields8.Append(field8);

            RowItems rowItems8 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem36 = new RowItem();
            MemberPropertyIndex memberPropertyIndex29 = new MemberPropertyIndex();

            rowItem36.Append(memberPropertyIndex29);

            RowItem rowItem37 = new RowItem();
            MemberPropertyIndex memberPropertyIndex30 = new MemberPropertyIndex(){ Val = 3 };

            rowItem37.Append(memberPropertyIndex30);

            RowItem rowItem38 = new RowItem();
            MemberPropertyIndex memberPropertyIndex31 = new MemberPropertyIndex(){ Val = 4 };

            rowItem38.Append(memberPropertyIndex31);

            RowItem rowItem39 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex32 = new MemberPropertyIndex();

            rowItem39.Append(memberPropertyIndex32);

            rowItems8.Append(rowItem36);
            rowItems8.Append(rowItem37);
            rowItems8.Append(rowItem38);
            rowItems8.Append(rowItem39);

            ColumnItems columnItems8 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem40 = new RowItem();

            columnItems8.Append(rowItem40);

            DataFields dataFields8 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField8 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields8.Append(dataField8);

            ChartFormats chartFormats8 = new ChartFormats(){ Count = (UInt32Value)3U };

            ChartFormat chartFormat67 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea67 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences67 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference67 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem89 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference67.Append(fieldItem89);

            pivotAreaReferences67.Append(pivotAreaReference67);

            pivotArea67.Append(pivotAreaReferences67);

            chartFormat67.Append(pivotArea67);

            ChartFormat chartFormat68 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea68 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences68 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference68 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem90 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference68.Append(fieldItem90);

            pivotAreaReferences68.Append(pivotAreaReference68);

            pivotArea68.Append(pivotAreaReferences68);

            chartFormat68.Append(pivotArea68);

            ChartFormat chartFormat69 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea69 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences69 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference69 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem91 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference69.Append(fieldItem91);

            pivotAreaReferences69.Append(pivotAreaReference69);

            pivotArea69.Append(pivotAreaReferences69);

            chartFormat69.Append(pivotArea69);

            chartFormats8.Append(chartFormat67);
            chartFormats8.Append(chartFormat68);
            chartFormats8.Append(chartFormat69);
            PivotTableStyle pivotTableStyle8 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList8 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension8 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension8.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition16 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition16.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension8.Append(pivotTableDefinition16);

            pivotTableDefinitionExtensionList8.Append(pivotTableDefinitionExtension8);

            pivotTableDefinition15.Append(location8);
            pivotTableDefinition15.Append(pivotFields8);
            pivotTableDefinition15.Append(rowFields8);
            pivotTableDefinition15.Append(rowItems8);
            pivotTableDefinition15.Append(columnItems8);
            pivotTableDefinition15.Append(dataFields8);
            pivotTableDefinition15.Append(chartFormats8);
            pivotTableDefinition15.Append(pivotTableStyle8);
            pivotTableDefinition15.Append(pivotTableDefinitionExtensionList8);

            pivotTablePart8.PivotTableDefinition = pivotTableDefinition15;
        }
コード例 #5
0
        // Generates content of pivotTablePart9.
        private void GeneratePivotTablePart9Content(PivotTablePart pivotTablePart9)
        {
            PivotTableDefinition pivotTableDefinition17 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)17U };
            Location location9 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields9 = new PivotFields(){ Count = (UInt32Value)7U };

            PivotField pivotField56 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items31 = new Items(){ Count = (UInt32Value)15U };
            Item item270 = new Item(){ Index = (UInt32Value)0U };
            Item item271 = new Item(){ Index = (UInt32Value)1U };
            Item item272 = new Item(){ Index = (UInt32Value)2U };
            Item item273 = new Item(){ Index = (UInt32Value)3U };
            Item item274 = new Item(){ Index = (UInt32Value)4U };
            Item item275 = new Item(){ Index = (UInt32Value)5U };
            Item item276 = new Item(){ Index = (UInt32Value)6U };
            Item item277 = new Item(){ Index = (UInt32Value)7U };
            Item item278 = new Item(){ Index = (UInt32Value)8U };
            Item item279 = new Item(){ Index = (UInt32Value)9U };
            Item item280 = new Item(){ Index = (UInt32Value)10U };
            Item item281 = new Item(){ Index = (UInt32Value)11U };
            Item item282 = new Item(){ Index = (UInt32Value)12U };
            Item item283 = new Item(){ Index = (UInt32Value)13U };
            Item item284 = new Item(){ ItemType = ItemValues.Default };

            items31.Append(item270);
            items31.Append(item271);
            items31.Append(item272);
            items31.Append(item273);
            items31.Append(item274);
            items31.Append(item275);
            items31.Append(item276);
            items31.Append(item277);
            items31.Append(item278);
            items31.Append(item279);
            items31.Append(item280);
            items31.Append(item281);
            items31.Append(item282);
            items31.Append(item283);
            items31.Append(item284);

            pivotField56.Append(items31);

            PivotField pivotField57 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items32 = new Items(){ Count = (UInt32Value)11U };
            Item item285 = new Item(){ Index = (UInt32Value)0U };
            Item item286 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item287 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item288 = new Item(){ Index = (UInt32Value)1U };
            Item item289 = new Item(){ Index = (UInt32Value)2U };
            Item item290 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item291 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item292 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item293 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item294 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item295 = new Item(){ ItemType = ItemValues.Default };

            items32.Append(item285);
            items32.Append(item286);
            items32.Append(item287);
            items32.Append(item288);
            items32.Append(item289);
            items32.Append(item290);
            items32.Append(item291);
            items32.Append(item292);
            items32.Append(item293);
            items32.Append(item294);
            items32.Append(item295);

            pivotField57.Append(items32);
            PivotField pivotField58 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField59 = new PivotField(){ ShowAll = false };

            PivotField pivotField60 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items33 = new Items(){ Count = (UInt32Value)5U };
            Item item296 = new Item(){ Index = (UInt32Value)0U };
            Item item297 = new Item(){ Index = (UInt32Value)1U };
            Item item298 = new Item(){ Index = (UInt32Value)3U };
            Item item299 = new Item(){ Index = (UInt32Value)2U };
            Item item300 = new Item(){ ItemType = ItemValues.Default };

            items33.Append(item296);
            items33.Append(item297);
            items33.Append(item298);
            items33.Append(item299);
            items33.Append(item300);

            pivotField60.Append(items33);
            PivotField pivotField61 = new PivotField(){ ShowAll = false };

            PivotField pivotField62 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };

            Items items34 = new Items(){ Count = (UInt32Value)5U };
            Item item301 = new Item(){ Index = (UInt32Value)0U };
            Item item302 = new Item(){ Index = (UInt32Value)1U };
            Item item303 = new Item(){ Index = (UInt32Value)2U };
            Item item304 = new Item(){ Index = (UInt32Value)3U };
            Item item305 = new Item(){ Index = (UInt32Value)4U };

            items34.Append(item301);
            items34.Append(item302);
            items34.Append(item303);
            items34.Append(item304);
            items34.Append(item305);

            pivotField62.Append(items34);

            pivotFields9.Append(pivotField56);
            pivotFields9.Append(pivotField57);
            pivotFields9.Append(pivotField58);
            pivotFields9.Append(pivotField59);
            pivotFields9.Append(pivotField60);
            pivotFields9.Append(pivotField61);
            pivotFields9.Append(pivotField62);

            RowFields rowFields9 = new RowFields(){ Count = (UInt32Value)1U };
            Field field9 = new Field(){ Index = 1 };

            rowFields9.Append(field9);

            RowItems rowItems9 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem41 = new RowItem();
            MemberPropertyIndex memberPropertyIndex33 = new MemberPropertyIndex();

            rowItem41.Append(memberPropertyIndex33);

            RowItem rowItem42 = new RowItem();
            MemberPropertyIndex memberPropertyIndex34 = new MemberPropertyIndex(){ Val = 3 };

            rowItem42.Append(memberPropertyIndex34);

            RowItem rowItem43 = new RowItem();
            MemberPropertyIndex memberPropertyIndex35 = new MemberPropertyIndex(){ Val = 4 };

            rowItem43.Append(memberPropertyIndex35);

            RowItem rowItem44 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex36 = new MemberPropertyIndex();

            rowItem44.Append(memberPropertyIndex36);

            rowItems9.Append(rowItem41);
            rowItems9.Append(rowItem42);
            rowItems9.Append(rowItem43);
            rowItems9.Append(rowItem44);

            ColumnItems columnItems9 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem45 = new RowItem();

            columnItems9.Append(rowItem45);

            DataFields dataFields9 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField9 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields9.Append(dataField9);

            ChartFormats chartFormats9 = new ChartFormats(){ Count = (UInt32Value)13U };

            ChartFormat chartFormat70 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea70 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences70 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference70 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem92 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference70.Append(fieldItem92);

            pivotAreaReferences70.Append(pivotAreaReference70);

            pivotArea70.Append(pivotAreaReferences70);

            chartFormat70.Append(pivotArea70);

            ChartFormat chartFormat71 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea71 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences71 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference71 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem93 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference71.Append(fieldItem93);

            pivotAreaReferences71.Append(pivotAreaReference71);

            pivotArea71.Append(pivotAreaReferences71);

            chartFormat71.Append(pivotArea71);

            ChartFormat chartFormat72 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea72 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences72 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference72 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem94 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference72.Append(fieldItem94);

            pivotAreaReferences72.Append(pivotAreaReference72);

            pivotArea72.Append(pivotAreaReferences72);

            chartFormat72.Append(pivotArea72);

            ChartFormat chartFormat73 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };

            PivotArea pivotArea73 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences73 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference73 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem95 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference73.Append(fieldItem95);

            pivotAreaReferences73.Append(pivotAreaReference73);

            pivotArea73.Append(pivotAreaReferences73);

            chartFormat73.Append(pivotArea73);

            ChartFormat chartFormat74 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };

            PivotArea pivotArea74 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences74 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference74 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem96 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference74.Append(fieldItem96);

            pivotAreaReferences74.Append(pivotAreaReference74);

            pivotArea74.Append(pivotAreaReferences74);

            chartFormat74.Append(pivotArea74);

            ChartFormat chartFormat75 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };

            PivotArea pivotArea75 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences75 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference75 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem97 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference75.Append(fieldItem97);

            pivotAreaReferences75.Append(pivotAreaReference75);

            pivotArea75.Append(pivotAreaReferences75);

            chartFormat75.Append(pivotArea75);

            ChartFormat chartFormat76 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea76 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences76 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference76 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem98 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference76.Append(fieldItem98);

            pivotAreaReferences76.Append(pivotAreaReference76);

            pivotArea76.Append(pivotAreaReferences76);

            chartFormat76.Append(pivotArea76);

            ChartFormat chartFormat77 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };

            PivotArea pivotArea77 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences77 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference77 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem99 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference77.Append(fieldItem99);

            pivotAreaReferences77.Append(pivotAreaReference77);

            pivotArea77.Append(pivotAreaReferences77);

            chartFormat77.Append(pivotArea77);

            ChartFormat chartFormat78 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };

            PivotArea pivotArea78 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences78 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference78 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem100 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference78.Append(fieldItem100);

            pivotAreaReferences78.Append(pivotAreaReference78);

            pivotArea78.Append(pivotAreaReferences78);

            chartFormat78.Append(pivotArea78);

            ChartFormat chartFormat79 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };

            PivotArea pivotArea79 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences79 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference79 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem101 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference79.Append(fieldItem101);

            pivotAreaReferences79.Append(pivotAreaReference79);

            pivotArea79.Append(pivotAreaReferences79);

            chartFormat79.Append(pivotArea79);

            ChartFormat chartFormat80 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };

            PivotArea pivotArea80 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences80 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference80 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem102 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference80.Append(fieldItem102);

            pivotAreaReferences80.Append(pivotAreaReference80);

            pivotArea80.Append(pivotAreaReferences80);

            chartFormat80.Append(pivotArea80);

            ChartFormat chartFormat81 = new ChartFormat(){ Chart = (UInt32Value)15U, Format = (UInt32Value)18U, Series = true };

            PivotArea pivotArea81 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences81 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference81 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem103 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference81.Append(fieldItem103);

            pivotAreaReferences81.Append(pivotAreaReference81);

            pivotArea81.Append(pivotAreaReferences81);

            chartFormat81.Append(pivotArea81);

            ChartFormat chartFormat82 = new ChartFormat(){ Chart = (UInt32Value)16U, Format = (UInt32Value)5U, Series = true };

            PivotArea pivotArea82 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences82 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference82 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem104 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference82.Append(fieldItem104);

            pivotAreaReferences82.Append(pivotAreaReference82);

            pivotArea82.Append(pivotAreaReferences82);

            chartFormat82.Append(pivotArea82);

            chartFormats9.Append(chartFormat70);
            chartFormats9.Append(chartFormat71);
            chartFormats9.Append(chartFormat72);
            chartFormats9.Append(chartFormat73);
            chartFormats9.Append(chartFormat74);
            chartFormats9.Append(chartFormat75);
            chartFormats9.Append(chartFormat76);
            chartFormats9.Append(chartFormat77);
            chartFormats9.Append(chartFormat78);
            chartFormats9.Append(chartFormat79);
            chartFormats9.Append(chartFormat80);
            chartFormats9.Append(chartFormat81);
            chartFormats9.Append(chartFormat82);
            PivotTableStyle pivotTableStyle9 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotFilters pivotFilters1 = new PivotFilters(){ Count = (UInt32Value)1U };

            PivotFilter pivotFilter1 = new PivotFilter(){ Field = (UInt32Value)4U, Type = PivotFilterValues.DateBetween, EvaluationOrder = -1, Id = (UInt32Value)6U, Name = "DeliveryDate" };

            AutoFilter autoFilter7 = new AutoFilter(){ Reference = "A1" };

            FilterColumn filterColumn1 = new FilterColumn(){ ColumnId = (UInt32Value)0U };

            CustomFilters customFilters1 = new CustomFilters(){ And = true };
            CustomFilter customFilter1 = new CustomFilter(){ Operator = FilterOperatorValues.GreaterThanOrEqual, Val = "36526" };
            CustomFilter customFilter2 = new CustomFilter(){ Operator = FilterOperatorValues.LessThanOrEqual, Val = "37986" };

            customFilters1.Append(customFilter1);
            customFilters1.Append(customFilter2);

            filterColumn1.Append(customFilters1);

            autoFilter7.Append(filterColumn1);

            PivotFilterExtensionList pivotFilterExtensionList1 = new PivotFilterExtensionList();

            PivotFilterExtension pivotFilterExtension1 = new PivotFilterExtension(){ Uri = "{0605FD5F-26C8-4aeb-8148-2DB25E43C511}" };
            pivotFilterExtension1.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
            X15.PivotFilter pivotFilter2 = new X15.PivotFilter(){ UseWholeDay = true };

            pivotFilterExtension1.Append(pivotFilter2);

            pivotFilterExtensionList1.Append(pivotFilterExtension1);

            pivotFilter1.Append(autoFilter7);
            pivotFilter1.Append(pivotFilterExtensionList1);

            pivotFilters1.Append(pivotFilter1);

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList9 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension9 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension9.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition18 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition18.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension9.Append(pivotTableDefinition18);

            pivotTableDefinitionExtensionList9.Append(pivotTableDefinitionExtension9);

            pivotTableDefinition17.Append(location9);
            pivotTableDefinition17.Append(pivotFields9);
            pivotTableDefinition17.Append(rowFields9);
            pivotTableDefinition17.Append(rowItems9);
            pivotTableDefinition17.Append(columnItems9);
            pivotTableDefinition17.Append(dataFields9);
            pivotTableDefinition17.Append(chartFormats9);
            pivotTableDefinition17.Append(pivotTableStyle9);
            pivotTableDefinition17.Append(pivotFilters1);
            pivotTableDefinition17.Append(pivotTableDefinitionExtensionList9);

            pivotTablePart9.PivotTableDefinition = pivotTableDefinition17;
        }
コード例 #6
0
        // Generates content of pivotTablePart7.
        private void GeneratePivotTablePart7Content(PivotTablePart pivotTablePart7)
        {
            PivotTableDefinition pivotTableDefinition13 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)19U };
            Location location7 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields7 = new PivotFields(){ Count = (UInt32Value)7U };

            PivotField pivotField42 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items23 = new Items(){ Count = (UInt32Value)15U };
            Item item198 = new Item(){ Index = (UInt32Value)0U };
            Item item199 = new Item(){ Index = (UInt32Value)1U };
            Item item200 = new Item(){ Index = (UInt32Value)2U };
            Item item201 = new Item(){ Index = (UInt32Value)3U };
            Item item202 = new Item(){ Index = (UInt32Value)4U };
            Item item203 = new Item(){ Index = (UInt32Value)5U };
            Item item204 = new Item(){ Index = (UInt32Value)6U };
            Item item205 = new Item(){ Index = (UInt32Value)7U };
            Item item206 = new Item(){ Index = (UInt32Value)8U };
            Item item207 = new Item(){ Index = (UInt32Value)9U };
            Item item208 = new Item(){ Index = (UInt32Value)10U };
            Item item209 = new Item(){ Index = (UInt32Value)11U };
            Item item210 = new Item(){ Index = (UInt32Value)12U };
            Item item211 = new Item(){ Index = (UInt32Value)13U };
            Item item212 = new Item(){ ItemType = ItemValues.Default };

            items23.Append(item198);
            items23.Append(item199);
            items23.Append(item200);
            items23.Append(item201);
            items23.Append(item202);
            items23.Append(item203);
            items23.Append(item204);
            items23.Append(item205);
            items23.Append(item206);
            items23.Append(item207);
            items23.Append(item208);
            items23.Append(item209);
            items23.Append(item210);
            items23.Append(item211);
            items23.Append(item212);

            pivotField42.Append(items23);

            PivotField pivotField43 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items24 = new Items(){ Count = (UInt32Value)11U };
            Item item213 = new Item(){ Index = (UInt32Value)0U };
            Item item214 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item215 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item216 = new Item(){ Index = (UInt32Value)1U };
            Item item217 = new Item(){ Index = (UInt32Value)2U };
            Item item218 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item219 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item220 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item221 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item222 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item223 = new Item(){ ItemType = ItemValues.Default };

            items24.Append(item213);
            items24.Append(item214);
            items24.Append(item215);
            items24.Append(item216);
            items24.Append(item217);
            items24.Append(item218);
            items24.Append(item219);
            items24.Append(item220);
            items24.Append(item221);
            items24.Append(item222);
            items24.Append(item223);

            pivotField43.Append(items24);
            PivotField pivotField44 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField45 = new PivotField(){ ShowAll = false };

            PivotField pivotField46 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items25 = new Items(){ Count = (UInt32Value)5U };
            Item item224 = new Item(){ Index = (UInt32Value)0U };
            Item item225 = new Item(){ Index = (UInt32Value)1U };
            Item item226 = new Item(){ Index = (UInt32Value)3U };
            Item item227 = new Item(){ Index = (UInt32Value)2U };
            Item item228 = new Item(){ ItemType = ItemValues.Default };

            items25.Append(item224);
            items25.Append(item225);
            items25.Append(item226);
            items25.Append(item227);
            items25.Append(item228);

            pivotField46.Append(items25);
            PivotField pivotField47 = new PivotField(){ ShowAll = false };

            PivotField pivotField48 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };

            Items items26 = new Items(){ Count = (UInt32Value)5U };
            Item item229 = new Item(){ Index = (UInt32Value)0U };
            Item item230 = new Item(){ Index = (UInt32Value)1U };
            Item item231 = new Item(){ Index = (UInt32Value)2U };
            Item item232 = new Item(){ Index = (UInt32Value)3U };
            Item item233 = new Item(){ Index = (UInt32Value)4U };

            items26.Append(item229);
            items26.Append(item230);
            items26.Append(item231);
            items26.Append(item232);
            items26.Append(item233);

            pivotField48.Append(items26);

            pivotFields7.Append(pivotField42);
            pivotFields7.Append(pivotField43);
            pivotFields7.Append(pivotField44);
            pivotFields7.Append(pivotField45);
            pivotFields7.Append(pivotField46);
            pivotFields7.Append(pivotField47);
            pivotFields7.Append(pivotField48);

            RowFields rowFields7 = new RowFields(){ Count = (UInt32Value)1U };
            Field field7 = new Field(){ Index = 1 };

            rowFields7.Append(field7);

            RowItems rowItems7 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem31 = new RowItem();
            MemberPropertyIndex memberPropertyIndex25 = new MemberPropertyIndex();

            rowItem31.Append(memberPropertyIndex25);

            RowItem rowItem32 = new RowItem();
            MemberPropertyIndex memberPropertyIndex26 = new MemberPropertyIndex(){ Val = 3 };

            rowItem32.Append(memberPropertyIndex26);

            RowItem rowItem33 = new RowItem();
            MemberPropertyIndex memberPropertyIndex27 = new MemberPropertyIndex(){ Val = 4 };

            rowItem33.Append(memberPropertyIndex27);

            RowItem rowItem34 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex28 = new MemberPropertyIndex();

            rowItem34.Append(memberPropertyIndex28);

            rowItems7.Append(rowItem31);
            rowItems7.Append(rowItem32);
            rowItems7.Append(rowItem33);
            rowItems7.Append(rowItem34);

            ColumnItems columnItems7 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem35 = new RowItem();

            columnItems7.Append(rowItem35);

            DataFields dataFields7 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField7 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields7.Append(dataField7);

            ChartFormats chartFormats7 = new ChartFormats(){ Count = (UInt32Value)15U };

            ChartFormat chartFormat52 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea52 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences52 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference52 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem74 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference52.Append(fieldItem74);

            pivotAreaReferences52.Append(pivotAreaReference52);

            pivotArea52.Append(pivotAreaReferences52);

            chartFormat52.Append(pivotArea52);

            ChartFormat chartFormat53 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea53 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences53 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference53 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem75 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference53.Append(fieldItem75);

            pivotAreaReferences53.Append(pivotAreaReference53);

            pivotArea53.Append(pivotAreaReferences53);

            chartFormat53.Append(pivotArea53);

            ChartFormat chartFormat54 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea54 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences54 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference54 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem76 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference54.Append(fieldItem76);

            pivotAreaReferences54.Append(pivotAreaReference54);

            pivotArea54.Append(pivotAreaReferences54);

            chartFormat54.Append(pivotArea54);

            ChartFormat chartFormat55 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };

            PivotArea pivotArea55 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences55 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference55 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem77 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference55.Append(fieldItem77);

            pivotAreaReferences55.Append(pivotAreaReference55);

            pivotArea55.Append(pivotAreaReferences55);

            chartFormat55.Append(pivotArea55);

            ChartFormat chartFormat56 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };

            PivotArea pivotArea56 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences56 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference56 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem78 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference56.Append(fieldItem78);

            pivotAreaReferences56.Append(pivotAreaReference56);

            pivotArea56.Append(pivotAreaReferences56);

            chartFormat56.Append(pivotArea56);

            ChartFormat chartFormat57 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };

            PivotArea pivotArea57 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences57 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference57 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem79 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference57.Append(fieldItem79);

            pivotAreaReferences57.Append(pivotAreaReference57);

            pivotArea57.Append(pivotAreaReferences57);

            chartFormat57.Append(pivotArea57);

            ChartFormat chartFormat58 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea58 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences58 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference58 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem80 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference58.Append(fieldItem80);

            pivotAreaReferences58.Append(pivotAreaReference58);

            pivotArea58.Append(pivotAreaReferences58);

            chartFormat58.Append(pivotArea58);

            ChartFormat chartFormat59 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };

            PivotArea pivotArea59 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences59 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference59 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem81 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference59.Append(fieldItem81);

            pivotAreaReferences59.Append(pivotAreaReference59);

            pivotArea59.Append(pivotAreaReferences59);

            chartFormat59.Append(pivotArea59);

            ChartFormat chartFormat60 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };

            PivotArea pivotArea60 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences60 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference60 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem82 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference60.Append(fieldItem82);

            pivotAreaReferences60.Append(pivotAreaReference60);

            pivotArea60.Append(pivotAreaReferences60);

            chartFormat60.Append(pivotArea60);

            ChartFormat chartFormat61 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };

            PivotArea pivotArea61 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences61 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference61 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem83 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference61.Append(fieldItem83);

            pivotAreaReferences61.Append(pivotAreaReference61);

            pivotArea61.Append(pivotAreaReferences61);

            chartFormat61.Append(pivotArea61);

            ChartFormat chartFormat62 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };

            PivotArea pivotArea62 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences62 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference62 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem84 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference62.Append(fieldItem84);

            pivotAreaReferences62.Append(pivotAreaReference62);

            pivotArea62.Append(pivotAreaReferences62);

            chartFormat62.Append(pivotArea62);

            ChartFormat chartFormat63 = new ChartFormat(){ Chart = (UInt32Value)15U, Format = (UInt32Value)18U, Series = true };

            PivotArea pivotArea63 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences63 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference63 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem85 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference63.Append(fieldItem85);

            pivotAreaReferences63.Append(pivotAreaReference63);

            pivotArea63.Append(pivotAreaReferences63);

            chartFormat63.Append(pivotArea63);

            ChartFormat chartFormat64 = new ChartFormat(){ Chart = (UInt32Value)16U, Format = (UInt32Value)5U, Series = true };

            PivotArea pivotArea64 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences64 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference64 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem86 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference64.Append(fieldItem86);

            pivotAreaReferences64.Append(pivotAreaReference64);

            pivotArea64.Append(pivotAreaReferences64);

            chartFormat64.Append(pivotArea64);

            ChartFormat chartFormat65 = new ChartFormat(){ Chart = (UInt32Value)17U, Format = (UInt32Value)19U, Series = true };

            PivotArea pivotArea65 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences65 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference65 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem87 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference65.Append(fieldItem87);

            pivotAreaReferences65.Append(pivotAreaReference65);

            pivotArea65.Append(pivotAreaReferences65);

            chartFormat65.Append(pivotArea65);

            ChartFormat chartFormat66 = new ChartFormat(){ Chart = (UInt32Value)18U, Format = (UInt32Value)6U, Series = true };

            PivotArea pivotArea66 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences66 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference66 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem88 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference66.Append(fieldItem88);

            pivotAreaReferences66.Append(pivotAreaReference66);

            pivotArea66.Append(pivotAreaReferences66);

            chartFormat66.Append(pivotArea66);

            chartFormats7.Append(chartFormat52);
            chartFormats7.Append(chartFormat53);
            chartFormats7.Append(chartFormat54);
            chartFormats7.Append(chartFormat55);
            chartFormats7.Append(chartFormat56);
            chartFormats7.Append(chartFormat57);
            chartFormats7.Append(chartFormat58);
            chartFormats7.Append(chartFormat59);
            chartFormats7.Append(chartFormat60);
            chartFormats7.Append(chartFormat61);
            chartFormats7.Append(chartFormat62);
            chartFormats7.Append(chartFormat63);
            chartFormats7.Append(chartFormat64);
            chartFormats7.Append(chartFormat65);
            chartFormats7.Append(chartFormat66);
            PivotTableStyle pivotTableStyle7 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList7 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension7 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension7.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition14 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition14.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension7.Append(pivotTableDefinition14);

            pivotTableDefinitionExtensionList7.Append(pivotTableDefinitionExtension7);

            pivotTableDefinition13.Append(location7);
            pivotTableDefinition13.Append(pivotFields7);
            pivotTableDefinition13.Append(rowFields7);
            pivotTableDefinition13.Append(rowItems7);
            pivotTableDefinition13.Append(columnItems7);
            pivotTableDefinition13.Append(dataFields7);
            pivotTableDefinition13.Append(chartFormats7);
            pivotTableDefinition13.Append(pivotTableStyle7);
            pivotTableDefinition13.Append(pivotTableDefinitionExtensionList7);

            pivotTablePart7.PivotTableDefinition = pivotTableDefinition13;
        }
コード例 #7
0
        // Generates content of pivotTablePart6.
        private void GeneratePivotTablePart6Content(PivotTablePart pivotTablePart6)
        {
            PivotTableDefinition pivotTableDefinition11 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)9U };
            Location location6 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields6 = new PivotFields(){ Count = (UInt32Value)7U };

            PivotField pivotField35 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items19 = new Items(){ Count = (UInt32Value)15U };
            Item item162 = new Item(){ Index = (UInt32Value)0U };
            Item item163 = new Item(){ Index = (UInt32Value)1U };
            Item item164 = new Item(){ Index = (UInt32Value)2U };
            Item item165 = new Item(){ Index = (UInt32Value)3U };
            Item item166 = new Item(){ Index = (UInt32Value)4U };
            Item item167 = new Item(){ Index = (UInt32Value)5U };
            Item item168 = new Item(){ Index = (UInt32Value)6U };
            Item item169 = new Item(){ Index = (UInt32Value)7U };
            Item item170 = new Item(){ Index = (UInt32Value)8U };
            Item item171 = new Item(){ Index = (UInt32Value)9U };
            Item item172 = new Item(){ Index = (UInt32Value)10U };
            Item item173 = new Item(){ Index = (UInt32Value)11U };
            Item item174 = new Item(){ Index = (UInt32Value)12U };
            Item item175 = new Item(){ Index = (UInt32Value)13U };
            Item item176 = new Item(){ ItemType = ItemValues.Default };

            items19.Append(item162);
            items19.Append(item163);
            items19.Append(item164);
            items19.Append(item165);
            items19.Append(item166);
            items19.Append(item167);
            items19.Append(item168);
            items19.Append(item169);
            items19.Append(item170);
            items19.Append(item171);
            items19.Append(item172);
            items19.Append(item173);
            items19.Append(item174);
            items19.Append(item175);
            items19.Append(item176);

            pivotField35.Append(items19);

            PivotField pivotField36 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items20 = new Items(){ Count = (UInt32Value)11U };
            Item item177 = new Item(){ Index = (UInt32Value)0U };
            Item item178 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item179 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item180 = new Item(){ Index = (UInt32Value)1U };
            Item item181 = new Item(){ Index = (UInt32Value)2U };
            Item item182 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item183 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item184 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item185 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item186 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item187 = new Item(){ ItemType = ItemValues.Default };

            items20.Append(item177);
            items20.Append(item178);
            items20.Append(item179);
            items20.Append(item180);
            items20.Append(item181);
            items20.Append(item182);
            items20.Append(item183);
            items20.Append(item184);
            items20.Append(item185);
            items20.Append(item186);
            items20.Append(item187);

            pivotField36.Append(items20);
            PivotField pivotField37 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField38 = new PivotField(){ ShowAll = false };

            PivotField pivotField39 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items21 = new Items(){ Count = (UInt32Value)5U };
            Item item188 = new Item(){ Index = (UInt32Value)0U };
            Item item189 = new Item(){ Index = (UInt32Value)1U };
            Item item190 = new Item(){ Index = (UInt32Value)3U };
            Item item191 = new Item(){ Index = (UInt32Value)2U };
            Item item192 = new Item(){ ItemType = ItemValues.Default };

            items21.Append(item188);
            items21.Append(item189);
            items21.Append(item190);
            items21.Append(item191);
            items21.Append(item192);

            pivotField39.Append(items21);
            PivotField pivotField40 = new PivotField(){ ShowAll = false };

            PivotField pivotField41 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };

            Items items22 = new Items(){ Count = (UInt32Value)5U };
            Item item193 = new Item(){ Index = (UInt32Value)0U };
            Item item194 = new Item(){ Index = (UInt32Value)1U };
            Item item195 = new Item(){ Index = (UInt32Value)2U };
            Item item196 = new Item(){ Index = (UInt32Value)3U };
            Item item197 = new Item(){ Index = (UInt32Value)4U };

            items22.Append(item193);
            items22.Append(item194);
            items22.Append(item195);
            items22.Append(item196);
            items22.Append(item197);

            pivotField41.Append(items22);

            pivotFields6.Append(pivotField35);
            pivotFields6.Append(pivotField36);
            pivotFields6.Append(pivotField37);
            pivotFields6.Append(pivotField38);
            pivotFields6.Append(pivotField39);
            pivotFields6.Append(pivotField40);
            pivotFields6.Append(pivotField41);

            RowFields rowFields6 = new RowFields(){ Count = (UInt32Value)1U };
            Field field6 = new Field(){ Index = 1 };

            rowFields6.Append(field6);

            RowItems rowItems6 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem26 = new RowItem();
            MemberPropertyIndex memberPropertyIndex21 = new MemberPropertyIndex();

            rowItem26.Append(memberPropertyIndex21);

            RowItem rowItem27 = new RowItem();
            MemberPropertyIndex memberPropertyIndex22 = new MemberPropertyIndex(){ Val = 3 };

            rowItem27.Append(memberPropertyIndex22);

            RowItem rowItem28 = new RowItem();
            MemberPropertyIndex memberPropertyIndex23 = new MemberPropertyIndex(){ Val = 4 };

            rowItem28.Append(memberPropertyIndex23);

            RowItem rowItem29 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex24 = new MemberPropertyIndex();

            rowItem29.Append(memberPropertyIndex24);

            rowItems6.Append(rowItem26);
            rowItems6.Append(rowItem27);
            rowItems6.Append(rowItem28);
            rowItems6.Append(rowItem29);

            ColumnItems columnItems6 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem30 = new RowItem();

            columnItems6.Append(rowItem30);

            DataFields dataFields6 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField6 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields6.Append(dataField6);

            ChartFormats chartFormats6 = new ChartFormats(){ Count = (UInt32Value)5U };

            ChartFormat chartFormat47 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea47 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences47 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference47 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem69 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference47.Append(fieldItem69);

            pivotAreaReferences47.Append(pivotAreaReference47);

            pivotArea47.Append(pivotAreaReferences47);

            chartFormat47.Append(pivotArea47);

            ChartFormat chartFormat48 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea48 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences48 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference48 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem70 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference48.Append(fieldItem70);

            pivotAreaReferences48.Append(pivotAreaReference48);

            pivotArea48.Append(pivotAreaReferences48);

            chartFormat48.Append(pivotArea48);

            ChartFormat chartFormat49 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea49 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences49 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference49 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem71 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference49.Append(fieldItem71);

            pivotAreaReferences49.Append(pivotAreaReference49);

            pivotArea49.Append(pivotAreaReferences49);

            chartFormat49.Append(pivotArea49);

            ChartFormat chartFormat50 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };

            PivotArea pivotArea50 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences50 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference50 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem72 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference50.Append(fieldItem72);

            pivotAreaReferences50.Append(pivotAreaReference50);

            pivotArea50.Append(pivotAreaReferences50);

            chartFormat50.Append(pivotArea50);

            ChartFormat chartFormat51 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };

            PivotArea pivotArea51 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences51 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference51 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem73 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference51.Append(fieldItem73);

            pivotAreaReferences51.Append(pivotAreaReference51);

            pivotArea51.Append(pivotAreaReferences51);

            chartFormat51.Append(pivotArea51);

            chartFormats6.Append(chartFormat47);
            chartFormats6.Append(chartFormat48);
            chartFormats6.Append(chartFormat49);
            chartFormats6.Append(chartFormat50);
            chartFormats6.Append(chartFormat51);
            PivotTableStyle pivotTableStyle6 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList6 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension6 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension6.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition12 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition12.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension6.Append(pivotTableDefinition12);

            pivotTableDefinitionExtensionList6.Append(pivotTableDefinitionExtension6);

            pivotTableDefinition11.Append(location6);
            pivotTableDefinition11.Append(pivotFields6);
            pivotTableDefinition11.Append(rowFields6);
            pivotTableDefinition11.Append(rowItems6);
            pivotTableDefinition11.Append(columnItems6);
            pivotTableDefinition11.Append(dataFields6);
            pivotTableDefinition11.Append(chartFormats6);
            pivotTableDefinition11.Append(pivotTableStyle6);
            pivotTableDefinition11.Append(pivotTableDefinitionExtensionList6);

            pivotTablePart6.PivotTableDefinition = pivotTableDefinition11;
        }
コード例 #8
0
        // Generates content of pivotTablePart5.
        private void GeneratePivotTablePart5Content(PivotTablePart pivotTablePart5)
        {
            PivotTableDefinition pivotTableDefinition9 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)21U };
            Location location5 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields5 = new PivotFields(){ Count = (UInt32Value)7U };

            PivotField pivotField28 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items15 = new Items(){ Count = (UInt32Value)15U };
            Item item126 = new Item(){ Index = (UInt32Value)0U };
            Item item127 = new Item(){ Index = (UInt32Value)1U };
            Item item128 = new Item(){ Index = (UInt32Value)2U };
            Item item129 = new Item(){ Index = (UInt32Value)3U };
            Item item130 = new Item(){ Index = (UInt32Value)4U };
            Item item131 = new Item(){ Index = (UInt32Value)5U };
            Item item132 = new Item(){ Index = (UInt32Value)6U };
            Item item133 = new Item(){ Index = (UInt32Value)7U };
            Item item134 = new Item(){ Index = (UInt32Value)8U };
            Item item135 = new Item(){ Index = (UInt32Value)9U };
            Item item136 = new Item(){ Index = (UInt32Value)10U };
            Item item137 = new Item(){ Index = (UInt32Value)11U };
            Item item138 = new Item(){ Index = (UInt32Value)12U };
            Item item139 = new Item(){ Index = (UInt32Value)13U };
            Item item140 = new Item(){ ItemType = ItemValues.Default };

            items15.Append(item126);
            items15.Append(item127);
            items15.Append(item128);
            items15.Append(item129);
            items15.Append(item130);
            items15.Append(item131);
            items15.Append(item132);
            items15.Append(item133);
            items15.Append(item134);
            items15.Append(item135);
            items15.Append(item136);
            items15.Append(item137);
            items15.Append(item138);
            items15.Append(item139);
            items15.Append(item140);

            pivotField28.Append(items15);

            PivotField pivotField29 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items16 = new Items(){ Count = (UInt32Value)11U };
            Item item141 = new Item(){ Index = (UInt32Value)0U };
            Item item142 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item143 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item144 = new Item(){ Index = (UInt32Value)1U };
            Item item145 = new Item(){ Index = (UInt32Value)2U };
            Item item146 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item147 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item148 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item149 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item150 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item151 = new Item(){ ItemType = ItemValues.Default };

            items16.Append(item141);
            items16.Append(item142);
            items16.Append(item143);
            items16.Append(item144);
            items16.Append(item145);
            items16.Append(item146);
            items16.Append(item147);
            items16.Append(item148);
            items16.Append(item149);
            items16.Append(item150);
            items16.Append(item151);

            pivotField29.Append(items16);
            PivotField pivotField30 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField31 = new PivotField(){ ShowAll = false };

            PivotField pivotField32 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items17 = new Items(){ Count = (UInt32Value)5U };
            Item item152 = new Item(){ Index = (UInt32Value)0U };
            Item item153 = new Item(){ Index = (UInt32Value)1U };
            Item item154 = new Item(){ Index = (UInt32Value)3U };
            Item item155 = new Item(){ Index = (UInt32Value)2U };
            Item item156 = new Item(){ ItemType = ItemValues.Default };

            items17.Append(item152);
            items17.Append(item153);
            items17.Append(item154);
            items17.Append(item155);
            items17.Append(item156);

            pivotField32.Append(items17);
            PivotField pivotField33 = new PivotField(){ ShowAll = false };

            PivotField pivotField34 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };

            Items items18 = new Items(){ Count = (UInt32Value)5U };
            Item item157 = new Item(){ Index = (UInt32Value)0U };
            Item item158 = new Item(){ Index = (UInt32Value)1U };
            Item item159 = new Item(){ Index = (UInt32Value)2U };
            Item item160 = new Item(){ Index = (UInt32Value)3U };
            Item item161 = new Item(){ Index = (UInt32Value)4U };

            items18.Append(item157);
            items18.Append(item158);
            items18.Append(item159);
            items18.Append(item160);
            items18.Append(item161);

            pivotField34.Append(items18);

            pivotFields5.Append(pivotField28);
            pivotFields5.Append(pivotField29);
            pivotFields5.Append(pivotField30);
            pivotFields5.Append(pivotField31);
            pivotFields5.Append(pivotField32);
            pivotFields5.Append(pivotField33);
            pivotFields5.Append(pivotField34);

            RowFields rowFields5 = new RowFields(){ Count = (UInt32Value)1U };
            Field field5 = new Field(){ Index = 1 };

            rowFields5.Append(field5);

            RowItems rowItems5 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem21 = new RowItem();
            MemberPropertyIndex memberPropertyIndex17 = new MemberPropertyIndex();

            rowItem21.Append(memberPropertyIndex17);

            RowItem rowItem22 = new RowItem();
            MemberPropertyIndex memberPropertyIndex18 = new MemberPropertyIndex(){ Val = 3 };

            rowItem22.Append(memberPropertyIndex18);

            RowItem rowItem23 = new RowItem();
            MemberPropertyIndex memberPropertyIndex19 = new MemberPropertyIndex(){ Val = 4 };

            rowItem23.Append(memberPropertyIndex19);

            RowItem rowItem24 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex20 = new MemberPropertyIndex();

            rowItem24.Append(memberPropertyIndex20);

            rowItems5.Append(rowItem21);
            rowItems5.Append(rowItem22);
            rowItems5.Append(rowItem23);
            rowItems5.Append(rowItem24);

            ColumnItems columnItems5 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem25 = new RowItem();

            columnItems5.Append(rowItem25);

            DataFields dataFields5 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField5 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields5.Append(dataField5);

            ChartFormats chartFormats5 = new ChartFormats(){ Count = (UInt32Value)17U };

            ChartFormat chartFormat30 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea30 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences30 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference30 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem52 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference30.Append(fieldItem52);

            pivotAreaReferences30.Append(pivotAreaReference30);

            pivotArea30.Append(pivotAreaReferences30);

            chartFormat30.Append(pivotArea30);

            ChartFormat chartFormat31 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea31 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences31 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference31 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem53 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference31.Append(fieldItem53);

            pivotAreaReferences31.Append(pivotAreaReference31);

            pivotArea31.Append(pivotAreaReferences31);

            chartFormat31.Append(pivotArea31);

            ChartFormat chartFormat32 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea32 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences32 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference32 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem54 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference32.Append(fieldItem54);

            pivotAreaReferences32.Append(pivotAreaReference32);

            pivotArea32.Append(pivotAreaReferences32);

            chartFormat32.Append(pivotArea32);

            ChartFormat chartFormat33 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };

            PivotArea pivotArea33 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences33 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference33 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem55 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference33.Append(fieldItem55);

            pivotAreaReferences33.Append(pivotAreaReference33);

            pivotArea33.Append(pivotAreaReferences33);

            chartFormat33.Append(pivotArea33);

            ChartFormat chartFormat34 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };

            PivotArea pivotArea34 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences34 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference34 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem56 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference34.Append(fieldItem56);

            pivotAreaReferences34.Append(pivotAreaReference34);

            pivotArea34.Append(pivotAreaReferences34);

            chartFormat34.Append(pivotArea34);

            ChartFormat chartFormat35 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };

            PivotArea pivotArea35 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences35 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference35 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem57 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference35.Append(fieldItem57);

            pivotAreaReferences35.Append(pivotAreaReference35);

            pivotArea35.Append(pivotAreaReferences35);

            chartFormat35.Append(pivotArea35);

            ChartFormat chartFormat36 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea36 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences36 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference36 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem58 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference36.Append(fieldItem58);

            pivotAreaReferences36.Append(pivotAreaReference36);

            pivotArea36.Append(pivotAreaReferences36);

            chartFormat36.Append(pivotArea36);

            ChartFormat chartFormat37 = new ChartFormat(){ Chart = (UInt32Value)11U, Format = (UInt32Value)16U, Series = true };

            PivotArea pivotArea37 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences37 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference37 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem59 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference37.Append(fieldItem59);

            pivotAreaReferences37.Append(pivotAreaReference37);

            pivotArea37.Append(pivotAreaReferences37);

            chartFormat37.Append(pivotArea37);

            ChartFormat chartFormat38 = new ChartFormat(){ Chart = (UInt32Value)12U, Format = (UInt32Value)3U, Series = true };

            PivotArea pivotArea38 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences38 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference38 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem60 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference38.Append(fieldItem60);

            pivotAreaReferences38.Append(pivotAreaReference38);

            pivotArea38.Append(pivotAreaReferences38);

            chartFormat38.Append(pivotArea38);

            ChartFormat chartFormat39 = new ChartFormat(){ Chart = (UInt32Value)13U, Format = (UInt32Value)17U, Series = true };

            PivotArea pivotArea39 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences39 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference39 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem61 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference39.Append(fieldItem61);

            pivotAreaReferences39.Append(pivotAreaReference39);

            pivotArea39.Append(pivotAreaReferences39);

            chartFormat39.Append(pivotArea39);

            ChartFormat chartFormat40 = new ChartFormat(){ Chart = (UInt32Value)14U, Format = (UInt32Value)4U, Series = true };

            PivotArea pivotArea40 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences40 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference40 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem62 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference40.Append(fieldItem62);

            pivotAreaReferences40.Append(pivotAreaReference40);

            pivotArea40.Append(pivotAreaReferences40);

            chartFormat40.Append(pivotArea40);

            ChartFormat chartFormat41 = new ChartFormat(){ Chart = (UInt32Value)15U, Format = (UInt32Value)18U, Series = true };

            PivotArea pivotArea41 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences41 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference41 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem63 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference41.Append(fieldItem63);

            pivotAreaReferences41.Append(pivotAreaReference41);

            pivotArea41.Append(pivotAreaReferences41);

            chartFormat41.Append(pivotArea41);

            ChartFormat chartFormat42 = new ChartFormat(){ Chart = (UInt32Value)16U, Format = (UInt32Value)5U, Series = true };

            PivotArea pivotArea42 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences42 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference42 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem64 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference42.Append(fieldItem64);

            pivotAreaReferences42.Append(pivotAreaReference42);

            pivotArea42.Append(pivotAreaReferences42);

            chartFormat42.Append(pivotArea42);

            ChartFormat chartFormat43 = new ChartFormat(){ Chart = (UInt32Value)17U, Format = (UInt32Value)19U, Series = true };

            PivotArea pivotArea43 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences43 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference43 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem65 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference43.Append(fieldItem65);

            pivotAreaReferences43.Append(pivotAreaReference43);

            pivotArea43.Append(pivotAreaReferences43);

            chartFormat43.Append(pivotArea43);

            ChartFormat chartFormat44 = new ChartFormat(){ Chart = (UInt32Value)18U, Format = (UInt32Value)6U, Series = true };

            PivotArea pivotArea44 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences44 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference44 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem66 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference44.Append(fieldItem66);

            pivotAreaReferences44.Append(pivotAreaReference44);

            pivotArea44.Append(pivotAreaReferences44);

            chartFormat44.Append(pivotArea44);

            ChartFormat chartFormat45 = new ChartFormat(){ Chart = (UInt32Value)19U, Format = (UInt32Value)20U, Series = true };

            PivotArea pivotArea45 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences45 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference45 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem67 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference45.Append(fieldItem67);

            pivotAreaReferences45.Append(pivotAreaReference45);

            pivotArea45.Append(pivotAreaReferences45);

            chartFormat45.Append(pivotArea45);

            ChartFormat chartFormat46 = new ChartFormat(){ Chart = (UInt32Value)20U, Format = (UInt32Value)7U, Series = true };

            PivotArea pivotArea46 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences46 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference46 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem68 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference46.Append(fieldItem68);

            pivotAreaReferences46.Append(pivotAreaReference46);

            pivotArea46.Append(pivotAreaReferences46);

            chartFormat46.Append(pivotArea46);

            chartFormats5.Append(chartFormat30);
            chartFormats5.Append(chartFormat31);
            chartFormats5.Append(chartFormat32);
            chartFormats5.Append(chartFormat33);
            chartFormats5.Append(chartFormat34);
            chartFormats5.Append(chartFormat35);
            chartFormats5.Append(chartFormat36);
            chartFormats5.Append(chartFormat37);
            chartFormats5.Append(chartFormat38);
            chartFormats5.Append(chartFormat39);
            chartFormats5.Append(chartFormat40);
            chartFormats5.Append(chartFormat41);
            chartFormats5.Append(chartFormat42);
            chartFormats5.Append(chartFormat43);
            chartFormats5.Append(chartFormat44);
            chartFormats5.Append(chartFormat45);
            chartFormats5.Append(chartFormat46);
            PivotTableStyle pivotTableStyle5 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList5 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension5 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension5.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition10 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition10.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension5.Append(pivotTableDefinition10);

            pivotTableDefinitionExtensionList5.Append(pivotTableDefinitionExtension5);

            pivotTableDefinition9.Append(location5);
            pivotTableDefinition9.Append(pivotFields5);
            pivotTableDefinition9.Append(rowFields5);
            pivotTableDefinition9.Append(rowItems5);
            pivotTableDefinition9.Append(columnItems5);
            pivotTableDefinition9.Append(dataFields5);
            pivotTableDefinition9.Append(chartFormats5);
            pivotTableDefinition9.Append(pivotTableStyle5);
            pivotTableDefinition9.Append(pivotTableDefinitionExtensionList5);

            pivotTablePart5.PivotTableDefinition = pivotTableDefinition9;
        }
コード例 #9
0
        // Generates content of pivotTablePart4.
        private void GeneratePivotTablePart4Content(PivotTablePart pivotTablePart4)
        {
            PivotTableDefinition pivotTableDefinition7 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)1U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 5, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 4, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false, ChartFormat = (UInt32Value)11U };
            Location location4 = new Location(){ Reference = "A1:B5", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)1U };

            PivotFields pivotFields4 = new PivotFields(){ Count = (UInt32Value)7U };

            PivotField pivotField21 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items11 = new Items(){ Count = (UInt32Value)15U };
            Item item90 = new Item(){ Index = (UInt32Value)0U };
            Item item91 = new Item(){ Index = (UInt32Value)1U };
            Item item92 = new Item(){ Index = (UInt32Value)2U };
            Item item93 = new Item(){ Index = (UInt32Value)3U };
            Item item94 = new Item(){ Index = (UInt32Value)4U };
            Item item95 = new Item(){ Index = (UInt32Value)5U };
            Item item96 = new Item(){ Index = (UInt32Value)6U };
            Item item97 = new Item(){ Index = (UInt32Value)7U };
            Item item98 = new Item(){ Index = (UInt32Value)8U };
            Item item99 = new Item(){ Index = (UInt32Value)9U };
            Item item100 = new Item(){ Index = (UInt32Value)10U };
            Item item101 = new Item(){ Index = (UInt32Value)11U };
            Item item102 = new Item(){ Index = (UInt32Value)12U };
            Item item103 = new Item(){ Index = (UInt32Value)13U };
            Item item104 = new Item(){ ItemType = ItemValues.Default };

            items11.Append(item90);
            items11.Append(item91);
            items11.Append(item92);
            items11.Append(item93);
            items11.Append(item94);
            items11.Append(item95);
            items11.Append(item96);
            items11.Append(item97);
            items11.Append(item98);
            items11.Append(item99);
            items11.Append(item100);
            items11.Append(item101);
            items11.Append(item102);
            items11.Append(item103);
            items11.Append(item104);

            pivotField21.Append(items11);

            PivotField pivotField22 = new PivotField(){ Axis = PivotTableAxisValues.AxisRow, ShowAll = false };

            Items items12 = new Items(){ Count = (UInt32Value)11U };
            Item item105 = new Item(){ Index = (UInt32Value)0U };
            Item item106 = new Item(){ Missing = true, Index = (UInt32Value)4U };
            Item item107 = new Item(){ Missing = true, Index = (UInt32Value)3U };
            Item item108 = new Item(){ Index = (UInt32Value)1U };
            Item item109 = new Item(){ Index = (UInt32Value)2U };
            Item item110 = new Item(){ Missing = true, Index = (UInt32Value)9U };
            Item item111 = new Item(){ Missing = true, Index = (UInt32Value)8U };
            Item item112 = new Item(){ Missing = true, Index = (UInt32Value)7U };
            Item item113 = new Item(){ Missing = true, Index = (UInt32Value)6U };
            Item item114 = new Item(){ Missing = true, Index = (UInt32Value)5U };
            Item item115 = new Item(){ ItemType = ItemValues.Default };

            items12.Append(item105);
            items12.Append(item106);
            items12.Append(item107);
            items12.Append(item108);
            items12.Append(item109);
            items12.Append(item110);
            items12.Append(item111);
            items12.Append(item112);
            items12.Append(item113);
            items12.Append(item114);
            items12.Append(item115);

            pivotField22.Append(items12);
            PivotField pivotField23 = new PivotField(){ DataField = true, ShowAll = false };
            PivotField pivotField24 = new PivotField(){ ShowAll = false };

            PivotField pivotField25 = new PivotField(){ NumberFormatId = (UInt32Value)14U, ShowAll = false };

            Items items13 = new Items(){ Count = (UInt32Value)5U };
            Item item116 = new Item(){ Index = (UInt32Value)0U };
            Item item117 = new Item(){ Index = (UInt32Value)1U };
            Item item118 = new Item(){ Index = (UInt32Value)3U };
            Item item119 = new Item(){ Index = (UInt32Value)2U };
            Item item120 = new Item(){ ItemType = ItemValues.Default };

            items13.Append(item116);
            items13.Append(item117);
            items13.Append(item118);
            items13.Append(item119);
            items13.Append(item120);

            pivotField25.Append(items13);
            PivotField pivotField26 = new PivotField(){ ShowAll = false };

            PivotField pivotField27 = new PivotField(){ ShowAll = false, DefaultSubtotal = false };

            Items items14 = new Items(){ Count = (UInt32Value)5U };
            Item item121 = new Item(){ Index = (UInt32Value)0U };
            Item item122 = new Item(){ Index = (UInt32Value)1U };
            Item item123 = new Item(){ Index = (UInt32Value)2U };
            Item item124 = new Item(){ Index = (UInt32Value)3U };
            Item item125 = new Item(){ Index = (UInt32Value)4U };

            items14.Append(item121);
            items14.Append(item122);
            items14.Append(item123);
            items14.Append(item124);
            items14.Append(item125);

            pivotField27.Append(items14);

            pivotFields4.Append(pivotField21);
            pivotFields4.Append(pivotField22);
            pivotFields4.Append(pivotField23);
            pivotFields4.Append(pivotField24);
            pivotFields4.Append(pivotField25);
            pivotFields4.Append(pivotField26);
            pivotFields4.Append(pivotField27);

            RowFields rowFields4 = new RowFields(){ Count = (UInt32Value)1U };
            Field field4 = new Field(){ Index = 1 };

            rowFields4.Append(field4);

            RowItems rowItems4 = new RowItems(){ Count = (UInt32Value)4U };

            RowItem rowItem16 = new RowItem();
            MemberPropertyIndex memberPropertyIndex13 = new MemberPropertyIndex();

            rowItem16.Append(memberPropertyIndex13);

            RowItem rowItem17 = new RowItem();
            MemberPropertyIndex memberPropertyIndex14 = new MemberPropertyIndex(){ Val = 3 };

            rowItem17.Append(memberPropertyIndex14);

            RowItem rowItem18 = new RowItem();
            MemberPropertyIndex memberPropertyIndex15 = new MemberPropertyIndex(){ Val = 4 };

            rowItem18.Append(memberPropertyIndex15);

            RowItem rowItem19 = new RowItem(){ ItemType = ItemValues.Grand };
            MemberPropertyIndex memberPropertyIndex16 = new MemberPropertyIndex();

            rowItem19.Append(memberPropertyIndex16);

            rowItems4.Append(rowItem16);
            rowItems4.Append(rowItem17);
            rowItems4.Append(rowItem18);
            rowItems4.Append(rowItem19);

            ColumnItems columnItems4 = new ColumnItems(){ Count = (UInt32Value)1U };
            RowItem rowItem20 = new RowItem();

            columnItems4.Append(rowItem20);

            DataFields dataFields4 = new DataFields(){ Count = (UInt32Value)1U };
            DataField dataField4 = new DataField(){ Name = "Sum of Quantity", Field = (UInt32Value)2U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields4.Append(dataField4);

            ChartFormats chartFormats4 = new ChartFormats(){ Count = (UInt32Value)7U };

            ChartFormat chartFormat23 = new ChartFormat(){ Chart = (UInt32Value)4U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea23 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences23 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference23 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem45 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference23.Append(fieldItem45);

            pivotAreaReferences23.Append(pivotAreaReference23);

            pivotArea23.Append(pivotAreaReferences23);

            chartFormat23.Append(pivotArea23);

            ChartFormat chartFormat24 = new ChartFormat(){ Chart = (UInt32Value)5U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea24 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences24 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference24 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem46 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference24.Append(fieldItem46);

            pivotAreaReferences24.Append(pivotAreaReference24);

            pivotArea24.Append(pivotAreaReferences24);

            chartFormat24.Append(pivotArea24);

            ChartFormat chartFormat25 = new ChartFormat(){ Chart = (UInt32Value)6U, Format = (UInt32Value)0U, Series = true };

            PivotArea pivotArea25 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences25 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference25 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem47 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference25.Append(fieldItem47);

            pivotAreaReferences25.Append(pivotAreaReference25);

            pivotArea25.Append(pivotAreaReferences25);

            chartFormat25.Append(pivotArea25);

            ChartFormat chartFormat26 = new ChartFormat(){ Chart = (UInt32Value)7U, Format = (UInt32Value)14U, Series = true };

            PivotArea pivotArea26 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences26 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference26 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem48 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference26.Append(fieldItem48);

            pivotAreaReferences26.Append(pivotAreaReference26);

            pivotArea26.Append(pivotAreaReferences26);

            chartFormat26.Append(pivotArea26);

            ChartFormat chartFormat27 = new ChartFormat(){ Chart = (UInt32Value)8U, Format = (UInt32Value)1U, Series = true };

            PivotArea pivotArea27 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences27 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference27 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem49 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference27.Append(fieldItem49);

            pivotAreaReferences27.Append(pivotAreaReference27);

            pivotArea27.Append(pivotAreaReferences27);

            chartFormat27.Append(pivotArea27);

            ChartFormat chartFormat28 = new ChartFormat(){ Chart = (UInt32Value)9U, Format = (UInt32Value)15U, Series = true };

            PivotArea pivotArea28 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences28 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference28 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem50 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference28.Append(fieldItem50);

            pivotAreaReferences28.Append(pivotAreaReference28);

            pivotArea28.Append(pivotAreaReferences28);

            chartFormat28.Append(pivotArea28);

            ChartFormat chartFormat29 = new ChartFormat(){ Chart = (UInt32Value)10U, Format = (UInt32Value)2U, Series = true };

            PivotArea pivotArea29 = new PivotArea(){ Type = PivotAreaValues.Data, Outline = false, FieldPosition = (UInt32Value)0U };

            PivotAreaReferences pivotAreaReferences29 = new PivotAreaReferences(){ Count = (UInt32Value)1U };

            PivotAreaReference pivotAreaReference29 = new PivotAreaReference(){ Field = (UInt32Value)4294967294U, Count = (UInt32Value)1U, Selected = false };
            FieldItem fieldItem51 = new FieldItem(){ Val = (UInt32Value)0U };

            pivotAreaReference29.Append(fieldItem51);

            pivotAreaReferences29.Append(pivotAreaReference29);

            pivotArea29.Append(pivotAreaReferences29);

            chartFormat29.Append(pivotArea29);

            chartFormats4.Append(chartFormat23);
            chartFormats4.Append(chartFormat24);
            chartFormats4.Append(chartFormat25);
            chartFormats4.Append(chartFormat26);
            chartFormats4.Append(chartFormat27);
            chartFormats4.Append(chartFormat28);
            chartFormats4.Append(chartFormat29);
            PivotTableStyle pivotTableStyle4 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList4 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension4 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension4.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition8 = new X14.PivotTableDefinition(){ HideValuesRow = true };
            pivotTableDefinition8.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension4.Append(pivotTableDefinition8);

            pivotTableDefinitionExtensionList4.Append(pivotTableDefinitionExtension4);

            pivotTableDefinition7.Append(location4);
            pivotTableDefinition7.Append(pivotFields4);
            pivotTableDefinition7.Append(rowFields4);
            pivotTableDefinition7.Append(rowItems4);
            pivotTableDefinition7.Append(columnItems4);
            pivotTableDefinition7.Append(dataFields4);
            pivotTableDefinition7.Append(chartFormats4);
            pivotTableDefinition7.Append(pivotTableStyle4);
            pivotTableDefinition7.Append(pivotTableDefinitionExtensionList4);

            pivotTablePart4.PivotTableDefinition = pivotTableDefinition7;
        }
コード例 #10
0
        // Generates content of pivotTablePart1.
        private void GeneratePivotTablePart1Content(PivotTablePart pivotTablePart1)
        {
            PivotTableDefinition pivotTableDefinition1 = new PivotTableDefinition(){ Name = "PivotTable1", CacheId = (UInt32Value)0U, ApplyNumberFormats = false, ApplyBorderFormats = false, ApplyFontFormats = false, ApplyPatternFormats = false, ApplyAlignmentFormats = false, ApplyWidthHeightFormats = true, DataCaption = "Values", UpdatedVersion = 5, MinRefreshableVersion = 3, UseAutoFormatting = true, ItemPrintTitles = true, CreatedVersion = 5, Indent = (UInt32Value)0U, Outline = true, OutlineData = true, MultipleFieldFilters = false };
            Location location1 = new Location(){ Reference = "C24:E41", FirstHeaderRow = (UInt32Value)1U, FirstDataRow = (UInt32Value)1U, FirstDataColumn = (UInt32Value)0U };

            PivotHierarchies pivotHierarchies1 = new PivotHierarchies(){ Count = (UInt32Value)11U };
            PivotHierarchy pivotHierarchy1 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy2 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy3 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy4 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy5 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy6 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy7 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy8 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy9 = new PivotHierarchy(){ DragToData = true };
            PivotHierarchy pivotHierarchy10 = new PivotHierarchy(){ DragToRow = false, DragToColumn = false, DragToPage = false, DragToData = true };
            PivotHierarchy pivotHierarchy11 = new PivotHierarchy(){ DragToRow = false, DragToColumn = false, DragToPage = false, DragToData = true };

            pivotHierarchies1.Append(pivotHierarchy1);
            pivotHierarchies1.Append(pivotHierarchy2);
            pivotHierarchies1.Append(pivotHierarchy3);
            pivotHierarchies1.Append(pivotHierarchy4);
            pivotHierarchies1.Append(pivotHierarchy5);
            pivotHierarchies1.Append(pivotHierarchy6);
            pivotHierarchies1.Append(pivotHierarchy7);
            pivotHierarchies1.Append(pivotHierarchy8);
            pivotHierarchies1.Append(pivotHierarchy9);
            pivotHierarchies1.Append(pivotHierarchy10);
            pivotHierarchies1.Append(pivotHierarchy11);
            PivotTableStyle pivotTableStyle1 = new PivotTableStyle(){ Name = "PivotStyleLight16", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList1 = new PivotTableDefinitionExtensionList();

            PivotTableDefinitionExtension pivotTableDefinitionExtension1 = new PivotTableDefinitionExtension(){ Uri = "{962EF5D1-5CA2-4c93-8EF4-DBF5C05439D2}" };
            pivotTableDefinitionExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");

            X14.PivotTableDefinition pivotTableDefinition2 = new X14.PivotTableDefinition(){ CalculatedMembersInFilters = true, HideValuesRow = true };
            pivotTableDefinition2.AddNamespaceDeclaration("xm", "http://schemas.microsoft.com/office/excel/2006/main");

            pivotTableDefinitionExtension1.Append(pivotTableDefinition2);

            PivotTableDefinitionExtension pivotTableDefinitionExtension2 = new PivotTableDefinitionExtension(){ Uri = "{E67621CE-5B39-4880-91FE-76760E9C1902}" };
            pivotTableDefinitionExtension2.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");
            X15.PivotTableUISettings pivotTableUISettings1 = new X15.PivotTableUISettings();

            pivotTableDefinitionExtension2.Append(pivotTableUISettings1);

            pivotTableDefinitionExtensionList1.Append(pivotTableDefinitionExtension1);
            pivotTableDefinitionExtensionList1.Append(pivotTableDefinitionExtension2);

            pivotTableDefinition1.Append(location1);
            pivotTableDefinition1.Append(pivotHierarchies1);
            pivotTableDefinition1.Append(pivotTableStyle1);
            pivotTableDefinition1.Append(pivotTableDefinitionExtensionList1);

            pivotTablePart1.PivotTableDefinition = pivotTableDefinition1;
        }