コード例 #1
0
        // Generates content of drawingsPart1.
        private void GenerateDrawingsPart1Content(DrawingsPart drawingsPart1)
        {
            Xdr.WorksheetDrawing worksheetDrawing1 = new Xdr.WorksheetDrawing();
            worksheetDrawing1.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor1 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker1 = new Xdr.FromMarker();
            Xdr.ColumnId columnId1 = new Xdr.ColumnId();
            columnId1.Text = "2";
            Xdr.ColumnOffset columnOffset1 = new Xdr.ColumnOffset();
            columnOffset1.Text = "185737";
            Xdr.RowId rowId1 = new Xdr.RowId();
            rowId1.Text = "0";
            Xdr.RowOffset rowOffset1 = new Xdr.RowOffset();
            rowOffset1.Text = "0";

            fromMarker1.Append(columnId1);
            fromMarker1.Append(columnOffset1);
            fromMarker1.Append(rowId1);
            fromMarker1.Append(rowOffset1);

            Xdr.ToMarker toMarker1 = new Xdr.ToMarker();
            Xdr.ColumnId columnId2 = new Xdr.ColumnId();
            columnId2.Text = "9";
            Xdr.ColumnOffset columnOffset2 = new Xdr.ColumnOffset();
            columnOffset2.Text = "90487";
            Xdr.RowId rowId2 = new Xdr.RowId();
            rowId2.Text = "14";
            Xdr.RowOffset rowOffset2 = new Xdr.RowOffset();
            rowOffset2.Text = "76200";

            toMarker1.Append(columnId2);
            toMarker1.Append(columnOffset2);
            toMarker1.Append(rowId2);
            toMarker1.Append(rowOffset2);

            Xdr.GraphicFrame graphicFrame1 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties1 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties1 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties1 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks1 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties1.Append(graphicFrameLocks1);

            nonVisualGraphicFrameProperties1.Append(nonVisualDrawingProperties1);
            nonVisualGraphicFrameProperties1.Append(nonVisualGraphicFrameDrawingProperties1);

            Xdr.Transform transform1 = new Xdr.Transform();
            A.Offset offset1 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents1 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform1.Append(offset1);
            transform1.Append(extents1);

            A.Graphic graphic1 = new A.Graphic();

            A.GraphicData graphicData1 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference1 = new C.ChartReference(){ Id = "rId1" };
            chartReference1.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData1.Append(chartReference1);

            graphic1.Append(graphicData1);

            graphicFrame1.Append(nonVisualGraphicFrameProperties1);
            graphicFrame1.Append(transform1);
            graphicFrame1.Append(graphic1);
            Xdr.ClientData clientData1 = new Xdr.ClientData();

            twoCellAnchor1.Append(fromMarker1);
            twoCellAnchor1.Append(toMarker1);
            twoCellAnchor1.Append(graphicFrame1);
            twoCellAnchor1.Append(clientData1);

            Xdr.TwoCellAnchor twoCellAnchor2 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker2 = new Xdr.FromMarker();
            Xdr.ColumnId columnId3 = new Xdr.ColumnId();
            columnId3.Text = "2";
            Xdr.ColumnOffset columnOffset3 = new Xdr.ColumnOffset();
            columnOffset3.Text = "200025";
            Xdr.RowId rowId3 = new Xdr.RowId();
            rowId3.Text = "14";
            Xdr.RowOffset rowOffset3 = new Xdr.RowOffset();
            rowOffset3.Text = "147637";

            fromMarker2.Append(columnId3);
            fromMarker2.Append(columnOffset3);
            fromMarker2.Append(rowId3);
            fromMarker2.Append(rowOffset3);

            Xdr.ToMarker toMarker2 = new Xdr.ToMarker();
            Xdr.ColumnId columnId4 = new Xdr.ColumnId();
            columnId4.Text = "7";
            Xdr.ColumnOffset columnOffset4 = new Xdr.ColumnOffset();
            columnOffset4.Text = "476250";
            Xdr.RowId rowId4 = new Xdr.RowId();
            rowId4.Text = "29";
            Xdr.RowOffset rowOffset4 = new Xdr.RowOffset();
            rowOffset4.Text = "33337";

            toMarker2.Append(columnId4);
            toMarker2.Append(columnOffset4);
            toMarker2.Append(rowId4);
            toMarker2.Append(rowOffset4);

            Xdr.GraphicFrame graphicFrame2 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties2 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties2 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties2 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks2 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties2.Append(graphicFrameLocks2);

            nonVisualGraphicFrameProperties2.Append(nonVisualDrawingProperties2);
            nonVisualGraphicFrameProperties2.Append(nonVisualGraphicFrameDrawingProperties2);

            Xdr.Transform transform2 = new Xdr.Transform();
            A.Offset offset2 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents2 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform2.Append(offset2);
            transform2.Append(extents2);

            A.Graphic graphic2 = new A.Graphic();

            A.GraphicData graphicData2 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference2 = new C.ChartReference(){ Id = "rId2" };
            chartReference2.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData2.Append(chartReference2);

            graphic2.Append(graphicData2);

            graphicFrame2.Append(nonVisualGraphicFrameProperties2);
            graphicFrame2.Append(transform2);
            graphicFrame2.Append(graphic2);
            Xdr.ClientData clientData2 = new Xdr.ClientData();

            twoCellAnchor2.Append(fromMarker2);
            twoCellAnchor2.Append(toMarker2);
            twoCellAnchor2.Append(graphicFrame2);
            twoCellAnchor2.Append(clientData2);

            Xdr.TwoCellAnchor twoCellAnchor3 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker3 = new Xdr.FromMarker();
            Xdr.ColumnId columnId5 = new Xdr.ColumnId();
            columnId5.Text = "10";
            Xdr.ColumnOffset columnOffset5 = new Xdr.ColumnOffset();
            columnOffset5.Text = "9525";
            Xdr.RowId rowId5 = new Xdr.RowId();
            rowId5.Text = "0";
            Xdr.RowOffset rowOffset5 = new Xdr.RowOffset();
            rowOffset5.Text = "171450";

            fromMarker3.Append(columnId5);
            fromMarker3.Append(columnOffset5);
            fromMarker3.Append(rowId5);
            fromMarker3.Append(rowOffset5);

            Xdr.ToMarker toMarker3 = new Xdr.ToMarker();
            Xdr.ColumnId columnId6 = new Xdr.ColumnId();
            columnId6.Text = "13";
            Xdr.ColumnOffset columnOffset6 = new Xdr.ColumnOffset();
            columnOffset6.Text = "742950";
            Xdr.RowId rowId6 = new Xdr.RowId();
            rowId6.Text = "7";
            Xdr.RowOffset rowOffset6 = new Xdr.RowOffset();
            rowOffset6.Text = "28575";

            toMarker3.Append(columnId6);
            toMarker3.Append(columnOffset6);
            toMarker3.Append(rowId6);
            toMarker3.Append(rowOffset6);

            AlternateContent alternateContent2 = new AlternateContent();
            alternateContent2.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent2.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice2 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame3 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties3 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties3 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 10" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties3 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties3.Append(nonVisualDrawingProperties3);
            nonVisualGraphicFrameProperties3.Append(nonVisualGraphicFrameDrawingProperties3);

            Xdr.Transform transform3 = new Xdr.Transform();
            A.Offset offset3 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents3 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform3.Append(offset3);
            transform3.Append(extents3);

            A.Graphic graphic3 = new A.Graphic();

            A.GraphicData graphicData3 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer1 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 10" };
            timeSlicer1.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData3.Append(timeSlicer1);

            graphic3.Append(graphicData3);

            graphicFrame3.Append(nonVisualGraphicFrameProperties3);
            graphicFrame3.Append(transform3);
            graphicFrame3.Append(graphic3);

            alternateContentChoice2.Append(graphicFrame3);

            AlternateContentFallback alternateContentFallback1 = new AlternateContentFallback();
            alternateContentFallback1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback1.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape1 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties1 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties4 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties1 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks1 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties1.Append(shapeLocks1);

            nonVisualShapeProperties1.Append(nonVisualDrawingProperties4);
            nonVisualShapeProperties1.Append(nonVisualShapeDrawingProperties1);

            Xdr.ShapeProperties shapeProperties1 = new Xdr.ShapeProperties();

            A.Transform2D transform2D1 = new A.Transform2D();
            A.Offset offset4 = new A.Offset(){ X = 8610600L, Y = 171450L };
            A.Extents extents4 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D1.Append(offset4);
            transform2D1.Append(extents4);

            A.PresetGeometry presetGeometry1 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList1 = new A.AdjustValueList();

            presetGeometry1.Append(adjustValueList1);

            A.SolidFill solidFill1 = new A.SolidFill();
            A.PresetColor presetColor1 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill1.Append(presetColor1);

            A.Outline outline1 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill2 = new A.SolidFill();
            A.PresetColor presetColor2 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill2.Append(presetColor2);

            outline1.Append(solidFill2);

            shapeProperties1.Append(transform2D1);
            shapeProperties1.Append(presetGeometry1);
            shapeProperties1.Append(solidFill1);
            shapeProperties1.Append(outline1);

            Xdr.TextBody textBody1 = new Xdr.TextBody();
            A.BodyProperties bodyProperties1 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle1 = new A.ListStyle();

            A.Paragraph paragraph1 = new A.Paragraph();

            A.Run run1 = new A.Run();
            A.RunProperties runProperties1 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text1 = new A.Text();
            text1.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run1.Append(runProperties1);
            run1.Append(text1);

            paragraph1.Append(run1);

            textBody1.Append(bodyProperties1);
            textBody1.Append(listStyle1);
            textBody1.Append(paragraph1);

            shape1.Append(nonVisualShapeProperties1);
            shape1.Append(shapeProperties1);
            shape1.Append(textBody1);

            alternateContentFallback1.Append(shape1);

            alternateContent2.Append(alternateContentChoice2);
            alternateContent2.Append(alternateContentFallback1);
            Xdr.ClientData clientData3 = new Xdr.ClientData();

            twoCellAnchor3.Append(fromMarker3);
            twoCellAnchor3.Append(toMarker3);
            twoCellAnchor3.Append(alternateContent2);
            twoCellAnchor3.Append(clientData3);

            Xdr.TwoCellAnchor twoCellAnchor4 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker4 = new Xdr.FromMarker();
            Xdr.ColumnId columnId7 = new Xdr.ColumnId();
            columnId7.Text = "10";
            Xdr.ColumnOffset columnOffset7 = new Xdr.ColumnOffset();
            columnOffset7.Text = "9525";
            Xdr.RowId rowId7 = new Xdr.RowId();
            rowId7.Text = "8";
            Xdr.RowOffset rowOffset7 = new Xdr.RowOffset();
            rowOffset7.Text = "57150";

            fromMarker4.Append(columnId7);
            fromMarker4.Append(columnOffset7);
            fromMarker4.Append(rowId7);
            fromMarker4.Append(rowOffset7);

            Xdr.ToMarker toMarker4 = new Xdr.ToMarker();
            Xdr.ColumnId columnId8 = new Xdr.ColumnId();
            columnId8.Text = "13";
            Xdr.ColumnOffset columnOffset8 = new Xdr.ColumnOffset();
            columnOffset8.Text = "866775";
            Xdr.RowId rowId8 = new Xdr.RowId();
            rowId8.Text = "14";
            Xdr.RowOffset rowOffset8 = new Xdr.RowOffset();
            rowOffset8.Text = "85725";

            toMarker4.Append(columnId8);
            toMarker4.Append(columnOffset8);
            toMarker4.Append(rowId8);
            toMarker4.Append(rowOffset8);

            AlternateContent alternateContent3 = new AlternateContent();
            alternateContent3.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent3.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice3 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame4 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties4 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties5 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 11" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties4 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties4.Append(nonVisualDrawingProperties5);
            nonVisualGraphicFrameProperties4.Append(nonVisualGraphicFrameDrawingProperties4);

            Xdr.Transform transform4 = new Xdr.Transform();
            A.Offset offset5 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents5 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform4.Append(offset5);
            transform4.Append(extents5);

            A.Graphic graphic4 = new A.Graphic();

            A.GraphicData graphicData4 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer2 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 11" };
            timeSlicer2.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData4.Append(timeSlicer2);

            graphic4.Append(graphicData4);

            graphicFrame4.Append(nonVisualGraphicFrameProperties4);
            graphicFrame4.Append(transform4);
            graphicFrame4.Append(graphic4);

            alternateContentChoice3.Append(graphicFrame4);

            AlternateContentFallback alternateContentFallback2 = new AlternateContentFallback();

            Xdr.Shape shape2 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties2 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties6 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties2 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks2 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties2.Append(shapeLocks2);

            nonVisualShapeProperties2.Append(nonVisualDrawingProperties6);
            nonVisualShapeProperties2.Append(nonVisualShapeDrawingProperties2);

            Xdr.ShapeProperties shapeProperties2 = new Xdr.ShapeProperties();

            A.Transform2D transform2D2 = new A.Transform2D();
            A.Offset offset6 = new A.Offset(){ X = 10296525L, Y = 1428750L };
            A.Extents extents6 = new A.Extents(){ Cx = 3829050L, Cy = 1057275L };

            transform2D2.Append(offset6);
            transform2D2.Append(extents6);

            A.PresetGeometry presetGeometry2 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList2 = new A.AdjustValueList();

            presetGeometry2.Append(adjustValueList2);

            A.SolidFill solidFill3 = new A.SolidFill();
            A.PresetColor presetColor3 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill3.Append(presetColor3);

            A.Outline outline2 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill4 = new A.SolidFill();
            A.PresetColor presetColor4 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill4.Append(presetColor4);

            outline2.Append(solidFill4);

            shapeProperties2.Append(transform2D2);
            shapeProperties2.Append(presetGeometry2);
            shapeProperties2.Append(solidFill3);
            shapeProperties2.Append(outline2);

            Xdr.TextBody textBody2 = new Xdr.TextBody();
            A.BodyProperties bodyProperties2 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle2 = new A.ListStyle();

            A.Paragraph paragraph2 = new A.Paragraph();

            A.Run run2 = new A.Run();
            A.RunProperties runProperties2 = new A.RunProperties(){ Language = "ja-JP", AlternativeLanguage = "en-US", FontSize = 1100 };
            A.Text text2 = new A.Text();
            text2.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run2.Append(runProperties2);
            run2.Append(text2);

            paragraph2.Append(run2);

            textBody2.Append(bodyProperties2);
            textBody2.Append(listStyle2);
            textBody2.Append(paragraph2);

            shape2.Append(nonVisualShapeProperties2);
            shape2.Append(shapeProperties2);
            shape2.Append(textBody2);

            alternateContentFallback2.Append(shape2);

            alternateContent3.Append(alternateContentChoice3);
            alternateContent3.Append(alternateContentFallback2);
            Xdr.ClientData clientData4 = new Xdr.ClientData();

            twoCellAnchor4.Append(fromMarker4);
            twoCellAnchor4.Append(toMarker4);
            twoCellAnchor4.Append(alternateContent3);
            twoCellAnchor4.Append(clientData4);

            worksheetDrawing1.Append(twoCellAnchor1);
            worksheetDrawing1.Append(twoCellAnchor2);
            worksheetDrawing1.Append(twoCellAnchor3);
            worksheetDrawing1.Append(twoCellAnchor4);

            drawingsPart1.WorksheetDrawing = worksheetDrawing1;
        }
コード例 #2
0
        // Generates content of drawingsPart4.
        private void GenerateDrawingsPart4Content(DrawingsPart drawingsPart4)
        {
            Xdr.WorksheetDrawing worksheetDrawing4 = new Xdr.WorksheetDrawing();
            worksheetDrawing4.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing4.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor13 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker13 = new Xdr.FromMarker();
            Xdr.ColumnId columnId25 = new Xdr.ColumnId();
            columnId25.Text = "2";
            Xdr.ColumnOffset columnOffset25 = new Xdr.ColumnOffset();
            columnOffset25.Text = "185737";
            Xdr.RowId rowId25 = new Xdr.RowId();
            rowId25.Text = "0";
            Xdr.RowOffset rowOffset25 = new Xdr.RowOffset();
            rowOffset25.Text = "0";

            fromMarker13.Append(columnId25);
            fromMarker13.Append(columnOffset25);
            fromMarker13.Append(rowId25);
            fromMarker13.Append(rowOffset25);

            Xdr.ToMarker toMarker13 = new Xdr.ToMarker();
            Xdr.ColumnId columnId26 = new Xdr.ColumnId();
            columnId26.Text = "9";
            Xdr.ColumnOffset columnOffset26 = new Xdr.ColumnOffset();
            columnOffset26.Text = "90487";
            Xdr.RowId rowId26 = new Xdr.RowId();
            rowId26.Text = "14";
            Xdr.RowOffset rowOffset26 = new Xdr.RowOffset();
            rowOffset26.Text = "76200";

            toMarker13.Append(columnId26);
            toMarker13.Append(columnOffset26);
            toMarker13.Append(rowId26);
            toMarker13.Append(rowOffset26);

            Xdr.GraphicFrame graphicFrame13 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties13 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties19 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties13 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks5 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties13.Append(graphicFrameLocks5);

            nonVisualGraphicFrameProperties13.Append(nonVisualDrawingProperties19);
            nonVisualGraphicFrameProperties13.Append(nonVisualGraphicFrameDrawingProperties13);

            Xdr.Transform transform13 = new Xdr.Transform();
            A.Offset offset19 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents19 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform13.Append(offset19);
            transform13.Append(extents19);

            A.Graphic graphic13 = new A.Graphic();

            A.GraphicData graphicData13 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference7 = new C.ChartReference(){ Id = "rId1" };
            chartReference7.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference7.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData13.Append(chartReference7);

            graphic13.Append(graphicData13);

            graphicFrame13.Append(nonVisualGraphicFrameProperties13);
            graphicFrame13.Append(transform13);
            graphicFrame13.Append(graphic13);
            Xdr.ClientData clientData13 = new Xdr.ClientData();

            twoCellAnchor13.Append(fromMarker13);
            twoCellAnchor13.Append(toMarker13);
            twoCellAnchor13.Append(graphicFrame13);
            twoCellAnchor13.Append(clientData13);

            Xdr.TwoCellAnchor twoCellAnchor14 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker14 = new Xdr.FromMarker();
            Xdr.ColumnId columnId27 = new Xdr.ColumnId();
            columnId27.Text = "2";
            Xdr.ColumnOffset columnOffset27 = new Xdr.ColumnOffset();
            columnOffset27.Text = "200025";
            Xdr.RowId rowId27 = new Xdr.RowId();
            rowId27.Text = "14";
            Xdr.RowOffset rowOffset27 = new Xdr.RowOffset();
            rowOffset27.Text = "147637";

            fromMarker14.Append(columnId27);
            fromMarker14.Append(columnOffset27);
            fromMarker14.Append(rowId27);
            fromMarker14.Append(rowOffset27);

            Xdr.ToMarker toMarker14 = new Xdr.ToMarker();
            Xdr.ColumnId columnId28 = new Xdr.ColumnId();
            columnId28.Text = "7";
            Xdr.ColumnOffset columnOffset28 = new Xdr.ColumnOffset();
            columnOffset28.Text = "476250";
            Xdr.RowId rowId28 = new Xdr.RowId();
            rowId28.Text = "29";
            Xdr.RowOffset rowOffset28 = new Xdr.RowOffset();
            rowOffset28.Text = "33337";

            toMarker14.Append(columnId28);
            toMarker14.Append(columnOffset28);
            toMarker14.Append(rowId28);
            toMarker14.Append(rowOffset28);

            Xdr.GraphicFrame graphicFrame14 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties14 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties20 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties14 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks6 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties14.Append(graphicFrameLocks6);

            nonVisualGraphicFrameProperties14.Append(nonVisualDrawingProperties20);
            nonVisualGraphicFrameProperties14.Append(nonVisualGraphicFrameDrawingProperties14);

            Xdr.Transform transform14 = new Xdr.Transform();
            A.Offset offset20 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents20 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform14.Append(offset20);
            transform14.Append(extents20);

            A.Graphic graphic14 = new A.Graphic();

            A.GraphicData graphicData14 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference8 = new C.ChartReference(){ Id = "rId2" };
            chartReference8.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference8.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData14.Append(chartReference8);

            graphic14.Append(graphicData14);

            graphicFrame14.Append(nonVisualGraphicFrameProperties14);
            graphicFrame14.Append(transform14);
            graphicFrame14.Append(graphic14);
            Xdr.ClientData clientData14 = new Xdr.ClientData();

            twoCellAnchor14.Append(fromMarker14);
            twoCellAnchor14.Append(toMarker14);
            twoCellAnchor14.Append(graphicFrame14);
            twoCellAnchor14.Append(clientData14);

            Xdr.TwoCellAnchor twoCellAnchor15 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker15 = new Xdr.FromMarker();
            Xdr.ColumnId columnId29 = new Xdr.ColumnId();
            columnId29.Text = "10";
            Xdr.ColumnOffset columnOffset29 = new Xdr.ColumnOffset();
            columnOffset29.Text = "19050";
            Xdr.RowId rowId29 = new Xdr.RowId();
            rowId29.Text = "1";
            Xdr.RowOffset rowOffset29 = new Xdr.RowOffset();
            rowOffset29.Text = "19050";

            fromMarker15.Append(columnId29);
            fromMarker15.Append(columnOffset29);
            fromMarker15.Append(rowId29);
            fromMarker15.Append(rowOffset29);

            Xdr.ToMarker toMarker15 = new Xdr.ToMarker();
            Xdr.ColumnId columnId30 = new Xdr.ColumnId();
            columnId30.Text = "13";
            Xdr.ColumnOffset columnOffset30 = new Xdr.ColumnOffset();
            columnOffset30.Text = "752475";
            Xdr.RowId rowId30 = new Xdr.RowId();
            rowId30.Text = "7";
            Xdr.RowOffset rowOffset30 = new Xdr.RowOffset();
            rowOffset30.Text = "66675";

            toMarker15.Append(columnId30);
            toMarker15.Append(columnOffset30);
            toMarker15.Append(rowId30);
            toMarker15.Append(rowOffset30);

            AlternateContent alternateContent14 = new AlternateContent();
            alternateContent14.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent14.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice14 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame15 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties15 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties21 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 6" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties15 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties15.Append(nonVisualDrawingProperties21);
            nonVisualGraphicFrameProperties15.Append(nonVisualGraphicFrameDrawingProperties15);

            Xdr.Transform transform15 = new Xdr.Transform();
            A.Offset offset21 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents21 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform15.Append(offset21);
            transform15.Append(extents21);

            A.Graphic graphic15 = new A.Graphic();

            A.GraphicData graphicData15 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer7 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 6" };
            timeSlicer7.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData15.Append(timeSlicer7);

            graphic15.Append(graphicData15);

            graphicFrame15.Append(nonVisualGraphicFrameProperties15);
            graphicFrame15.Append(transform15);
            graphicFrame15.Append(graphic15);

            alternateContentChoice14.Append(graphicFrame15);

            AlternateContentFallback alternateContentFallback13 = new AlternateContentFallback();
            alternateContentFallback13.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback13.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape7 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties7 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties22 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties7 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks7 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties7.Append(shapeLocks7);

            nonVisualShapeProperties7.Append(nonVisualDrawingProperties22);
            nonVisualShapeProperties7.Append(nonVisualShapeDrawingProperties7);

            Xdr.ShapeProperties shapeProperties22 = new Xdr.ShapeProperties();

            A.Transform2D transform2D7 = new A.Transform2D();
            A.Offset offset22 = new A.Offset(){ X = 8620125L, Y = 209550L };
            A.Extents extents22 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D7.Append(offset22);
            transform2D7.Append(extents22);

            A.PresetGeometry presetGeometry7 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList7 = new A.AdjustValueList();

            presetGeometry7.Append(adjustValueList7);

            A.SolidFill solidFill40 = new A.SolidFill();
            A.PresetColor presetColor13 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill40.Append(presetColor13);

            A.Outline outline32 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill41 = new A.SolidFill();
            A.PresetColor presetColor14 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill41.Append(presetColor14);

            outline32.Append(solidFill41);

            shapeProperties22.Append(transform2D7);
            shapeProperties22.Append(presetGeometry7);
            shapeProperties22.Append(solidFill40);
            shapeProperties22.Append(outline32);

            Xdr.TextBody textBody7 = new Xdr.TextBody();
            A.BodyProperties bodyProperties15 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle15 = new A.ListStyle();

            A.Paragraph paragraph15 = new A.Paragraph();

            A.Run run7 = new A.Run();
            A.RunProperties runProperties7 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text45 = new A.Text();
            text45.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run7.Append(runProperties7);
            run7.Append(text45);

            paragraph15.Append(run7);

            textBody7.Append(bodyProperties15);
            textBody7.Append(listStyle15);
            textBody7.Append(paragraph15);

            shape7.Append(nonVisualShapeProperties7);
            shape7.Append(shapeProperties22);
            shape7.Append(textBody7);

            alternateContentFallback13.Append(shape7);

            alternateContent14.Append(alternateContentChoice14);
            alternateContent14.Append(alternateContentFallback13);
            Xdr.ClientData clientData15 = new Xdr.ClientData();

            twoCellAnchor15.Append(fromMarker15);
            twoCellAnchor15.Append(toMarker15);
            twoCellAnchor15.Append(alternateContent14);
            twoCellAnchor15.Append(clientData15);

            Xdr.TwoCellAnchor twoCellAnchor16 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker16 = new Xdr.FromMarker();
            Xdr.ColumnId columnId31 = new Xdr.ColumnId();
            columnId31.Text = "10";
            Xdr.ColumnOffset columnOffset31 = new Xdr.ColumnOffset();
            columnOffset31.Text = "28575";
            Xdr.RowId rowId31 = new Xdr.RowId();
            rowId31.Text = "9";
            Xdr.RowOffset rowOffset31 = new Xdr.RowOffset();
            rowOffset31.Text = "19050";

            fromMarker16.Append(columnId31);
            fromMarker16.Append(columnOffset31);
            fromMarker16.Append(rowId31);
            fromMarker16.Append(rowOffset31);

            Xdr.ToMarker toMarker16 = new Xdr.ToMarker();
            Xdr.ColumnId columnId32 = new Xdr.ColumnId();
            columnId32.Text = "13";
            Xdr.ColumnOffset columnOffset32 = new Xdr.ColumnOffset();
            columnOffset32.Text = "762000";
            Xdr.RowId rowId32 = new Xdr.RowId();
            rowId32.Text = "15";
            Xdr.RowOffset rowOffset32 = new Xdr.RowOffset();
            rowOffset32.Text = "66675";

            toMarker16.Append(columnId32);
            toMarker16.Append(columnOffset32);
            toMarker16.Append(rowId32);
            toMarker16.Append(rowOffset32);

            AlternateContent alternateContent15 = new AlternateContent();
            alternateContent15.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent15.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice15 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame16 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties16 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties23 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 7" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties16 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties16.Append(nonVisualDrawingProperties23);
            nonVisualGraphicFrameProperties16.Append(nonVisualGraphicFrameDrawingProperties16);

            Xdr.Transform transform16 = new Xdr.Transform();
            A.Offset offset23 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents23 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform16.Append(offset23);
            transform16.Append(extents23);

            A.Graphic graphic16 = new A.Graphic();

            A.GraphicData graphicData16 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer8 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 7" };
            timeSlicer8.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData16.Append(timeSlicer8);

            graphic16.Append(graphicData16);

            graphicFrame16.Append(nonVisualGraphicFrameProperties16);
            graphicFrame16.Append(transform16);
            graphicFrame16.Append(graphic16);

            alternateContentChoice15.Append(graphicFrame16);

            AlternateContentFallback alternateContentFallback14 = new AlternateContentFallback();
            alternateContentFallback14.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback14.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape8 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties8 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties24 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties8 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks8 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties8.Append(shapeLocks8);

            nonVisualShapeProperties8.Append(nonVisualDrawingProperties24);
            nonVisualShapeProperties8.Append(nonVisualShapeDrawingProperties8);

            Xdr.ShapeProperties shapeProperties23 = new Xdr.ShapeProperties();

            A.Transform2D transform2D8 = new A.Transform2D();
            A.Offset offset24 = new A.Offset(){ X = 8629650L, Y = 1733550L };
            A.Extents extents24 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D8.Append(offset24);
            transform2D8.Append(extents24);

            A.PresetGeometry presetGeometry8 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList8 = new A.AdjustValueList();

            presetGeometry8.Append(adjustValueList8);

            A.SolidFill solidFill42 = new A.SolidFill();
            A.PresetColor presetColor15 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill42.Append(presetColor15);

            A.Outline outline33 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill43 = new A.SolidFill();
            A.PresetColor presetColor16 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill43.Append(presetColor16);

            outline33.Append(solidFill43);

            shapeProperties23.Append(transform2D8);
            shapeProperties23.Append(presetGeometry8);
            shapeProperties23.Append(solidFill42);
            shapeProperties23.Append(outline33);

            Xdr.TextBody textBody8 = new Xdr.TextBody();
            A.BodyProperties bodyProperties16 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle16 = new A.ListStyle();

            A.Paragraph paragraph16 = new A.Paragraph();

            A.Run run8 = new A.Run();
            A.RunProperties runProperties8 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text46 = new A.Text();
            text46.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run8.Append(runProperties8);
            run8.Append(text46);

            paragraph16.Append(run8);

            textBody8.Append(bodyProperties16);
            textBody8.Append(listStyle16);
            textBody8.Append(paragraph16);

            shape8.Append(nonVisualShapeProperties8);
            shape8.Append(shapeProperties23);
            shape8.Append(textBody8);

            alternateContentFallback14.Append(shape8);

            alternateContent15.Append(alternateContentChoice15);
            alternateContent15.Append(alternateContentFallback14);
            Xdr.ClientData clientData16 = new Xdr.ClientData();

            twoCellAnchor16.Append(fromMarker16);
            twoCellAnchor16.Append(toMarker16);
            twoCellAnchor16.Append(alternateContent15);
            twoCellAnchor16.Append(clientData16);

            worksheetDrawing4.Append(twoCellAnchor13);
            worksheetDrawing4.Append(twoCellAnchor14);
            worksheetDrawing4.Append(twoCellAnchor15);
            worksheetDrawing4.Append(twoCellAnchor16);

            drawingsPart4.WorksheetDrawing = worksheetDrawing4;
        }
コード例 #3
0
        // Generates content of drawingsPart2.
        private void GenerateDrawingsPart2Content(DrawingsPart drawingsPart2)
        {
            Xdr.WorksheetDrawing worksheetDrawing2 = new Xdr.WorksheetDrawing();
            worksheetDrawing2.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing2.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor5 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker5 = new Xdr.FromMarker();
            Xdr.ColumnId columnId9 = new Xdr.ColumnId();
            columnId9.Text = "3";
            Xdr.ColumnOffset columnOffset9 = new Xdr.ColumnOffset();
            columnOffset9.Text = "257175";
            Xdr.RowId rowId9 = new Xdr.RowId();
            rowId9.Text = "0";
            Xdr.RowOffset rowOffset9 = new Xdr.RowOffset();
            rowOffset9.Text = "23812";

            fromMarker5.Append(columnId9);
            fromMarker5.Append(columnOffset9);
            fromMarker5.Append(rowId9);
            fromMarker5.Append(rowOffset9);

            Xdr.ToMarker toMarker5 = new Xdr.ToMarker();
            Xdr.ColumnId columnId10 = new Xdr.ColumnId();
            columnId10.Text = "10";
            Xdr.ColumnOffset columnOffset10 = new Xdr.ColumnOffset();
            columnOffset10.Text = "561975";
            Xdr.RowId rowId10 = new Xdr.RowId();
            rowId10.Text = "14";
            Xdr.RowOffset rowOffset10 = new Xdr.RowOffset();
            rowOffset10.Text = "100012";

            toMarker5.Append(columnId10);
            toMarker5.Append(columnOffset10);
            toMarker5.Append(rowId10);
            toMarker5.Append(rowOffset10);

            Xdr.GraphicFrame graphicFrame5 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties5 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties7 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "グラフ 1" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties5 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties5.Append(nonVisualDrawingProperties7);
            nonVisualGraphicFrameProperties5.Append(nonVisualGraphicFrameDrawingProperties5);

            Xdr.Transform transform5 = new Xdr.Transform();
            A.Offset offset7 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents7 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform5.Append(offset7);
            transform5.Append(extents7);

            A.Graphic graphic5 = new A.Graphic();

            A.GraphicData graphicData5 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference3 = new C.ChartReference(){ Id = "rId1" };
            chartReference3.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference3.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData5.Append(chartReference3);

            graphic5.Append(graphicData5);

            graphicFrame5.Append(nonVisualGraphicFrameProperties5);
            graphicFrame5.Append(transform5);
            graphicFrame5.Append(graphic5);
            Xdr.ClientData clientData5 = new Xdr.ClientData();

            twoCellAnchor5.Append(fromMarker5);
            twoCellAnchor5.Append(toMarker5);
            twoCellAnchor5.Append(graphicFrame5);
            twoCellAnchor5.Append(clientData5);

            Xdr.TwoCellAnchor twoCellAnchor6 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker6 = new Xdr.FromMarker();
            Xdr.ColumnId columnId11 = new Xdr.ColumnId();
            columnId11.Text = "3";
            Xdr.ColumnOffset columnOffset11 = new Xdr.ColumnOffset();
            columnOffset11.Text = "257175";
            Xdr.RowId rowId11 = new Xdr.RowId();
            rowId11.Text = "15";
            Xdr.RowOffset rowOffset11 = new Xdr.RowOffset();
            rowOffset11.Text = "80962";

            fromMarker6.Append(columnId11);
            fromMarker6.Append(columnOffset11);
            fromMarker6.Append(rowId11);
            fromMarker6.Append(rowOffset11);

            Xdr.ToMarker toMarker6 = new Xdr.ToMarker();
            Xdr.ColumnId columnId12 = new Xdr.ColumnId();
            columnId12.Text = "10";
            Xdr.ColumnOffset columnOffset12 = new Xdr.ColumnOffset();
            columnOffset12.Text = "561975";
            Xdr.RowId rowId12 = new Xdr.RowId();
            rowId12.Text = "29";
            Xdr.RowOffset rowOffset12 = new Xdr.RowOffset();
            rowOffset12.Text = "157162";

            toMarker6.Append(columnId12);
            toMarker6.Append(columnOffset12);
            toMarker6.Append(rowId12);
            toMarker6.Append(rowOffset12);

            Xdr.GraphicFrame graphicFrame6 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties6 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties8 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties6 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties6.Append(nonVisualDrawingProperties8);
            nonVisualGraphicFrameProperties6.Append(nonVisualGraphicFrameDrawingProperties6);

            Xdr.Transform transform6 = new Xdr.Transform();
            A.Offset offset8 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents8 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform6.Append(offset8);
            transform6.Append(extents8);

            A.Graphic graphic6 = new A.Graphic();

            A.GraphicData graphicData6 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference4 = new C.ChartReference(){ Id = "rId2" };
            chartReference4.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference4.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData6.Append(chartReference4);

            graphic6.Append(graphicData6);

            graphicFrame6.Append(nonVisualGraphicFrameProperties6);
            graphicFrame6.Append(transform6);
            graphicFrame6.Append(graphic6);
            Xdr.ClientData clientData6 = new Xdr.ClientData();

            twoCellAnchor6.Append(fromMarker6);
            twoCellAnchor6.Append(toMarker6);
            twoCellAnchor6.Append(graphicFrame6);
            twoCellAnchor6.Append(clientData6);

            Xdr.TwoCellAnchor twoCellAnchor7 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker7 = new Xdr.FromMarker();
            Xdr.ColumnId columnId13 = new Xdr.ColumnId();
            columnId13.Text = "12";
            Xdr.ColumnOffset columnOffset13 = new Xdr.ColumnOffset();
            columnOffset13.Text = "19050";
            Xdr.RowId rowId13 = new Xdr.RowId();
            rowId13.Text = "0";
            Xdr.RowOffset rowOffset13 = new Xdr.RowOffset();
            rowOffset13.Text = "19050";

            fromMarker7.Append(columnId13);
            fromMarker7.Append(columnOffset13);
            fromMarker7.Append(rowId13);
            fromMarker7.Append(rowOffset13);

            Xdr.ToMarker toMarker7 = new Xdr.ToMarker();
            Xdr.ColumnId columnId14 = new Xdr.ColumnId();
            columnId14.Text = "17";
            Xdr.ColumnOffset columnOffset14 = new Xdr.ColumnOffset();
            columnOffset14.Text = "304800";
            Xdr.RowId rowId14 = new Xdr.RowId();
            rowId14.Text = "6";
            Xdr.RowOffset rowOffset14 = new Xdr.RowOffset();
            rowOffset14.Text = "66675";

            toMarker7.Append(columnId14);
            toMarker7.Append(columnOffset14);
            toMarker7.Append(rowId14);
            toMarker7.Append(rowOffset14);

            AlternateContent alternateContent6 = new AlternateContent();
            alternateContent6.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent6.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice6 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame7 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties7 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties9 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "Date" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties7 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties7.Append(nonVisualDrawingProperties9);
            nonVisualGraphicFrameProperties7.Append(nonVisualGraphicFrameDrawingProperties7);

            Xdr.Transform transform7 = new Xdr.Transform();
            A.Offset offset9 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents9 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform7.Append(offset9);
            transform7.Append(extents9);

            A.Graphic graphic7 = new A.Graphic();

            A.GraphicData graphicData7 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer3 = new Tsle.TimeSlicer(){ Name = "Date" };
            timeSlicer3.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData7.Append(timeSlicer3);

            graphic7.Append(graphicData7);

            graphicFrame7.Append(nonVisualGraphicFrameProperties7);
            graphicFrame7.Append(transform7);
            graphicFrame7.Append(graphic7);

            alternateContentChoice6.Append(graphicFrame7);

            AlternateContentFallback alternateContentFallback5 = new AlternateContentFallback();
            alternateContentFallback5.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback5.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape3 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties3 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties10 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties3 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks3 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties3.Append(shapeLocks3);

            nonVisualShapeProperties3.Append(nonVisualDrawingProperties10);
            nonVisualShapeProperties3.Append(nonVisualShapeDrawingProperties3);

            Xdr.ShapeProperties shapeProperties11 = new Xdr.ShapeProperties();

            A.Transform2D transform2D3 = new A.Transform2D();
            A.Offset offset10 = new A.Offset(){ X = 7820025L, Y = 19050L };
            A.Extents extents10 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D3.Append(offset10);
            transform2D3.Append(extents10);

            A.PresetGeometry presetGeometry3 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList3 = new A.AdjustValueList();

            presetGeometry3.Append(adjustValueList3);

            A.SolidFill solidFill19 = new A.SolidFill();
            A.PresetColor presetColor5 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill19.Append(presetColor5);

            A.Outline outline16 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill20 = new A.SolidFill();
            A.PresetColor presetColor6 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill20.Append(presetColor6);

            outline16.Append(solidFill20);

            shapeProperties11.Append(transform2D3);
            shapeProperties11.Append(presetGeometry3);
            shapeProperties11.Append(solidFill19);
            shapeProperties11.Append(outline16);

            Xdr.TextBody textBody3 = new Xdr.TextBody();
            A.BodyProperties bodyProperties7 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle7 = new A.ListStyle();

            A.Paragraph paragraph7 = new A.Paragraph();

            A.Run run3 = new A.Run();
            A.RunProperties runProperties3 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text3 = new A.Text();
            text3.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run3.Append(runProperties3);
            run3.Append(text3);

            paragraph7.Append(run3);

            textBody3.Append(bodyProperties7);
            textBody3.Append(listStyle7);
            textBody3.Append(paragraph7);

            shape3.Append(nonVisualShapeProperties3);
            shape3.Append(shapeProperties11);
            shape3.Append(textBody3);

            alternateContentFallback5.Append(shape3);

            alternateContent6.Append(alternateContentChoice6);
            alternateContent6.Append(alternateContentFallback5);
            Xdr.ClientData clientData7 = new Xdr.ClientData();

            twoCellAnchor7.Append(fromMarker7);
            twoCellAnchor7.Append(toMarker7);
            twoCellAnchor7.Append(alternateContent6);
            twoCellAnchor7.Append(clientData7);

            Xdr.TwoCellAnchor twoCellAnchor8 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker8 = new Xdr.FromMarker();
            Xdr.ColumnId columnId15 = new Xdr.ColumnId();
            columnId15.Text = "12";
            Xdr.ColumnOffset columnOffset15 = new Xdr.ColumnOffset();
            columnOffset15.Text = "9525";
            Xdr.RowId rowId15 = new Xdr.RowId();
            rowId15.Text = "7";
            Xdr.RowOffset rowOffset15 = new Xdr.RowOffset();
            rowOffset15.Text = "19050";

            fromMarker8.Append(columnId15);
            fromMarker8.Append(columnOffset15);
            fromMarker8.Append(rowId15);
            fromMarker8.Append(rowOffset15);

            Xdr.ToMarker toMarker8 = new Xdr.ToMarker();
            Xdr.ColumnId columnId16 = new Xdr.ColumnId();
            columnId16.Text = "17";
            Xdr.ColumnOffset columnOffset16 = new Xdr.ColumnOffset();
            columnOffset16.Text = "371475";
            Xdr.RowId rowId16 = new Xdr.RowId();
            rowId16.Text = "13";
            Xdr.RowOffset rowOffset16 = new Xdr.RowOffset();
            rowOffset16.Text = "66675";

            toMarker8.Append(columnId16);
            toMarker8.Append(columnOffset16);
            toMarker8.Append(rowId16);
            toMarker8.Append(rowOffset16);

            AlternateContent alternateContent7 = new AlternateContent();
            alternateContent7.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent7.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice7 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame8 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties8 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties11 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)7U, Name = "Date 1" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties8 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties8.Append(nonVisualDrawingProperties11);
            nonVisualGraphicFrameProperties8.Append(nonVisualGraphicFrameDrawingProperties8);

            Xdr.Transform transform8 = new Xdr.Transform();
            A.Offset offset11 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents11 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform8.Append(offset11);
            transform8.Append(extents11);

            A.Graphic graphic8 = new A.Graphic();

            A.GraphicData graphicData8 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer4 = new Tsle.TimeSlicer(){ Name = "Date 1" };
            timeSlicer4.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData8.Append(timeSlicer4);

            graphic8.Append(graphicData8);

            graphicFrame8.Append(nonVisualGraphicFrameProperties8);
            graphicFrame8.Append(transform8);
            graphicFrame8.Append(graphic8);

            alternateContentChoice7.Append(graphicFrame8);

            AlternateContentFallback alternateContentFallback6 = new AlternateContentFallback();

            Xdr.Shape shape4 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties4 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties12 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties4 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks4 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties4.Append(shapeLocks4);

            nonVisualShapeProperties4.Append(nonVisualDrawingProperties12);
            nonVisualShapeProperties4.Append(nonVisualShapeDrawingProperties4);

            Xdr.ShapeProperties shapeProperties12 = new Xdr.ShapeProperties();

            A.Transform2D transform2D4 = new A.Transform2D();
            A.Offset offset12 = new A.Offset(){ X = 9020175L, Y = 1219200L };
            A.Extents extents12 = new A.Extents(){ Cx = 3790950L, Cy = 1076325L };

            transform2D4.Append(offset12);
            transform2D4.Append(extents12);

            A.PresetGeometry presetGeometry4 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList4 = new A.AdjustValueList();

            presetGeometry4.Append(adjustValueList4);

            A.SolidFill solidFill21 = new A.SolidFill();
            A.PresetColor presetColor7 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill21.Append(presetColor7);

            A.Outline outline17 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill22 = new A.SolidFill();
            A.PresetColor presetColor8 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill22.Append(presetColor8);

            outline17.Append(solidFill22);

            shapeProperties12.Append(transform2D4);
            shapeProperties12.Append(presetGeometry4);
            shapeProperties12.Append(solidFill21);
            shapeProperties12.Append(outline17);

            Xdr.TextBody textBody4 = new Xdr.TextBody();
            A.BodyProperties bodyProperties8 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle8 = new A.ListStyle();

            A.Paragraph paragraph8 = new A.Paragraph();

            A.Run run4 = new A.Run();
            A.RunProperties runProperties4 = new A.RunProperties(){ Language = "ja-JP", AlternativeLanguage = "en-US", FontSize = 1100 };
            A.Text text4 = new A.Text();
            text4.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run4.Append(runProperties4);
            run4.Append(text4);

            paragraph8.Append(run4);

            textBody4.Append(bodyProperties8);
            textBody4.Append(listStyle8);
            textBody4.Append(paragraph8);

            shape4.Append(nonVisualShapeProperties4);
            shape4.Append(shapeProperties12);
            shape4.Append(textBody4);

            alternateContentFallback6.Append(shape4);

            alternateContent7.Append(alternateContentChoice7);
            alternateContent7.Append(alternateContentFallback6);
            Xdr.ClientData clientData8 = new Xdr.ClientData();

            twoCellAnchor8.Append(fromMarker8);
            twoCellAnchor8.Append(toMarker8);
            twoCellAnchor8.Append(alternateContent7);
            twoCellAnchor8.Append(clientData8);

            worksheetDrawing2.Append(twoCellAnchor5);
            worksheetDrawing2.Append(twoCellAnchor6);
            worksheetDrawing2.Append(twoCellAnchor7);
            worksheetDrawing2.Append(twoCellAnchor8);

            drawingsPart2.WorksheetDrawing = worksheetDrawing2;
        }
コード例 #4
0
        // Generates content of drawingsPart3.
        private void GenerateDrawingsPart3Content(DrawingsPart drawingsPart3)
        {
            Xdr.WorksheetDrawing worksheetDrawing3 = new Xdr.WorksheetDrawing();
            worksheetDrawing3.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing3.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor9 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker9 = new Xdr.FromMarker();
            Xdr.ColumnId columnId17 = new Xdr.ColumnId();
            columnId17.Text = "2";
            Xdr.ColumnOffset columnOffset17 = new Xdr.ColumnOffset();
            columnOffset17.Text = "185737";
            Xdr.RowId rowId17 = new Xdr.RowId();
            rowId17.Text = "0";
            Xdr.RowOffset rowOffset17 = new Xdr.RowOffset();
            rowOffset17.Text = "0";

            fromMarker9.Append(columnId17);
            fromMarker9.Append(columnOffset17);
            fromMarker9.Append(rowId17);
            fromMarker9.Append(rowOffset17);

            Xdr.ToMarker toMarker9 = new Xdr.ToMarker();
            Xdr.ColumnId columnId18 = new Xdr.ColumnId();
            columnId18.Text = "9";
            Xdr.ColumnOffset columnOffset18 = new Xdr.ColumnOffset();
            columnOffset18.Text = "90487";
            Xdr.RowId rowId18 = new Xdr.RowId();
            rowId18.Text = "14";
            Xdr.RowOffset rowOffset18 = new Xdr.RowOffset();
            rowOffset18.Text = "76200";

            toMarker9.Append(columnId18);
            toMarker9.Append(columnOffset18);
            toMarker9.Append(rowId18);
            toMarker9.Append(rowOffset18);

            Xdr.GraphicFrame graphicFrame9 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties9 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties13 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties9 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks3 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties9.Append(graphicFrameLocks3);

            nonVisualGraphicFrameProperties9.Append(nonVisualDrawingProperties13);
            nonVisualGraphicFrameProperties9.Append(nonVisualGraphicFrameDrawingProperties9);

            Xdr.Transform transform9 = new Xdr.Transform();
            A.Offset offset13 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents13 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform9.Append(offset13);
            transform9.Append(extents13);

            A.Graphic graphic9 = new A.Graphic();

            A.GraphicData graphicData9 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference5 = new C.ChartReference(){ Id = "rId1" };
            chartReference5.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference5.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData9.Append(chartReference5);

            graphic9.Append(graphicData9);

            graphicFrame9.Append(nonVisualGraphicFrameProperties9);
            graphicFrame9.Append(transform9);
            graphicFrame9.Append(graphic9);
            Xdr.ClientData clientData9 = new Xdr.ClientData();

            twoCellAnchor9.Append(fromMarker9);
            twoCellAnchor9.Append(toMarker9);
            twoCellAnchor9.Append(graphicFrame9);
            twoCellAnchor9.Append(clientData9);

            Xdr.TwoCellAnchor twoCellAnchor10 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker10 = new Xdr.FromMarker();
            Xdr.ColumnId columnId19 = new Xdr.ColumnId();
            columnId19.Text = "2";
            Xdr.ColumnOffset columnOffset19 = new Xdr.ColumnOffset();
            columnOffset19.Text = "200025";
            Xdr.RowId rowId19 = new Xdr.RowId();
            rowId19.Text = "14";
            Xdr.RowOffset rowOffset19 = new Xdr.RowOffset();
            rowOffset19.Text = "147637";

            fromMarker10.Append(columnId19);
            fromMarker10.Append(columnOffset19);
            fromMarker10.Append(rowId19);
            fromMarker10.Append(rowOffset19);

            Xdr.ToMarker toMarker10 = new Xdr.ToMarker();
            Xdr.ColumnId columnId20 = new Xdr.ColumnId();
            columnId20.Text = "7";
            Xdr.ColumnOffset columnOffset20 = new Xdr.ColumnOffset();
            columnOffset20.Text = "476250";
            Xdr.RowId rowId20 = new Xdr.RowId();
            rowId20.Text = "29";
            Xdr.RowOffset rowOffset20 = new Xdr.RowOffset();
            rowOffset20.Text = "33337";

            toMarker10.Append(columnId20);
            toMarker10.Append(columnOffset20);
            toMarker10.Append(rowId20);
            toMarker10.Append(rowOffset20);

            Xdr.GraphicFrame graphicFrame10 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties10 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties14 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties10 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks4 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties10.Append(graphicFrameLocks4);

            nonVisualGraphicFrameProperties10.Append(nonVisualDrawingProperties14);
            nonVisualGraphicFrameProperties10.Append(nonVisualGraphicFrameDrawingProperties10);

            Xdr.Transform transform10 = new Xdr.Transform();
            A.Offset offset14 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents14 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform10.Append(offset14);
            transform10.Append(extents14);

            A.Graphic graphic10 = new A.Graphic();

            A.GraphicData graphicData10 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference6 = new C.ChartReference(){ Id = "rId2" };
            chartReference6.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference6.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData10.Append(chartReference6);

            graphic10.Append(graphicData10);

            graphicFrame10.Append(nonVisualGraphicFrameProperties10);
            graphicFrame10.Append(transform10);
            graphicFrame10.Append(graphic10);
            Xdr.ClientData clientData10 = new Xdr.ClientData();

            twoCellAnchor10.Append(fromMarker10);
            twoCellAnchor10.Append(toMarker10);
            twoCellAnchor10.Append(graphicFrame10);
            twoCellAnchor10.Append(clientData10);

            Xdr.TwoCellAnchor twoCellAnchor11 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker11 = new Xdr.FromMarker();
            Xdr.ColumnId columnId21 = new Xdr.ColumnId();
            columnId21.Text = "10";
            Xdr.ColumnOffset columnOffset21 = new Xdr.ColumnOffset();
            columnOffset21.Text = "28575";
            Xdr.RowId rowId21 = new Xdr.RowId();
            rowId21.Text = "1";
            Xdr.RowOffset rowOffset21 = new Xdr.RowOffset();
            rowOffset21.Text = "9525";

            fromMarker11.Append(columnId21);
            fromMarker11.Append(columnOffset21);
            fromMarker11.Append(rowId21);
            fromMarker11.Append(rowOffset21);

            Xdr.ToMarker toMarker11 = new Xdr.ToMarker();
            Xdr.ColumnId columnId22 = new Xdr.ColumnId();
            columnId22.Text = "13";
            Xdr.ColumnOffset columnOffset22 = new Xdr.ColumnOffset();
            columnOffset22.Text = "762000";
            Xdr.RowId rowId22 = new Xdr.RowId();
            rowId22.Text = "7";
            Xdr.RowOffset rowOffset22 = new Xdr.RowOffset();
            rowOffset22.Text = "57150";

            toMarker11.Append(columnId22);
            toMarker11.Append(columnOffset22);
            toMarker11.Append(rowId22);
            toMarker11.Append(rowOffset22);

            AlternateContent alternateContent10 = new AlternateContent();
            alternateContent10.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent10.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice10 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame11 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties11 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties15 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 8" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties11 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties11.Append(nonVisualDrawingProperties15);
            nonVisualGraphicFrameProperties11.Append(nonVisualGraphicFrameDrawingProperties11);

            Xdr.Transform transform11 = new Xdr.Transform();
            A.Offset offset15 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents15 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform11.Append(offset15);
            transform11.Append(extents15);

            A.Graphic graphic11 = new A.Graphic();

            A.GraphicData graphicData11 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer5 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 8" };
            timeSlicer5.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData11.Append(timeSlicer5);

            graphic11.Append(graphicData11);

            graphicFrame11.Append(nonVisualGraphicFrameProperties11);
            graphicFrame11.Append(transform11);
            graphicFrame11.Append(graphic11);

            alternateContentChoice10.Append(graphicFrame11);

            AlternateContentFallback alternateContentFallback9 = new AlternateContentFallback();
            alternateContentFallback9.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback9.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape5 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties5 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties16 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties5 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks5 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties5.Append(shapeLocks5);

            nonVisualShapeProperties5.Append(nonVisualDrawingProperties16);
            nonVisualShapeProperties5.Append(nonVisualShapeDrawingProperties5);

            Xdr.ShapeProperties shapeProperties13 = new Xdr.ShapeProperties();

            A.Transform2D transform2D5 = new A.Transform2D();
            A.Offset offset16 = new A.Offset(){ X = 8629650L, Y = 200025L };
            A.Extents extents16 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D5.Append(offset16);
            transform2D5.Append(extents16);

            A.PresetGeometry presetGeometry5 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList5 = new A.AdjustValueList();

            presetGeometry5.Append(adjustValueList5);

            A.SolidFill solidFill23 = new A.SolidFill();
            A.PresetColor presetColor9 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill23.Append(presetColor9);

            A.Outline outline18 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill24 = new A.SolidFill();
            A.PresetColor presetColor10 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill24.Append(presetColor10);

            outline18.Append(solidFill24);

            shapeProperties13.Append(transform2D5);
            shapeProperties13.Append(presetGeometry5);
            shapeProperties13.Append(solidFill23);
            shapeProperties13.Append(outline18);

            Xdr.TextBody textBody5 = new Xdr.TextBody();
            A.BodyProperties bodyProperties9 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle9 = new A.ListStyle();

            A.Paragraph paragraph9 = new A.Paragraph();

            A.Run run5 = new A.Run();
            A.RunProperties runProperties5 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text5 = new A.Text();
            text5.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run5.Append(runProperties5);
            run5.Append(text5);

            paragraph9.Append(run5);

            textBody5.Append(bodyProperties9);
            textBody5.Append(listStyle9);
            textBody5.Append(paragraph9);

            shape5.Append(nonVisualShapeProperties5);
            shape5.Append(shapeProperties13);
            shape5.Append(textBody5);

            alternateContentFallback9.Append(shape5);

            alternateContent10.Append(alternateContentChoice10);
            alternateContent10.Append(alternateContentFallback9);
            Xdr.ClientData clientData11 = new Xdr.ClientData();

            twoCellAnchor11.Append(fromMarker11);
            twoCellAnchor11.Append(toMarker11);
            twoCellAnchor11.Append(alternateContent10);
            twoCellAnchor11.Append(clientData11);

            Xdr.TwoCellAnchor twoCellAnchor12 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker12 = new Xdr.FromMarker();
            Xdr.ColumnId columnId23 = new Xdr.ColumnId();
            columnId23.Text = "10";
            Xdr.ColumnOffset columnOffset23 = new Xdr.ColumnOffset();
            columnOffset23.Text = "28575";
            Xdr.RowId rowId23 = new Xdr.RowId();
            rowId23.Text = "8";
            Xdr.RowOffset rowOffset23 = new Xdr.RowOffset();
            rowOffset23.Text = "114300";

            fromMarker12.Append(columnId23);
            fromMarker12.Append(columnOffset23);
            fromMarker12.Append(rowId23);
            fromMarker12.Append(rowOffset23);

            Xdr.ToMarker toMarker12 = new Xdr.ToMarker();
            Xdr.ColumnId columnId24 = new Xdr.ColumnId();
            columnId24.Text = "13";
            Xdr.ColumnOffset columnOffset24 = new Xdr.ColumnOffset();
            columnOffset24.Text = "762000";
            Xdr.RowId rowId24 = new Xdr.RowId();
            rowId24.Text = "14";
            Xdr.RowOffset rowOffset24 = new Xdr.RowOffset();
            rowOffset24.Text = "161925";

            toMarker12.Append(columnId24);
            toMarker12.Append(columnOffset24);
            toMarker12.Append(rowId24);
            toMarker12.Append(rowOffset24);

            AlternateContent alternateContent11 = new AlternateContent();
            alternateContent11.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent11.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice11 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame12 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties12 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties17 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 9" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties12 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties12.Append(nonVisualDrawingProperties17);
            nonVisualGraphicFrameProperties12.Append(nonVisualGraphicFrameDrawingProperties12);

            Xdr.Transform transform12 = new Xdr.Transform();
            A.Offset offset17 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents17 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform12.Append(offset17);
            transform12.Append(extents17);

            A.Graphic graphic12 = new A.Graphic();

            A.GraphicData graphicData12 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer6 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 9" };
            timeSlicer6.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData12.Append(timeSlicer6);

            graphic12.Append(graphicData12);

            graphicFrame12.Append(nonVisualGraphicFrameProperties12);
            graphicFrame12.Append(transform12);
            graphicFrame12.Append(graphic12);

            alternateContentChoice11.Append(graphicFrame12);

            AlternateContentFallback alternateContentFallback10 = new AlternateContentFallback();
            alternateContentFallback10.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback10.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape6 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties6 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties18 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties6 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks6 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties6.Append(shapeLocks6);

            nonVisualShapeProperties6.Append(nonVisualDrawingProperties18);
            nonVisualShapeProperties6.Append(nonVisualShapeDrawingProperties6);

            Xdr.ShapeProperties shapeProperties14 = new Xdr.ShapeProperties();

            A.Transform2D transform2D6 = new A.Transform2D();
            A.Offset offset18 = new A.Offset(){ X = 8629650L, Y = 1638300L };
            A.Extents extents18 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D6.Append(offset18);
            transform2D6.Append(extents18);

            A.PresetGeometry presetGeometry6 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList6 = new A.AdjustValueList();

            presetGeometry6.Append(adjustValueList6);

            A.SolidFill solidFill25 = new A.SolidFill();
            A.PresetColor presetColor11 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill25.Append(presetColor11);

            A.Outline outline19 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill26 = new A.SolidFill();
            A.PresetColor presetColor12 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill26.Append(presetColor12);

            outline19.Append(solidFill26);

            shapeProperties14.Append(transform2D6);
            shapeProperties14.Append(presetGeometry6);
            shapeProperties14.Append(solidFill25);
            shapeProperties14.Append(outline19);

            Xdr.TextBody textBody6 = new Xdr.TextBody();
            A.BodyProperties bodyProperties10 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle10 = new A.ListStyle();

            A.Paragraph paragraph10 = new A.Paragraph();

            A.Run run6 = new A.Run();
            A.RunProperties runProperties6 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text6 = new A.Text();
            text6.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run6.Append(runProperties6);
            run6.Append(text6);

            paragraph10.Append(run6);

            textBody6.Append(bodyProperties10);
            textBody6.Append(listStyle10);
            textBody6.Append(paragraph10);

            shape6.Append(nonVisualShapeProperties6);
            shape6.Append(shapeProperties14);
            shape6.Append(textBody6);

            alternateContentFallback10.Append(shape6);

            alternateContent11.Append(alternateContentChoice11);
            alternateContent11.Append(alternateContentFallback10);
            Xdr.ClientData clientData12 = new Xdr.ClientData();

            twoCellAnchor12.Append(fromMarker12);
            twoCellAnchor12.Append(toMarker12);
            twoCellAnchor12.Append(alternateContent11);
            twoCellAnchor12.Append(clientData12);

            worksheetDrawing3.Append(twoCellAnchor9);
            worksheetDrawing3.Append(twoCellAnchor10);
            worksheetDrawing3.Append(twoCellAnchor11);
            worksheetDrawing3.Append(twoCellAnchor12);

            drawingsPart3.WorksheetDrawing = worksheetDrawing3;
        }
コード例 #5
0
        // Generates content of drawingsPart9.
        private void GenerateDrawingsPart9Content(DrawingsPart drawingsPart9)
        {
            Xdr.WorksheetDrawing worksheetDrawing9 = new Xdr.WorksheetDrawing();
            worksheetDrawing9.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing9.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor35 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker35 = new Xdr.FromMarker();
            Xdr.ColumnId columnId69 = new Xdr.ColumnId();
            columnId69.Text = "2";
            Xdr.ColumnOffset columnOffset69 = new Xdr.ColumnOffset();
            columnOffset69.Text = "185737";
            Xdr.RowId rowId69 = new Xdr.RowId();
            rowId69.Text = "0";
            Xdr.RowOffset rowOffset69 = new Xdr.RowOffset();
            rowOffset69.Text = "0";

            fromMarker35.Append(columnId69);
            fromMarker35.Append(columnOffset69);
            fromMarker35.Append(rowId69);
            fromMarker35.Append(rowOffset69);

            Xdr.ToMarker toMarker35 = new Xdr.ToMarker();
            Xdr.ColumnId columnId70 = new Xdr.ColumnId();
            columnId70.Text = "9";
            Xdr.ColumnOffset columnOffset70 = new Xdr.ColumnOffset();
            columnOffset70.Text = "90487";
            Xdr.RowId rowId70 = new Xdr.RowId();
            rowId70.Text = "14";
            Xdr.RowOffset rowOffset70 = new Xdr.RowOffset();
            rowOffset70.Text = "76200";

            toMarker35.Append(columnId70);
            toMarker35.Append(columnOffset70);
            toMarker35.Append(rowId70);
            toMarker35.Append(rowOffset70);

            Xdr.GraphicFrame graphicFrame35 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties35 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties53 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties35 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks13 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties35.Append(graphicFrameLocks13);

            nonVisualGraphicFrameProperties35.Append(nonVisualDrawingProperties53);
            nonVisualGraphicFrameProperties35.Append(nonVisualGraphicFrameDrawingProperties35);

            Xdr.Transform transform35 = new Xdr.Transform();
            A.Offset offset53 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents53 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform35.Append(offset53);
            transform35.Append(extents53);

            A.Graphic graphic35 = new A.Graphic();

            A.GraphicData graphicData35 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference17 = new C.ChartReference(){ Id = "rId1" };
            chartReference17.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference17.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData35.Append(chartReference17);

            graphic35.Append(graphicData35);

            graphicFrame35.Append(nonVisualGraphicFrameProperties35);
            graphicFrame35.Append(transform35);
            graphicFrame35.Append(graphic35);
            Xdr.ClientData clientData35 = new Xdr.ClientData();

            twoCellAnchor35.Append(fromMarker35);
            twoCellAnchor35.Append(toMarker35);
            twoCellAnchor35.Append(graphicFrame35);
            twoCellAnchor35.Append(clientData35);

            Xdr.TwoCellAnchor twoCellAnchor36 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker36 = new Xdr.FromMarker();
            Xdr.ColumnId columnId71 = new Xdr.ColumnId();
            columnId71.Text = "2";
            Xdr.ColumnOffset columnOffset71 = new Xdr.ColumnOffset();
            columnOffset71.Text = "200025";
            Xdr.RowId rowId71 = new Xdr.RowId();
            rowId71.Text = "14";
            Xdr.RowOffset rowOffset71 = new Xdr.RowOffset();
            rowOffset71.Text = "147637";

            fromMarker36.Append(columnId71);
            fromMarker36.Append(columnOffset71);
            fromMarker36.Append(rowId71);
            fromMarker36.Append(rowOffset71);

            Xdr.ToMarker toMarker36 = new Xdr.ToMarker();
            Xdr.ColumnId columnId72 = new Xdr.ColumnId();
            columnId72.Text = "7";
            Xdr.ColumnOffset columnOffset72 = new Xdr.ColumnOffset();
            columnOffset72.Text = "476250";
            Xdr.RowId rowId72 = new Xdr.RowId();
            rowId72.Text = "29";
            Xdr.RowOffset rowOffset72 = new Xdr.RowOffset();
            rowOffset72.Text = "33337";

            toMarker36.Append(columnId72);
            toMarker36.Append(columnOffset72);
            toMarker36.Append(rowId72);
            toMarker36.Append(rowOffset72);

            Xdr.GraphicFrame graphicFrame36 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties36 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties54 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties36 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks14 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties36.Append(graphicFrameLocks14);

            nonVisualGraphicFrameProperties36.Append(nonVisualDrawingProperties54);
            nonVisualGraphicFrameProperties36.Append(nonVisualGraphicFrameDrawingProperties36);

            Xdr.Transform transform36 = new Xdr.Transform();
            A.Offset offset54 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents54 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform36.Append(offset54);
            transform36.Append(extents54);

            A.Graphic graphic36 = new A.Graphic();

            A.GraphicData graphicData36 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference18 = new C.ChartReference(){ Id = "rId2" };
            chartReference18.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference18.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData36.Append(chartReference18);

            graphic36.Append(graphicData36);

            graphicFrame36.Append(nonVisualGraphicFrameProperties36);
            graphicFrame36.Append(transform36);
            graphicFrame36.Append(graphic36);
            Xdr.ClientData clientData36 = new Xdr.ClientData();

            twoCellAnchor36.Append(fromMarker36);
            twoCellAnchor36.Append(toMarker36);
            twoCellAnchor36.Append(graphicFrame36);
            twoCellAnchor36.Append(clientData36);

            Xdr.TwoCellAnchor twoCellAnchor37 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker37 = new Xdr.FromMarker();
            Xdr.ColumnId columnId73 = new Xdr.ColumnId();
            columnId73.Text = "9";
            Xdr.ColumnOffset columnOffset73 = new Xdr.ColumnOffset();
            columnOffset73.Text = "847725";
            Xdr.RowId rowId73 = new Xdr.RowId();
            rowId73.Text = "0";
            Xdr.RowOffset rowOffset73 = new Xdr.RowOffset();
            rowOffset73.Text = "161925";

            fromMarker37.Append(columnId73);
            fromMarker37.Append(columnOffset73);
            fromMarker37.Append(rowId73);
            fromMarker37.Append(rowOffset73);

            Xdr.ToMarker toMarker37 = new Xdr.ToMarker();
            Xdr.ColumnId columnId74 = new Xdr.ColumnId();
            columnId74.Text = "13";
            Xdr.ColumnOffset columnOffset74 = new Xdr.ColumnOffset();
            columnOffset74.Text = "714375";
            Xdr.RowId rowId74 = new Xdr.RowId();
            rowId74.Text = "7";
            Xdr.RowOffset rowOffset74 = new Xdr.RowOffset();
            rowOffset74.Text = "19050";

            toMarker37.Append(columnId74);
            toMarker37.Append(columnOffset74);
            toMarker37.Append(rowId74);
            toMarker37.Append(rowOffset74);

            AlternateContent alternateContent35 = new AlternateContent();
            alternateContent35.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent35.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice35 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame37 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties37 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties55 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 12" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties37 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties37.Append(nonVisualDrawingProperties55);
            nonVisualGraphicFrameProperties37.Append(nonVisualGraphicFrameDrawingProperties37);

            Xdr.Transform transform37 = new Xdr.Transform();
            A.Offset offset55 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents55 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform37.Append(offset55);
            transform37.Append(extents55);

            A.Graphic graphic37 = new A.Graphic();

            A.GraphicData graphicData37 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer19 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 12" };
            timeSlicer19.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData37.Append(timeSlicer19);

            graphic37.Append(graphicData37);

            graphicFrame37.Append(nonVisualGraphicFrameProperties37);
            graphicFrame37.Append(transform37);
            graphicFrame37.Append(graphic37);

            alternateContentChoice35.Append(graphicFrame37);

            AlternateContentFallback alternateContentFallback34 = new AlternateContentFallback();
            alternateContentFallback34.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback34.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape19 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties19 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties56 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties19 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks19 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties19.Append(shapeLocks19);

            nonVisualShapeProperties19.Append(nonVisualDrawingProperties56);
            nonVisualShapeProperties19.Append(nonVisualShapeDrawingProperties19);

            Xdr.ShapeProperties shapeProperties70 = new Xdr.ShapeProperties();

            A.Transform2D transform2D19 = new A.Transform2D();
            A.Offset offset56 = new A.Offset(){ X = 8582025L, Y = 161925L };
            A.Extents extents56 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D19.Append(offset56);
            transform2D19.Append(extents56);

            A.PresetGeometry presetGeometry19 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList19 = new A.AdjustValueList();

            presetGeometry19.Append(adjustValueList19);

            A.SolidFill solidFill135 = new A.SolidFill();
            A.PresetColor presetColor37 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill135.Append(presetColor37);

            A.Outline outline108 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill136 = new A.SolidFill();
            A.PresetColor presetColor38 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill136.Append(presetColor38);

            outline108.Append(solidFill136);

            shapeProperties70.Append(transform2D19);
            shapeProperties70.Append(presetGeometry19);
            shapeProperties70.Append(solidFill135);
            shapeProperties70.Append(outline108);

            Xdr.TextBody textBody19 = new Xdr.TextBody();
            A.BodyProperties bodyProperties47 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle47 = new A.ListStyle();

            A.Paragraph paragraph47 = new A.Paragraph();

            A.Run run19 = new A.Run();
            A.RunProperties runProperties19 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text57 = new A.Text();
            text57.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run19.Append(runProperties19);
            run19.Append(text57);

            paragraph47.Append(run19);

            textBody19.Append(bodyProperties47);
            textBody19.Append(listStyle47);
            textBody19.Append(paragraph47);

            shape19.Append(nonVisualShapeProperties19);
            shape19.Append(shapeProperties70);
            shape19.Append(textBody19);

            alternateContentFallback34.Append(shape19);

            alternateContent35.Append(alternateContentChoice35);
            alternateContent35.Append(alternateContentFallback34);
            Xdr.ClientData clientData37 = new Xdr.ClientData();

            twoCellAnchor37.Append(fromMarker37);
            twoCellAnchor37.Append(toMarker37);
            twoCellAnchor37.Append(alternateContent35);
            twoCellAnchor37.Append(clientData37);

            Xdr.TwoCellAnchor twoCellAnchor38 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker38 = new Xdr.FromMarker();
            Xdr.ColumnId columnId75 = new Xdr.ColumnId();
            columnId75.Text = "9";
            Xdr.ColumnOffset columnOffset75 = new Xdr.ColumnOffset();
            columnOffset75.Text = "847725";
            Xdr.RowId rowId75 = new Xdr.RowId();
            rowId75.Text = "8";
            Xdr.RowOffset rowOffset75 = new Xdr.RowOffset();
            rowOffset75.Text = "28575";

            fromMarker38.Append(columnId75);
            fromMarker38.Append(columnOffset75);
            fromMarker38.Append(rowId75);
            fromMarker38.Append(rowOffset75);

            Xdr.ToMarker toMarker38 = new Xdr.ToMarker();
            Xdr.ColumnId columnId76 = new Xdr.ColumnId();
            columnId76.Text = "13";
            Xdr.ColumnOffset columnOffset76 = new Xdr.ColumnOffset();
            columnOffset76.Text = "590550";
            Xdr.RowId rowId76 = new Xdr.RowId();
            rowId76.Text = "14";
            Xdr.RowOffset rowOffset76 = new Xdr.RowOffset();
            rowOffset76.Text = "76200";

            toMarker38.Append(columnId76);
            toMarker38.Append(columnOffset76);
            toMarker38.Append(rowId76);
            toMarker38.Append(rowOffset76);

            AlternateContent alternateContent36 = new AlternateContent();
            alternateContent36.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent36.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice36 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame38 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties38 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties57 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 13" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties38 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties38.Append(nonVisualDrawingProperties57);
            nonVisualGraphicFrameProperties38.Append(nonVisualGraphicFrameDrawingProperties38);

            Xdr.Transform transform38 = new Xdr.Transform();
            A.Offset offset57 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents57 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform38.Append(offset57);
            transform38.Append(extents57);

            A.Graphic graphic38 = new A.Graphic();

            A.GraphicData graphicData38 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer20 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 13" };
            timeSlicer20.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData38.Append(timeSlicer20);

            graphic38.Append(graphicData38);

            graphicFrame38.Append(nonVisualGraphicFrameProperties38);
            graphicFrame38.Append(transform38);
            graphicFrame38.Append(graphic38);

            alternateContentChoice36.Append(graphicFrame38);

            AlternateContentFallback alternateContentFallback35 = new AlternateContentFallback();

            Xdr.Shape shape20 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties20 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties58 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties20 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks20 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties20.Append(shapeLocks20);

            nonVisualShapeProperties20.Append(nonVisualDrawingProperties58);
            nonVisualShapeProperties20.Append(nonVisualShapeDrawingProperties20);

            Xdr.ShapeProperties shapeProperties71 = new Xdr.ShapeProperties();

            A.Transform2D transform2D20 = new A.Transform2D();
            A.Offset offset58 = new A.Offset(){ X = 10144125L, Y = 1400175L };
            A.Extents extents58 = new A.Extents(){ Cx = 3705225L, Cy = 1076325L };

            transform2D20.Append(offset58);
            transform2D20.Append(extents58);

            A.PresetGeometry presetGeometry20 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList20 = new A.AdjustValueList();

            presetGeometry20.Append(adjustValueList20);

            A.SolidFill solidFill137 = new A.SolidFill();
            A.PresetColor presetColor39 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill137.Append(presetColor39);

            A.Outline outline109 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill138 = new A.SolidFill();
            A.PresetColor presetColor40 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill138.Append(presetColor40);

            outline109.Append(solidFill138);

            shapeProperties71.Append(transform2D20);
            shapeProperties71.Append(presetGeometry20);
            shapeProperties71.Append(solidFill137);
            shapeProperties71.Append(outline109);

            Xdr.TextBody textBody20 = new Xdr.TextBody();
            A.BodyProperties bodyProperties48 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle48 = new A.ListStyle();

            A.Paragraph paragraph48 = new A.Paragraph();

            A.Run run20 = new A.Run();
            A.RunProperties runProperties20 = new A.RunProperties(){ Language = "ja-JP", AlternativeLanguage = "en-US", FontSize = 1100 };
            A.Text text58 = new A.Text();
            text58.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run20.Append(runProperties20);
            run20.Append(text58);

            paragraph48.Append(run20);

            textBody20.Append(bodyProperties48);
            textBody20.Append(listStyle48);
            textBody20.Append(paragraph48);

            shape20.Append(nonVisualShapeProperties20);
            shape20.Append(shapeProperties71);
            shape20.Append(textBody20);

            alternateContentFallback35.Append(shape20);

            alternateContent36.Append(alternateContentChoice36);
            alternateContent36.Append(alternateContentFallback35);
            Xdr.ClientData clientData38 = new Xdr.ClientData();

            twoCellAnchor38.Append(fromMarker38);
            twoCellAnchor38.Append(toMarker38);
            twoCellAnchor38.Append(alternateContent36);
            twoCellAnchor38.Append(clientData38);

            worksheetDrawing9.Append(twoCellAnchor35);
            worksheetDrawing9.Append(twoCellAnchor36);
            worksheetDrawing9.Append(twoCellAnchor37);
            worksheetDrawing9.Append(twoCellAnchor38);

            drawingsPart9.WorksheetDrawing = worksheetDrawing9;
        }
コード例 #6
0
        // Generates content of drawingsPart8.
        private void GenerateDrawingsPart8Content(DrawingsPart drawingsPart8)
        {
            Xdr.WorksheetDrawing worksheetDrawing8 = new Xdr.WorksheetDrawing();
            worksheetDrawing8.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing8.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor29 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker29 = new Xdr.FromMarker();
            Xdr.ColumnId columnId57 = new Xdr.ColumnId();
            columnId57.Text = "2";
            Xdr.ColumnOffset columnOffset57 = new Xdr.ColumnOffset();
            columnOffset57.Text = "185737";
            Xdr.RowId rowId57 = new Xdr.RowId();
            rowId57.Text = "0";
            Xdr.RowOffset rowOffset57 = new Xdr.RowOffset();
            rowOffset57.Text = "0";

            fromMarker29.Append(columnId57);
            fromMarker29.Append(columnOffset57);
            fromMarker29.Append(rowId57);
            fromMarker29.Append(rowOffset57);

            Xdr.ToMarker toMarker29 = new Xdr.ToMarker();
            Xdr.ColumnId columnId58 = new Xdr.ColumnId();
            columnId58.Text = "9";
            Xdr.ColumnOffset columnOffset58 = new Xdr.ColumnOffset();
            columnOffset58.Text = "90487";
            Xdr.RowId rowId58 = new Xdr.RowId();
            rowId58.Text = "14";
            Xdr.RowOffset rowOffset58 = new Xdr.RowOffset();
            rowOffset58.Text = "76200";

            toMarker29.Append(columnId58);
            toMarker29.Append(columnOffset58);
            toMarker29.Append(rowId58);
            toMarker29.Append(rowOffset58);

            Xdr.GraphicFrame graphicFrame29 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties29 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties43 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties29 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties29.Append(nonVisualDrawingProperties43);
            nonVisualGraphicFrameProperties29.Append(nonVisualGraphicFrameDrawingProperties29);

            Xdr.Transform transform29 = new Xdr.Transform();
            A.Offset offset43 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents43 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform29.Append(offset43);
            transform29.Append(extents43);

            A.Graphic graphic29 = new A.Graphic();

            A.GraphicData graphicData29 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference15 = new C.ChartReference(){ Id = "rId1" };
            chartReference15.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference15.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData29.Append(chartReference15);

            graphic29.Append(graphicData29);

            graphicFrame29.Append(nonVisualGraphicFrameProperties29);
            graphicFrame29.Append(transform29);
            graphicFrame29.Append(graphic29);
            Xdr.ClientData clientData29 = new Xdr.ClientData();

            twoCellAnchor29.Append(fromMarker29);
            twoCellAnchor29.Append(toMarker29);
            twoCellAnchor29.Append(graphicFrame29);
            twoCellAnchor29.Append(clientData29);

            Xdr.TwoCellAnchor twoCellAnchor30 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker30 = new Xdr.FromMarker();
            Xdr.ColumnId columnId59 = new Xdr.ColumnId();
            columnId59.Text = "2";
            Xdr.ColumnOffset columnOffset59 = new Xdr.ColumnOffset();
            columnOffset59.Text = "200025";
            Xdr.RowId rowId59 = new Xdr.RowId();
            rowId59.Text = "14";
            Xdr.RowOffset rowOffset59 = new Xdr.RowOffset();
            rowOffset59.Text = "147637";

            fromMarker30.Append(columnId59);
            fromMarker30.Append(columnOffset59);
            fromMarker30.Append(rowId59);
            fromMarker30.Append(rowOffset59);

            Xdr.ToMarker toMarker30 = new Xdr.ToMarker();
            Xdr.ColumnId columnId60 = new Xdr.ColumnId();
            columnId60.Text = "7";
            Xdr.ColumnOffset columnOffset60 = new Xdr.ColumnOffset();
            columnOffset60.Text = "476250";
            Xdr.RowId rowId60 = new Xdr.RowId();
            rowId60.Text = "29";
            Xdr.RowOffset rowOffset60 = new Xdr.RowOffset();
            rowOffset60.Text = "33337";

            toMarker30.Append(columnId60);
            toMarker30.Append(columnOffset60);
            toMarker30.Append(rowId60);
            toMarker30.Append(rowOffset60);

            Xdr.GraphicFrame graphicFrame30 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties30 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties44 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties30 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties30.Append(nonVisualDrawingProperties44);
            nonVisualGraphicFrameProperties30.Append(nonVisualGraphicFrameDrawingProperties30);

            Xdr.Transform transform30 = new Xdr.Transform();
            A.Offset offset44 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents44 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform30.Append(offset44);
            transform30.Append(extents44);

            A.Graphic graphic30 = new A.Graphic();

            A.GraphicData graphicData30 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference16 = new C.ChartReference(){ Id = "rId2" };
            chartReference16.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference16.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData30.Append(chartReference16);

            graphic30.Append(graphicData30);

            graphicFrame30.Append(nonVisualGraphicFrameProperties30);
            graphicFrame30.Append(transform30);
            graphicFrame30.Append(graphic30);
            Xdr.ClientData clientData30 = new Xdr.ClientData();

            twoCellAnchor30.Append(fromMarker30);
            twoCellAnchor30.Append(toMarker30);
            twoCellAnchor30.Append(graphicFrame30);
            twoCellAnchor30.Append(clientData30);

            Xdr.TwoCellAnchor twoCellAnchor31 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker31 = new Xdr.FromMarker();
            Xdr.ColumnId columnId61 = new Xdr.ColumnId();
            columnId61.Text = "10";
            Xdr.ColumnOffset columnOffset61 = new Xdr.ColumnOffset();
            columnOffset61.Text = "28575";
            Xdr.RowId rowId61 = new Xdr.RowId();
            rowId61.Text = "0";
            Xdr.RowOffset rowOffset61 = new Xdr.RowOffset();
            rowOffset61.Text = "38100";

            fromMarker31.Append(columnId61);
            fromMarker31.Append(columnOffset61);
            fromMarker31.Append(rowId61);
            fromMarker31.Append(rowOffset61);

            Xdr.ToMarker toMarker31 = new Xdr.ToMarker();
            Xdr.ColumnId columnId62 = new Xdr.ColumnId();
            columnId62.Text = "13";
            Xdr.ColumnOffset columnOffset62 = new Xdr.ColumnOffset();
            columnOffset62.Text = "762000";
            Xdr.RowId rowId62 = new Xdr.RowId();
            rowId62.Text = "6";
            Xdr.RowOffset rowOffset62 = new Xdr.RowOffset();
            rowOffset62.Text = "85725";

            toMarker31.Append(columnId62);
            toMarker31.Append(columnOffset62);
            toMarker31.Append(rowId62);
            toMarker31.Append(rowOffset62);

            AlternateContent alternateContent30 = new AlternateContent();
            alternateContent30.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent30.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice30 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame31 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties31 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties45 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties31 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties31.Append(nonVisualDrawingProperties45);
            nonVisualGraphicFrameProperties31.Append(nonVisualGraphicFrameDrawingProperties31);

            Xdr.Transform transform31 = new Xdr.Transform();
            A.Offset offset45 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents45 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform31.Append(offset45);
            transform31.Append(extents45);

            A.Graphic graphic31 = new A.Graphic();

            A.GraphicData graphicData31 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer15 = new Tsle.TimeSlicer(){ Name = "DeliveryDate" };
            timeSlicer15.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData31.Append(timeSlicer15);

            graphic31.Append(graphicData31);

            graphicFrame31.Append(nonVisualGraphicFrameProperties31);
            graphicFrame31.Append(transform31);
            graphicFrame31.Append(graphic31);

            alternateContentChoice30.Append(graphicFrame31);

            AlternateContentFallback alternateContentFallback29 = new AlternateContentFallback();
            alternateContentFallback29.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback29.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape15 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties15 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties46 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties15 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks15 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties15.Append(shapeLocks15);

            nonVisualShapeProperties15.Append(nonVisualDrawingProperties46);
            nonVisualShapeProperties15.Append(nonVisualShapeDrawingProperties15);

            Xdr.ShapeProperties shapeProperties62 = new Xdr.ShapeProperties();

            A.Transform2D transform2D15 = new A.Transform2D();
            A.Offset offset46 = new A.Offset(){ X = 8629650L, Y = 38100L };
            A.Extents extents46 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D15.Append(offset46);
            transform2D15.Append(extents46);

            A.PresetGeometry presetGeometry15 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList15 = new A.AdjustValueList();

            presetGeometry15.Append(adjustValueList15);

            A.SolidFill solidFill117 = new A.SolidFill();
            A.PresetColor presetColor29 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill117.Append(presetColor29);

            A.Outline outline95 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill118 = new A.SolidFill();
            A.PresetColor presetColor30 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill118.Append(presetColor30);

            outline95.Append(solidFill118);

            shapeProperties62.Append(transform2D15);
            shapeProperties62.Append(presetGeometry15);
            shapeProperties62.Append(solidFill117);
            shapeProperties62.Append(outline95);

            Xdr.TextBody textBody15 = new Xdr.TextBody();
            A.BodyProperties bodyProperties39 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle39 = new A.ListStyle();

            A.Paragraph paragraph39 = new A.Paragraph();

            A.Run run15 = new A.Run();
            A.RunProperties runProperties15 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text53 = new A.Text();
            text53.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run15.Append(runProperties15);
            run15.Append(text53);

            paragraph39.Append(run15);

            textBody15.Append(bodyProperties39);
            textBody15.Append(listStyle39);
            textBody15.Append(paragraph39);

            shape15.Append(nonVisualShapeProperties15);
            shape15.Append(shapeProperties62);
            shape15.Append(textBody15);

            alternateContentFallback29.Append(shape15);

            alternateContent30.Append(alternateContentChoice30);
            alternateContent30.Append(alternateContentFallback29);
            Xdr.ClientData clientData31 = new Xdr.ClientData();

            twoCellAnchor31.Append(fromMarker31);
            twoCellAnchor31.Append(toMarker31);
            twoCellAnchor31.Append(alternateContent30);
            twoCellAnchor31.Append(clientData31);

            Xdr.TwoCellAnchor twoCellAnchor32 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker32 = new Xdr.FromMarker();
            Xdr.ColumnId columnId63 = new Xdr.ColumnId();
            columnId63.Text = "9";
            Xdr.ColumnOffset columnOffset63 = new Xdr.ColumnOffset();
            columnOffset63.Text = "857250";
            Xdr.RowId rowId63 = new Xdr.RowId();
            rowId63.Text = "8";
            Xdr.RowOffset rowOffset63 = new Xdr.RowOffset();
            rowOffset63.Text = "19050";

            fromMarker32.Append(columnId63);
            fromMarker32.Append(columnOffset63);
            fromMarker32.Append(rowId63);
            fromMarker32.Append(rowOffset63);

            Xdr.ToMarker toMarker32 = new Xdr.ToMarker();
            Xdr.ColumnId columnId64 = new Xdr.ColumnId();
            columnId64.Text = "13";
            Xdr.ColumnOffset columnOffset64 = new Xdr.ColumnOffset();
            columnOffset64.Text = "723900";
            Xdr.RowId rowId64 = new Xdr.RowId();
            rowId64.Text = "14";
            Xdr.RowOffset rowOffset64 = new Xdr.RowOffset();
            rowOffset64.Text = "66675";

            toMarker32.Append(columnId64);
            toMarker32.Append(columnOffset64);
            toMarker32.Append(rowId64);
            toMarker32.Append(rowOffset64);

            AlternateContent alternateContent31 = new AlternateContent();
            alternateContent31.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent31.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice31 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame32 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties32 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties47 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)6U, Name = "DeliveryDate 1" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties32 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties32.Append(nonVisualDrawingProperties47);
            nonVisualGraphicFrameProperties32.Append(nonVisualGraphicFrameDrawingProperties32);

            Xdr.Transform transform32 = new Xdr.Transform();
            A.Offset offset47 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents47 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform32.Append(offset47);
            transform32.Append(extents47);

            A.Graphic graphic32 = new A.Graphic();

            A.GraphicData graphicData32 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer16 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 1" };
            timeSlicer16.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData32.Append(timeSlicer16);

            graphic32.Append(graphicData32);

            graphicFrame32.Append(nonVisualGraphicFrameProperties32);
            graphicFrame32.Append(transform32);
            graphicFrame32.Append(graphic32);

            alternateContentChoice31.Append(graphicFrame32);

            AlternateContentFallback alternateContentFallback30 = new AlternateContentFallback();
            alternateContentFallback30.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback30.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape16 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties16 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties48 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties16 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks16 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties16.Append(shapeLocks16);

            nonVisualShapeProperties16.Append(nonVisualDrawingProperties48);
            nonVisualShapeProperties16.Append(nonVisualShapeDrawingProperties16);

            Xdr.ShapeProperties shapeProperties63 = new Xdr.ShapeProperties();

            A.Transform2D transform2D16 = new A.Transform2D();
            A.Offset offset48 = new A.Offset(){ X = 8591550L, Y = 1543050L };
            A.Extents extents48 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D16.Append(offset48);
            transform2D16.Append(extents48);

            A.PresetGeometry presetGeometry16 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList16 = new A.AdjustValueList();

            presetGeometry16.Append(adjustValueList16);

            A.SolidFill solidFill119 = new A.SolidFill();
            A.PresetColor presetColor31 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill119.Append(presetColor31);

            A.Outline outline96 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill120 = new A.SolidFill();
            A.PresetColor presetColor32 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill120.Append(presetColor32);

            outline96.Append(solidFill120);

            shapeProperties63.Append(transform2D16);
            shapeProperties63.Append(presetGeometry16);
            shapeProperties63.Append(solidFill119);
            shapeProperties63.Append(outline96);

            Xdr.TextBody textBody16 = new Xdr.TextBody();
            A.BodyProperties bodyProperties40 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle40 = new A.ListStyle();

            A.Paragraph paragraph40 = new A.Paragraph();

            A.Run run16 = new A.Run();
            A.RunProperties runProperties16 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text54 = new A.Text();
            text54.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run16.Append(runProperties16);
            run16.Append(text54);

            paragraph40.Append(run16);

            textBody16.Append(bodyProperties40);
            textBody16.Append(listStyle40);
            textBody16.Append(paragraph40);

            shape16.Append(nonVisualShapeProperties16);
            shape16.Append(shapeProperties63);
            shape16.Append(textBody16);

            alternateContentFallback30.Append(shape16);

            alternateContent31.Append(alternateContentChoice31);
            alternateContent31.Append(alternateContentFallback30);
            Xdr.ClientData clientData32 = new Xdr.ClientData();

            twoCellAnchor32.Append(fromMarker32);
            twoCellAnchor32.Append(toMarker32);
            twoCellAnchor32.Append(alternateContent31);
            twoCellAnchor32.Append(clientData32);

            Xdr.TwoCellAnchor twoCellAnchor33 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker33 = new Xdr.FromMarker();
            Xdr.ColumnId columnId65 = new Xdr.ColumnId();
            columnId65.Text = "10";
            Xdr.ColumnOffset columnOffset65 = new Xdr.ColumnOffset();
            columnOffset65.Text = "9525";
            Xdr.RowId rowId65 = new Xdr.RowId();
            rowId65.Text = "16";
            Xdr.RowOffset rowOffset65 = new Xdr.RowOffset();
            rowOffset65.Text = "0";

            fromMarker33.Append(columnId65);
            fromMarker33.Append(columnOffset65);
            fromMarker33.Append(rowId65);
            fromMarker33.Append(rowOffset65);

            Xdr.ToMarker toMarker33 = new Xdr.ToMarker();
            Xdr.ColumnId columnId66 = new Xdr.ColumnId();
            columnId66.Text = "13";
            Xdr.ColumnOffset columnOffset66 = new Xdr.ColumnOffset();
            columnOffset66.Text = "742950";
            Xdr.RowId rowId66 = new Xdr.RowId();
            rowId66.Text = "22";
            Xdr.RowOffset rowOffset66 = new Xdr.RowOffset();
            rowOffset66.Text = "47625";

            toMarker33.Append(columnId66);
            toMarker33.Append(columnOffset66);
            toMarker33.Append(rowId66);
            toMarker33.Append(rowOffset66);

            AlternateContent alternateContent32 = new AlternateContent();
            alternateContent32.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent32.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice32 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame33 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties33 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties49 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)7U, Name = "DeliveryDate 2" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties33 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties33.Append(nonVisualDrawingProperties49);
            nonVisualGraphicFrameProperties33.Append(nonVisualGraphicFrameDrawingProperties33);

            Xdr.Transform transform33 = new Xdr.Transform();
            A.Offset offset49 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents49 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform33.Append(offset49);
            transform33.Append(extents49);

            A.Graphic graphic33 = new A.Graphic();

            A.GraphicData graphicData33 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer17 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 2" };
            timeSlicer17.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData33.Append(timeSlicer17);

            graphic33.Append(graphicData33);

            graphicFrame33.Append(nonVisualGraphicFrameProperties33);
            graphicFrame33.Append(transform33);
            graphicFrame33.Append(graphic33);

            alternateContentChoice32.Append(graphicFrame33);

            AlternateContentFallback alternateContentFallback31 = new AlternateContentFallback();
            alternateContentFallback31.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback31.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape17 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties17 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties50 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties17 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks17 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties17.Append(shapeLocks17);

            nonVisualShapeProperties17.Append(nonVisualDrawingProperties50);
            nonVisualShapeProperties17.Append(nonVisualShapeDrawingProperties17);

            Xdr.ShapeProperties shapeProperties64 = new Xdr.ShapeProperties();

            A.Transform2D transform2D17 = new A.Transform2D();
            A.Offset offset50 = new A.Offset(){ X = 8610600L, Y = 3048000L };
            A.Extents extents50 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D17.Append(offset50);
            transform2D17.Append(extents50);

            A.PresetGeometry presetGeometry17 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList17 = new A.AdjustValueList();

            presetGeometry17.Append(adjustValueList17);

            A.SolidFill solidFill121 = new A.SolidFill();
            A.PresetColor presetColor33 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill121.Append(presetColor33);

            A.Outline outline97 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill122 = new A.SolidFill();
            A.PresetColor presetColor34 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill122.Append(presetColor34);

            outline97.Append(solidFill122);

            shapeProperties64.Append(transform2D17);
            shapeProperties64.Append(presetGeometry17);
            shapeProperties64.Append(solidFill121);
            shapeProperties64.Append(outline97);

            Xdr.TextBody textBody17 = new Xdr.TextBody();
            A.BodyProperties bodyProperties41 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle41 = new A.ListStyle();

            A.Paragraph paragraph41 = new A.Paragraph();

            A.Run run17 = new A.Run();
            A.RunProperties runProperties17 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text55 = new A.Text();
            text55.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run17.Append(runProperties17);
            run17.Append(text55);

            paragraph41.Append(run17);

            textBody17.Append(bodyProperties41);
            textBody17.Append(listStyle41);
            textBody17.Append(paragraph41);

            shape17.Append(nonVisualShapeProperties17);
            shape17.Append(shapeProperties64);
            shape17.Append(textBody17);

            alternateContentFallback31.Append(shape17);

            alternateContent32.Append(alternateContentChoice32);
            alternateContent32.Append(alternateContentFallback31);
            Xdr.ClientData clientData33 = new Xdr.ClientData();

            twoCellAnchor33.Append(fromMarker33);
            twoCellAnchor33.Append(toMarker33);
            twoCellAnchor33.Append(alternateContent32);
            twoCellAnchor33.Append(clientData33);

            Xdr.TwoCellAnchor twoCellAnchor34 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker34 = new Xdr.FromMarker();
            Xdr.ColumnId columnId67 = new Xdr.ColumnId();
            columnId67.Text = "10";
            Xdr.ColumnOffset columnOffset67 = new Xdr.ColumnOffset();
            columnOffset67.Text = "0";
            Xdr.RowId rowId67 = new Xdr.RowId();
            rowId67.Text = "23";
            Xdr.RowOffset rowOffset67 = new Xdr.RowOffset();
            rowOffset67.Text = "85725";

            fromMarker34.Append(columnId67);
            fromMarker34.Append(columnOffset67);
            fromMarker34.Append(rowId67);
            fromMarker34.Append(rowOffset67);

            Xdr.ToMarker toMarker34 = new Xdr.ToMarker();
            Xdr.ColumnId columnId68 = new Xdr.ColumnId();
            columnId68.Text = "13";
            Xdr.ColumnOffset columnOffset68 = new Xdr.ColumnOffset();
            columnOffset68.Text = "733425";
            Xdr.RowId rowId68 = new Xdr.RowId();
            rowId68.Text = "29";
            Xdr.RowOffset rowOffset68 = new Xdr.RowOffset();
            rowOffset68.Text = "133350";

            toMarker34.Append(columnId68);
            toMarker34.Append(columnOffset68);
            toMarker34.Append(rowId68);
            toMarker34.Append(rowOffset68);

            AlternateContent alternateContent33 = new AlternateContent();
            alternateContent33.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent33.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice33 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame34 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties34 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties51 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)8U, Name = "DeliveryDate 3" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties34 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties34.Append(nonVisualDrawingProperties51);
            nonVisualGraphicFrameProperties34.Append(nonVisualGraphicFrameDrawingProperties34);

            Xdr.Transform transform34 = new Xdr.Transform();
            A.Offset offset51 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents51 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform34.Append(offset51);
            transform34.Append(extents51);

            A.Graphic graphic34 = new A.Graphic();

            A.GraphicData graphicData34 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer18 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 3" };
            timeSlicer18.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData34.Append(timeSlicer18);

            graphic34.Append(graphicData34);

            graphicFrame34.Append(nonVisualGraphicFrameProperties34);
            graphicFrame34.Append(transform34);
            graphicFrame34.Append(graphic34);

            alternateContentChoice33.Append(graphicFrame34);

            AlternateContentFallback alternateContentFallback32 = new AlternateContentFallback();
            alternateContentFallback32.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback32.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape18 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties18 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties52 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties18 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks18 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties18.Append(shapeLocks18);

            nonVisualShapeProperties18.Append(nonVisualDrawingProperties52);
            nonVisualShapeProperties18.Append(nonVisualShapeDrawingProperties18);

            Xdr.ShapeProperties shapeProperties65 = new Xdr.ShapeProperties();

            A.Transform2D transform2D18 = new A.Transform2D();
            A.Offset offset52 = new A.Offset(){ X = 8601075L, Y = 4467225L };
            A.Extents extents52 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D18.Append(offset52);
            transform2D18.Append(extents52);

            A.PresetGeometry presetGeometry18 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList18 = new A.AdjustValueList();

            presetGeometry18.Append(adjustValueList18);

            A.SolidFill solidFill123 = new A.SolidFill();
            A.PresetColor presetColor35 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill123.Append(presetColor35);

            A.Outline outline98 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill124 = new A.SolidFill();
            A.PresetColor presetColor36 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill124.Append(presetColor36);

            outline98.Append(solidFill124);

            shapeProperties65.Append(transform2D18);
            shapeProperties65.Append(presetGeometry18);
            shapeProperties65.Append(solidFill123);
            shapeProperties65.Append(outline98);

            Xdr.TextBody textBody18 = new Xdr.TextBody();
            A.BodyProperties bodyProperties42 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle42 = new A.ListStyle();

            A.Paragraph paragraph42 = new A.Paragraph();

            A.Run run18 = new A.Run();
            A.RunProperties runProperties18 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text56 = new A.Text();
            text56.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run18.Append(runProperties18);
            run18.Append(text56);

            paragraph42.Append(run18);

            textBody18.Append(bodyProperties42);
            textBody18.Append(listStyle42);
            textBody18.Append(paragraph42);

            shape18.Append(nonVisualShapeProperties18);
            shape18.Append(shapeProperties65);
            shape18.Append(textBody18);

            alternateContentFallback32.Append(shape18);

            alternateContent33.Append(alternateContentChoice33);
            alternateContent33.Append(alternateContentFallback32);
            Xdr.ClientData clientData34 = new Xdr.ClientData();

            twoCellAnchor34.Append(fromMarker34);
            twoCellAnchor34.Append(toMarker34);
            twoCellAnchor34.Append(alternateContent33);
            twoCellAnchor34.Append(clientData34);

            worksheetDrawing8.Append(twoCellAnchor29);
            worksheetDrawing8.Append(twoCellAnchor30);
            worksheetDrawing8.Append(twoCellAnchor31);
            worksheetDrawing8.Append(twoCellAnchor32);
            worksheetDrawing8.Append(twoCellAnchor33);
            worksheetDrawing8.Append(twoCellAnchor34);

            drawingsPart8.WorksheetDrawing = worksheetDrawing8;
        }
コード例 #7
0
        // Generates content of drawingsPart7.
        private void GenerateDrawingsPart7Content(DrawingsPart drawingsPart7)
        {
            Xdr.WorksheetDrawing worksheetDrawing7 = new Xdr.WorksheetDrawing();
            worksheetDrawing7.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing7.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor25 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker25 = new Xdr.FromMarker();
            Xdr.ColumnId columnId49 = new Xdr.ColumnId();
            columnId49.Text = "2";
            Xdr.ColumnOffset columnOffset49 = new Xdr.ColumnOffset();
            columnOffset49.Text = "185737";
            Xdr.RowId rowId49 = new Xdr.RowId();
            rowId49.Text = "0";
            Xdr.RowOffset rowOffset49 = new Xdr.RowOffset();
            rowOffset49.Text = "0";

            fromMarker25.Append(columnId49);
            fromMarker25.Append(columnOffset49);
            fromMarker25.Append(rowId49);
            fromMarker25.Append(rowOffset49);

            Xdr.ToMarker toMarker25 = new Xdr.ToMarker();
            Xdr.ColumnId columnId50 = new Xdr.ColumnId();
            columnId50.Text = "9";
            Xdr.ColumnOffset columnOffset50 = new Xdr.ColumnOffset();
            columnOffset50.Text = "90487";
            Xdr.RowId rowId50 = new Xdr.RowId();
            rowId50.Text = "14";
            Xdr.RowOffset rowOffset50 = new Xdr.RowOffset();
            rowOffset50.Text = "76200";

            toMarker25.Append(columnId50);
            toMarker25.Append(columnOffset50);
            toMarker25.Append(rowId50);
            toMarker25.Append(rowOffset50);

            Xdr.GraphicFrame graphicFrame25 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties25 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties37 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties25 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks11 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties25.Append(graphicFrameLocks11);

            nonVisualGraphicFrameProperties25.Append(nonVisualDrawingProperties37);
            nonVisualGraphicFrameProperties25.Append(nonVisualGraphicFrameDrawingProperties25);

            Xdr.Transform transform25 = new Xdr.Transform();
            A.Offset offset37 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents37 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform25.Append(offset37);
            transform25.Append(extents37);

            A.Graphic graphic25 = new A.Graphic();

            A.GraphicData graphicData25 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference13 = new C.ChartReference(){ Id = "rId1" };
            chartReference13.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference13.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData25.Append(chartReference13);

            graphic25.Append(graphicData25);

            graphicFrame25.Append(nonVisualGraphicFrameProperties25);
            graphicFrame25.Append(transform25);
            graphicFrame25.Append(graphic25);
            Xdr.ClientData clientData25 = new Xdr.ClientData();

            twoCellAnchor25.Append(fromMarker25);
            twoCellAnchor25.Append(toMarker25);
            twoCellAnchor25.Append(graphicFrame25);
            twoCellAnchor25.Append(clientData25);

            Xdr.TwoCellAnchor twoCellAnchor26 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker26 = new Xdr.FromMarker();
            Xdr.ColumnId columnId51 = new Xdr.ColumnId();
            columnId51.Text = "2";
            Xdr.ColumnOffset columnOffset51 = new Xdr.ColumnOffset();
            columnOffset51.Text = "200025";
            Xdr.RowId rowId51 = new Xdr.RowId();
            rowId51.Text = "14";
            Xdr.RowOffset rowOffset51 = new Xdr.RowOffset();
            rowOffset51.Text = "147637";

            fromMarker26.Append(columnId51);
            fromMarker26.Append(columnOffset51);
            fromMarker26.Append(rowId51);
            fromMarker26.Append(rowOffset51);

            Xdr.ToMarker toMarker26 = new Xdr.ToMarker();
            Xdr.ColumnId columnId52 = new Xdr.ColumnId();
            columnId52.Text = "7";
            Xdr.ColumnOffset columnOffset52 = new Xdr.ColumnOffset();
            columnOffset52.Text = "476250";
            Xdr.RowId rowId52 = new Xdr.RowId();
            rowId52.Text = "29";
            Xdr.RowOffset rowOffset52 = new Xdr.RowOffset();
            rowOffset52.Text = "33337";

            toMarker26.Append(columnId52);
            toMarker26.Append(columnOffset52);
            toMarker26.Append(rowId52);
            toMarker26.Append(rowOffset52);

            Xdr.GraphicFrame graphicFrame26 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties26 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties38 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties26 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks12 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties26.Append(graphicFrameLocks12);

            nonVisualGraphicFrameProperties26.Append(nonVisualDrawingProperties38);
            nonVisualGraphicFrameProperties26.Append(nonVisualGraphicFrameDrawingProperties26);

            Xdr.Transform transform26 = new Xdr.Transform();
            A.Offset offset38 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents38 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform26.Append(offset38);
            transform26.Append(extents38);

            A.Graphic graphic26 = new A.Graphic();

            A.GraphicData graphicData26 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference14 = new C.ChartReference(){ Id = "rId2" };
            chartReference14.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference14.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData26.Append(chartReference14);

            graphic26.Append(graphicData26);

            graphicFrame26.Append(nonVisualGraphicFrameProperties26);
            graphicFrame26.Append(transform26);
            graphicFrame26.Append(graphic26);
            Xdr.ClientData clientData26 = new Xdr.ClientData();

            twoCellAnchor26.Append(fromMarker26);
            twoCellAnchor26.Append(toMarker26);
            twoCellAnchor26.Append(graphicFrame26);
            twoCellAnchor26.Append(clientData26);

            Xdr.TwoCellAnchor twoCellAnchor27 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker27 = new Xdr.FromMarker();
            Xdr.ColumnId columnId53 = new Xdr.ColumnId();
            columnId53.Text = "10";
            Xdr.ColumnOffset columnOffset53 = new Xdr.ColumnOffset();
            columnOffset53.Text = "9525";
            Xdr.RowId rowId53 = new Xdr.RowId();
            rowId53.Text = "1";
            Xdr.RowOffset rowOffset53 = new Xdr.RowOffset();
            rowOffset53.Text = "0";

            fromMarker27.Append(columnId53);
            fromMarker27.Append(columnOffset53);
            fromMarker27.Append(rowId53);
            fromMarker27.Append(rowOffset53);

            Xdr.ToMarker toMarker27 = new Xdr.ToMarker();
            Xdr.ColumnId columnId54 = new Xdr.ColumnId();
            columnId54.Text = "13";
            Xdr.ColumnOffset columnOffset54 = new Xdr.ColumnOffset();
            columnOffset54.Text = "742950";
            Xdr.RowId rowId54 = new Xdr.RowId();
            rowId54.Text = "7";
            Xdr.RowOffset rowOffset54 = new Xdr.RowOffset();
            rowOffset54.Text = "47625";

            toMarker27.Append(columnId54);
            toMarker27.Append(columnOffset54);
            toMarker27.Append(rowId54);
            toMarker27.Append(rowOffset54);

            AlternateContent alternateContent26 = new AlternateContent();
            alternateContent26.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent26.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice26 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame27 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties27 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties39 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 14" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties27 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties27.Append(nonVisualDrawingProperties39);
            nonVisualGraphicFrameProperties27.Append(nonVisualGraphicFrameDrawingProperties27);

            Xdr.Transform transform27 = new Xdr.Transform();
            A.Offset offset39 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents39 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform27.Append(offset39);
            transform27.Append(extents39);

            A.Graphic graphic27 = new A.Graphic();

            A.GraphicData graphicData27 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer13 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 14" };
            timeSlicer13.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData27.Append(timeSlicer13);

            graphic27.Append(graphicData27);

            graphicFrame27.Append(nonVisualGraphicFrameProperties27);
            graphicFrame27.Append(transform27);
            graphicFrame27.Append(graphic27);

            alternateContentChoice26.Append(graphicFrame27);

            AlternateContentFallback alternateContentFallback25 = new AlternateContentFallback();
            alternateContentFallback25.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback25.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape13 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties13 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties40 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties13 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks13 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties13.Append(shapeLocks13);

            nonVisualShapeProperties13.Append(nonVisualDrawingProperties40);
            nonVisualShapeProperties13.Append(nonVisualShapeDrawingProperties13);

            Xdr.ShapeProperties shapeProperties50 = new Xdr.ShapeProperties();

            A.Transform2D transform2D13 = new A.Transform2D();
            A.Offset offset40 = new A.Offset(){ X = 8610600L, Y = 190500L };
            A.Extents extents40 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D13.Append(offset40);
            transform2D13.Append(extents40);

            A.PresetGeometry presetGeometry13 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList13 = new A.AdjustValueList();

            presetGeometry13.Append(adjustValueList13);

            A.SolidFill solidFill97 = new A.SolidFill();
            A.PresetColor presetColor25 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill97.Append(presetColor25);

            A.Outline outline78 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill98 = new A.SolidFill();
            A.PresetColor presetColor26 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill98.Append(presetColor26);

            outline78.Append(solidFill98);

            shapeProperties50.Append(transform2D13);
            shapeProperties50.Append(presetGeometry13);
            shapeProperties50.Append(solidFill97);
            shapeProperties50.Append(outline78);

            Xdr.TextBody textBody13 = new Xdr.TextBody();
            A.BodyProperties bodyProperties33 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle33 = new A.ListStyle();

            A.Paragraph paragraph33 = new A.Paragraph();

            A.Run run13 = new A.Run();
            A.RunProperties runProperties13 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text51 = new A.Text();
            text51.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run13.Append(runProperties13);
            run13.Append(text51);

            paragraph33.Append(run13);

            textBody13.Append(bodyProperties33);
            textBody13.Append(listStyle33);
            textBody13.Append(paragraph33);

            shape13.Append(nonVisualShapeProperties13);
            shape13.Append(shapeProperties50);
            shape13.Append(textBody13);

            alternateContentFallback25.Append(shape13);

            alternateContent26.Append(alternateContentChoice26);
            alternateContent26.Append(alternateContentFallback25);
            Xdr.ClientData clientData27 = new Xdr.ClientData();

            twoCellAnchor27.Append(fromMarker27);
            twoCellAnchor27.Append(toMarker27);
            twoCellAnchor27.Append(alternateContent26);
            twoCellAnchor27.Append(clientData27);

            Xdr.TwoCellAnchor twoCellAnchor28 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker28 = new Xdr.FromMarker();
            Xdr.ColumnId columnId55 = new Xdr.ColumnId();
            columnId55.Text = "10";
            Xdr.ColumnOffset columnOffset55 = new Xdr.ColumnOffset();
            columnOffset55.Text = "19050";
            Xdr.RowId rowId55 = new Xdr.RowId();
            rowId55.Text = "9";
            Xdr.RowOffset rowOffset55 = new Xdr.RowOffset();
            rowOffset55.Text = "9525";

            fromMarker28.Append(columnId55);
            fromMarker28.Append(columnOffset55);
            fromMarker28.Append(rowId55);
            fromMarker28.Append(rowOffset55);

            Xdr.ToMarker toMarker28 = new Xdr.ToMarker();
            Xdr.ColumnId columnId56 = new Xdr.ColumnId();
            columnId56.Text = "13";
            Xdr.ColumnOffset columnOffset56 = new Xdr.ColumnOffset();
            columnOffset56.Text = "752475";
            Xdr.RowId rowId56 = new Xdr.RowId();
            rowId56.Text = "15";
            Xdr.RowOffset rowOffset56 = new Xdr.RowOffset();
            rowOffset56.Text = "57150";

            toMarker28.Append(columnId56);
            toMarker28.Append(columnOffset56);
            toMarker28.Append(rowId56);
            toMarker28.Append(rowOffset56);

            AlternateContent alternateContent27 = new AlternateContent();
            alternateContent27.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent27.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice27 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame28 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties28 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties41 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 15" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties28 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties28.Append(nonVisualDrawingProperties41);
            nonVisualGraphicFrameProperties28.Append(nonVisualGraphicFrameDrawingProperties28);

            Xdr.Transform transform28 = new Xdr.Transform();
            A.Offset offset41 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents41 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform28.Append(offset41);
            transform28.Append(extents41);

            A.Graphic graphic28 = new A.Graphic();

            A.GraphicData graphicData28 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer14 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 15" };
            timeSlicer14.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData28.Append(timeSlicer14);

            graphic28.Append(graphicData28);

            graphicFrame28.Append(nonVisualGraphicFrameProperties28);
            graphicFrame28.Append(transform28);
            graphicFrame28.Append(graphic28);

            alternateContentChoice27.Append(graphicFrame28);

            AlternateContentFallback alternateContentFallback26 = new AlternateContentFallback();
            alternateContentFallback26.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback26.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape14 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties14 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties42 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties14 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks14 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties14.Append(shapeLocks14);

            nonVisualShapeProperties14.Append(nonVisualDrawingProperties42);
            nonVisualShapeProperties14.Append(nonVisualShapeDrawingProperties14);

            Xdr.ShapeProperties shapeProperties51 = new Xdr.ShapeProperties();

            A.Transform2D transform2D14 = new A.Transform2D();
            A.Offset offset42 = new A.Offset(){ X = 8620125L, Y = 1724025L };
            A.Extents extents42 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D14.Append(offset42);
            transform2D14.Append(extents42);

            A.PresetGeometry presetGeometry14 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList14 = new A.AdjustValueList();

            presetGeometry14.Append(adjustValueList14);

            A.SolidFill solidFill99 = new A.SolidFill();
            A.PresetColor presetColor27 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill99.Append(presetColor27);

            A.Outline outline79 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill100 = new A.SolidFill();
            A.PresetColor presetColor28 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill100.Append(presetColor28);

            outline79.Append(solidFill100);

            shapeProperties51.Append(transform2D14);
            shapeProperties51.Append(presetGeometry14);
            shapeProperties51.Append(solidFill99);
            shapeProperties51.Append(outline79);

            Xdr.TextBody textBody14 = new Xdr.TextBody();
            A.BodyProperties bodyProperties34 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle34 = new A.ListStyle();

            A.Paragraph paragraph34 = new A.Paragraph();

            A.Run run14 = new A.Run();
            A.RunProperties runProperties14 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text52 = new A.Text();
            text52.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run14.Append(runProperties14);
            run14.Append(text52);

            paragraph34.Append(run14);

            textBody14.Append(bodyProperties34);
            textBody14.Append(listStyle34);
            textBody14.Append(paragraph34);

            shape14.Append(nonVisualShapeProperties14);
            shape14.Append(shapeProperties51);
            shape14.Append(textBody14);

            alternateContentFallback26.Append(shape14);

            alternateContent27.Append(alternateContentChoice27);
            alternateContent27.Append(alternateContentFallback26);
            Xdr.ClientData clientData28 = new Xdr.ClientData();

            twoCellAnchor28.Append(fromMarker28);
            twoCellAnchor28.Append(toMarker28);
            twoCellAnchor28.Append(alternateContent27);
            twoCellAnchor28.Append(clientData28);

            worksheetDrawing7.Append(twoCellAnchor25);
            worksheetDrawing7.Append(twoCellAnchor26);
            worksheetDrawing7.Append(twoCellAnchor27);
            worksheetDrawing7.Append(twoCellAnchor28);

            drawingsPart7.WorksheetDrawing = worksheetDrawing7;
        }
コード例 #8
0
        // Generates content of drawingsPart6.
        private void GenerateDrawingsPart6Content(DrawingsPart drawingsPart6)
        {
            Xdr.WorksheetDrawing worksheetDrawing6 = new Xdr.WorksheetDrawing();
            worksheetDrawing6.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing6.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor21 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker21 = new Xdr.FromMarker();
            Xdr.ColumnId columnId41 = new Xdr.ColumnId();
            columnId41.Text = "2";
            Xdr.ColumnOffset columnOffset41 = new Xdr.ColumnOffset();
            columnOffset41.Text = "185737";
            Xdr.RowId rowId41 = new Xdr.RowId();
            rowId41.Text = "0";
            Xdr.RowOffset rowOffset41 = new Xdr.RowOffset();
            rowOffset41.Text = "0";

            fromMarker21.Append(columnId41);
            fromMarker21.Append(columnOffset41);
            fromMarker21.Append(rowId41);
            fromMarker21.Append(rowOffset41);

            Xdr.ToMarker toMarker21 = new Xdr.ToMarker();
            Xdr.ColumnId columnId42 = new Xdr.ColumnId();
            columnId42.Text = "9";
            Xdr.ColumnOffset columnOffset42 = new Xdr.ColumnOffset();
            columnOffset42.Text = "90487";
            Xdr.RowId rowId42 = new Xdr.RowId();
            rowId42.Text = "14";
            Xdr.RowOffset rowOffset42 = new Xdr.RowOffset();
            rowOffset42.Text = "76200";

            toMarker21.Append(columnId42);
            toMarker21.Append(columnOffset42);
            toMarker21.Append(rowId42);
            toMarker21.Append(rowOffset42);

            Xdr.GraphicFrame graphicFrame21 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties21 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties31 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties21 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks9 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties21.Append(graphicFrameLocks9);

            nonVisualGraphicFrameProperties21.Append(nonVisualDrawingProperties31);
            nonVisualGraphicFrameProperties21.Append(nonVisualGraphicFrameDrawingProperties21);

            Xdr.Transform transform21 = new Xdr.Transform();
            A.Offset offset31 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents31 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform21.Append(offset31);
            transform21.Append(extents31);

            A.Graphic graphic21 = new A.Graphic();

            A.GraphicData graphicData21 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference11 = new C.ChartReference(){ Id = "rId1" };
            chartReference11.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference11.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData21.Append(chartReference11);

            graphic21.Append(graphicData21);

            graphicFrame21.Append(nonVisualGraphicFrameProperties21);
            graphicFrame21.Append(transform21);
            graphicFrame21.Append(graphic21);
            Xdr.ClientData clientData21 = new Xdr.ClientData();

            twoCellAnchor21.Append(fromMarker21);
            twoCellAnchor21.Append(toMarker21);
            twoCellAnchor21.Append(graphicFrame21);
            twoCellAnchor21.Append(clientData21);

            Xdr.TwoCellAnchor twoCellAnchor22 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker22 = new Xdr.FromMarker();
            Xdr.ColumnId columnId43 = new Xdr.ColumnId();
            columnId43.Text = "2";
            Xdr.ColumnOffset columnOffset43 = new Xdr.ColumnOffset();
            columnOffset43.Text = "200025";
            Xdr.RowId rowId43 = new Xdr.RowId();
            rowId43.Text = "14";
            Xdr.RowOffset rowOffset43 = new Xdr.RowOffset();
            rowOffset43.Text = "147637";

            fromMarker22.Append(columnId43);
            fromMarker22.Append(columnOffset43);
            fromMarker22.Append(rowId43);
            fromMarker22.Append(rowOffset43);

            Xdr.ToMarker toMarker22 = new Xdr.ToMarker();
            Xdr.ColumnId columnId44 = new Xdr.ColumnId();
            columnId44.Text = "7";
            Xdr.ColumnOffset columnOffset44 = new Xdr.ColumnOffset();
            columnOffset44.Text = "476250";
            Xdr.RowId rowId44 = new Xdr.RowId();
            rowId44.Text = "29";
            Xdr.RowOffset rowOffset44 = new Xdr.RowOffset();
            rowOffset44.Text = "33337";

            toMarker22.Append(columnId44);
            toMarker22.Append(columnOffset44);
            toMarker22.Append(rowId44);
            toMarker22.Append(rowOffset44);

            Xdr.GraphicFrame graphicFrame22 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties22 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties32 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties22 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks10 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties22.Append(graphicFrameLocks10);

            nonVisualGraphicFrameProperties22.Append(nonVisualDrawingProperties32);
            nonVisualGraphicFrameProperties22.Append(nonVisualGraphicFrameDrawingProperties22);

            Xdr.Transform transform22 = new Xdr.Transform();
            A.Offset offset32 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents32 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform22.Append(offset32);
            transform22.Append(extents32);

            A.Graphic graphic22 = new A.Graphic();

            A.GraphicData graphicData22 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference12 = new C.ChartReference(){ Id = "rId2" };
            chartReference12.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference12.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData22.Append(chartReference12);

            graphic22.Append(graphicData22);

            graphicFrame22.Append(nonVisualGraphicFrameProperties22);
            graphicFrame22.Append(transform22);
            graphicFrame22.Append(graphic22);
            Xdr.ClientData clientData22 = new Xdr.ClientData();

            twoCellAnchor22.Append(fromMarker22);
            twoCellAnchor22.Append(toMarker22);
            twoCellAnchor22.Append(graphicFrame22);
            twoCellAnchor22.Append(clientData22);

            Xdr.TwoCellAnchor twoCellAnchor23 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker23 = new Xdr.FromMarker();
            Xdr.ColumnId columnId45 = new Xdr.ColumnId();
            columnId45.Text = "10";
            Xdr.ColumnOffset columnOffset45 = new Xdr.ColumnOffset();
            columnOffset45.Text = "38100";
            Xdr.RowId rowId45 = new Xdr.RowId();
            rowId45.Text = "1";
            Xdr.RowOffset rowOffset45 = new Xdr.RowOffset();
            rowOffset45.Text = "0";

            fromMarker23.Append(columnId45);
            fromMarker23.Append(columnOffset45);
            fromMarker23.Append(rowId45);
            fromMarker23.Append(rowOffset45);

            Xdr.ToMarker toMarker23 = new Xdr.ToMarker();
            Xdr.ColumnId columnId46 = new Xdr.ColumnId();
            columnId46.Text = "13";
            Xdr.ColumnOffset columnOffset46 = new Xdr.ColumnOffset();
            columnOffset46.Text = "771525";
            Xdr.RowId rowId46 = new Xdr.RowId();
            rowId46.Text = "7";
            Xdr.RowOffset rowOffset46 = new Xdr.RowOffset();
            rowOffset46.Text = "47625";

            toMarker23.Append(columnId46);
            toMarker23.Append(columnOffset46);
            toMarker23.Append(rowId46);
            toMarker23.Append(rowOffset46);

            AlternateContent alternateContent22 = new AlternateContent();
            alternateContent22.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent22.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice22 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame23 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties23 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties33 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 4" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties23 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties23.Append(nonVisualDrawingProperties33);
            nonVisualGraphicFrameProperties23.Append(nonVisualGraphicFrameDrawingProperties23);

            Xdr.Transform transform23 = new Xdr.Transform();
            A.Offset offset33 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents33 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform23.Append(offset33);
            transform23.Append(extents33);

            A.Graphic graphic23 = new A.Graphic();

            A.GraphicData graphicData23 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer11 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 4" };
            timeSlicer11.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData23.Append(timeSlicer11);

            graphic23.Append(graphicData23);

            graphicFrame23.Append(nonVisualGraphicFrameProperties23);
            graphicFrame23.Append(transform23);
            graphicFrame23.Append(graphic23);

            alternateContentChoice22.Append(graphicFrame23);

            AlternateContentFallback alternateContentFallback21 = new AlternateContentFallback();
            alternateContentFallback21.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback21.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape11 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties11 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties34 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties11 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks11 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties11.Append(shapeLocks11);

            nonVisualShapeProperties11.Append(nonVisualDrawingProperties34);
            nonVisualShapeProperties11.Append(nonVisualShapeDrawingProperties11);

            Xdr.ShapeProperties shapeProperties43 = new Xdr.ShapeProperties();

            A.Transform2D transform2D11 = new A.Transform2D();
            A.Offset offset34 = new A.Offset(){ X = 8639175L, Y = 190500L };
            A.Extents extents34 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D11.Append(offset34);
            transform2D11.Append(extents34);

            A.PresetGeometry presetGeometry11 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList11 = new A.AdjustValueList();

            presetGeometry11.Append(adjustValueList11);

            A.SolidFill solidFill77 = new A.SolidFill();
            A.PresetColor presetColor21 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill77.Append(presetColor21);

            A.Outline outline63 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill78 = new A.SolidFill();
            A.PresetColor presetColor22 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill78.Append(presetColor22);

            outline63.Append(solidFill78);

            shapeProperties43.Append(transform2D11);
            shapeProperties43.Append(presetGeometry11);
            shapeProperties43.Append(solidFill77);
            shapeProperties43.Append(outline63);

            Xdr.TextBody textBody11 = new Xdr.TextBody();
            A.BodyProperties bodyProperties27 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle27 = new A.ListStyle();

            A.Paragraph paragraph27 = new A.Paragraph();

            A.Run run11 = new A.Run();
            A.RunProperties runProperties11 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text49 = new A.Text();
            text49.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run11.Append(runProperties11);
            run11.Append(text49);

            paragraph27.Append(run11);

            textBody11.Append(bodyProperties27);
            textBody11.Append(listStyle27);
            textBody11.Append(paragraph27);

            shape11.Append(nonVisualShapeProperties11);
            shape11.Append(shapeProperties43);
            shape11.Append(textBody11);

            alternateContentFallback21.Append(shape11);

            alternateContent22.Append(alternateContentChoice22);
            alternateContent22.Append(alternateContentFallback21);
            Xdr.ClientData clientData23 = new Xdr.ClientData();

            twoCellAnchor23.Append(fromMarker23);
            twoCellAnchor23.Append(toMarker23);
            twoCellAnchor23.Append(alternateContent22);
            twoCellAnchor23.Append(clientData23);

            Xdr.TwoCellAnchor twoCellAnchor24 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker24 = new Xdr.FromMarker();
            Xdr.ColumnId columnId47 = new Xdr.ColumnId();
            columnId47.Text = "10";
            Xdr.ColumnOffset columnOffset47 = new Xdr.ColumnOffset();
            columnOffset47.Text = "47625";
            Xdr.RowId rowId47 = new Xdr.RowId();
            rowId47.Text = "8";
            Xdr.RowOffset rowOffset47 = new Xdr.RowOffset();
            rowOffset47.Text = "85725";

            fromMarker24.Append(columnId47);
            fromMarker24.Append(columnOffset47);
            fromMarker24.Append(rowId47);
            fromMarker24.Append(rowOffset47);

            Xdr.ToMarker toMarker24 = new Xdr.ToMarker();
            Xdr.ColumnId columnId48 = new Xdr.ColumnId();
            columnId48.Text = "13";
            Xdr.ColumnOffset columnOffset48 = new Xdr.ColumnOffset();
            columnOffset48.Text = "781050";
            Xdr.RowId rowId48 = new Xdr.RowId();
            rowId48.Text = "14";
            Xdr.RowOffset rowOffset48 = new Xdr.RowOffset();
            rowOffset48.Text = "133350";

            toMarker24.Append(columnId48);
            toMarker24.Append(columnOffset48);
            toMarker24.Append(rowId48);
            toMarker24.Append(rowOffset48);

            AlternateContent alternateContent23 = new AlternateContent();
            alternateContent23.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent23.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice23 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame24 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties24 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties35 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 5" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties24 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties24.Append(nonVisualDrawingProperties35);
            nonVisualGraphicFrameProperties24.Append(nonVisualGraphicFrameDrawingProperties24);

            Xdr.Transform transform24 = new Xdr.Transform();
            A.Offset offset35 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents35 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform24.Append(offset35);
            transform24.Append(extents35);

            A.Graphic graphic24 = new A.Graphic();

            A.GraphicData graphicData24 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer12 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 5" };
            timeSlicer12.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData24.Append(timeSlicer12);

            graphic24.Append(graphicData24);

            graphicFrame24.Append(nonVisualGraphicFrameProperties24);
            graphicFrame24.Append(transform24);
            graphicFrame24.Append(graphic24);

            alternateContentChoice23.Append(graphicFrame24);

            AlternateContentFallback alternateContentFallback22 = new AlternateContentFallback();
            alternateContentFallback22.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback22.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape12 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties12 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties36 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties12 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks12 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties12.Append(shapeLocks12);

            nonVisualShapeProperties12.Append(nonVisualDrawingProperties36);
            nonVisualShapeProperties12.Append(nonVisualShapeDrawingProperties12);

            Xdr.ShapeProperties shapeProperties44 = new Xdr.ShapeProperties();

            A.Transform2D transform2D12 = new A.Transform2D();
            A.Offset offset36 = new A.Offset(){ X = 8648700L, Y = 1609725L };
            A.Extents extents36 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D12.Append(offset36);
            transform2D12.Append(extents36);

            A.PresetGeometry presetGeometry12 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList12 = new A.AdjustValueList();

            presetGeometry12.Append(adjustValueList12);

            A.SolidFill solidFill79 = new A.SolidFill();
            A.PresetColor presetColor23 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill79.Append(presetColor23);

            A.Outline outline64 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill80 = new A.SolidFill();
            A.PresetColor presetColor24 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill80.Append(presetColor24);

            outline64.Append(solidFill80);

            shapeProperties44.Append(transform2D12);
            shapeProperties44.Append(presetGeometry12);
            shapeProperties44.Append(solidFill79);
            shapeProperties44.Append(outline64);

            Xdr.TextBody textBody12 = new Xdr.TextBody();
            A.BodyProperties bodyProperties28 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle28 = new A.ListStyle();

            A.Paragraph paragraph28 = new A.Paragraph();

            A.Run run12 = new A.Run();
            A.RunProperties runProperties12 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text50 = new A.Text();
            text50.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run12.Append(runProperties12);
            run12.Append(text50);

            paragraph28.Append(run12);

            textBody12.Append(bodyProperties28);
            textBody12.Append(listStyle28);
            textBody12.Append(paragraph28);

            shape12.Append(nonVisualShapeProperties12);
            shape12.Append(shapeProperties44);
            shape12.Append(textBody12);

            alternateContentFallback22.Append(shape12);

            alternateContent23.Append(alternateContentChoice23);
            alternateContent23.Append(alternateContentFallback22);
            Xdr.ClientData clientData24 = new Xdr.ClientData();

            twoCellAnchor24.Append(fromMarker24);
            twoCellAnchor24.Append(toMarker24);
            twoCellAnchor24.Append(alternateContent23);
            twoCellAnchor24.Append(clientData24);

            worksheetDrawing6.Append(twoCellAnchor21);
            worksheetDrawing6.Append(twoCellAnchor22);
            worksheetDrawing6.Append(twoCellAnchor23);
            worksheetDrawing6.Append(twoCellAnchor24);

            drawingsPart6.WorksheetDrawing = worksheetDrawing6;
        }
コード例 #9
0
        // Generates content of drawingsPart5.
        private void GenerateDrawingsPart5Content(DrawingsPart drawingsPart5)
        {
            Xdr.WorksheetDrawing worksheetDrawing5 = new Xdr.WorksheetDrawing();
            worksheetDrawing5.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing5.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

            Xdr.TwoCellAnchor twoCellAnchor17 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker17 = new Xdr.FromMarker();
            Xdr.ColumnId columnId33 = new Xdr.ColumnId();
            columnId33.Text = "2";
            Xdr.ColumnOffset columnOffset33 = new Xdr.ColumnOffset();
            columnOffset33.Text = "185737";
            Xdr.RowId rowId33 = new Xdr.RowId();
            rowId33.Text = "0";
            Xdr.RowOffset rowOffset33 = new Xdr.RowOffset();
            rowOffset33.Text = "0";

            fromMarker17.Append(columnId33);
            fromMarker17.Append(columnOffset33);
            fromMarker17.Append(rowId33);
            fromMarker17.Append(rowOffset33);

            Xdr.ToMarker toMarker17 = new Xdr.ToMarker();
            Xdr.ColumnId columnId34 = new Xdr.ColumnId();
            columnId34.Text = "9";
            Xdr.ColumnOffset columnOffset34 = new Xdr.ColumnOffset();
            columnOffset34.Text = "90487";
            Xdr.RowId rowId34 = new Xdr.RowId();
            rowId34.Text = "14";
            Xdr.RowOffset rowOffset34 = new Xdr.RowOffset();
            rowOffset34.Text = "76200";

            toMarker17.Append(columnId34);
            toMarker17.Append(columnOffset34);
            toMarker17.Append(rowId34);
            toMarker17.Append(rowOffset34);

            Xdr.GraphicFrame graphicFrame17 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties17 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties25 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Chart 1" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties17 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks7 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties17.Append(graphicFrameLocks7);

            nonVisualGraphicFrameProperties17.Append(nonVisualDrawingProperties25);
            nonVisualGraphicFrameProperties17.Append(nonVisualGraphicFrameDrawingProperties17);

            Xdr.Transform transform17 = new Xdr.Transform();
            A.Offset offset25 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents25 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform17.Append(offset25);
            transform17.Append(extents25);

            A.Graphic graphic17 = new A.Graphic();

            A.GraphicData graphicData17 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference9 = new C.ChartReference(){ Id = "rId1" };
            chartReference9.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference9.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData17.Append(chartReference9);

            graphic17.Append(graphicData17);

            graphicFrame17.Append(nonVisualGraphicFrameProperties17);
            graphicFrame17.Append(transform17);
            graphicFrame17.Append(graphic17);
            Xdr.ClientData clientData17 = new Xdr.ClientData();

            twoCellAnchor17.Append(fromMarker17);
            twoCellAnchor17.Append(toMarker17);
            twoCellAnchor17.Append(graphicFrame17);
            twoCellAnchor17.Append(clientData17);

            Xdr.TwoCellAnchor twoCellAnchor18 = new Xdr.TwoCellAnchor();

            Xdr.FromMarker fromMarker18 = new Xdr.FromMarker();
            Xdr.ColumnId columnId35 = new Xdr.ColumnId();
            columnId35.Text = "2";
            Xdr.ColumnOffset columnOffset35 = new Xdr.ColumnOffset();
            columnOffset35.Text = "200025";
            Xdr.RowId rowId35 = new Xdr.RowId();
            rowId35.Text = "14";
            Xdr.RowOffset rowOffset35 = new Xdr.RowOffset();
            rowOffset35.Text = "147637";

            fromMarker18.Append(columnId35);
            fromMarker18.Append(columnOffset35);
            fromMarker18.Append(rowId35);
            fromMarker18.Append(rowOffset35);

            Xdr.ToMarker toMarker18 = new Xdr.ToMarker();
            Xdr.ColumnId columnId36 = new Xdr.ColumnId();
            columnId36.Text = "7";
            Xdr.ColumnOffset columnOffset36 = new Xdr.ColumnOffset();
            columnOffset36.Text = "476250";
            Xdr.RowId rowId36 = new Xdr.RowId();
            rowId36.Text = "29";
            Xdr.RowOffset rowOffset36 = new Xdr.RowOffset();
            rowOffset36.Text = "33337";

            toMarker18.Append(columnId36);
            toMarker18.Append(columnOffset36);
            toMarker18.Append(rowId36);
            toMarker18.Append(rowOffset36);

            Xdr.GraphicFrame graphicFrame18 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties18 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties26 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "グラフ 2" };

            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties18 = new Xdr.NonVisualGraphicFrameDrawingProperties();
            A.GraphicFrameLocks graphicFrameLocks8 = new A.GraphicFrameLocks();

            nonVisualGraphicFrameDrawingProperties18.Append(graphicFrameLocks8);

            nonVisualGraphicFrameProperties18.Append(nonVisualDrawingProperties26);
            nonVisualGraphicFrameProperties18.Append(nonVisualGraphicFrameDrawingProperties18);

            Xdr.Transform transform18 = new Xdr.Transform();
            A.Offset offset26 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents26 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform18.Append(offset26);
            transform18.Append(extents26);

            A.Graphic graphic18 = new A.Graphic();

            A.GraphicData graphicData18 = new A.GraphicData(){ Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart" };

            C.ChartReference chartReference10 = new C.ChartReference(){ Id = "rId2" };
            chartReference10.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
            chartReference10.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData18.Append(chartReference10);

            graphic18.Append(graphicData18);

            graphicFrame18.Append(nonVisualGraphicFrameProperties18);
            graphicFrame18.Append(transform18);
            graphicFrame18.Append(graphic18);
            Xdr.ClientData clientData18 = new Xdr.ClientData();

            twoCellAnchor18.Append(fromMarker18);
            twoCellAnchor18.Append(toMarker18);
            twoCellAnchor18.Append(graphicFrame18);
            twoCellAnchor18.Append(clientData18);

            Xdr.TwoCellAnchor twoCellAnchor19 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker19 = new Xdr.FromMarker();
            Xdr.ColumnId columnId37 = new Xdr.ColumnId();
            columnId37.Text = "10";
            Xdr.ColumnOffset columnOffset37 = new Xdr.ColumnOffset();
            columnOffset37.Text = "19050";
            Xdr.RowId rowId37 = new Xdr.RowId();
            rowId37.Text = "1";
            Xdr.RowOffset rowOffset37 = new Xdr.RowOffset();
            rowOffset37.Text = "19050";

            fromMarker19.Append(columnId37);
            fromMarker19.Append(columnOffset37);
            fromMarker19.Append(rowId37);
            fromMarker19.Append(rowOffset37);

            Xdr.ToMarker toMarker19 = new Xdr.ToMarker();
            Xdr.ColumnId columnId38 = new Xdr.ColumnId();
            columnId38.Text = "13";
            Xdr.ColumnOffset columnOffset38 = new Xdr.ColumnOffset();
            columnOffset38.Text = "752475";
            Xdr.RowId rowId38 = new Xdr.RowId();
            rowId38.Text = "7";
            Xdr.RowOffset rowOffset38 = new Xdr.RowOffset();
            rowOffset38.Text = "66675";

            toMarker19.Append(columnId38);
            toMarker19.Append(columnOffset38);
            toMarker19.Append(rowId38);
            toMarker19.Append(rowOffset38);

            AlternateContent alternateContent18 = new AlternateContent();
            alternateContent18.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent18.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice18 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame19 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties19 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties27 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)4U, Name = "DeliveryDate 16" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties19 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties19.Append(nonVisualDrawingProperties27);
            nonVisualGraphicFrameProperties19.Append(nonVisualGraphicFrameDrawingProperties19);

            Xdr.Transform transform19 = new Xdr.Transform();
            A.Offset offset27 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents27 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform19.Append(offset27);
            transform19.Append(extents27);

            A.Graphic graphic19 = new A.Graphic();

            A.GraphicData graphicData19 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer9 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 16" };
            timeSlicer9.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData19.Append(timeSlicer9);

            graphic19.Append(graphicData19);

            graphicFrame19.Append(nonVisualGraphicFrameProperties19);
            graphicFrame19.Append(transform19);
            graphicFrame19.Append(graphic19);

            alternateContentChoice18.Append(graphicFrame19);

            AlternateContentFallback alternateContentFallback17 = new AlternateContentFallback();
            alternateContentFallback17.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback17.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape9 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties9 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties28 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties9 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks9 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties9.Append(shapeLocks9);

            nonVisualShapeProperties9.Append(nonVisualDrawingProperties28);
            nonVisualShapeProperties9.Append(nonVisualShapeDrawingProperties9);

            Xdr.ShapeProperties shapeProperties30 = new Xdr.ShapeProperties();

            A.Transform2D transform2D9 = new A.Transform2D();
            A.Offset offset28 = new A.Offset(){ X = 8620125L, Y = 209550L };
            A.Extents extents28 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D9.Append(offset28);
            transform2D9.Append(extents28);

            A.PresetGeometry presetGeometry9 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList9 = new A.AdjustValueList();

            presetGeometry9.Append(adjustValueList9);

            A.SolidFill solidFill56 = new A.SolidFill();
            A.PresetColor presetColor17 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill56.Append(presetColor17);

            A.Outline outline45 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill57 = new A.SolidFill();
            A.PresetColor presetColor18 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill57.Append(presetColor18);

            outline45.Append(solidFill57);

            shapeProperties30.Append(transform2D9);
            shapeProperties30.Append(presetGeometry9);
            shapeProperties30.Append(solidFill56);
            shapeProperties30.Append(outline45);

            Xdr.TextBody textBody9 = new Xdr.TextBody();
            A.BodyProperties bodyProperties21 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle21 = new A.ListStyle();

            A.Paragraph paragraph21 = new A.Paragraph();

            A.Run run9 = new A.Run();
            A.RunProperties runProperties9 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text47 = new A.Text();
            text47.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run9.Append(runProperties9);
            run9.Append(text47);

            paragraph21.Append(run9);

            textBody9.Append(bodyProperties21);
            textBody9.Append(listStyle21);
            textBody9.Append(paragraph21);

            shape9.Append(nonVisualShapeProperties9);
            shape9.Append(shapeProperties30);
            shape9.Append(textBody9);

            alternateContentFallback17.Append(shape9);

            alternateContent18.Append(alternateContentChoice18);
            alternateContent18.Append(alternateContentFallback17);
            Xdr.ClientData clientData19 = new Xdr.ClientData();

            twoCellAnchor19.Append(fromMarker19);
            twoCellAnchor19.Append(toMarker19);
            twoCellAnchor19.Append(alternateContent18);
            twoCellAnchor19.Append(clientData19);

            Xdr.TwoCellAnchor twoCellAnchor20 = new Xdr.TwoCellAnchor(){ EditAs = Xdr.EditAsValues.OneCell };

            Xdr.FromMarker fromMarker20 = new Xdr.FromMarker();
            Xdr.ColumnId columnId39 = new Xdr.ColumnId();
            columnId39.Text = "10";
            Xdr.ColumnOffset columnOffset39 = new Xdr.ColumnOffset();
            columnOffset39.Text = "9525";
            Xdr.RowId rowId39 = new Xdr.RowId();
            rowId39.Text = "9";
            Xdr.RowOffset rowOffset39 = new Xdr.RowOffset();
            rowOffset39.Text = "19050";

            fromMarker20.Append(columnId39);
            fromMarker20.Append(columnOffset39);
            fromMarker20.Append(rowId39);
            fromMarker20.Append(rowOffset39);

            Xdr.ToMarker toMarker20 = new Xdr.ToMarker();
            Xdr.ColumnId columnId40 = new Xdr.ColumnId();
            columnId40.Text = "13";
            Xdr.ColumnOffset columnOffset40 = new Xdr.ColumnOffset();
            columnOffset40.Text = "742950";
            Xdr.RowId rowId40 = new Xdr.RowId();
            rowId40.Text = "15";
            Xdr.RowOffset rowOffset40 = new Xdr.RowOffset();
            rowOffset40.Text = "66675";

            toMarker20.Append(columnId40);
            toMarker20.Append(columnOffset40);
            toMarker20.Append(rowId40);
            toMarker20.Append(rowOffset40);

            AlternateContent alternateContent19 = new AlternateContent();
            alternateContent19.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
            alternateContent19.AddNamespaceDeclaration("a15", "http://schemas.microsoft.com/office/drawing/2012/main");

            AlternateContentChoice alternateContentChoice19 = new AlternateContentChoice(){ Requires = "a15" };

            Xdr.GraphicFrame graphicFrame20 = new Xdr.GraphicFrame(){ Macro = "" };

            Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties20 = new Xdr.NonVisualGraphicFrameProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties29 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)5U, Name = "DeliveryDate 17" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties20 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            nonVisualGraphicFrameProperties20.Append(nonVisualDrawingProperties29);
            nonVisualGraphicFrameProperties20.Append(nonVisualGraphicFrameDrawingProperties20);

            Xdr.Transform transform20 = new Xdr.Transform();
            A.Offset offset29 = new A.Offset(){ X = 0L, Y = 0L };
            A.Extents extents29 = new A.Extents(){ Cx = 0L, Cy = 0L };

            transform20.Append(offset29);
            transform20.Append(extents29);

            A.Graphic graphic20 = new A.Graphic();

            A.GraphicData graphicData20 = new A.GraphicData(){ Uri = "http://schemas.microsoft.com/office/drawing/2012/timeslicer" };

            Tsle.TimeSlicer timeSlicer10 = new Tsle.TimeSlicer(){ Name = "DeliveryDate 17" };
            timeSlicer10.AddNamespaceDeclaration("tsle", "http://schemas.microsoft.com/office/drawing/2012/timeslicer");

            graphicData20.Append(timeSlicer10);

            graphic20.Append(graphicData20);

            graphicFrame20.Append(nonVisualGraphicFrameProperties20);
            graphicFrame20.Append(transform20);
            graphicFrame20.Append(graphic20);

            alternateContentChoice19.Append(graphicFrame20);

            AlternateContentFallback alternateContentFallback18 = new AlternateContentFallback();
            alternateContentFallback18.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            alternateContentFallback18.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");

            Xdr.Shape shape10 = new Xdr.Shape(){ Macro = "", TextLink = "" };

            Xdr.NonVisualShapeProperties nonVisualShapeProperties10 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties30 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)0U, Name = "" };

            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties10 = new Xdr.NonVisualShapeDrawingProperties();
            A.ShapeLocks shapeLocks10 = new A.ShapeLocks(){ NoTextEdit = true };

            nonVisualShapeDrawingProperties10.Append(shapeLocks10);

            nonVisualShapeProperties10.Append(nonVisualDrawingProperties30);
            nonVisualShapeProperties10.Append(nonVisualShapeDrawingProperties10);

            Xdr.ShapeProperties shapeProperties31 = new Xdr.ShapeProperties();

            A.Transform2D transform2D10 = new A.Transform2D();
            A.Offset offset30 = new A.Offset(){ X = 8610600L, Y = 1733550L };
            A.Extents extents30 = new A.Extents(){ Cx = 3333750L, Cy = 1190625L };

            transform2D10.Append(offset30);
            transform2D10.Append(extents30);

            A.PresetGeometry presetGeometry10 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle };
            A.AdjustValueList adjustValueList10 = new A.AdjustValueList();

            presetGeometry10.Append(adjustValueList10);

            A.SolidFill solidFill58 = new A.SolidFill();
            A.PresetColor presetColor19 = new A.PresetColor(){ Val = A.PresetColorValues.White };

            solidFill58.Append(presetColor19);

            A.Outline outline46 = new A.Outline(){ Width = 1 };

            A.SolidFill solidFill59 = new A.SolidFill();
            A.PresetColor presetColor20 = new A.PresetColor(){ Val = A.PresetColorValues.Green };

            solidFill59.Append(presetColor20);

            outline46.Append(solidFill59);

            shapeProperties31.Append(transform2D10);
            shapeProperties31.Append(presetGeometry10);
            shapeProperties31.Append(solidFill58);
            shapeProperties31.Append(outline46);

            Xdr.TextBody textBody10 = new Xdr.TextBody();
            A.BodyProperties bodyProperties22 = new A.BodyProperties(){ VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip };
            A.ListStyle listStyle22 = new A.ListStyle();

            A.Paragraph paragraph22 = new A.Paragraph();

            A.Run run10 = new A.Run();
            A.RunProperties runProperties10 = new A.RunProperties(){ Language = "en-US", FontSize = 1100 };
            A.Text text48 = new A.Text();
            text48.Text = "Timeline: Works in Excel 15 or higher. Do not move or resize.";

            run10.Append(runProperties10);
            run10.Append(text48);

            paragraph22.Append(run10);

            textBody10.Append(bodyProperties22);
            textBody10.Append(listStyle22);
            textBody10.Append(paragraph22);

            shape10.Append(nonVisualShapeProperties10);
            shape10.Append(shapeProperties31);
            shape10.Append(textBody10);

            alternateContentFallback18.Append(shape10);

            alternateContent19.Append(alternateContentChoice19);
            alternateContent19.Append(alternateContentFallback18);
            Xdr.ClientData clientData20 = new Xdr.ClientData();

            twoCellAnchor20.Append(fromMarker20);
            twoCellAnchor20.Append(toMarker20);
            twoCellAnchor20.Append(alternateContent19);
            twoCellAnchor20.Append(clientData20);

            worksheetDrawing5.Append(twoCellAnchor17);
            worksheetDrawing5.Append(twoCellAnchor18);
            worksheetDrawing5.Append(twoCellAnchor19);
            worksheetDrawing5.Append(twoCellAnchor20);

            drawingsPart5.WorksheetDrawing = worksheetDrawing5;
        }