Get Started
Documentation

ApiDrawing

new ApiDrawing()

Class representing a graphical object.

Methods

Name Description
GetClassType

Get the type of the class based on this base class.

SetPosition

Change the position for the drawing object. Please note, that the horizontal nColOffset and vertical nRowOffset offsets are calculated within the limits of the specified nFromCol column and nFromRow row cell only. If this value exceeds the cell width or height, another vertical/horizontal position will be set.

SetSize

Set the size of the object (image, shape, chart) bounding box.

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oStroke, oFill;
oFill = Api.CreateSolidFill(Api.CreateRGBColor(104, 155, 104));
oStroke = Api.CreateStroke(0, Api.CreateNoFill());
var oDrawing = oWorksheet.AddShape("flowChartOnlineStorage", 60 * 36000, 35 * 36000, oFill, oStroke, 0, 2 * 36000, 0, 3 * 36000);
oDrawing.SetSize(120 * 36000, 70 * 36000);
oDrawing.SetPosition(4, 2 * 36000, 2, 3 * 36000);
builder.SaveFile("xlsx", "ApiDrawing.xlsx");
builder.CloseFile();

Resulting document