excel.addShapeInRange.md

Excel.addShapeInRange

The addShapeInRange function is established to create a shape by coping to encircle cell range. Only XSSF(xlsx,xlsm).

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.
lastCellPosition	String	The absolute reference of the last cell.
templateSheetName	String	The template sheet name.
templateShapeName	String	The name of the copied shape.
text	String	The created shape's text value.
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.