Picture

Details about adding and manipulating picture to a worksheet

Basic Code Sample

public void AddPicture()
	{
		Worksheet worksheet = excel.AddSheet("Data4");
		worksheet.AddPicture("./TestFiles/tom_and_jerry.jpg", new()
		{
			imageType = ImageType.JPEG,
			from = new()
			{
				column = 6,
				row = 6
			},
			to = new()
			{
				column = 8,
				row = 8
			}
		});
		Assert.IsTrue(true);
	}

ExcelPictureSetting Options

Property	Type	Details
hyperlinkProperties	HyperlinkProperties	Attach hyperlink to the image
imageType	ImageType	Image extension type
anchorEditType	AnchorEditType	Mode of picture starting point
from	AnchorPosition	Top Left coordinate
to	AnchorPosition	Bottom right X coordinate

AnchorPosition Options

Property	Type	Details
column	uint
columnOffset	uint
row	uint
rowOffset	uint