PictureCollection

add(upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, fileName) → Number

Adds a picture to the collection. ///

Returns

Number Picture object index.

add(upperLeftRow, upperLeftColumn, fileName) → Number

Adds a picture to the collection.

Returns

Number Picture object index.

add(upperLeftRow, upperLeftColumn, fileName, widthScale, heightScale) → Number

Adds a picture to the collection.

Returns

Number Picture object index.

clear()

Clear all pictures.

contains()

Reserved for internal use.

get(index) → Picture

Gets the Picture element at the specified index.

Returns

Picture The element at the specified index.

get()

Reserved for internal use.

getCount()

indexOf()

Reserved for internal use.

iterator()

removeAt()

Remove shapes at the specific index

addPictureFromStream(pictures, upperLeftRow, upperLeftColumn, lowerRightRow, lowerRightColumn, stream, callback) → Picture

Adds a picture to the collection.

var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var fs = require("fs");
var workbook = new aspose.cells.Workbook();
var pictures = workbook.getWorksheets().add("picture").getPictures();
var pictureStream = fs.createReadStream("boxing.PNG");
aspose.cells.PictureCollection.addPictureFromStream(pictures, 0, 0, 10, 8, pictureStream,
function(index, err) {
if (err) {
console.log("addPictureFromStream error");
return;
}
console.log("picture add index: " + index);
workbook.save('result.xlsx');
console.log('saved to file');
}
);

Returns

Picture Picture object index.

addPictureFromStream(pictures, upperLeftRow, upperLeftColumn, stream, callback) → Picture

Adds a picture to the collection.

var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var fs = require("fs");
var workbook = new aspose.cells.Workbook();
var pictures = workbook.getWorksheets().add("picture").getPictures();
var pictureStream = fs.createReadStream("boxing.PNG");
aspose.cells.PictureCollection.addPictureFromStream(pictures, 0, 0, pictureStream,
function(index, err) {
if (err) {
console.log("addPictureFromStream error");
return;
}
console.log("picture add index: " + index);
workbook.save('result.xlsx');
console.log('saved to file');
}
);

Returns

Picture Picture object index.

addPictureFromStream(pictures, upperLeftRow, upperLeftColumn, stream, widthScale, heightScale, callback) → Picture

Adds a picture to the collection.

var aspose = aspose || {};
aspose.cells = require("aspose.cells");
var fs = require("fs");
var workbook = new aspose.cells.Workbook();
var pictures = workbook.getWorksheets().add("picture").getPictures();
var pictureStream = fs.createReadStream("boxing.PNG");
aspose.cells.PictureCollection.addPictureFromStream(pictures, 0, 0, pictureStream, 80, 60,
function(index, err) {
if (err) {
console.log("addPictureFromStream error");
return;
}
console.log("picture add index: " + index);
workbook.save('result.xlsx');
console.log('saved to file');
}
);

Returns

Picture Picture object index.