📚
OpenXML-Office
v4.x (Alpha)
v4.x (Alpha)
  • Welcome
    • Getting Started
    • Introduction
    • Benchmark🚧🛠️
    • Status Badge 🚧🛠️
    • Privacy Policy
    • License
  • Spreadsheet
    • Excel
    • Worksheet🚧🛠️
    • Shape🚧🛠️
    • Picture🚧🛠️
    • Table🚧🛠️
    • Chart🚧🛠️
      • Area
      • Bar
      • Column
      • Line
      • Pie
      • Scatter
      • Combo
    • Style🚧🛠️
    • Shared🚧🛠️
  • Presentation🚧🛠️
    • PowerPoint🚧🛠️
    • Slide🚧🛠️
    • Shape🚧🛠️
    • Picture🚧🛠️
    • Textbox🚧🛠️
    • Table🚧🛠️
    • Chart🚧🛠️
      • Area
      • Bar
      • Column
      • Line
      • Pie
      • Scatter
      • Combo
      • Waterfall
  • Document🚧🛠️
    • Word🚧🛠️
    • Shape🚧🛠️
    • Picture🚧🛠️
    • Table🚧🛠️
    • Chart🚧🛠️
  • FFI🚧🛠️
    • Spreadsheet🚧🛠️
    • Presentation 🚧🛠️
    • Document🚧🛠️
Powered by GitBook
On this page
  • Basic Code Sample
  • ExcelPictureSetting Options
  • AnchorPosition Options

Was this helpful?

  1. Spreadsheet

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

Attach hyperlink to the image

imageType

ImageType

Image extension type

anchorEditType

AnchorEditType

Mode of picture starting point

from

Top Left coordinate

to

Bottom right X coordinate

AnchorPosition Options

Property
Type
Details

column

uint

columnOffset

uint

row

uint

rowOffset

uint

PreviousShape🚧🛠️NextTable🚧🛠️

Was this helpful?

AnchorPosition
AnchorPosition
HyperlinkProperties