当前位置: 首页>>代码示例>>C#>>正文


C# Items.Append方法代码示例

本文整理汇总了C#中Items.Append方法的典型用法代码示例。如果您正苦于以下问题:C# Items.Append方法的具体用法?C# Items.Append怎么用?C# Items.Append使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Items的用法示例。


在下文中一共展示了Items.Append方法的10个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。

示例1: GeneratePivotTablePart1Content

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

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

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

            Items items1 = new Items() { Count = (UInt32Value)4U };
            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() { ItemType = ItemValues.Default };

            items1.Append(item1);
            items1.Append(item2);
            items1.Append(item3);
            items1.Append(item4);

            pivotField1.Append(items1);
            PivotField pivotField2 = new PivotField() { DataField = true, ShowAll = false };

            pivotFields1.Append(pivotField1);
            pivotFields1.Append(pivotField2);

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

            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 = 1 };

            rowItem2.Append(memberPropertyIndex2);

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

            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 score", Field = (UInt32Value)1U, BaseField = 0, BaseItem = (UInt32Value)0U };

            dataFields1.Append(dataField1);
            PivotTableStyle pivotTableStyle1 = new PivotTableStyle() { Name = "PivotStyleMedium9", ShowRowHeaders = true, ShowColumnHeaders = true, ShowRowStripes = false, ShowColumnStripes = false, ShowLastColumn = true };

            PivotTableDefinitionExtensionList pivotTableDefinitionExtensionList1 = new PivotTableDefinitionExtensionList();

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

            pivotTablePart1.PivotTableDefinition = pivotTableDefinition1;
        }
开发者ID:DigitalJo,项目名称:jordanius-repository,代码行数:83,代码来源:GeneratedClass.cs

示例2: GeneratePivotTablePart2Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs

示例3: GeneratePivotTablePart3Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs

示例4: GeneratePivotTablePart9Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs

示例5: GeneratePivotTablePart1Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs

示例6: GeneratePivotTablePart8Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs

示例7: GeneratePivotTablePart7Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs

示例8: GeneratePivotTablePart6Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs

示例9: GeneratePivotTablePart5Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs

示例10: GeneratePivotTablePart4Content

        // 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 };
//.........这里部分代码省略.........
开发者ID:eriawan,项目名称:Open-XML-SDK,代码行数:101,代码来源:GeneratedDocument.cs


注:本文中的Items.Append方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。