internal FieldGroup ToFieldGroup()
{
FieldGroup fg = new FieldGroup();
if (this.ParentId != null)
{
fg.ParentId = this.ParentId.Value;
}
if (this.Base != null)
{
fg.Base = this.Base.Value;
}
if (this.HasRangeProperties)
{
fg.Append(this.RangeProperties.ToRangeProperties());
}
if (this.DiscreteProperties.Count > 0)
{
DiscreteProperties dp = new DiscreteProperties();
dp.Count = (uint)this.DiscreteProperties.Count;
foreach (uint i in this.DiscreteProperties)
{
dp.Append(new FieldItem()
{
Val = i
});
}
fg.Append(dp);
}
if (this.HasGroupItems)
{
fg.Append(this.GroupItems.ToGroupItems());
}
return(fg);
}
internal FieldGroup ToFieldGroup()
{
var fg = new FieldGroup();
if (ParentId != null)
{
fg.ParentId = ParentId.Value;
}
if (Base != null)
{
fg.Base = Base.Value;
}
if (HasRangeProperties)
{
fg.Append(RangeProperties.ToRangeProperties());
}
if (DiscreteProperties.Count > 0)
{
var dp = new DiscreteProperties();
dp.Count = (uint)DiscreteProperties.Count;
foreach (var i in DiscreteProperties)
{
dp.Append(new FieldItem {
Val = i
});
}
fg.Append(dp);
}
if (HasGroupItems)
{
fg.Append(GroupItems.ToGroupItems());
}
return(fg);
}
internal FieldGroup ToFieldGroup()
{
FieldGroup fg = new FieldGroup();
if (this.ParentId != null) fg.ParentId = this.ParentId.Value;
if (this.Base != null) fg.Base = this.Base.Value;
if (this.HasRangeProperties)
{
fg.Append(this.RangeProperties.ToRangeProperties());
}
if (this.DiscreteProperties.Count > 0)
{
DiscreteProperties dp = new DiscreteProperties();
dp.Count = (uint)this.DiscreteProperties.Count;
foreach (uint i in this.DiscreteProperties)
{
dp.Append(new FieldItem() { Val = i });
}
fg.Append(dp);
}
if (this.HasGroupItems)
{
fg.Append(this.GroupItems.ToGroupItems());
}
return fg;
}
// Generates content of pivotTableCacheDefinitionPart1.
private void GeneratePivotTableCacheDefinitionPart1Content(PivotTableCacheDefinitionPart pivotTableCacheDefinitionPart1)
{
PivotCacheDefinition pivotCacheDefinition1 = new PivotCacheDefinition(){ Id = "rId1", RefreshedBy = "Masaki Tamura (Pasona Tech)", RefreshedDate = 40946.731165509256D, CreatedVersion = 4, RefreshedVersion = 5, MinRefreshableVersion = 3, RecordCount = (UInt32Value)4U };
pivotCacheDefinition1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
CacheSource cacheSource1 = new CacheSource(){ Type = SourceValues.Worksheet };
WorksheetSource worksheetSource1 = new WorksheetSource(){ Name = "DataTable1" };
cacheSource1.Append(worksheetSource1);
CacheFields cacheFields1 = new CacheFields(){ Count = (UInt32Value)7U };
CacheField cacheField1 = new CacheField(){ Name = "Date", NumberFormatId = (UInt32Value)14U };
SharedItems sharedItems1 = new SharedItems(){ ContainsSemiMixedTypes = false, ContainsNonDate = false, ContainsDate = true, ContainsString = false, MinDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T15:40:41Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), MaxDate = System.Xml.XmlConvert.ToDateTime("2002-12-30T20:50:43Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), Count = (UInt32Value)4U };
DateTimeItem dateTimeItem1 = new DateTimeItem(){ Val = System.Xml.XmlConvert.ToDateTime("2000-01-01T15:40:41Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
DateTimeItem dateTimeItem2 = new DateTimeItem(){ Val = System.Xml.XmlConvert.ToDateTime("2000-01-02T03:35:07Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
DateTimeItem dateTimeItem3 = new DateTimeItem(){ Val = System.Xml.XmlConvert.ToDateTime("2002-12-30T06:43:15Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
DateTimeItem dateTimeItem4 = new DateTimeItem(){ Val = System.Xml.XmlConvert.ToDateTime("2002-12-30T20:50:43Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
sharedItems1.Append(dateTimeItem1);
sharedItems1.Append(dateTimeItem2);
sharedItems1.Append(dateTimeItem3);
sharedItems1.Append(dateTimeItem4);
FieldGroup fieldGroup1 = new FieldGroup(){ ParentId = (UInt32Value)6U, Base = (UInt32Value)0U };
RangeProperties rangeProperties1 = new RangeProperties(){ GroupBy = GroupByValues.Months, StartDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T15:40:41Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), EndDate = System.Xml.XmlConvert.ToDateTime("2002-12-30T20:50:43Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
GroupItems groupItems1 = new GroupItems(){ Count = (UInt32Value)14U };
StringItem stringItem1 = new StringItem(){ Val = "<2000/01/01" };
StringItem stringItem2 = new StringItem(){ Val = "1月" };
StringItem stringItem3 = new StringItem(){ Val = "2月" };
StringItem stringItem4 = new StringItem(){ Val = "3月" };
StringItem stringItem5 = new StringItem(){ Val = "4月" };
StringItem stringItem6 = new StringItem(){ Val = "5月" };
StringItem stringItem7 = new StringItem(){ Val = "6月" };
StringItem stringItem8 = new StringItem(){ Val = "7月" };
StringItem stringItem9 = new StringItem(){ Val = "8月" };
StringItem stringItem10 = new StringItem(){ Val = "9月" };
StringItem stringItem11 = new StringItem(){ Val = "10月" };
StringItem stringItem12 = new StringItem(){ Val = "11月" };
StringItem stringItem13 = new StringItem(){ Val = "12月" };
StringItem stringItem14 = new StringItem(){ Val = ">2002/12/30" };
groupItems1.Append(stringItem1);
groupItems1.Append(stringItem2);
groupItems1.Append(stringItem3);
groupItems1.Append(stringItem4);
groupItems1.Append(stringItem5);
groupItems1.Append(stringItem6);
groupItems1.Append(stringItem7);
groupItems1.Append(stringItem8);
groupItems1.Append(stringItem9);
groupItems1.Append(stringItem10);
groupItems1.Append(stringItem11);
groupItems1.Append(stringItem12);
groupItems1.Append(stringItem13);
groupItems1.Append(stringItem14);
fieldGroup1.Append(rangeProperties1);
fieldGroup1.Append(groupItems1);
cacheField1.Append(sharedItems1);
cacheField1.Append(fieldGroup1);
CacheField cacheField2 = new CacheField(){ Name = "Product", NumberFormatId = (UInt32Value)0U };
SharedItems sharedItems2 = new SharedItems(){ Count = (UInt32Value)10U };
StringItem stringItem15 = new StringItem(){ Val = "product_A" };
StringItem stringItem16 = new StringItem(){ Val = "product_D" };
StringItem stringItem17 = new StringItem(){ Val = "product_E" };
StringItem stringItem18 = new StringItem(){ Val = "product_C", Unused = true };
StringItem stringItem19 = new StringItem(){ Val = "product_B", Unused = true };
StringItem stringItem20 = new StringItem(){ Val = "product_J", Unused = true };
StringItem stringItem21 = new StringItem(){ Val = "product_I", Unused = true };
StringItem stringItem22 = new StringItem(){ Val = "product_H", Unused = true };
StringItem stringItem23 = new StringItem(){ Val = "product_G", Unused = true };
StringItem stringItem24 = new StringItem(){ Val = "product_F", Unused = true };
sharedItems2.Append(stringItem15);
sharedItems2.Append(stringItem16);
sharedItems2.Append(stringItem17);
sharedItems2.Append(stringItem18);
sharedItems2.Append(stringItem19);
sharedItems2.Append(stringItem20);
sharedItems2.Append(stringItem21);
sharedItems2.Append(stringItem22);
sharedItems2.Append(stringItem23);
sharedItems2.Append(stringItem24);
cacheField2.Append(sharedItems2);
CacheField cacheField3 = new CacheField(){ Name = "Quantity", NumberFormatId = (UInt32Value)0U };
SharedItems sharedItems3 = new SharedItems(){ ContainsSemiMixedTypes = false, ContainsString = false, ContainsNumber = true, ContainsInteger = true, MinValue = 4D, MaxValue = 29D };
cacheField3.Append(sharedItems3);
CacheField cacheField4 = new CacheField(){ Name = "Price", NumberFormatId = (UInt32Value)0U };
SharedItems sharedItems4 = new SharedItems(){ ContainsSemiMixedTypes = false, ContainsString = false, ContainsNumber = true, ContainsInteger = true, MinValue = 312D, MaxValue = 15990D };
cacheField4.Append(sharedItems4);
CacheField cacheField5 = new CacheField(){ Name = "DeliveryDate", NumberFormatId = (UInt32Value)14U };
SharedItems sharedItems5 = new SharedItems(){ ContainsSemiMixedTypes = false, ContainsNonDate = false, ContainsDate = true, ContainsString = false, MinDate = System.Xml.XmlConvert.ToDateTime("2000-01-06T15:40:41Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), MaxDate = System.Xml.XmlConvert.ToDateTime("2003-01-03T06:43:15Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), Count = (UInt32Value)4U };
DateTimeItem dateTimeItem5 = new DateTimeItem(){ Val = System.Xml.XmlConvert.ToDateTime("2000-01-06T15:40:41Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
DateTimeItem dateTimeItem6 = new DateTimeItem(){ Val = System.Xml.XmlConvert.ToDateTime("2000-01-07T03:35:07Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
DateTimeItem dateTimeItem7 = new DateTimeItem(){ Val = System.Xml.XmlConvert.ToDateTime("2003-01-03T06:43:15Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
DateTimeItem dateTimeItem8 = new DateTimeItem(){ Val = System.Xml.XmlConvert.ToDateTime("2002-12-31T20:50:43Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
sharedItems5.Append(dateTimeItem5);
sharedItems5.Append(dateTimeItem6);
sharedItems5.Append(dateTimeItem7);
sharedItems5.Append(dateTimeItem8);
cacheField5.Append(sharedItems5);
CacheField cacheField6 = new CacheField(){ Name = "Employee", NumberFormatId = (UInt32Value)0U };
SharedItems sharedItems6 = new SharedItems();
cacheField6.Append(sharedItems6);
CacheField cacheField7 = new CacheField(){ Name = "Years", NumberFormatId = (UInt32Value)0U, DatabaseField = false };
FieldGroup fieldGroup2 = new FieldGroup(){ Base = (UInt32Value)0U };
RangeProperties rangeProperties2 = new RangeProperties(){ GroupBy = GroupByValues.Years, StartDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T15:40:41Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), EndDate = System.Xml.XmlConvert.ToDateTime("2002-12-30T20:50:43Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
GroupItems groupItems2 = new GroupItems(){ Count = (UInt32Value)5U };
StringItem stringItem25 = new StringItem(){ Val = "<2000/01/01" };
StringItem stringItem26 = new StringItem(){ Val = "2000年" };
StringItem stringItem27 = new StringItem(){ Val = "2001年" };
StringItem stringItem28 = new StringItem(){ Val = "2002年" };
StringItem stringItem29 = new StringItem(){ Val = ">2002/12/30" };
groupItems2.Append(stringItem25);
groupItems2.Append(stringItem26);
groupItems2.Append(stringItem27);
groupItems2.Append(stringItem28);
groupItems2.Append(stringItem29);
fieldGroup2.Append(rangeProperties2);
fieldGroup2.Append(groupItems2);
cacheField7.Append(fieldGroup2);
cacheFields1.Append(cacheField1);
cacheFields1.Append(cacheField2);
cacheFields1.Append(cacheField3);
cacheFields1.Append(cacheField4);
cacheFields1.Append(cacheField5);
cacheFields1.Append(cacheField6);
cacheFields1.Append(cacheField7);
PivotCacheDefinitionExtensionList pivotCacheDefinitionExtensionList1 = new PivotCacheDefinitionExtensionList();
PivotCacheDefinitionExtension pivotCacheDefinitionExtension1 = new PivotCacheDefinitionExtension(){ Uri = "{725AE2AE-9491-48be-B2B4-4EB974FC3084}" };
pivotCacheDefinitionExtension1.AddNamespaceDeclaration("x14", "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main");
X14.PivotCacheDefinition pivotCacheDefinition2 = new X14.PivotCacheDefinition(){ PivotCacheId = (UInt32Value)2U };
pivotCacheDefinitionExtension1.Append(pivotCacheDefinition2);
pivotCacheDefinitionExtensionList1.Append(pivotCacheDefinitionExtension1);
pivotCacheDefinition1.Append(cacheSource1);
pivotCacheDefinition1.Append(cacheFields1);
pivotCacheDefinition1.Append(pivotCacheDefinitionExtensionList1);
pivotTableCacheDefinitionPart1.PivotCacheDefinition = pivotCacheDefinition1;
}