private Xdr.OneCellAnchor createImageAnchor(ImageDetails details)
{
var image = _images[details.ImageIndex];
long imgWidth = convertPixelsToEMUs(image.Width, image.HorizontalResolution);
long imgHeight = convertPixelsToEMUs(image.Height, image.VerticalResolution);
// ReSharper disable once CompareOfFloatsByEqualityOperator
if (details.ImageScaleFactor != 0)
{
imgWidth = (long)(imgWidth * details.ImageScaleFactor);
imgHeight = (long)(imgHeight * details.ImageScaleFactor);
}
// there is still work to be done here since the images can get fuzzy and there is no indent
// but, since you cannot have thousands of cell images(which we need) without performance penalty in the Excel application itselft
// we can easily and quickly generate such excel files, but Excel has trouble reading and rendering them
// so for now this stay as is
Xdr.OneCellAnchor oneCellAnchor = new Xdr.OneCellAnchor();
Xdr.FromMarker fromMarker1 = new Xdr.FromMarker();
Xdr.ColumnId columnId1 = new Xdr.ColumnId();
columnId1.Text = (details.Column - 1).ToString();
Xdr.ColumnOffset columnOffset1 = new Xdr.ColumnOffset();
columnOffset1.Text = "0";
Xdr.RowId rowId1 = new Xdr.RowId();
rowId1.Text = (details.Row - 1).ToString();
Xdr.RowOffset rowOffset1 = new Xdr.RowOffset();
rowOffset1.Text = "0";
fromMarker1.Append(columnId1);
fromMarker1.Append(columnOffset1);
fromMarker1.Append(rowId1);
fromMarker1.Append(rowOffset1);
var anchorExtent = new Xdr.Extent()
{
Cx = imgWidth, Cy = imgWidth
};
//Xdr.ToMarker toMarker1 = new Xdr.ToMarker();
//Xdr.ColumnId columnId2 = new Xdr.ColumnId();
//columnId2.Text = (details.Column-1).ToString();
//Xdr.ColumnOffset columnOffset2 = new Xdr.ColumnOffset();
//columnOffset2.Text = "203175";
//Xdr.RowId rowId2 = new Xdr.RowId();
//rowId2.Text = (details.Row -1).ToString(); ;
//Xdr.RowOffset rowOffset2 = new Xdr.RowOffset();
//rowOffset2.Text = "12675";
//toMarker1.Append(columnId2);
//toMarker1.Append(columnOffset2);
//toMarker1.Append(rowId2);
//toMarker1.Append(rowOffset2);
Xdr.Picture picture1 = new Xdr.Picture();
Xdr.NonVisualPictureProperties nonVisualPictureProperties1 = new Xdr.NonVisualPictureProperties();
UInt32Value id = (UInt32Value)_pictureCounter;
_pictureCounter++;
Xdr.NonVisualDrawingProperties nonVisualDrawingProperties1 = new Xdr.NonVisualDrawingProperties()
{
Id = id, Name = "Picture " + id
};
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();
A.Blip blip1 = new A.Blip()
{
Embed = "image" + details.ImageIndex
};
blip1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
A.BlipExtensionList blipExtensionList1 = new A.BlipExtensionList();
A.BlipExtension blipExtension1 = 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");
blipExtension1.Append(useLocalDpi1);
blipExtensionList1.Append(blipExtension1);
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 shapeProperties1 = new Xdr.ShapeProperties();
A.Transform2D transform2D1 = new A.Transform2D();
A.Offset offset1 = new A.Offset()
{
X = 0, Y = 0
};
A.Extents extents1 = new A.Extents()
{
Cx = imgWidth, Cy = imgHeight
};
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();
oneCellAnchor.Append(fromMarker1);
oneCellAnchor.Append(anchorExtent);
//twoCellAnchor1.Append(toMarker1);
oneCellAnchor.Append(picture1);
oneCellAnchor.Append(clientData1);
return(oneCellAnchor);
}
private void WriteImageParts(DrawingsPart dp)
{
ImagePart imgp;
Xdr.WorksheetDrawing wsd = dp.WorksheetDrawing;
SLRowProperties rp;
SLColumnProperties cp;
#region Charts
if (slws.Charts.Count > 0)
{
int FromAnchorRowIndex = 0;
long FromAnchorRowOffset = 0;
int FromAnchorColumnIndex = 0;
long FromAnchorColumnOffset = 0;
int ToAnchorRowIndex = 4;
long ToAnchorRowOffset = 0;
int ToAnchorColumnIndex = 4;
long ToAnchorColumnOffset = 0;
double fTemp = 0;
ChartPart chartp;
Xdr.GraphicFrame gf;
foreach (Charts.SLChart Chart in slws.Charts)
{
chartp = dp.AddNewPart<ChartPart>();
chartp.ChartSpace = Chart.ToChartSpace(ref chartp);
gf = new Xdr.GraphicFrame();
gf.Macro = string.Empty;
gf.NonVisualGraphicFrameProperties = new Xdr.NonVisualGraphicFrameProperties();
gf.NonVisualGraphicFrameProperties.NonVisualDrawingProperties = new Xdr.NonVisualDrawingProperties();
gf.NonVisualGraphicFrameProperties.NonVisualDrawingProperties.Id = slws.NextWorksheetDrawingId;
++slws.NextWorksheetDrawingId;
gf.NonVisualGraphicFrameProperties.NonVisualDrawingProperties.Name = Chart.ChartName;
// alt text for charts
//...gf.NonVisualGraphicFrameProperties.NonVisualDrawingProperties.Description = "";
gf.NonVisualGraphicFrameProperties.NonVisualGraphicFrameDrawingProperties = new Xdr.NonVisualGraphicFrameDrawingProperties();
gf.Transform = new Xdr.Transform();
gf.Transform.Offset = new A.Offset() { X = 0, Y = 0 };
gf.Transform.Extents = new A.Extents() { Cx = 0, Cy = 0 };
gf.Graphic = new A.Graphic();
gf.Graphic.GraphicData = new A.GraphicData();
gf.Graphic.GraphicData.Uri = SLConstants.NamespaceC;
gf.Graphic.GraphicData.Append(new C.ChartReference() { Id = dp.GetIdOfPart(chartp) });
FromAnchorRowIndex = (int)Math.Floor(Chart.TopPosition);
fTemp = Chart.TopPosition - FromAnchorRowIndex;
FromAnchorRowOffset = (long)(fTemp * slws.SheetFormatProperties.DefaultRowHeightInEMU);
if (slws.RowProperties.ContainsKey(FromAnchorRowIndex + 1))
{
rp = slws.RowProperties[FromAnchorRowIndex + 1];
if (rp.HasHeight) FromAnchorRowOffset = (long)(fTemp * rp.HeightInEMU);
}
FromAnchorColumnIndex = (int)Math.Floor(Chart.LeftPosition);
fTemp = Chart.LeftPosition - FromAnchorColumnIndex;
FromAnchorColumnOffset = (long)(fTemp * slws.SheetFormatProperties.DefaultColumnWidthInEMU);
if (slws.ColumnProperties.ContainsKey(FromAnchorColumnIndex + 1))
{
cp = slws.ColumnProperties[FromAnchorColumnIndex + 1];
if (cp.HasWidth)
{
FromAnchorColumnOffset = (long)(fTemp * cp.WidthInEMU);
}
}
ToAnchorRowIndex = (int)Math.Floor(Chart.BottomPosition);
fTemp = Chart.BottomPosition - ToAnchorRowIndex;
ToAnchorRowOffset = (long)(fTemp * slws.SheetFormatProperties.DefaultRowHeightInEMU);
if (slws.RowProperties.ContainsKey(ToAnchorRowIndex + 1))
{
rp = slws.RowProperties[ToAnchorRowIndex + 1];
if (rp.HasHeight) ToAnchorRowOffset = (long)(fTemp * rp.HeightInEMU);
}
ToAnchorColumnIndex = (int)Math.Floor(Chart.RightPosition);
fTemp = Chart.RightPosition - ToAnchorColumnIndex;
ToAnchorColumnOffset = (long)(fTemp * slws.SheetFormatProperties.DefaultColumnWidthInEMU);
if (slws.ColumnProperties.ContainsKey(ToAnchorColumnIndex + 1))
{
cp = slws.ColumnProperties[ToAnchorColumnIndex + 1];
if (cp.HasWidth)
{
ToAnchorColumnOffset = (long)(fTemp * cp.WidthInEMU);
}
}
Xdr.TwoCellAnchor tcanchor = new Xdr.TwoCellAnchor();
tcanchor.FromMarker = new Xdr.FromMarker();
tcanchor.FromMarker.RowId = new Xdr.RowId(FromAnchorRowIndex.ToString(CultureInfo.InvariantCulture));
tcanchor.FromMarker.RowOffset = new Xdr.RowOffset(FromAnchorRowOffset.ToString(CultureInfo.InvariantCulture));
tcanchor.FromMarker.ColumnId = new Xdr.ColumnId(FromAnchorColumnIndex.ToString(CultureInfo.InvariantCulture));
tcanchor.FromMarker.ColumnOffset = new Xdr.ColumnOffset(FromAnchorColumnOffset.ToString(CultureInfo.InvariantCulture));
tcanchor.ToMarker = new Xdr.ToMarker();
tcanchor.ToMarker.RowId = new Xdr.RowId(ToAnchorRowIndex.ToString(CultureInfo.InvariantCulture));
tcanchor.ToMarker.RowOffset = new Xdr.RowOffset(ToAnchorRowOffset.ToString(CultureInfo.InvariantCulture));
tcanchor.ToMarker.ColumnId = new Xdr.ColumnId(ToAnchorColumnIndex.ToString(CultureInfo.InvariantCulture));
tcanchor.ToMarker.ColumnOffset = new Xdr.ColumnOffset(ToAnchorColumnOffset.ToString(CultureInfo.InvariantCulture));
tcanchor.Append(gf);
tcanchor.Append(new Xdr.ClientData());
wsd.Append(tcanchor);
wsd.Save(dp);
}
}
#endregion
#region Pictures
if (slws.Pictures.Count > 0)
{
foreach (Drawing.SLPicture Picture in slws.Pictures)
{
imgp = dp.AddImagePart(Picture.PictureImagePartType);
if (Picture.DataIsInFile)
{
using (FileStream fs = new FileStream(Picture.PictureFileName, FileMode.Open))
{
imgp.FeedData(fs);
}
}
else
{
using (MemoryStream ms = new MemoryStream(Picture.PictureByteData))
{
imgp.FeedData(ms);
}
}
Xdr.Picture pic = new Xdr.Picture();
pic.NonVisualPictureProperties = new Xdr.NonVisualPictureProperties();
pic.NonVisualPictureProperties.NonVisualDrawingProperties = new Xdr.NonVisualDrawingProperties();
pic.NonVisualPictureProperties.NonVisualDrawingProperties.Id = slws.NextWorksheetDrawingId;
++slws.NextWorksheetDrawingId;
// recommendation is to set as the actual filename, but we'll follow Excel here...
// Note: the name value can be used multiple times without Excel choking.
// So for example, you can have two pictures with "Picture 1".
pic.NonVisualPictureProperties.NonVisualDrawingProperties.Name = string.Format("Picture {0}", dp.ImageParts.Count());
pic.NonVisualPictureProperties.NonVisualDrawingProperties.Description = Picture.AlternativeText;
// hlinkClick and hlinkHover as children
if (Picture.HasUri)
{
HyperlinkRelationship hlinkrel = dp.AddHyperlinkRelationship(new System.Uri(Picture.HyperlinkUri, Picture.HyperlinkUriKind), Picture.IsHyperlinkExternal);
pic.NonVisualPictureProperties.NonVisualDrawingProperties.HyperlinkOnClick = new A.HyperlinkOnClick() { Id = hlinkrel.Id };
}
pic.NonVisualPictureProperties.NonVisualPictureDrawingProperties = new Xdr.NonVisualPictureDrawingProperties();
pic.BlipFill = new Xdr.BlipFill();
pic.BlipFill.Blip = new A.Blip();
pic.BlipFill.Blip.Embed = dp.GetIdOfPart(imgp);
if (Picture.CompressionState != A.BlipCompressionValues.None)
{
pic.BlipFill.Blip.CompressionState = Picture.CompressionState;
}
if (Picture.Brightness != 0 || Picture.Contrast != 0)
{
A.LuminanceEffect lumeffect = new A.LuminanceEffect();
if (Picture.Brightness != 0) lumeffect.Brightness = Convert.ToInt32(Picture.Brightness * 1000);
if (Picture.Contrast != 0) lumeffect.Contrast = Convert.ToInt32(Picture.Contrast * 1000);
pic.BlipFill.Blip.Append(lumeffect);
}
pic.BlipFill.SourceRectangle = new A.SourceRectangle();
pic.BlipFill.Append(new A.Stretch() { FillRectangle = new A.FillRectangle() });
Picture.ShapeProperties.BlackWhiteMode = A.BlackWhiteModeValues.Auto;
Picture.ShapeProperties.HasTransform2D = true;
Picture.ShapeProperties.Transform2D.HasOffset = true;
Picture.ShapeProperties.Transform2D.HasExtents = true;
// not supporting yet because you need to change the positional offsets too.
//if (Picture.RotationAngle != 0)
//{
// pic.ShapeProperties.Transform2D.Rotation = Convert.ToInt32(Picture.RotationAngle * (decimal)SLConstants.DegreeToAngleRepresentation);
//}
// used when it's relative positioning
// these are the actual values used, so it's 1 less than the given anchor indices.
int iColumnId = 0, iRowId = 0;
long lColumnOffset = 0, lRowOffset = 0;
if (Picture.UseRelativePositioning)
{
iColumnId = Picture.AnchorColumnIndex - 1;
iRowId = Picture.AnchorRowIndex - 1;
long lOffset = 0;
long lOffsetBuffer = 0;
int i;
for (i = 1; i <= iColumnId; ++i)
{
if (slws.ColumnProperties.ContainsKey(i))
{
cp = slws.ColumnProperties[i];
if (cp.HasWidth)
{
lOffsetBuffer += cp.WidthInEMU;
}
else
{
lOffsetBuffer += slws.SheetFormatProperties.DefaultColumnWidthInEMU;
}
}
else
{
// we use the current worksheet's column width
lOffsetBuffer += slws.SheetFormatProperties.DefaultColumnWidthInEMU;
}
}
lOffsetBuffer += Picture.OffsetX;
lOffset = lOffsetBuffer;
if (lOffset <= 0)
{
// in case the given offset is so negative, it pushes the sum to negative
// We use "<= 0" here, so the else part assumes a positive offset
iColumnId = 0;
lColumnOffset = 0;
}
else
{
lOffsetBuffer = 0;
i = 1;
while (lOffset > lOffsetBuffer)
{
iColumnId = i - 1;
lColumnOffset = lOffset - lOffsetBuffer;
if (slws.ColumnProperties.ContainsKey(i))
{
cp = slws.ColumnProperties[i];
if (cp.HasWidth)
{
lOffsetBuffer += cp.WidthInEMU;
}
else
{
lOffsetBuffer += slws.SheetFormatProperties.DefaultColumnWidthInEMU;
}
}
else
{
// we use the current worksheet's column width
lOffsetBuffer += slws.SheetFormatProperties.DefaultColumnWidthInEMU;
}
++i;
}
}
Picture.ShapeProperties.Transform2D.Offset.X = lColumnOffset;
lOffsetBuffer = 0;
for (i = 1; i <= iRowId; ++i)
{
if (slws.RowProperties.ContainsKey(i))
{
rp = slws.RowProperties[i];
if (rp.HasHeight)
{
lOffsetBuffer += rp.HeightInEMU;
}
else
{
lOffsetBuffer += slws.SheetFormatProperties.DefaultRowHeightInEMU;
}
}
else
{
// we use the current worksheet's row height
lOffsetBuffer += slws.SheetFormatProperties.DefaultRowHeightInEMU;
}
}
lOffsetBuffer += Picture.OffsetY;
lOffset = lOffsetBuffer;
if (lOffset <= 0)
{
// in case the given offset is so negative, it pushes the sum to negative
// We use "<= 0" here, so the else part assumes a positive offset
iRowId = 0;
lRowOffset = 0;
}
else
{
lOffsetBuffer = 0;
i = 1;
while (lOffset > lOffsetBuffer)
{
iRowId = i - 1;
lRowOffset = lOffset - lOffsetBuffer;
if (slws.RowProperties.ContainsKey(i))
{
rp = slws.RowProperties[i];
if (rp.HasHeight)
{
lOffsetBuffer += rp.HeightInEMU;
}
else
{
lOffsetBuffer += slws.SheetFormatProperties.DefaultRowHeightInEMU;
}
}
else
{
// we use the current worksheet's row height
lOffsetBuffer += slws.SheetFormatProperties.DefaultRowHeightInEMU;
}
++i;
}
}
Picture.ShapeProperties.Transform2D.Offset.Y = lRowOffset;
}
else
{
Picture.ShapeProperties.Transform2D.Offset.X = 0;
Picture.ShapeProperties.Transform2D.Offset.Y = 0;
}
Picture.ShapeProperties.Transform2D.Extents.Cx = Picture.WidthInEMU;
Picture.ShapeProperties.Transform2D.Extents.Cy = Picture.HeightInEMU;
Picture.ShapeProperties.HasPresetGeometry = true;
Picture.ShapeProperties.PresetGeometry = Picture.PictureShape;
pic.ShapeProperties = Picture.ShapeProperties.ToXdrShapeProperties();
Xdr.ClientData clientdata = new Xdr.ClientData();
// the properties are true by default
if (!Picture.LockWithSheet) clientdata.LockWithSheet = false;
if (!Picture.PrintWithSheet) clientdata.PrintWithSheet = false;
if (Picture.UseRelativePositioning)
{
Xdr.OneCellAnchor ocanchor = new Xdr.OneCellAnchor();
ocanchor.FromMarker = new Xdr.FromMarker();
// Subtract 1 because picture goes to bottom right corner
// Subtracting 1 makes it more intuitive that (1,1) means top-left corner of (1,1)
ocanchor.FromMarker.ColumnId = new Xdr.ColumnId() { Text = iColumnId.ToString(CultureInfo.InvariantCulture) };
ocanchor.FromMarker.ColumnOffset = new Xdr.ColumnOffset() { Text = lColumnOffset.ToString(CultureInfo.InvariantCulture) };
ocanchor.FromMarker.RowId = new Xdr.RowId() { Text = iRowId.ToString(CultureInfo.InvariantCulture) };
ocanchor.FromMarker.RowOffset = new Xdr.RowOffset() { Text = lRowOffset.ToString(CultureInfo.InvariantCulture) };
ocanchor.Extent = new Xdr.Extent();
ocanchor.Extent.Cx = Picture.WidthInEMU;
ocanchor.Extent.Cy = Picture.HeightInEMU;
ocanchor.Append(pic);
ocanchor.Append(clientdata);
wsd.Append(ocanchor);
}
else
{
Xdr.AbsoluteAnchor absanchor = new Xdr.AbsoluteAnchor();
absanchor.Position = new Xdr.Position();
absanchor.Position.X = Picture.OffsetX;
absanchor.Position.Y = Picture.OffsetY;
absanchor.Extent = new Xdr.Extent();
absanchor.Extent.Cx = Picture.WidthInEMU;
absanchor.Extent.Cy = Picture.HeightInEMU;
absanchor.Append(pic);
absanchor.Append(clientdata);
wsd.Append(absanchor);
}
wsd.Save(dp);
}
}
#endregion
}
private void WriteImageParts(DrawingsPart dp)
{
ImagePart imgp;
Xdr.WorksheetDrawing wsd = dp.WorksheetDrawing;
SLRowProperties rp;
SLColumnProperties cp;
#region Charts
if (slws.Charts.Count > 0)
{
int FromAnchorRowIndex = 0;
long FromAnchorRowOffset = 0;
int FromAnchorColumnIndex = 0;
long FromAnchorColumnOffset = 0;
int ToAnchorRowIndex = 4;
long ToAnchorRowOffset = 0;
int ToAnchorColumnIndex = 4;
long ToAnchorColumnOffset = 0;
double fTemp = 0;
ChartPart chartp;
Xdr.GraphicFrame gf;
foreach (Charts.SLChart Chart in slws.Charts)
{
chartp = dp.AddNewPart<ChartPart>();
chartp.ChartSpace = Chart.ToChartSpace(ref chartp);
gf = new Xdr.GraphicFrame();
gf.Macro = string.Empty;
gf.NonVisualGraphicFrameProperties = new Xdr.NonVisualGraphicFrameProperties();
gf.NonVisualGraphicFrameProperties.NonVisualDrawingProperties = new Xdr.NonVisualDrawingProperties();
gf.NonVisualGraphicFrameProperties.NonVisualDrawingProperties.Id = slws.NextWorksheetDrawingId;
++slws.NextWorksheetDrawingId;
gf.NonVisualGraphicFrameProperties.NonVisualDrawingProperties.Name = Chart.ChartName;
// alt text for charts
//...gf.NonVisualGraphicFrameProperties.NonVisualDrawingProperties.Description = "";
gf.NonVisualGraphicFrameProperties.NonVisualGraphicFrameDrawingProperties = new Xdr.NonVisualGraphicFrameDrawingProperties();
gf.Transform = new Xdr.Transform();
gf.Transform.Offset = new A.Offset() { X = 0, Y = 0 };
gf.Transform.Extents = new A.Extents() { Cx = 0, Cy = 0 };
gf.Graphic = new A.Graphic();
gf.Graphic.GraphicData = new A.GraphicData();
gf.Graphic.GraphicData.Uri = "http://schemas.openxmlformats.org/drawingml/2006/chart";
gf.Graphic.GraphicData.Append(new C.ChartReference() { Id = dp.GetIdOfPart(chartp) });
FromAnchorRowIndex = (int)Math.Floor(Chart.TopPosition);
fTemp = Chart.TopPosition - FromAnchorRowIndex;
FromAnchorRowOffset = (long)(fTemp * slws.SheetFormatProperties.DefaultRowHeightInEMU);
if (slws.RowProperties.ContainsKey(FromAnchorRowIndex + 1))
{
rp = slws.RowProperties[FromAnchorRowIndex + 1];
if (rp.HasHeight) FromAnchorRowOffset = (long)(fTemp * rp.HeightInEMU);
}
FromAnchorColumnIndex = (int)Math.Floor(Chart.LeftPosition);
fTemp = Chart.LeftPosition - FromAnchorColumnIndex;
FromAnchorColumnOffset = (long)(fTemp * slws.SheetFormatProperties.DefaultColumnWidthInEMU);
if (slws.ColumnProperties.ContainsKey(FromAnchorColumnIndex + 1))
{
cp = slws.ColumnProperties[FromAnchorColumnIndex + 1];
if (cp.HasWidth) FromAnchorColumnOffset = (long)(fTemp * cp.WidthInEMU);
}
ToAnchorRowIndex = (int)Math.Floor(Chart.BottomPosition);
fTemp = Chart.BottomPosition - ToAnchorRowIndex;
ToAnchorRowOffset = (long)(fTemp * slws.SheetFormatProperties.DefaultRowHeightInEMU);
if (slws.RowProperties.ContainsKey(ToAnchorRowIndex + 1))
{
rp = slws.RowProperties[ToAnchorRowIndex + 1];
if (rp.HasHeight) ToAnchorRowOffset = (long)(fTemp * rp.HeightInEMU);
}
ToAnchorColumnIndex = (int)Math.Floor(Chart.RightPosition);
fTemp = Chart.RightPosition - ToAnchorColumnIndex;
ToAnchorColumnOffset = (long)(fTemp * slws.SheetFormatProperties.DefaultColumnWidthInEMU);
if (slws.ColumnProperties.ContainsKey(ToAnchorColumnIndex + 1))
{
cp = slws.ColumnProperties[ToAnchorColumnIndex + 1];
if (cp.HasWidth) ToAnchorColumnOffset = (long)(fTemp * cp.WidthInEMU);
}
Xdr.TwoCellAnchor tcanchor = new Xdr.TwoCellAnchor();
tcanchor.FromMarker = new Xdr.FromMarker();
tcanchor.FromMarker.RowId = new Xdr.RowId(FromAnchorRowIndex.ToString(CultureInfo.InvariantCulture));
tcanchor.FromMarker.RowOffset = new Xdr.RowOffset(FromAnchorRowOffset.ToString(CultureInfo.InvariantCulture));
tcanchor.FromMarker.ColumnId = new Xdr.ColumnId(FromAnchorColumnIndex.ToString(CultureInfo.InvariantCulture));
tcanchor.FromMarker.ColumnOffset = new Xdr.ColumnOffset(FromAnchorColumnOffset.ToString(CultureInfo.InvariantCulture));
tcanchor.ToMarker = new Xdr.ToMarker();
tcanchor.ToMarker.RowId = new Xdr.RowId(ToAnchorRowIndex.ToString(CultureInfo.InvariantCulture));
tcanchor.ToMarker.RowOffset = new Xdr.RowOffset(ToAnchorRowOffset.ToString(CultureInfo.InvariantCulture));
tcanchor.ToMarker.ColumnId = new Xdr.ColumnId(ToAnchorColumnIndex.ToString(CultureInfo.InvariantCulture));
tcanchor.ToMarker.ColumnOffset = new Xdr.ColumnOffset(ToAnchorColumnOffset.ToString(CultureInfo.InvariantCulture));
tcanchor.Append(gf);
tcanchor.Append(new Xdr.ClientData());
wsd.Append(tcanchor);
wsd.Save(dp);
}
}
#endregion
#region Pictures
if (slws.Pictures.Count > 0)
{
foreach (Drawing.SLPicture Picture in slws.Pictures)
{
imgp = dp.AddImagePart(Picture.PictureImagePartType);
if (Picture.DataIsInFile)
{
using (FileStream fs = new FileStream(Picture.PictureFileName, FileMode.Open))
{
imgp.FeedData(fs);
}
}
else
{
using (MemoryStream ms = new MemoryStream(Picture.PictureByteData))
{
imgp.FeedData(ms);
}
}
Xdr.Picture pic = new Xdr.Picture();
pic.NonVisualPictureProperties = new Xdr.NonVisualPictureProperties();
pic.NonVisualPictureProperties.NonVisualDrawingProperties = new Xdr.NonVisualDrawingProperties();
pic.NonVisualPictureProperties.NonVisualDrawingProperties.Id = slws.NextWorksheetDrawingId;
++slws.NextWorksheetDrawingId;
// recommendation is to set as the actual filename, but we'll follow Excel here...
// Note: the name value can be used multiple times without Excel choking.
// So for example, you can have two pictures with "Picture 1".
pic.NonVisualPictureProperties.NonVisualDrawingProperties.Name = string.Format("Picture {0}", dp.ImageParts.Count());
pic.NonVisualPictureProperties.NonVisualDrawingProperties.Description = Picture.AlternativeText;
// hlinkClick and hlinkHover as children
if (Picture.HasUri)
{
HyperlinkRelationship hlinkrel = dp.AddHyperlinkRelationship(new System.Uri(Picture.HyperlinkUri, Picture.HyperlinkUriKind), Picture.IsHyperlinkExternal);
pic.NonVisualPictureProperties.NonVisualDrawingProperties.HyperlinkOnClick = new A.HyperlinkOnClick() { Id = hlinkrel.Id };
}
pic.NonVisualPictureProperties.NonVisualPictureDrawingProperties = new Xdr.NonVisualPictureDrawingProperties();
pic.BlipFill = new Xdr.BlipFill();
pic.BlipFill.Blip = new A.Blip();
pic.BlipFill.Blip.Embed = dp.GetIdOfPart(imgp);
if (Picture.CompressionState != A.BlipCompressionValues.None)
{
pic.BlipFill.Blip.CompressionState = Picture.CompressionState;
}
if (Picture.Brightness != 0 || Picture.Contrast != 0)
{
A.LuminanceEffect lumeffect = new A.LuminanceEffect();
if (Picture.Brightness != 0) lumeffect.Brightness = Convert.ToInt32(Picture.Brightness * 1000);
if (Picture.Contrast != 0) lumeffect.Contrast = Convert.ToInt32(Picture.Contrast * 1000);
pic.BlipFill.Blip.Append(lumeffect);
}
pic.BlipFill.SourceRectangle = new A.SourceRectangle();
pic.BlipFill.Append(new A.Stretch() { FillRectangle = new A.FillRectangle() });
pic.ShapeProperties = new Xdr.ShapeProperties();
pic.ShapeProperties.BlackWhiteMode = A.BlackWhiteModeValues.Auto;
pic.ShapeProperties.Transform2D = new A.Transform2D();
// not supporting yet because you need to change the positional offsets too.
//if (Picture.RotationAngle != 0)
//{
// pic.ShapeProperties.Transform2D.Rotation = Convert.ToInt32(Picture.RotationAngle * (decimal)SLConstants.DegreeToAngleRepresentation);
//}
pic.ShapeProperties.Transform2D.Offset = new A.Offset();
// used when it's relative positioning
// these are the actual values used, so it's 1 less than the given anchor indices.
int iColumnId = 0, iRowId = 0;
long lColumnOffset = 0, lRowOffset = 0;
if (Picture.UseRelativePositioning)
{
iColumnId = Picture.AnchorColumnIndex - 1;
iRowId = Picture.AnchorRowIndex - 1;
long lOffset = 0;
long lOffsetBuffer = 0;
int i;
if (iColumnId > 0)
{
for (i = 1; i <= iColumnId; ++i)
{
if (slws.ColumnProperties.ContainsKey(i))
{
cp = slws.ColumnProperties[i];
if (cp.HasWidth)
{
lOffsetBuffer += cp.WidthInEMU;
}
else
{
lOffsetBuffer += slws.SheetFormatProperties.DefaultColumnWidthInEMU;
}
}
else
{
// we use the current worksheet's column width
lOffsetBuffer += slws.SheetFormatProperties.DefaultColumnWidthInEMU;
}
}
}
lOffsetBuffer += Picture.OffsetX;
lOffset = lOffsetBuffer;
if (lOffset <= 0)
{
// in case the given offset is so negative, it pushes the sum to negative
// We use "<= 0" here, so the else part assumes a positive offset
iColumnId = 0;
lColumnOffset = 0;
}
else
{
lOffsetBuffer = 0;
i = 1;
while (lOffset > lOffsetBuffer)
{
iColumnId = i - 1;
lColumnOffset = lOffset - lOffsetBuffer;
if (slws.ColumnProperties.ContainsKey(i))
{
cp = slws.ColumnProperties[i];
if (cp.HasWidth)
{
lOffsetBuffer += cp.WidthInEMU;
}
else
{
lOffsetBuffer += slws.SheetFormatProperties.DefaultColumnWidthInEMU;
}
}
else
{
// we use the current worksheet's column width
lOffsetBuffer += slws.SheetFormatProperties.DefaultColumnWidthInEMU;
}
++i;
}
}
pic.ShapeProperties.Transform2D.Offset.X = lColumnOffset;
lOffsetBuffer = 0;
if (iRowId > 0)
{
for (i = 1; i <= iRowId; ++i)
{
if (slws.RowProperties.ContainsKey(i))
{
rp = slws.RowProperties[i];
if (rp.HasHeight)
{
lOffsetBuffer += rp.HeightInEMU;
}
else
{
lOffsetBuffer += slws.SheetFormatProperties.DefaultRowHeightInEMU;
}
}
else
{
// we use the current worksheet's row height
lOffsetBuffer += slws.SheetFormatProperties.DefaultRowHeightInEMU;
}
}
}
lOffsetBuffer += Picture.OffsetY;
lOffset = lOffsetBuffer;
if (lOffset <= 0)
{
// in case the given offset is so negative, it pushes the sum to negative
// We use "<= 0" here, so the else part assumes a positive offset
iRowId = 0;
lRowOffset = 0;
}
else
{
lOffsetBuffer = 0;
i = 1;
while (lOffset > lOffsetBuffer)
{
iRowId = i - 1;
lRowOffset = lOffset - lOffsetBuffer;
if (slws.RowProperties.ContainsKey(i))
{
rp = slws.RowProperties[i];
if (rp.HasHeight)
{
lOffsetBuffer += rp.HeightInEMU;
}
else
{
lOffsetBuffer += slws.SheetFormatProperties.DefaultRowHeightInEMU;
}
}
else
{
// we use the current worksheet's row height
lOffsetBuffer += slws.SheetFormatProperties.DefaultRowHeightInEMU;
}
++i;
}
}
pic.ShapeProperties.Transform2D.Offset.Y = lRowOffset;
}
else
{
pic.ShapeProperties.Transform2D.Offset.X = 0;
pic.ShapeProperties.Transform2D.Offset.Y = 0;
}
pic.ShapeProperties.Transform2D.Extents = new A.Extents();
pic.ShapeProperties.Transform2D.Extents.Cx = Picture.WidthInEMU;
pic.ShapeProperties.Transform2D.Extents.Cy = Picture.HeightInEMU;
pic.ShapeProperties.Append(new A.PresetGeometry() { Preset = Picture.PictureShape, AdjustValueList = new A.AdjustValueList() });
switch (Picture.FillType)
{
case Drawing.SLPicture.SLPictureFillType.None:
pic.ShapeProperties.Append(new A.NoFill());
break;
case Drawing.SLPicture.SLPictureFillType.Solid:
A.SolidFill solidfill = new A.SolidFill();
solidfill.InnerXml = Picture.FillClassInnerXml;
pic.ShapeProperties.Append(solidfill);
break;
default:
pic.ShapeProperties.Append(new A.NoFill());
break;
}
if (Picture.HasOutline)
{
A.Outline outline = new A.Outline();
if (Picture.PictureOutline.Width != null)
{
outline.Width = Picture.PictureOutline.Width.Value;
}
if (Picture.PictureOutline.CompoundLineType != null)
{
outline.CompoundLineType = Picture.PictureOutline.CompoundLineType.Value;
}
if (Picture.PictureOutline.CapType != null)
{
outline.CapType = Picture.PictureOutline.CapType.Value;
}
outline.Append((A.SolidFill)Picture.PictureOutlineFill.CloneNode(true));
foreach (var child in Picture.PictureOutlineFill.ChildElements)
{
if (child is A.PresetDash)
{
outline.Append((A.PresetDash)child.CloneNode(true));
}
else if (child is A.Round)
{
outline.Append((A.Round)child.CloneNode(true));
}
else if (child is A.Bevel)
{
outline.Append((A.Bevel)child.CloneNode(true));
}
else if (child is A.Miter)
{
outline.Append((A.Miter)child.CloneNode(true));
}
}
pic.ShapeProperties.Append(outline);
}
if (Picture.HasEffectList)
{
A.EffectList effectlist = new A.EffectList();
if (Picture.HasGlow)
{
A.Glow glow = new A.Glow();
glow.Radius = Picture.GlowRadius;
glow.InnerXml = Picture.GlowColorInnerXml;
effectlist.Append(glow);
}
if (Picture.HasInnerShadow)
{
effectlist.Append((A.InnerShadow)Picture.PictureInnerShadow.CloneNode(true));
}
if (Picture.HasOuterShadow)
{
effectlist.Append((A.OuterShadow)Picture.PictureOuterShadow.CloneNode(true));
}
if (Picture.HasReflection)
{
A.Reflection refl = new A.Reflection();
if (Picture.ReflectionBlurRadius != 0) refl.BlurRadius = Picture.ReflectionBlurRadius;
if (Picture.ReflectionStartOpacity != 100000) refl.StartOpacity = Picture.ReflectionStartOpacity;
if (Picture.ReflectionStartPosition != 0) refl.StartPosition = Picture.ReflectionStartPosition;
if (Picture.ReflectionEndAlpha != 0) refl.EndAlpha = Picture.ReflectionEndAlpha;
if (Picture.ReflectionEndPosition != 100000) refl.EndPosition = Picture.ReflectionEndPosition;
if (Picture.ReflectionDistance != 0) refl.Distance = Picture.ReflectionDistance;
if (Picture.ReflectionDirection != 0) refl.Direction = Picture.ReflectionDirection;
if (Picture.ReflectionFadeDirection != 5400000) refl.FadeDirection = Picture.ReflectionFadeDirection;
if (Picture.ReflectionHorizontalRatio != 100000) refl.HorizontalRatio = Picture.ReflectionHorizontalRatio;
if (Picture.ReflectionVerticalRatio != 100000) refl.VerticalRatio = Picture.ReflectionVerticalRatio;
if (Picture.ReflectionHorizontalSkew != 0) refl.HorizontalSkew = Picture.ReflectionHorizontalSkew;
if (Picture.ReflectionVerticalSkew != 0) refl.VerticalSkew = Picture.ReflectionVerticalSkew;
if (Picture.ReflectionAlignment != A.RectangleAlignmentValues.Bottom) refl.Alignment = Picture.ReflectionAlignment;
if (!Picture.ReflectionRotateWithShape) refl.RotateWithShape = false;
effectlist.Append(refl);
}
if (Picture.HasSoftEdge)
{
A.SoftEdge softedge = new A.SoftEdge();
softedge.Radius = Picture.SoftEdgeRadius;
effectlist.Append(softedge);
}
pic.ShapeProperties.Append(effectlist);
}
if (Picture.HasScene3D)
{
A.Scene3DType scene3d = new A.Scene3DType();
scene3d.Camera = new A.Camera();
scene3d.Camera.Preset = Picture.CameraPreset;
scene3d.Camera.FieldOfView = Picture.CameraFieldOfView;
// default is 100%
if (Picture.CameraZoom != 100000)
{
scene3d.Camera.Zoom = Picture.CameraZoom;
}
if (Picture.CameraLatitude != 0 || Picture.CameraLongitude != 0 || Picture.CameraRevolution != 0)
{
scene3d.Camera.Rotation = new A.Rotation();
scene3d.Camera.Rotation.Latitude = Picture.CameraLatitude;
scene3d.Camera.Rotation.Longitude = Picture.CameraLongitude;
scene3d.Camera.Rotation.Revolution = Picture.CameraRevolution;
}
scene3d.LightRig = new A.LightRig();
scene3d.LightRig.Rig = Picture.LightRigType;
scene3d.LightRig.Direction = Picture.LightRigDirection;
if (Picture.LightRigLatitude != 0 || Picture.LightRigLongitude != 0 || Picture.LightRigRevolution != 0)
{
scene3d.LightRig.Rotation = new A.Rotation();
scene3d.LightRig.Rotation.Latitude = Picture.LightRigLatitude;
scene3d.LightRig.Rotation.Longitude = Picture.LightRigLongitude;
scene3d.LightRig.Rotation.Revolution = Picture.LightRigRevolution;
}
pic.ShapeProperties.Append(scene3d);
}
if (Picture.HasShape3D)
{
A.Shape3DType shape3d = new A.Shape3DType();
if (Picture.HasBevelTop)
{
shape3d.BevelTop = new A.BevelTop();
shape3d.BevelTop.Preset = Picture.BevelTopPreset;
shape3d.BevelTop.Width = Picture.BevelTopWidth;
shape3d.BevelTop.Height = Picture.BevelTopHeight;
}
if (Picture.HasBevelBottom)
{
shape3d.BevelBottom = new A.BevelBottom();
shape3d.BevelBottom.Preset = Picture.BevelBottomPreset;
shape3d.BevelBottom.Width = Picture.BevelBottomWidth;
shape3d.BevelBottom.Height = Picture.BevelBottomHeight;
}
if (Picture.HasExtrusion)
{
A.ExtrusionColor extcolor = new A.ExtrusionColor();
extcolor.InnerXml = Picture.ExtrusionColorInnerXml;
shape3d.ExtrusionColor = extcolor;
shape3d.ExtrusionHeight = Picture.ExtrusionHeight;
}
if (Picture.HasContour)
{
A.ContourColor contourcolor = new A.ContourColor();
contourcolor.InnerXml = Picture.ContourColorInnerXml;
shape3d.ContourColor = contourcolor;
shape3d.ContourWidth = Picture.ContourWidth;
}
if (Picture.HasMaterialType)
{
shape3d.PresetMaterial = Picture.MaterialType;
}
if (Picture.HasZDistance)
{
shape3d.Z = Picture.ZDistance;
}
pic.ShapeProperties.Append(shape3d);
}
Xdr.ClientData clientdata = new Xdr.ClientData();
// the properties are true by default
if (!Picture.LockWithSheet) clientdata.LockWithSheet = false;
if (!Picture.PrintWithSheet) clientdata.PrintWithSheet = false;
if (Picture.UseRelativePositioning)
{
Xdr.OneCellAnchor ocanchor = new Xdr.OneCellAnchor();
ocanchor.FromMarker = new Xdr.FromMarker();
// Subtract 1 because picture goes to bottom right corner
// Subtracting 1 makes it more intuitive that (1,1) means top-left corner of (1,1)
ocanchor.FromMarker.ColumnId = new Xdr.ColumnId() { Text = iColumnId.ToString(CultureInfo.InvariantCulture) };
ocanchor.FromMarker.ColumnOffset = new Xdr.ColumnOffset() { Text = lColumnOffset.ToString(CultureInfo.InvariantCulture) };
ocanchor.FromMarker.RowId = new Xdr.RowId() { Text = iRowId.ToString(CultureInfo.InvariantCulture) };
ocanchor.FromMarker.RowOffset = new Xdr.RowOffset() { Text = lRowOffset.ToString(CultureInfo.InvariantCulture) };
ocanchor.Extent = new Xdr.Extent();
ocanchor.Extent.Cx = Picture.WidthInEMU;
ocanchor.Extent.Cy = Picture.HeightInEMU;
ocanchor.Append(pic);
ocanchor.Append(clientdata);
wsd.Append(ocanchor);
}
else
{
Xdr.AbsoluteAnchor absanchor = new Xdr.AbsoluteAnchor();
absanchor.Position = new Xdr.Position();
absanchor.Position.X = Picture.OffsetX;
absanchor.Position.Y = Picture.OffsetY;
absanchor.Extent = new Xdr.Extent();
absanchor.Extent.Cx = Picture.WidthInEMU;
absanchor.Extent.Cy = Picture.HeightInEMU;
absanchor.Append(pic);
absanchor.Append(clientdata);
wsd.Append(absanchor);
}
wsd.Save(dp);
}
}
#endregion
}
private static void GeneratePartContentPie(DrawingsPart part, ChartPart chartPart1, int row, bool newe)
{
Xdr.WorksheetDrawing worksheetDrawing1 = new Xdr.WorksheetDrawing();
if (newe)
{
worksheetDrawing1.AddNamespaceDeclaration("xdr", "http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing");
worksheetDrawing1.AddNamespaceDeclaration("a", "http://schemas.openxmlformats.org/drawingml/2006/main");
worksheetDrawing1.AddNamespaceDeclaration("r", "http://schemas.openxmlformats.org/officeDocument/2006/relationships");
worksheetDrawing1.AddNamespaceDeclaration("c", "http://schemas.openxmlformats.org/drawingml/2006/chart");
worksheetDrawing1.AddNamespaceDeclaration("cx", "http://schemas.microsoft.com/office/drawing/2014/chartex");
worksheetDrawing1.AddNamespaceDeclaration("cx1", "http://schemas.microsoft.com/office/drawing/2015/9/8/chartex");
worksheetDrawing1.AddNamespaceDeclaration("mc", "http://schemas.openxmlformats.org/markup-compatibility/2006");
worksheetDrawing1.AddNamespaceDeclaration("dgm", "http://schemas.openxmlformats.org/drawingml/2006/diagram");
}
Xdr.OneCellAnchor oneCellAnchor1 = new Xdr.OneCellAnchor();
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 = row.ToString();
Xdr.RowOffset rowOffset1 = new Xdr.RowOffset();
rowOffset1.Text = "0";
fromMarker1.Append(columnId1);
fromMarker1.Append(columnOffset1);
fromMarker1.Append(rowId1);
fromMarker1.Append(rowOffset1);
Xdr.Extent extent1 = new Xdr.Extent()
{
Cx = 5743575L, Cy = 2667000L
};
Xdr.GraphicFrame graphicFrame1 = new Xdr.GraphicFrame();
Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties1 = new Xdr.NonVisualGraphicFrameProperties();
Xdr.NonVisualDrawingProperties nonVisualDrawingProperties1 = new Xdr.NonVisualDrawingProperties()
{
Id = (UInt32Value)(uint)row, Name = "Chart " + row.ToString()
};
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/chart"
};
C.ChartReference chartReference1 = new C.ChartReference()
{
Id = part.GetIdOfPart(chartPart1)
};
graphicData1.Append(chartReference1);
graphic1.Append(graphicData1);
graphicFrame1.Append(nonVisualGraphicFrameProperties1);
graphicFrame1.Append(transform1);
graphicFrame1.Append(graphic1);
Xdr.ClientData clientData1 = new Xdr.ClientData()
{
LockWithSheet = false
};
oneCellAnchor1.Append(fromMarker1);
oneCellAnchor1.Append(extent1);
oneCellAnchor1.Append(graphicFrame1);
oneCellAnchor1.Append(clientData1);
if (newe)
{
worksheetDrawing1.Append(oneCellAnchor1);
part.WorksheetDrawing = worksheetDrawing1;
}
else
{
part.WorksheetDrawing.Append(oneCellAnchor1);
}
}
// 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 = "6";
Xdr.ColumnOffset columnOffset9 = new Xdr.ColumnOffset();
columnOffset9.Text = "571500";
Xdr.RowId rowId9 = new Xdr.RowId();
rowId9.Text = "5";
Xdr.RowOffset rowOffset9 = new Xdr.RowOffset();
rowOffset9.Text = "147637";
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 = "14";
Xdr.ColumnOffset columnOffset10 = new Xdr.ColumnOffset();
columnOffset10.Text = "266700";
Xdr.RowId rowId10 = new Xdr.RowId();
rowId10.Text = "20";
Xdr.RowOffset rowOffset10 = new Xdr.RowOffset();
rowOffset10.Text = "33337";
toMarker5.Append(columnId10);
toMarker5.Append(columnOffset10);
toMarker5.Append(rowId10);
toMarker5.Append(rowOffset10);
Xdr.GraphicFrame graphicFrame2 = new Xdr.GraphicFrame() { Macro = "" };
Xdr.NonVisualGraphicFrameProperties nonVisualGraphicFrameProperties2 = new Xdr.NonVisualGraphicFrameProperties();
Xdr.NonVisualDrawingProperties nonVisualDrawingProperties11 = new Xdr.NonVisualDrawingProperties() { Id = (UInt32Value)2U, Name = "Chart 1" };
Xdr.NonVisualGraphicFrameDrawingProperties nonVisualGraphicFrameDrawingProperties2 = new Xdr.NonVisualGraphicFrameDrawingProperties();
nonVisualGraphicFrameProperties2.Append(nonVisualDrawingProperties11);
nonVisualGraphicFrameProperties2.Append(nonVisualGraphicFrameDrawingProperties2);
Xdr.Transform transform2 = new Xdr.Transform();
A.Offset offset15 = new A.Offset() { X = 0L, Y = 0L };
A.Extents extents15 = new A.Extents() { Cx = 0L, Cy = 0L };
transform2.Append(offset15);
transform2.Append(extents15);
A.Graphic graphic2 = new A.Graphic();
A.GraphicData graphicData2 = 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");
graphicData2.Append(chartReference1);
graphic2.Append(graphicData2);
graphicFrame2.Append(nonVisualGraphicFrameProperties2);
graphicFrame2.Append(transform2);
graphicFrame2.Append(graphic2);
Xdr.ClientData clientData5 = new Xdr.ClientData();
twoCellAnchor5.Append(fromMarker5);
twoCellAnchor5.Append(toMarker5);
twoCellAnchor5.Append(graphicFrame2);
twoCellAnchor5.Append(clientData5);
Xdr.OneCellAnchor oneCellAnchor1 = new Xdr.OneCellAnchor();
Xdr.FromMarker fromMarker6 = new Xdr.FromMarker();
Xdr.ColumnId columnId11 = new Xdr.ColumnId();
columnId11.Text = "17";
Xdr.ColumnOffset columnOffset11 = new Xdr.ColumnOffset();
columnOffset11.Text = "186742";
Xdr.RowId rowId11 = new Xdr.RowId();
rowId11.Text = "11";
Xdr.RowOffset rowOffset11 = new Xdr.RowOffset();
rowOffset11.Text = "174123";
fromMarker6.Append(columnId11);
fromMarker6.Append(columnOffset11);
fromMarker6.Append(rowId11);
fromMarker6.Append(rowOffset11);
Xdr.Extent extent1 = new Xdr.Extent() { Cx = 3627019L, Cy = 937629L };
Xdr.Shape shape11 = new Xdr.Shape() { Macro = "", TextLink = "" };
Xdr.NonVisualShapeProperties nonVisualShapeProperties3 = new Xdr.NonVisualShapeProperties();
Xdr.NonVisualDrawingProperties nonVisualDrawingProperties12 = new Xdr.NonVisualDrawingProperties() { Id = (UInt32Value)3U, Name = "Rectangle 2" };
Xdr.NonVisualShapeDrawingProperties nonVisualShapeDrawingProperties3 = new Xdr.NonVisualShapeDrawingProperties();
nonVisualShapeProperties3.Append(nonVisualDrawingProperties12);
nonVisualShapeProperties3.Append(nonVisualShapeDrawingProperties3);
Xdr.ShapeProperties shapeProperties35 = new Xdr.ShapeProperties();
A.Transform2D transform2D14 = new A.Transform2D() { Rotation = 1966164 };
A.Offset offset16 = new A.Offset() { X = 10549942L, Y = 3793623L };
A.Extents extents16 = new A.Extents() { Cx = 3627019L, Cy = 937629L };
transform2D14.Append(offset16);
transform2D14.Append(extents16);
A.PresetGeometry presetGeometry9 = new A.PresetGeometry() { Preset = A.ShapeTypeValues.Rectangle };
A.AdjustValueList adjustValueList9 = new A.AdjustValueList();
presetGeometry9.Append(adjustValueList9);
A.NoFill noFill1 = new A.NoFill();
shapeProperties35.Append(transform2D14);
shapeProperties35.Append(presetGeometry9);
shapeProperties35.Append(noFill1);
Xdr.TextBody textBody24 = new Xdr.TextBody();
A.BodyProperties bodyProperties24 = new A.BodyProperties() { Wrap = A.TextWrappingValues.None, LeftInset = 91440, TopInset = 45720, RightInset = 91440, BottomInset = 45720 };
A.ShapeAutoFit shapeAutoFit1 = new A.ShapeAutoFit();
bodyProperties24.Append(shapeAutoFit1);
A.ListStyle listStyle24 = new A.ListStyle();
A.Paragraph paragraph24 = new A.Paragraph();
A.ParagraphProperties paragraphProperties7 = new A.ParagraphProperties() { Alignment = A.TextAlignmentTypeValues.Center };
A.Run run12 = new A.Run();
A.RunProperties runProperties12 = new A.RunProperties() { Language = "en-US", FontSize = 5400, Bold = true, Capital = A.TextCapsValues.None, Spacing = 0 };
A.Outline outline10 = new A.Outline() { Width = 22225 };
A.SolidFill solidFill18 = new A.SolidFill();
A.SchemeColor schemeColor191 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent2 };
solidFill18.Append(schemeColor191);
A.PresetDash presetDash9 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
outline10.Append(solidFill18);
outline10.Append(presetDash9);
A.SolidFill solidFill19 = new A.SolidFill();
A.SchemeColor schemeColor192 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent2 };
A.LuminanceModulation luminanceModulation1 = new A.LuminanceModulation() { Val = 40000 };
A.LuminanceOffset luminanceOffset11 = new A.LuminanceOffset() { Val = 60000 };
schemeColor192.Append(luminanceModulation1);
schemeColor192.Append(luminanceOffset11);
solidFill19.Append(schemeColor192);
A.EffectList effectList9 = new A.EffectList();
runProperties12.Append(outline10);
runProperties12.Append(solidFill19);
runProperties12.Append(effectList9);
A.Text text12 = new A.Text();
text12.Text = "Hello";
run12.Append(runProperties12);
run12.Append(text12);
A.Run run13 = new A.Run();
A.RunProperties runProperties13 = new A.RunProperties() { Language = "en-US", FontSize = 5400, Bold = true, Capital = A.TextCapsValues.None, Spacing = 0, Baseline = 0 };
A.Outline outline11 = new A.Outline() { Width = 22225 };
A.SolidFill solidFill20 = new A.SolidFill();
A.SchemeColor schemeColor193 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent2 };
solidFill20.Append(schemeColor193);
A.PresetDash presetDash10 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
outline11.Append(solidFill20);
outline11.Append(presetDash10);
A.SolidFill solidFill21 = new A.SolidFill();
A.SchemeColor schemeColor194 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent2 };
A.LuminanceModulation luminanceModulation2 = new A.LuminanceModulation() { Val = 40000 };
A.LuminanceOffset luminanceOffset12 = new A.LuminanceOffset() { Val = 60000 };
schemeColor194.Append(luminanceModulation2);
schemeColor194.Append(luminanceOffset12);
solidFill21.Append(schemeColor194);
A.EffectList effectList10 = new A.EffectList();
runProperties13.Append(outline11);
runProperties13.Append(solidFill21);
runProperties13.Append(effectList10);
A.Text text13 = new A.Text();
text13.Text = " World";
run13.Append(runProperties13);
run13.Append(text13);
A.EndParagraphRunProperties endParagraphRunProperties13 = new A.EndParagraphRunProperties() { Language = "en-US", FontSize = 5400, Bold = true, Capital = A.TextCapsValues.None, Spacing = 0 };
A.Outline outline12 = new A.Outline() { Width = 22225 };
A.SolidFill solidFill22 = new A.SolidFill();
A.SchemeColor schemeColor195 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent2 };
solidFill22.Append(schemeColor195);
A.PresetDash presetDash11 = new A.PresetDash() { Val = A.PresetLineDashValues.Solid };
outline12.Append(solidFill22);
outline12.Append(presetDash11);
A.SolidFill solidFill23 = new A.SolidFill();
A.SchemeColor schemeColor196 = new A.SchemeColor() { Val = A.SchemeColorValues.Accent2 };
A.LuminanceModulation luminanceModulation3 = new A.LuminanceModulation() { Val = 40000 };
A.LuminanceOffset luminanceOffset13 = new A.LuminanceOffset() { Val = 60000 };
schemeColor196.Append(luminanceModulation3);
schemeColor196.Append(luminanceOffset13);
solidFill23.Append(schemeColor196);
A.EffectList effectList11 = new A.EffectList();
endParagraphRunProperties13.Append(outline12);
endParagraphRunProperties13.Append(solidFill23);
endParagraphRunProperties13.Append(effectList11);
paragraph24.Append(paragraphProperties7);
paragraph24.Append(run12);
paragraph24.Append(run13);
paragraph24.Append(endParagraphRunProperties13);
textBody24.Append(bodyProperties24);
textBody24.Append(listStyle24);
textBody24.Append(paragraph24);
shape11.Append(nonVisualShapeProperties3);
shape11.Append(shapeProperties35);
shape11.Append(textBody24);
Xdr.ClientData clientData6 = new Xdr.ClientData();
oneCellAnchor1.Append(fromMarker6);
oneCellAnchor1.Append(extent1);
oneCellAnchor1.Append(shape11);
oneCellAnchor1.Append(clientData6);
worksheetDrawing2.Append(twoCellAnchor5);
worksheetDrawing2.Append(oneCellAnchor1);
drawingsPart2.WorksheetDrawing = worksheetDrawing2;
}