SetPosition

SetPosition(nFromCol, nColOffset, nFromRow, nRowOffset)

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

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.

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFill = Api.CreateSolidFill(Api.CreateRGBColor(255, 111, 61));
var 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(0, 2 * 36000, 2, 3 * 36000);
builder.SaveFile("xlsx", "SetPosition.xlsx");
builder.CloseFile();

Resulting document