The replacePicture function is established to replace an image shape that exists on the excel. Only XSSF(xlsx,xlsm).
var excel = new Excel("test.xlsx");
excel.replacePicture("Sheet1","picture1","templates/tanaka.png");
Calling | Returning |
---|---|
Excel . addShapeInRange ( sheetName , shapeName , newPicturePath ) | Excel |
Parameters | Type | Description |
---|---|---|
sheetName | String | The template sheet name. |
shapeName | String | The name of the copied shape. |
newPicturePath | String | The image file path relatived to the storage folder. |