public static xdr.ShapeStyle InitDefault(this xdr.ShapeStyle shapeStyle)
        {
            var lineReference1 = new a.LineReference()
            {
                Index = 0U
            };

            shapeStyle.Append(lineReference1);

            var rgbColorModelPercentage1 = new a.RgbColorModelPercentage()
            {
                RedPortion = 0, GreenPortion = 0, BluePortion = 0
            };

            lineReference1.Append(rgbColorModelPercentage1);

            var fillReference1 = new a.FillReference()
            {
                Index = 0U
            };

            shapeStyle.Append(fillReference1);

            var rgbColorModelPercentage2 = new a.RgbColorModelPercentage()
            {
                RedPortion = 0, GreenPortion = 0, BluePortion = 0
            };

            fillReference1.Append(rgbColorModelPercentage2);

            var effectReference1 = new a.EffectReference()
            {
                Index = 0U
            };

            shapeStyle.Append(effectReference1);

            var rgbColorModelPercentage3 = new a.RgbColorModelPercentage()
            {
                RedPortion = 0, GreenPortion = 0, BluePortion = 0
            };

            effectReference1.Append(rgbColorModelPercentage3);

            var fontReference1 = new a.FontReference()
            {
                Index = a.FontCollectionIndexValues.Major
            };

            shapeStyle.Append(fontReference1);

            return(shapeStyle);
        }
Beispiel #2
0
        protected virtual void InitDrawingsPart(int logoToMarkerColOffset  = 824661,
                                                int titleFromMarkerColumn  = 7,
                                                int titleToMarkerColumn    = 9,
                                                int titleToMarkerColOffset = 285450)
        {
            Xdr.WorksheetDrawing worksheetDrawing = new Xdr.WorksheetDrawing();
            worksheetDrawing.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
            worksheetDrawing.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");

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

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

            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 = "2";
            Xdr.ColumnOffset columnOffset2 = new Xdr.ColumnOffset();
            columnOffset2.Text = logoToMarkerColOffset.ToString();
            Xdr.RowId rowId2 = new Xdr.RowId();
            rowId2.Text = "2";
            Xdr.RowOffset rowOffset2 = new Xdr.RowOffset();
            rowOffset2.Text = "126030";

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

            Xdr.Picture picture1 = new Xdr.Picture();

            Xdr.NonVisualPictureProperties nonVisualPictureProperties1 = new Xdr.NonVisualPictureProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties1 = new Xdr.NonVisualDrawingProperties()
            {
                Id = (UInt32Value)4U, Name = "Picture 3"
            };

            Xdr.NonVisualPictureDrawingProperties nonVisualPictureDrawingProperties1 = new Xdr.NonVisualPictureDrawingProperties();
            A.PictureLocks pictureLocks1 = new A.PictureLocks()
            {
                NoChangeAspect = true
            };

            nonVisualPictureDrawingProperties1.Append(pictureLocks1);

            nonVisualPictureProperties1.Append(nonVisualDrawingProperties1);
            nonVisualPictureProperties1.Append(nonVisualPictureDrawingProperties1);

            Xdr.BlipFill blipFill1 = new Xdr.BlipFill()
            {
                RotateWithShape = true
            };

            A.Blip blip1 = new A.Blip()
            {
                Embed = "rId1"
            };
            blip1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
            A.SourceRectangle sourceRectangle1 = new A.SourceRectangle()
            {
                Top = 32250, Bottom = 34913
            };
            A.Stretch stretch1 = new A.Stretch();

            blipFill1.Append(blip1);
            blipFill1.Append(sourceRectangle1);
            blipFill1.Append(stretch1);

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

            A.Transform2D transform2D1 = new A.Transform2D();
            A.Offset      offset1      = new A.Offset()
            {
                X = 0L, Y = 82404L
            };
            A.Extents extents1 = new A.Extents()
            {
                Cx = 1827961L, Cy = 450026L
            };

            transform2D1.Append(offset1);
            transform2D1.Append(extents1);

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

            presetGeometry1.Append(adjustValueList1);

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

            picture1.Append(nonVisualPictureProperties1);
            picture1.Append(blipFill1);
            picture1.Append(shapeProperties1);
            Xdr.ClientData clientData1 = new Xdr.ClientData();

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

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

            Xdr.FromMarker fromMarker2 = new Xdr.FromMarker();
            Xdr.ColumnId   columnId3   = new Xdr.ColumnId();
            columnId3.Text = titleFromMarkerColumn.ToString();
            Xdr.ColumnOffset columnOffset3 = new Xdr.ColumnOffset();
            columnOffset3.Text = "685800";
            Xdr.RowId rowId3 = new Xdr.RowId();
            rowId3.Text = "0";
            Xdr.RowOffset rowOffset3 = new Xdr.RowOffset();
            rowOffset3.Text = "114300";

            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 = titleToMarkerColumn.ToString();
            Xdr.ColumnOffset columnOffset4 = new Xdr.ColumnOffset();
            columnOffset4.Text = titleToMarkerColOffset.ToString();
            Xdr.RowId rowId4 = new Xdr.RowId();
            rowId4.Text = "2";
            Xdr.RowOffset rowOffset4 = new Xdr.RowOffset();
            rowOffset4.Text = "88900";

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

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

            Xdr.NonVisualShapeProperties   nonVisualShapeProperties1   = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties2 = new Xdr.NonVisualDrawingProperties()
            {
                Id = (UInt32Value)8U, Name = "TextBox 7"
            };
            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties1 = new Xdr.NonVisualShapeDrawingProperties()
            {
                TextBox = true
            };

            nonVisualShapeProperties1.Append(nonVisualDrawingProperties2);
            nonVisualShapeProperties1.Append(nonVisualShapeDrawingProperties1);

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

            A.Transform2D transform2D2 = new A.Transform2D();
            A.Offset      offset2      = new A.Offset()
            {
                X = 6769100L, Y = 114300L
            };
            A.Extents extents2 = new A.Extents()
            {
                Cx = 1631650L, Cy = 381000L
            };

            transform2D2.Append(offset2);
            transform2D2.Append(extents2);

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

            presetGeometry2.Append(adjustValueList2);

            A.SolidFill   solidFill1   = new A.SolidFill();
            A.SchemeColor schemeColor1 = new A.SchemeColor()
            {
                Val = A.SchemeColorValues.Text1
            };

            solidFill1.Append(schemeColor1);

            A.Outline outline1 = new A.Outline()
            {
                Width = 9525, CompoundLineType = A.CompoundLineValues.Single
            };
            A.NoFill noFill1 = new A.NoFill();

            outline1.Append(noFill1);

            shapeProperties2.Append(transform2D2);
            shapeProperties2.Append(presetGeometry2);
            shapeProperties2.Append(solidFill1);
            shapeProperties2.Append(outline1);

            Xdr.ShapeStyle shapeStyle1 = new Xdr.ShapeStyle();

            A.LineReference lineReference1 = new A.LineReference()
            {
                Index = (UInt32Value)0U
            };
            A.RgbColorModelPercentage rgbColorModelPercentage1 = new A.RgbColorModelPercentage()
            {
                RedPortion = 0, GreenPortion = 0, BluePortion = 0
            };

            lineReference1.Append(rgbColorModelPercentage1);

            A.FillReference fillReference1 = new A.FillReference()
            {
                Index = (UInt32Value)0U
            };
            A.RgbColorModelPercentage rgbColorModelPercentage2 = new A.RgbColorModelPercentage()
            {
                RedPortion = 0, GreenPortion = 0, BluePortion = 0
            };

            fillReference1.Append(rgbColorModelPercentage2);

            A.EffectReference effectReference1 = new A.EffectReference()
            {
                Index = (UInt32Value)0U
            };
            A.RgbColorModelPercentage rgbColorModelPercentage3 = new A.RgbColorModelPercentage()
            {
                RedPortion = 0, GreenPortion = 0, BluePortion = 0
            };

            effectReference1.Append(rgbColorModelPercentage3);

            A.FontReference fontReference1 = new A.FontReference()
            {
                Index = A.FontCollectionIndexValues.Minor
            };
            A.SchemeColor schemeColor2 = new A.SchemeColor()
            {
                Val = A.SchemeColorValues.Dark1
            };

            fontReference1.Append(schemeColor2);

            shapeStyle1.Append(lineReference1);
            shapeStyle1.Append(fillReference1);
            shapeStyle1.Append(effectReference1);
            shapeStyle1.Append(fontReference1);

            Xdr.TextBody     textBody1       = new Xdr.TextBody();
            A.BodyProperties bodyProperties1 = new A.BodyProperties()
            {
                VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip, Wrap = A.TextWrappingValues.Square, RightToLeftColumns = false, Anchor = A.TextAnchoringTypeValues.Center
            };
            A.ListStyle listStyle1 = new A.ListStyle();

            A.Paragraph           paragraph1           = new A.Paragraph();
            A.ParagraphProperties paragraphProperties1 = new A.ParagraphProperties()
            {
                Alignment = A.TextAlignmentTypeValues.Center
            };

            A.Run run1 = new A.Run();

            A.RunProperties runProperties1 = new A.RunProperties()
            {
                Language = "en-US", FontSize = 1600, Bold = true
            };

            A.SolidFill   solidFill2   = new A.SolidFill();
            A.SchemeColor schemeColor3 = new A.SchemeColor()
            {
                Val = A.SchemeColorValues.Background1
            };

            solidFill2.Append(schemeColor3);

            runProperties1.Append(solidFill2);
            A.Text text1 = new A.Text();
            text1.Text = "Deloitte Reveal";

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

            paragraph1.Append(paragraphProperties1);
            paragraph1.Append(run1);

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

            shape1.Append(nonVisualShapeProperties1);
            shape1.Append(shapeProperties2);
            shape1.Append(shapeStyle1);
            shape1.Append(textBody1);
            Xdr.ClientData clientData2 = new Xdr.ClientData();

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

            worksheetDrawing.Append(twoCellAnchor1);
            worksheetDrawing.Append(twoCellAnchor2);

            DrawingsPart.WorksheetDrawing = worksheetDrawing;
        }
        // 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 = "11";
            Xdr.ColumnOffset columnOffset1 = new Xdr.ColumnOffset();
            columnOffset1.Text = "47625";
            Xdr.RowId rowId1 = new Xdr.RowId();
            rowId1.Text = "12";
            Xdr.RowOffset rowOffset1 = new Xdr.RowOffset();
            rowOffset1.Text = "157162";

            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 = "18";
            Xdr.ColumnOffset columnOffset2 = new Xdr.ColumnOffset();
            columnOffset2.Text = "352425";
            Xdr.RowId rowId2 = new Xdr.RowId();
            rowId2.Text = "27";
            Xdr.RowOffset rowOffset2 = new Xdr.RowOffset();
            rowOffset2.Text = "42862";

            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 = "Diagram 1" };
            Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties1 = new Xdr.NonVisualGraphicFrameDrawingProperties();

            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/diagram" };

            Dgm.RelationshipIds relationshipIds1 = new Dgm.RelationshipIds() { DataPart = "rId1", LayoutPart = "rId2", StylePart = "rId3", ColorPart = "rId4" };
            relationshipIds1.AddNamespaceDeclaration("dgm", "http://schemas.openxmlformats.org/drawingml/2006/diagram");
            relationshipIds1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            graphicData1.Append(relationshipIds1);

            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 = "3";
            Xdr.ColumnOffset columnOffset3 = new Xdr.ColumnOffset();
            columnOffset3.Text = "523875";
            Xdr.RowId rowId3 = new Xdr.RowId();
            rowId3.Text = "5";
            Xdr.RowOffset rowOffset3 = new Xdr.RowOffset();
            rowOffset3.Text = "171450";

            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 = "6";
            Xdr.ColumnOffset columnOffset4 = new Xdr.ColumnOffset();
            columnOffset4.Text = "57150";
            Xdr.RowId rowId4 = new Xdr.RowId();
            rowId4.Text = "11";
            Xdr.RowOffset rowOffset4 = new Xdr.RowOffset();
            rowOffset4.Text = "142875";

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

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

            Xdr.NonVisualShapeProperties nonVisualShapeProperties1 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties2 = new Xdr.NonVisualDrawingProperties() { Id = (UInt32Value)3U, Name = "Rectangle 2" };
            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties1 = new Xdr.NonVisualShapeDrawingProperties();

            nonVisualShapeProperties1.Append(nonVisualDrawingProperties2);
            nonVisualShapeProperties1.Append(nonVisualShapeDrawingProperties1);

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

            A.Transform2D transform2D1 = new A.Transform2D();
            A.Offset offset2 = new A.Offset() { X = 2352675L, Y = 1123950L };
            A.Extents extents2 = new A.Extents() { Cx = 1362075L, Cy = 1114425L };

            transform2D1.Append(offset2);
            transform2D1.Append(extents2);

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

            presetGeometry1.Append(adjustValueList1);

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

            Xdr.ShapeStyle shapeStyle1 = new Xdr.ShapeStyle();

            A.LineReference lineReference1 = new A.LineReference() { Index = (UInt32Value)2U };

            A.SchemeColor schemeColor17 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent1 };
            A.Shade shade8 = new A.Shade() { Val = 50000 };

            schemeColor17.Append(shade8);

            lineReference1.Append(schemeColor17);

            A.FillReference fillReference1 = new A.FillReference() { Index = (UInt32Value)1U };
            A.SchemeColor schemeColor18 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent1 };

            fillReference1.Append(schemeColor18);

            A.EffectReference effectReference1 = new A.EffectReference() { Index = (UInt32Value)0U };
            A.SchemeColor schemeColor19 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent1 };

            effectReference1.Append(schemeColor19);

            A.FontReference fontReference1 = new A.FontReference() { Index = A.FontCollectionIndexValues.Minor };
            A.SchemeColor schemeColor20 = new A.SchemeColor() { Val = A.SchemeColorValues.Light1 };

            fontReference1.Append(schemeColor20);

            shapeStyle1.Append(lineReference1);
            shapeStyle1.Append(fillReference1);
            shapeStyle1.Append(effectReference1);
            shapeStyle1.Append(fontReference1);

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

            A.Paragraph paragraph1 = new A.Paragraph();
            A.ParagraphProperties paragraphProperties1 = new A.ParagraphProperties() { Alignment = A.TextAlignmentTypeValues.Left };
            A.EndParagraphRunProperties endParagraphRunProperties1 = new A.EndParagraphRunProperties() { Language = "en-US", FontSize = 1100 };

            paragraph1.Append(paragraphProperties1);
            paragraph1.Append(endParagraphRunProperties1);

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

            shape1.Append(nonVisualShapeProperties1);
            shape1.Append(shapeProperties1);
            shape1.Append(shapeStyle1);
            shape1.Append(textBody1);
            Xdr.ClientData clientData2 = new Xdr.ClientData();

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

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

            Xdr.FromMarker fromMarker3 = new Xdr.FromMarker();
            Xdr.ColumnId columnId5 = new Xdr.ColumnId();
            columnId5.Text = "7";
            Xdr.ColumnOffset columnOffset5 = new Xdr.ColumnOffset();
            columnOffset5.Text = "285750";
            Xdr.RowId rowId5 = new Xdr.RowId();
            rowId5.Text = "2";
            Xdr.RowOffset rowOffset5 = new Xdr.RowOffset();
            rowOffset5.Text = "9525";

            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 = "12";
            Xdr.ColumnOffset columnOffset6 = new Xdr.ColumnOffset();
            columnOffset6.Text = "161925";
            Xdr.RowId rowId6 = new Xdr.RowId();
            rowId6.Text = "10";
            Xdr.RowOffset rowOffset6 = new Xdr.RowOffset();
            rowOffset6.Text = "152400";

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

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

            Xdr.NonVisualShapeProperties nonVisualShapeProperties2 = new Xdr.NonVisualShapeProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties3 = new Xdr.NonVisualDrawingProperties() { Id = (UInt32Value)4U, Name = "TextBox 3" };
            Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties2 = new Xdr.NonVisualShapeDrawingProperties() { TextBox = true };

            nonVisualShapeProperties2.Append(nonVisualDrawingProperties3);
            nonVisualShapeProperties2.Append(nonVisualShapeDrawingProperties2);

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

            A.Transform2D transform2D2 = new A.Transform2D();
            A.Offset offset3 = new A.Offset() { X = 4552950L, Y = 390525L };
            A.Extents extents3 = new A.Extents() { Cx = 2924175L, Cy = 1666875L };

            transform2D2.Append(offset3);
            transform2D2.Append(extents3);

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

            presetGeometry2.Append(adjustValueList2);

            A.SolidFill solidFill6 = new A.SolidFill();
            A.SchemeColor schemeColor21 = new A.SchemeColor() { Val = A.SchemeColorValues.Light1 };

            solidFill6.Append(schemeColor21);

            A.Outline outline4 = new A.Outline() { Width = 9525, CompoundLineType = A.CompoundLineValues.Single };

            A.SolidFill solidFill7 = new A.SolidFill();

            A.SchemeColor schemeColor22 = new A.SchemeColor() { Val = A.SchemeColorValues.Light1 };
            A.Shade shade9 = new A.Shade() { Val = 50000 };

            schemeColor22.Append(shade9);

            solidFill7.Append(schemeColor22);

            outline4.Append(solidFill7);

            shapeProperties2.Append(transform2D2);
            shapeProperties2.Append(presetGeometry2);
            shapeProperties2.Append(solidFill6);
            shapeProperties2.Append(outline4);

            Xdr.ShapeStyle shapeStyle2 = new Xdr.ShapeStyle();

            A.LineReference lineReference2 = new A.LineReference() { Index = (UInt32Value)0U };
            A.RgbColorModelPercentage rgbColorModelPercentage1 = new A.RgbColorModelPercentage() { RedPortion = 0, GreenPortion = 0, BluePortion = 0 };

            lineReference2.Append(rgbColorModelPercentage1);

            A.FillReference fillReference2 = new A.FillReference() { Index = (UInt32Value)0U };
            A.RgbColorModelPercentage rgbColorModelPercentage2 = new A.RgbColorModelPercentage() { RedPortion = 0, GreenPortion = 0, BluePortion = 0 };

            fillReference2.Append(rgbColorModelPercentage2);

            A.EffectReference effectReference2 = new A.EffectReference() { Index = (UInt32Value)0U };
            A.RgbColorModelPercentage rgbColorModelPercentage3 = new A.RgbColorModelPercentage() { RedPortion = 0, GreenPortion = 0, BluePortion = 0 };

            effectReference2.Append(rgbColorModelPercentage3);

            A.FontReference fontReference2 = new A.FontReference() { Index = A.FontCollectionIndexValues.Minor };
            A.SchemeColor schemeColor23 = new A.SchemeColor() { Val = A.SchemeColorValues.Dark1 };

            fontReference2.Append(schemeColor23);

            shapeStyle2.Append(lineReference2);
            shapeStyle2.Append(fillReference2);
            shapeStyle2.Append(effectReference2);
            shapeStyle2.Append(fontReference2);

            Xdr.TextBody textBody2 = new Xdr.TextBody();
            A.BodyProperties bodyProperties2 = new A.BodyProperties() { VerticalOverflow = A.TextVerticalOverflowValues.Clip, HorizontalOverflow = A.TextHorizontalOverflowValues.Clip, Wrap = A.TextWrappingValues.Square, RightToLeftColumns = false, Anchor = A.TextAnchoringTypeValues.Top };
            A.ListStyle listStyle2 = new A.ListStyle();

            A.Paragraph paragraph2 = 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 = "Text box";

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

            paragraph2.Append(run1);

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

            shape2.Append(nonVisualShapeProperties2);
            shape2.Append(shapeProperties2);
            shape2.Append(shapeStyle2);
            shape2.Append(textBody2);
            Xdr.ClientData clientData3 = new Xdr.ClientData();

            twoCellAnchor3.Append(fromMarker3);
            twoCellAnchor3.Append(toMarker3);
            twoCellAnchor3.Append(shape2);
            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 = "19";
            Xdr.ColumnOffset columnOffset7 = new Xdr.ColumnOffset();
            columnOffset7.Text = "561975";
            Xdr.RowId rowId7 = new Xdr.RowId();
            rowId7.Text = "3";
            Xdr.RowOffset rowOffset7 = new Xdr.RowOffset();
            rowOffset7.Text = "95250";

            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 = "24";
            Xdr.ColumnOffset columnOffset8 = new Xdr.ColumnOffset();
            columnOffset8.Text = "19400";
            Xdr.RowId rowId8 = new Xdr.RowId();
            rowId8.Text = "30";
            Xdr.RowOffset rowOffset8 = new Xdr.RowOffset();
            rowOffset8.Text = "86442";

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

            Xdr.Picture picture1 = new Xdr.Picture();

            Xdr.NonVisualPictureProperties nonVisualPictureProperties1 = new Xdr.NonVisualPictureProperties();
            Xdr.NonVisualDrawingProperties nonVisualDrawingProperties4 = new Xdr.NonVisualDrawingProperties() { Id = (UInt32Value)7U, Name = "Picture 6", Description = "Screen Clipping" };

            Xdr.NonVisualPictureDrawingProperties nonVisualPictureDrawingProperties1 = new Xdr.NonVisualPictureDrawingProperties();
            A.PictureLocks pictureLocks1 = new A.PictureLocks() { NoChangeAspect = true };

            nonVisualPictureDrawingProperties1.Append(pictureLocks1);

            nonVisualPictureProperties1.Append(nonVisualDrawingProperties4);
            nonVisualPictureProperties1.Append(nonVisualPictureDrawingProperties1);

            Xdr.BlipFill blipFill1 = new Xdr.BlipFill();

            A.Blip blip1 = new A.Blip() { Embed = "rId6" };
            blip1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");

            A.Duotone duotone1 = new A.Duotone();
            A.PresetColor presetColor1 = new A.PresetColor() { Val = A.PresetColorValues.Black };

            A.SchemeColor schemeColor24 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent2 };
            A.Tint tint7 = new A.Tint() { Val = 45000 };
            A.SaturationModulation saturationModulation13 = new A.SaturationModulation() { Val = 400000 };

            schemeColor24.Append(tint7);
            schemeColor24.Append(saturationModulation13);

            duotone1.Append(presetColor1);
            duotone1.Append(schemeColor24);

            A.BlipExtensionList blipExtensionList1 = new A.BlipExtensionList();

            A.BlipExtension blipExtension1 = new A.BlipExtension() { Uri = "{BEBA8EAE-BF5A-486C-A8C5-ECC9F3942E4B}" };

            A14.ImageProperties imageProperties1 = new A14.ImageProperties();
            imageProperties1.AddNamespaceDeclaration("a14", "http://schemas.microsoft.com/office/drawing/2010/main");

            A14.ImageLayer imageLayer1 = new A14.ImageLayer() { Embed = "rId7" };

            A14.ImageEffect imageEffect1 = new A14.ImageEffect();
            A14.BackgroundRemoval backgroundRemoval1 = new A14.BackgroundRemoval() { MarqueeTop = 10000, MarqueeBottom = 90000, MarqueeLeft = 10000, MarqueeRight = 90000 };

            imageEffect1.Append(backgroundRemoval1);

            A14.ImageEffect imageEffect2 = new A14.ImageEffect();
            A14.ArtisticFilmGrain artisticFilmGrain1 = new A14.ArtisticFilmGrain();

            imageEffect2.Append(artisticFilmGrain1);

            imageLayer1.Append(imageEffect1);
            imageLayer1.Append(imageEffect2);

            imageProperties1.Append(imageLayer1);

            blipExtension1.Append(imageProperties1);

            A.BlipExtension blipExtension2 = new A.BlipExtension() { Uri = "{28A0092B-C50C-407E-A947-70E740481C1C}" };

            A14.UseLocalDpi useLocalDpi1 = new A14.UseLocalDpi() { Val = false };
            useLocalDpi1.AddNamespaceDeclaration("a14", "http://schemas.microsoft.com/office/drawing/2010/main");

            blipExtension2.Append(useLocalDpi1);

            blipExtensionList1.Append(blipExtension1);
            blipExtensionList1.Append(blipExtension2);

            blip1.Append(duotone1);
            blip1.Append(blipExtensionList1);

            A.Stretch stretch1 = new A.Stretch();
            A.FillRectangle fillRectangle1 = new A.FillRectangle();

            stretch1.Append(fillRectangle1);

            blipFill1.Append(blip1);
            blipFill1.Append(stretch1);

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

            A.Transform2D transform2D3 = new A.Transform2D();
            A.Offset offset4 = new A.Offset() { X = 12144375L, Y = 666750L };
            A.Extents extents4 = new A.Extents() { Cx = 2505425L, Cy = 5134692L };

            transform2D3.Append(offset4);
            transform2D3.Append(extents4);

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

            presetGeometry3.Append(adjustValueList3);

            shapeProperties3.Append(transform2D3);
            shapeProperties3.Append(presetGeometry3);

            picture1.Append(nonVisualPictureProperties1);
            picture1.Append(blipFill1);
            picture1.Append(shapeProperties3);
            Xdr.ClientData clientData4 = new Xdr.ClientData();

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

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

            drawingsPart1.WorksheetDrawing = worksheetDrawing1;
        }