本文整理汇总了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;
}示例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 };
//.........这里部分代码省略.........
示例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 };
//.........这里部分代码省略.........
示例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 };
//.........这里部分代码省略.........
示例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 };
//.........这里部分代码省略.........
示例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 };
//.........这里部分代码省略.........
示例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 };
//.........这里部分代码省略.........
示例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 };
//.........这里部分代码省略.........
示例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 };
//.........这里部分代码省略.........
示例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 };
//.........这里部分代码省略.........