Skip to content

Latest commit

 

History

History
34 lines (28 loc) · 1.82 KB

excel.addShapeInRange.md

File metadata and controls

34 lines (28 loc) · 1.82 KB

Excel.addShapeInRange

The addShapeInRange function is used to create a shape by copying a shape from a template sheet and placing it to encircle a cell range. This function only works with XSSF (xlsx, xlsm) files.

Sample

var excel = new Excel("test.xlsx");
excel.createSheet("newSheet")
.addShapeInRange("newSheet","firstCellPosition","lastCellPosition","templateSheet","shapeName")
.addShapeInRange("newSheet","firstCellPosition","lastCellPosition","templateSheet","shapeName","text")
.addShapeInRange("newSheet","firstCellPosition","lastCellPosition","templateSheet","shapeName","text",20,20,40,40);	// To create a shape like line by copying templateSheet's

API

Calling Returning
excel. addShapeInRange ( sheetName, firstCellPosition, lastCellPosition, templateSheetName, templateShapeName ) Excel
excel. addShapeInRange ( sheetName, firstCellPosition, lastCellPosition, templateSheetName, templateShapeName, text ) Excel
excel. addShapeInRange ( sheetName, firstCellPosition, lastCellPosition, templateSheetName, templateShapeName, text, x1, y1, x2, y2 ) Excel
Parameters Type Description
sheetName String The sheet name.
firstCellPosition String The absolute reference of the first cell (e.g., "A1").
lastCellPosition String The absolute reference of the last cell (e.g., "B2").
templateSheetName String The template sheet name.
templateShapeName String The name of the shape to be copied.
text String The text value for the created shape.
x1 Number The x-coordinate within the first cell.
y1 Number The y-coordinate within the first cell.
x2 Number The x-coordinate within the last cell.
y2 Number The y-coordinate within the last cell.