Class Picture
Contents
[
Hide
]Picture class
Encapsulates the object that represents a single picture in a spreadsheet.
public class Picture : Shape
Properties
Name | Description |
---|---|
ActiveXControl { get; } | Gets the ActiveX control.(Inherited from Shape .) |
ActualLowerRightRow { get; } | Get the actual bottom row.(Inherited from Shape .) |
AlternativeText { get; set; } | Returns or sets the descriptive (alternative) text string of the Shape object.(Inherited from Shape .) |
AnchorType { get; set; } | Gets and set the type of the shape anchor placeholder.(Inherited from Shape .) |
AutoShapeType { get; set; } | Gets and sets the auto shape type.(Inherited from Shape .) |
BorderLineColor { get; set; } | Represents the Color of the border line of a picture. |
BorderWeight { get; set; } | Gets or sets the weight of the border line of a picture in units of pt. |
Bottom { get; set; } | Represents the width of the shape’s vertical offset from its lower bottom corner row, in unit of pixels.(Inherited from Shape .) |
ControlData { get; } | Gets the data of control.(Inherited from Shape .) |
CreateId { get; set; } | Gets and sets create id for this shape.(Inherited from Shape .) |
Data { get; set; } | Gets the data of the picture. |
DisplayAsIcon { get; set; } | True if the specified object is displayed as an icon and the image will not be auto changed. |
Fill { get; } | Returns a FillFormat object that contains fill formatting properties for the specified shape.(Inherited from Shape .) |
FillFormat { get; } | (Obsolete.) Returns a MsoFillFormat object that contains fill formatting properties for the specified shape.(Inherited from Shape .) |
Font { get; set; } | Represents the font of shape.(Inherited from Shape .) |
FormatPicture { get; } | Gets and sets the options of the picture format.(Inherited from Shape .) |
Formula { get; set; } | Gets and sets the data of the formula. |
Geometry { get; } | Gets the geometry(Inherited from Shape .) |
Glow { get; } | Represents a GlowEffect object that specifies glow effect for the chart element or shape.(Inherited from Shape .) |
Group { get; } | Gets the group shape which contains this shape.(Inherited from Shape .) |
HasLine { get; set; } | Gets and sets the line border of the shape is visible.(Inherited from Shape .) |
Height { get; set; } | Represents the height of shape, in unit of pixel.(Inherited from Shape .) |
HeightCM { get; set; } | Represents the height of the shape, in unit of centimeters.(Inherited from Shape .) |
HeightInch { get; set; } | Represents the height of the shape, in unit of inches.(Inherited from Shape .) |
HeightInShape { get; set; } | Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape..(Inherited from Shape .) |
HeightPt { get; set; } | Represents the height of the shape, in unit of points.(Inherited from Shape .) |
HeightScale { get; set; } | Gets and sets the height scale,in unit of percent of the original picture height. If the shape is not picture ,the HeightScale property only returns 100;(Inherited from Shape .) |
HtmlText { get; set; } | Gets and sets the html string which contains data and some formats in this textbox.(Inherited from Shape .) |
Hyperlink { get; } | Gets the hyperlink of the shape.(Inherited from Shape .) |
Id { get; } | Gets the identifier of this shape.(Inherited from Shape .) |
ImageType { get; } | Gets the image format of the picture. |
InputRange { get; set; } | Gets or sets the worksheet range used to fill the specified combo box.(Inherited from Shape .) |
IsAspectRatioLocked { get; set; } | True means that aspect ratio of the shape is locked.(Inherited from Shape .) |
IsAutoSize { get; set; } | True indicates that the size of the ole object will be auto changed as the size of snapshot of the embedded content when the ole object is activated. |
IsDecorative { get; set; } | Indicates whether the object is decorative.(Inherited from Shape .) |
IsDynamicDataExchange { get; set; } | Gets or sets whether dynamic data exchange |
IsEquation { get; } | Indicates whether the shape only contains an equation.(Inherited from Shape .) |
IsFilled { get; set; } | Indicates whether the fill format is visible.(Inherited from Shape .) |
IsFlippedHorizontally { get; set; } | Gets and sets whether shape is horizontally flipped .(Inherited from Shape .) |
IsFlippedVertically { get; set; } | Gets and sets whether shape is vertically flipped .(Inherited from Shape .) |
IsGroup { get; } | Indicates whether this shape is a group shape.(Inherited from Shape .) |
IsHidden { get; set; } | Indicates whether the object is visible.(Inherited from Shape .) |
IsInGroup { get; } | Indicates whether the shape is grouped.(Inherited from Shape .) |
IsLink { get; set; } | Returns true if the picture is linked to a file. |
IsLockAspectRatio { get; set; } | (Obsolete.) True means that aspect ratio of the shape is locked.(Inherited from Shape .) |
IsLocked { get; set; } | True means the object can not be modified when the sheet is protected. Note that this value is meaningful only if the worksheet or objects in the worksheet are protected.(Inherited from Shape .) |
IsPrintable { get; set; } | Indicates whether the object is printable. If False, this shape will not be printed when printing.(Inherited from Shape .) |
IsRichText { get; } | Whether or not the text is rich text.(Inherited from Shape .) |
IsSmartArt { get; } | Indicates whether the shape is a smart art.(Inherited from Shape .) |
IsTextWrapped { get; set; } | Gets and sets the text wrapped type of the shape which contains text.(Inherited from Shape .) |
IsWordArt { get; } | Indicates whether this shape is a word art.(Inherited from Shape .) |
Left { get; set; } | Represents the horizontal offset of shape from its left column, in unit of pixels.(Inherited from Shape .) |
LeftCM { get; set; } | Represents the horizontal offset of shape from its left column, in unit of centimeters.(Inherited from Shape .) |
LeftInch { get; set; } | Represents the horizontal offset of shape from its left column, in unit of inches.(Inherited from Shape .) |
LeftInShape { get; set; } | Represents the horizontal offset of shape from the left border of the parent shape, in unit of 1/4000 of width of the parent shape.(Inherited from Shape .) |
LeftToCorner { get; set; } | Gets and sets the horizonal offset of shape from worksheet left border.(Inherited from Shape .) |
Line { get; } | Gets line style(Inherited from Shape .) |
LineFormat { get; } | (Obsolete.) Returns a MsoLineFormat object that contains line formatting properties for the specified shape.(Inherited from Shape .) |
LinkedCell { get; set; } | Gets or sets the worksheet range linked to the control’s value.(Inherited from Shape .) |
LowerDeltaX { get; set; } | Gets or sets the shape’s horizontal offset from its lower right corner column.(Inherited from Shape .) |
LowerDeltaY { get; set; } | Gets or sets the shape’s vertical offset from its lower right corner row.(Inherited from Shape .) |
LowerRightColumn { get; set; } | Represents lower right corner column index.(Inherited from Shape .) |
LowerRightRow { get; set; } | Represents lower right corner row index.(Inherited from Shape .) |
MacroName { get; set; } | Gets and sets the name of macro.(Inherited from Shape .) |
MsoDrawingType { get; } | Gets drawing type.(Inherited from Shape .) |
Name { get; set; } | Gets and sets the name of the shape.(Inherited from Shape .) |
OriginalHeight { get; } | Gets the original height of the picture. |
OriginalHeightCM { get; } | Gets the original height of picture, in unit of centimeters. |
OriginalHeightInch { get; } | Gets the original height of picture, in unit of inches. |
OriginalWidth { get; } | Gets the original width of the picture. |
OriginalWidthCM { get; } | Gets the original width of picture, in unit of centimeters. |
OriginalWidthInch { get; } | Gets the original width of picture, in unit of inches. |
Paths { get; } | Gets the paths of a custom geometric shape.(Inherited from Shape .) |
Placement { get; set; } | Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.(Inherited from Shape .) |
Reflection { get; } | Represents a ReflectionEffect object that specifies reflection effect for the chart element or shape.(Inherited from Shape .) |
RelativeToOriginalPictureSize { get; set; } | Indicates whether shape is relative to original picture size.(Inherited from Shape .) |
Right { get; set; } | Represents the width of the shape’s horizontal offset from its lower right corner column, in unit of pixels.(Inherited from Shape .) |
RotationAngle { get; set; } | Gets and sets the rotation of the shape.(Inherited from Shape .) |
ShadowEffect { get; } | Represents a ShadowEffect object that specifies shadow effect for the chart element or shape.(Inherited from Shape .) |
SignatureLine { get; set; } | Gets and sets the signature line |
SoftEdges { get; set; } | Gets and sets the radius of blur to apply to the edges, in unit of points.(Inherited from Shape .) |
SourceFullName { get; set; } | Gets or sets the path and name of the source file for the linked image. |
Spid { get; } | Specifies an optional string identifier that an application can use to identify the particular shape.(Inherited from Shape .) |
Spt { get; } | Specifies an optional number that an application can use to associate the particular shape with a defined shape type.(Inherited from Shape .) |
Text { get; set; } | Gets and sets the text of this shape.(Inherited from Shape .) |
TextBody { get; } | Gets and sets the setting of the shape’s text.(Inherited from Shape .) |
TextDirection { get; set; } | Gets/Sets the direction of the text flow for this object.(Inherited from Shape .) |
TextEffect { get; } | Returns a TextEffectFormat object that contains text-effect formatting properties for the specified shape. Applies to Shape objects that represent WordArt.(Inherited from Shape .) |
TextHorizontalAlignment { get; set; } | Gets and sets the text horizontal alignment type of the shape.(Inherited from Shape .) |
TextHorizontalOverflow { get; set; } | Gets and sets the text horizontal overflow type of the shape which contains text.(Inherited from Shape .) |
TextOptions { get; set; } | Represents the text options of the shape.(Inherited from Shape .) |
TextOrientationType { get; set; } | Gets and sets the text orientation type of the shape.(Inherited from Shape .) |
TextShapeType { get; set; } | Gets and sets the preset text shape type.(Inherited from Shape .) |
TextVerticalAlignment { get; set; } | Gets and sets the text vertical alignment type of the shape.(Inherited from Shape .) |
TextVerticalOverflow { get; set; } | Gets and sets the text vertical overflow type of the shape which contains text.(Inherited from Shape .) |
ThreeDFormat { get; } | Gets and sets 3d format of the shape.(Inherited from Shape .) |
Title { get; set; } | Specifies the title (caption) of the current shape object.(Inherited from Shape .) |
Top { get; set; } | Represents the vertical offset of shape from its top row, in unit of pixels.(Inherited from Shape .) |
TopCM { get; set; } | Represents the vertical offset of shape from its top row, in unit of centimeters.(Inherited from Shape .) |
TopInch { get; set; } | Represents the vertical offset of shape from its top row, in unit of inches.(Inherited from Shape .) |
TopInShape { get; set; } | Represents the vertical offset of shape from the top border of the parent shape, in unit of 1/4000 of height of the parent shape.(Inherited from Shape .) |
TopToCorner { get; set; } | Gets and sets the vertical offset of shape from worksheet top border, in unit of pixels.(Inherited from Shape .) |
Type { get; } | Gets the auto shape type.(Inherited from Shape .) |
UpperDeltaX { get; set; } | Gets or sets the shape’s horizontal offset from its upper left corner column.(Inherited from Shape .) |
UpperDeltaY { get; set; } | Gets or sets the shape’s vertical offset from its upper left corner row.(Inherited from Shape .) |
UpperLeftColumn { get; set; } | Represents upper left corner column index.(Inherited from Shape .) |
UpperLeftRow { get; set; } | Represents the top row index.(Inherited from Shape .) |
Width { get; set; } | Represents the width of shape, in unit of pixels.(Inherited from Shape .) |
WidthCM { get; set; } | Represents the width of the shape, in unit of centimeters.(Inherited from Shape .) |
WidthInch { get; set; } | Represents the width of the shape, in unit of inch.(Inherited from Shape .) |
WidthInShape { get; set; } | Represents the width of the shape, in unit of 1/4000 of the parent shape.(Inherited from Shape .) |
WidthPt { get; set; } | Represents the width of the shape, in unit of point.(Inherited from Shape .) |
WidthScale { get; set; } | Gets and sets the width scale, in unit of percent of the original picture width. If the shape is not picture ,the WidthScale property only returns 100;(Inherited from Shape .) |
Worksheet { get; } | Gets the Worksheet object which contains this shape.(Inherited from Shape .) |
X { get; set; } | Gets and sets the horizontal offset of shape from worksheet left border,in unit of pixels.(Inherited from Shape .) |
Y { get; set; } | Gets and sets the vertical offset of shape from worksheet top border,in unit of pixels.(Inherited from Shape .) |
ZOrderPosition { get; set; } | Returns the position of a shape in the z-order.(Inherited from Shape .) |
Methods
Name | Description |
---|---|
AddHyperlink(string) | Adds a hyperlink to the shape.(Inherited from Shape .) |
AlignTopRightCorner(int, int) | Moves the picture to the top-right corner.(Inherited from Shape .) |
CalculateTextSize() | Recalculate the text area(Inherited from Shape .) |
Characters(int, int) | Returns a Characters object that represents a range of characters within the text.(Inherited from Shape .) |
Copy(Picture, CopyOptions) | Copy the picture. |
FormatCharacters(int, int, Font, StyleFlag) | Formats some characters with the font setting.(Inherited from Shape .) |
GetActualBox() | Get the actual position and size of the shape (after applying rotation, flip, etc.)(Inherited from Shape .) |
GetCharacters() | (Obsolete.) Returns all Characters objects that represents a range of characters within the text .(Inherited from Shape .) |
GetConnectionPoints() | Get the connection points(Inherited from Shape .) |
GetInputRange(bool, bool) | Gets the range used to fill the control.(Inherited from Shape .) |
GetLinkedCell(bool, bool) | Gets the range linked to the control’s value.(Inherited from Shape .) |
GetLockedProperty(ShapeLockType) | Gets the value of locked property.(Inherited from Shape .) |
virtual GetResultOfSmartArt() | Converting smart art to grouped shapes.(Inherited from Shape .) |
GetRichFormattings() | Returns all Characters objects that represents a range of characters within the text .(Inherited from Shape .) |
override IsSameSetting(object) | Returns whether the shape is same. |
Move(int, int) | Moves the picture to a specified location. |
MoveToRange(int, int, int, int) | Moves the shape to a specified range.(Inherited from Shape .) |
PlaceInCell() | Place this picture in the cell |
RemoveActiveXControl() | Remove activeX control.(Inherited from Shape .) |
RemoveHyperlink() | Removes the hyperlink of the shape.(Inherited from Shape .) |
SetInputRange(string, bool, bool) | Sets the range used to fill the control.(Inherited from Shape .) |
SetLinkedCell(string, bool, bool) | Sets the range linked to the control’s value.(Inherited from Shape .) |
SetLockedProperty(ShapeLockType, bool) | Set the locked property.(Inherited from Shape .) |
ToFrontOrBack(int) | Brings the shape to the front or sends the shape to back.(Inherited from Shape .) |
ToImage(ImageOrPrintOptions) | Returns the bitmap object of the shape .(Inherited from Shape .) |
ToImage(Stream, ImageOrPrintOptions) | Saves the shape to a stream.(Inherited from Shape .) |
ToImage(Stream, ImageType) | Creates the shape image and saves it to a stream in the specified format.(Inherited from Shape .) |
ToImage(string, ImageOrPrintOptions) | Saves the shape to a file.(Inherited from Shape .) |
UpdateSelectedValue() | Update the selected value by the value of the linked cell.(Inherited from Shape .) |
Examples
[C#]
//Instantiating a Workbook object
Workbook workbook = new Workbook();
//Adding a new worksheet to the Workbook object
int sheetIndex = workbook.Worksheets.Add();
//Obtaining the reference of the newly added worksheet by passing its sheet index
Worksheet worksheet = workbook.Worksheets[sheetIndex];
//Adding a picture at the location of a cell whose row and column indices
//are 5 in the worksheet. It is "F6" cell
worksheet.Pictures.Add(5, 5, "image.gif");
//Saving the Excel file
workbook.Save("book1.xls", SaveFormat.Excel97To2003);
[Visual Basic]
'Instantiating a Workbook object
Dim workbook As Workbook = New Workbook()
'Adding a new worksheet to the Workbook object
Dim sheetIndex As Integer = workbook.Worksheets.Add()
'Obtaining the reference of the newly added worksheet by passing its sheet index
Dim worksheet As Worksheet = workbook.Worksheets(sheetIndex)
'Adding a picture at the location of a cell whose row and column indices
'are 5 in the worksheet. It is "F6" cell
worksheet.Pictures.Add(5, 5, "image.gif")
'Saving the Excel file
workbook.Save("book1.xls", SaveFormat.Excel97To2003)
See Also
- class Shape
- namespace Aspose.Cells.Drawing
- assembly Aspose.Cells