Picture Class

This class represents a picture element in the PictureCollection of the Worksheet.

Syntax

Visual Basic
C#

'Declaration

 

Public Class Picture 

   Inherits WorksheetElement

'Usage

 

Dim instance As Picture

public class Picture : WorksheetElement

Remarks

Pictures can be associated with one of three Anchor types : AbsoluteAnchor, OneCellAnchor or TwoCellAnchor. The type of Anchor used by a Picture can be retrieved with the AnchorType property.

Example

using( var workbook = Workbook.Create( "test.xlsx") )

  {

    // Get the first worksheet. A workbook contains at least 1 worksheet.

    var worksheet = workbook.Worksheets[ 0 ];



    var stream = new FileStream( PictureSampleResourcesDirectory + @"balloon.jpg", FileMode.Open, FileAccess.Read );

    // Add the stream picture in cell A4 and extend it to cell E12.

    var filenamePicture = worksheet.Pictures.Add( stream, "A4", "E12" );



    // Add the filename picture with its top left corner in 15th row and 1st column.

    var streamPicture = worksheet.Pictures.Add( PictureSampleResourcesDirectory + @"balloon.jpg", 14, 0 );



    workbook.Save();

  }

Inheritance Hierarchy

System.Object
   Xceed.Workbooks.NET.WorkbookElement
      Xceed.Workbooks.NET.WorksheetElement
         Xceed.Workbooks.NET.Picture

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

Picture Members
Xceed.Workbooks.NET Namespace