ExcelPicture Class

Represents a picture in the worksheet.

Inheritance Hierarchy

SystemObject
GemBox.SpreadsheetExcelDrawing
GemBox.SpreadsheetExcelPicture

Namespace: GemBox.Spreadsheet
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 43.0.35.1115

Syntax

Copy

public sealed class ExcelPicture : ExcelDrawing

Public NotInheritable Class ExcelPicture
	Inherits ExcelDrawing

The ExcelPicture type exposes the following members.

Properties

	Name	Description
	BottomRightCell	Obsolete. This property is obsolete. Use Position property and its To property instead. Gets or sets the bottom right anchor cell for the picture.
	BoundingRectangle	Obsolete. This property is obsolete. Use Position property and its GetLeft(LengthUnit), GetTop(LengthUnit), GetWidth(LengthUnit) and GetHeight(LengthUnit) methods instead. Gets the image bounding rectangle.
	HasHyperlink	Obsolete. Gets a value indicating whether this drawing (picture, chart, etc.) has hyperlink. (Inherited from ExcelDrawing.)
	Hyperlink	Gets or sets the hyperlink on this drawing (picture, chart, etc.). (Inherited from ExcelDrawing.)
	Image	Obsolete. This property is obsolete. Use ToImage method instead. Gets the picture as Image.
	ImageStream	Obsolete. This property is obsolete. Use PictureStream property instead. Gets the image stream.
	Metadata	Gets the metadata (non-visual properties) of this ExcelDrawing instance. (Inherited from ExcelDrawing.)
	PictureFormat	Gets the picture format.
	PictureStream	Gets the picture stream.
	Position	Gets the position of this drawing (picture, chart, etc.) in the worksheet. (Inherited from ExcelDrawing.)
	Positioning	Obsolete. This property is obsolete. Use Position property and its Mode property instead. Gets or sets the positioning options of the picture.
	TopLeftCell	Obsolete. This property is obsolete. Use Position property and its From property instead. Gets or sets the top left anchor cell for the picture.

Top

Methods

	Name	Description
	Delete	Removes this ExcelPicture instance from the worksheet.
	Format	Formats this drawing (picture, chart, etc.) to its default size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing.)
	Format(Double, Double, LengthUnit)	Formats this drawing (picture, chart, etc.) to specified size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing.)
	ToImage	Converts this ExcelPicture instance to a new Image instance.
	ToString	Returns a String that represents this ExcelPicture instance. (Overrides ObjectToString.)

Top

Examples

Following code demonstrates how to use images:

Copy

sheet.Pictures.Add("Image.bmp", 10, 50, 100, 100, LengthUnit.Pixel);
sheet.Pictures.Add("Image.bmp", 10, 50, 100, 100, LengthUnit.Pixel).Position.Mode = PositioningMode.Move;
sheet.Pictures.Add("Image.bmp", "A2").Position.Mode = PositioningMode.MoveAndSize;
sheet.Pictures.Add("Image.bmp", new AnchorCell(sheet.Columns[0], sheet.Rows[1], 10, 10, LengthUnit.Pixel), new AnchorCell(sheet.Columns[3], sheet.Rows[3], false));

// NOTE: pictureStream must not be disposed while it is still used by ExcelFile or exception will be thrown.
var pictureStream = new MemoryStream(File.ReadAllBytes("Image.bmp"));

// Picture format needs to be specified when adding from stream.
sheet.Pictures.Add(pictureStream, ExcelPictureFormat.Bmp, new AnchorCell(sheet.Columns[0], sheet.Rows[1], 10, 10, LengthUnit.Pixel), new AnchorCell(sheet.Columns[3], sheet.Rows[3], false));

sheet.Pictures.Add("Image.bmp", 10, 50, 100, 100, LengthUnit.Pixel)
sheet.Pictures.Add("Image.bmp", 10, 50, 100, 100, LengthUnit.Pixel).Position.Mode = PositioningMode.Move
sheet.Pictures.Add("Image.bmp", "A2").Position.Mode = PositioningMode.MoveAndSize
sheet.Pictures.Add("Image.bmp", New AnchorCell(sheet.Columns(0), sheet.Rows(1), 10, 10, LengthUnit.Pixel), New AnchorCell(sheet.Columns(3), sheet.Rows(3), False))

' NOTE: pictureStream must not be disposed while it is still used by ExcelFile or exception will be thrown.
Dim pictureStream = New MemoryStream(File.ReadAllBytes("Image.bmp"))

' Picture format needs to be specified when adding from stream.
sheet.Pictures.Add(pictureStream, ExcelPictureFormat.Bmp, New AnchorCell(sheet.Columns(0), sheet.Rows(1), 10, 10, LengthUnit.Pixel), New AnchorCell(sheet.Columns(3), sheet.Rows(3), False))

Reference

GemBox.Spreadsheet Namespace

ExcelWorksheet.Pictures