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); }
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; }