/// <summary>
/// Adds a picture to the worksheet
/// </summary>
/// <param name="Name"></param>
/// <param name="ImageFile">The image file</param>
/// <param name="Hyperlink">Picture Hyperlink</param>
/// <returns>A picture object</returns>
public ExcelPicture AddPicture(string Name, FileInfo ImageFile, Uri Hyperlink)
{
ValidatePictureFile(Name, ImageFile);
XmlElement drawNode = CreateDrawingXml(eEditAs.OneCell);
var type = PictureStore.GetPictureType(ImageFile.Extension);
var pic = new ExcelPicture(this, drawNode, Hyperlink);
pic.LoadImage(new FileStream(ImageFile.FullName, FileMode.Open, FileAccess.Read), type);
AddPicture(Name, pic);
return(pic);
}
/// <summary>
/// Adds a picture to the worksheet
/// </summary>
/// <param name="Name"></param>
/// <param name="pictureStream">An stream image.</param>
/// <param name="pictureType">The type of image</param>
/// <param name="Hyperlink">Picture Hyperlink</param>
/// <returns>A picture object</returns>
public ExcelPicture AddPicture(string Name, Stream pictureStream, ePictureType pictureType, Uri Hyperlink)
{
if (pictureStream == null)
{
throw (new ArgumentNullException("Stream can not be null"));
}
if (!pictureStream.CanRead || !pictureStream.CanSeek)
{
throw (new IOException("Stream must be readable and seekable"));
}
XmlElement drawNode = CreateDrawingXml(eEditAs.OneCell);
var pic = new ExcelPicture(this, drawNode, Hyperlink);
pic.LoadImage(pictureStream, pictureType);
AddPicture(Name, pic);
return(pic);
}