Picture

Details about adding and manipulating picture to a worksheet

Basic Code Sample

Rust

use draviavemal_openxml_office::spreadsheet_2007::models::ExcelPictureSetting;

let mut sheet = excel
.get_worksheet_mut("image".to_string())
.expect("Failed to get sheet");
sheet
.add_picture("./tom_and_jerry.jpg", ExcelPictureSetting::default())
.expect("Failed to add image");
sheet.flush().expect("Failed to save sheet");

C#🚧🛠️

Not yet available.

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