Get Started
Documentation

SetPosition

SetPosition(nFromCol, nColOffset, nFromRow, nRowOffset)

Change the position for the drawing object.

Parameters:

Name Type Description
nFromCol number The number of the column where the beginning of the drawing object will be placed.
nColOffset EMU The offset from the nFromCol column to the left part of the drawing object measured in English measure units.
nFromRow number The number of the row where the beginning of the drawing object will be placed.
nRowOffset EMU The offset from the nFromRow row to the upper part of the drawing object measured in English measure units.
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.

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", "SetPosition.xlsx");
builder.CloseFile();

Resulting document