コード例 #1
0
        // Generates content of timeLineCachePart5.
        private void GenerateTimeLineCachePart5Content(TimeLineCachePart timeLineCachePart5)
        {
            X15.TimelineCacheDefinition timelineCacheDefinition5 = new X15.TimelineCacheDefinition(){ Name = "NativeTimeline_DeliveryDate5", SourceName = "DeliveryDate" };
            timelineCacheDefinition5.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineCachePivotTables timelineCachePivotTables5 = new X15.TimelineCachePivotTables();
            X15.TimelineCachePivotTable timelineCachePivotTable5 = new X15.TimelineCachePivotTable(){ TabId = (UInt32Value)9U, Name = "PivotTable1" };

            timelineCachePivotTables5.Append(timelineCachePivotTable5);

            X15.TimelineState timelineState5 = new X15.TimelineState(){ MinimalRefreshVersion = (UInt32Value)6U, LastRefreshVersion = (UInt32Value)6U, PivotCacheId = (UInt32Value)2U, FilterType = PivotFilterValues.DateBetween };
            X15.SelectionTimelineRange selectionTimelineRange1 = new X15.SelectionTimelineRange(){ StartDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), EndDate = System.Xml.XmlConvert.ToDateTime("2003-12-31T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };
            X15.BoundsTimelineRange boundsTimelineRange5 = new X15.BoundsTimelineRange(){ StartDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), EndDate = System.Xml.XmlConvert.ToDateTime("2004-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };

            timelineState5.Append(selectionTimelineRange1);
            timelineState5.Append(boundsTimelineRange5);

            timelineCacheDefinition5.Append(timelineCachePivotTables5);
            timelineCacheDefinition5.Append(timelineState5);

            timeLineCachePart5.TimelineCacheDefinition = timelineCacheDefinition5;
        }
コード例 #2
0
        // Generates content of timeLineCachePart8.
        private void GenerateTimeLineCachePart8Content(TimeLineCachePart timeLineCachePart8)
        {
            X15.TimelineCacheDefinition timelineCacheDefinition8 = new X15.TimelineCacheDefinition(){ Name = "NativeTimeline_Date", SourceName = "Date" };
            timelineCacheDefinition8.AddNamespaceDeclaration("x15", "http://schemas.microsoft.com/office/spreadsheetml/2010/11/main");

            X15.TimelineCachePivotTables timelineCachePivotTables8 = new X15.TimelineCachePivotTables();
            X15.TimelineCachePivotTable timelineCachePivotTable8 = new X15.TimelineCachePivotTable(){ TabId = (UInt32Value)4U, Name = "PivotTable1" };

            timelineCachePivotTables8.Append(timelineCachePivotTable8);

            X15.TimelineState timelineState8 = new X15.TimelineState(){ MinimalRefreshVersion = (UInt32Value)6U, LastRefreshVersion = (UInt32Value)6U, PivotCacheId = (UInt32Value)1U, FilterType = PivotFilterValues.Unknown };
            X15.BoundsTimelineRange boundsTimelineRange8 = new X15.BoundsTimelineRange(){ StartDate = System.Xml.XmlConvert.ToDateTime("2000-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind), EndDate = System.Xml.XmlConvert.ToDateTime("2003-01-01T00:00:00Z", System.Xml.XmlDateTimeSerializationMode.RoundtripKind) };

            timelineState8.Append(boundsTimelineRange8);

            timelineCacheDefinition8.Append(timelineCachePivotTables8);
            timelineCacheDefinition8.Append(timelineState8);

            timeLineCachePart8.TimelineCacheDefinition = timelineCacheDefinition8;
        }