// 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 = "7"; Xdr.ColumnOffset columnOffset1 = new Xdr.ColumnOffset(); columnOffset1.Text = "576262"; Xdr.RowId rowId1 = new Xdr.RowId(); rowId1.Text = "2"; Xdr.RowOffset rowOffset1 = new Xdr.RowOffset(); rowOffset1.Text = "109537"; 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 = "14"; Xdr.ColumnOffset columnOffset2 = new Xdr.ColumnOffset(); columnOffset2.Text = "119062"; Xdr.RowId rowId2 = new Xdr.RowId(); rowId2.Text = "22"; Xdr.RowOffset rowOffset2 = new Xdr.RowOffset(); rowOffset2.Text = "109537"; toMarker1.Append(columnId2); toMarker1.Append(columnOffset2); toMarker1.Append(rowId2); toMarker1.Append(rowOffset2); AlternateContent alternateContent2 = new AlternateContent(); alternateContent2.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); AlternateContentChoice alternateContentChoice2 = new AlternateContentChoice(){ Requires = "we" }; alternateContentChoice2.AddNamespaceDeclaration("we", "http://schemas.microsoft.com/office/webextensions/webextension/2010/11"); Xdr.GraphicFrame graphicFrame1 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties1 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties1 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Agave 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties1 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks1 = new A.GraphicFrameLocks(){ NoGrouping = true }; 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.microsoft.com/office/webextensions/webextension/2010/11" }; We.WebExtensionReference webExtensionReference1 = new We.WebExtensionReference(){ Id = "rId1" }; webExtensionReference1.AddNamespaceDeclaration("we", "http://schemas.microsoft.com/office/webextensions/webextension/2010/11"); webExtensionReference1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData1.Append(webExtensionReference1); graphic1.Append(graphicData1); graphicFrame1.Append(nonVisualGraphicFrameProperties1); graphicFrame1.Append(transform1); graphicFrame1.Append(graphic1); alternateContentChoice2.Append(graphicFrame1); AlternateContentFallback alternateContentFallback1 = new AlternateContentFallback(); Xdr.Picture picture1 = new Xdr.Picture(); Xdr.NonVisualPictureProperties nonVisualPictureProperties1 = new Xdr.NonVisualPictureProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties2 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Agave 1" }; Xdr.NonVisualPictureDrawingProperties nonVisualPictureDrawingProperties1 = new Xdr.NonVisualPictureDrawingProperties(); nonVisualPictureProperties1.Append(nonVisualDrawingProperties2); nonVisualPictureProperties1.Append(nonVisualPictureDrawingProperties1); Xdr.BlipFill blipFill1 = new Xdr.BlipFill(); A.Blip blip1 = new A.Blip(){ Embed = "rId2" }; blip1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); A.Stretch stretch1 = new A.Stretch(); A.FillRectangle fillRectangle1 = new A.FillRectangle(); stretch1.Append(fillRectangle1); blipFill1.Append(blip1); blipFill1.Append(stretch1); Xdr.ShapeProperties shapeProperties1 = new Xdr.ShapeProperties(); A.PresetGeometry presetGeometry1 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList1 = new A.AdjustValueList(); presetGeometry1.Append(adjustValueList1); shapeProperties1.Append(presetGeometry1); picture1.Append(nonVisualPictureProperties1); picture1.Append(blipFill1); picture1.Append(shapeProperties1); alternateContentFallback1.Append(picture1); alternateContent2.Append(alternateContentChoice2); alternateContent2.Append(alternateContentFallback1); Xdr.ClientData clientData1 = new Xdr.ClientData(); twoCellAnchor1.Append(fromMarker1); twoCellAnchor1.Append(toMarker1); twoCellAnchor1.Append(alternateContent2); twoCellAnchor1.Append(clientData1); Xdr.TwoCellAnchor twoCellAnchor2 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker2 = new Xdr.FromMarker(); Xdr.ColumnId columnId3 = new Xdr.ColumnId(); columnId3.Text = "0"; Xdr.ColumnOffset columnOffset3 = new Xdr.ColumnOffset(); columnOffset3.Text = "119062"; Xdr.RowId rowId3 = new Xdr.RowId(); rowId3.Text = "3"; Xdr.RowOffset rowOffset3 = new Xdr.RowOffset(); rowOffset3.Text = "42862"; 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 = "271462"; Xdr.RowId rowId4 = new Xdr.RowId(); rowId4.Text = "23"; Xdr.RowOffset rowOffset4 = new Xdr.RowOffset(); rowOffset4.Text = "42862"; toMarker2.Append(columnId4); toMarker2.Append(columnOffset4); toMarker2.Append(rowId4); toMarker2.Append(rowOffset4); AlternateContent alternateContent3 = new AlternateContent(); alternateContent3.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); AlternateContentChoice alternateContentChoice3 = new AlternateContentChoice(){ Requires = "we" }; alternateContentChoice3.AddNamespaceDeclaration("we", "http://schemas.microsoft.com/office/webextensions/webextension/2010/11"); Xdr.GraphicFrame graphicFrame2 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties2 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties3 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "Agave 2" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties2 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks2 = new A.GraphicFrameLocks(){ NoGrouping = true }; nonVisualGraphicFrameDrawingProperties2.Append(graphicFrameLocks2); nonVisualGraphicFrameProperties2.Append(nonVisualDrawingProperties3); 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.microsoft.com/office/webextensions/webextension/2010/11" }; We.WebExtensionReference webExtensionReference2 = new We.WebExtensionReference(){ Id = "rId3" }; webExtensionReference2.AddNamespaceDeclaration("we", "http://schemas.microsoft.com/office/webextensions/webextension/2010/11"); webExtensionReference2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData2.Append(webExtensionReference2); graphic2.Append(graphicData2); graphicFrame2.Append(nonVisualGraphicFrameProperties2); graphicFrame2.Append(transform2); graphicFrame2.Append(graphic2); alternateContentChoice3.Append(graphicFrame2); AlternateContentFallback alternateContentFallback2 = new AlternateContentFallback(); Xdr.Picture picture2 = new Xdr.Picture(); Xdr.NonVisualPictureProperties nonVisualPictureProperties2 = new Xdr.NonVisualPictureProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties4 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)3U, Name = "Agave 2" }; Xdr.NonVisualPictureDrawingProperties nonVisualPictureDrawingProperties2 = new Xdr.NonVisualPictureDrawingProperties(); nonVisualPictureProperties2.Append(nonVisualDrawingProperties4); nonVisualPictureProperties2.Append(nonVisualPictureDrawingProperties2); Xdr.BlipFill blipFill2 = new Xdr.BlipFill(); A.Blip blip2 = new A.Blip(){ Embed = "rId4" }; blip2.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); A.Stretch stretch2 = new A.Stretch(); A.FillRectangle fillRectangle2 = new A.FillRectangle(); stretch2.Append(fillRectangle2); blipFill2.Append(blip2); blipFill2.Append(stretch2); Xdr.ShapeProperties shapeProperties2 = new Xdr.ShapeProperties(); A.PresetGeometry presetGeometry2 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList2 = new A.AdjustValueList(); presetGeometry2.Append(adjustValueList2); shapeProperties2.Append(presetGeometry2); picture2.Append(nonVisualPictureProperties2); picture2.Append(blipFill2); picture2.Append(shapeProperties2); alternateContentFallback2.Append(picture2); alternateContent3.Append(alternateContentChoice3); alternateContent3.Append(alternateContentFallback2); Xdr.ClientData clientData2 = new Xdr.ClientData(); twoCellAnchor2.Append(fromMarker2); twoCellAnchor2.Append(toMarker2); twoCellAnchor2.Append(alternateContent3); twoCellAnchor2.Append(clientData2); worksheetDrawing1.Append(twoCellAnchor1); worksheetDrawing1.Append(twoCellAnchor2); drawingsPart1.WorksheetDrawing = worksheetDrawing1; }
// 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 twoCellAnchor3 = new Xdr.TwoCellAnchor(); Xdr.FromMarker fromMarker3 = new Xdr.FromMarker(); Xdr.ColumnId columnId5 = new Xdr.ColumnId(); columnId5.Text = "1"; Xdr.ColumnOffset columnOffset5 = new Xdr.ColumnOffset(); columnOffset5.Text = "33337"; Xdr.RowId rowId5 = new Xdr.RowId(); rowId5.Text = "2"; Xdr.RowOffset rowOffset5 = new Xdr.RowOffset(); rowOffset5.Text = "61912"; 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 = "7"; Xdr.ColumnOffset columnOffset6 = new Xdr.ColumnOffset(); columnOffset6.Text = "185737"; Xdr.RowId rowId6 = new Xdr.RowId(); rowId6.Text = "22"; Xdr.RowOffset rowOffset6 = new Xdr.RowOffset(); rowOffset6.Text = "61912"; toMarker3.Append(columnId6); toMarker3.Append(columnOffset6); toMarker3.Append(rowId6); toMarker3.Append(rowOffset6); AlternateContent alternateContent4 = new AlternateContent(); alternateContent4.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006"); AlternateContentChoice alternateContentChoice4 = new AlternateContentChoice(){ Requires = "we" }; alternateContentChoice4.AddNamespaceDeclaration("we", "http://schemas.microsoft.com/office/webextensions/webextension/2010/11"); Xdr.GraphicFrame graphicFrame3 = new Xdr.GraphicFrame(){ Macro = "" }; Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties3 = new Xdr.NonVisualGraphicFrameProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties5 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Agave 1" }; Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties3 = new Xdr.NonVisualGraphicFrameDrawingProperties(); A.GraphicFrameLocks graphicFrameLocks3 = new A.GraphicFrameLocks(){ NoGrouping = true }; nonVisualGraphicFrameDrawingProperties3.Append(graphicFrameLocks3); nonVisualGraphicFrameProperties3.Append(nonVisualDrawingProperties5); 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/webextensions/webextension/2010/11" }; We.WebExtensionReference webExtensionReference3 = new We.WebExtensionReference(){ Id = "rId1" }; webExtensionReference3.AddNamespaceDeclaration("we", "http://schemas.microsoft.com/office/webextensions/webextension/2010/11"); webExtensionReference3.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); graphicData3.Append(webExtensionReference3); graphic3.Append(graphicData3); graphicFrame3.Append(nonVisualGraphicFrameProperties3); graphicFrame3.Append(transform3); graphicFrame3.Append(graphic3); alternateContentChoice4.Append(graphicFrame3); AlternateContentFallback alternateContentFallback3 = new AlternateContentFallback(); Xdr.Picture picture3 = new Xdr.Picture(); Xdr.NonVisualPictureProperties nonVisualPictureProperties3 = new Xdr.NonVisualPictureProperties(); Xdr.NonVisualDrawingProperties nonVisualDrawingProperties6 = new Xdr.NonVisualDrawingProperties(){ Id = (UInt32Value)2U, Name = "Agave 1" }; Xdr.NonVisualPictureDrawingProperties nonVisualPictureDrawingProperties3 = new Xdr.NonVisualPictureDrawingProperties(); nonVisualPictureProperties3.Append(nonVisualDrawingProperties6); nonVisualPictureProperties3.Append(nonVisualPictureDrawingProperties3); Xdr.BlipFill blipFill3 = new Xdr.BlipFill(); A.Blip blip3 = new A.Blip(){ Embed = "rId2" }; blip3.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships"); A.Stretch stretch3 = new A.Stretch(); A.FillRectangle fillRectangle3 = new A.FillRectangle(); stretch3.Append(fillRectangle3); blipFill3.Append(blip3); blipFill3.Append(stretch3); Xdr.ShapeProperties shapeProperties3 = new Xdr.ShapeProperties(); A.PresetGeometry presetGeometry3 = new A.PresetGeometry(){ Preset = A.ShapeTypeValues.Rectangle }; A.AdjustValueList adjustValueList3 = new A.AdjustValueList(); presetGeometry3.Append(adjustValueList3); shapeProperties3.Append(presetGeometry3); picture3.Append(nonVisualPictureProperties3); picture3.Append(blipFill3); picture3.Append(shapeProperties3); alternateContentFallback3.Append(picture3); alternateContent4.Append(alternateContentChoice4); alternateContent4.Append(alternateContentFallback3); Xdr.ClientData clientData3 = new Xdr.ClientData(); twoCellAnchor3.Append(fromMarker3); twoCellAnchor3.Append(toMarker3); twoCellAnchor3.Append(alternateContent4); twoCellAnchor3.Append(clientData3); worksheetDrawing2.Append(twoCellAnchor3); drawingsPart2.WorksheetDrawing = worksheetDrawing2; }