AddImage
Adds an image to the current sheet with the parameters specified.
Syntax
expression.AddImage(sImageSrc, nWidth, nHeight, nFromCol, nColOffset, nFromRow, nRowOffset);
expression - A variable that represents a ApiWorksheet class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| sImageSrc | Required | string | The image source where the image to be inserted should be taken from (currently only internet URL or Base64 encoded images are supported). | |
| nWidth | Required | EMU | The image width in English measure units. | |
| nHeight | Required | EMU | The image height in English measure units. | |
| nFromCol | Required | number | The number of the column where the beginning of the image will be placed. | |
| nColOffset | Required | EMU | The offset from the nFromCol column to the left part of the image measured in English measure units. | |
| nFromRow | Required | number | The number of the row where the beginning of the image will be placed. | |
| nRowOffset | Required | EMU | The offset from the nFromRow row to the upper part of the image measured in English measure units. |
Returns
Example
Place an image onto a sheet at a specific position and size in a spreadsheet.
// How do I embed a picture from a URL into my sheet in a spreadsheet?
// Decorate a worksheet by inserting an image with defined dimensions and placement.
let worksheet = Api.GetActiveSheet();
worksheet.AddImage("https://static.onlyoffice.com/assets/docs/samples/img/presentation_sky.png", 60 * 36000, 35 * 36000, 0, 2 * 36000, 0, 3 * 36000);