InsertPictureCellReference.java

package com.aspose.cells.examples.articles;

import java.io.FileInputStream;

import com.aspose.cells.Cells;
import com.aspose.cells.Picture;
import com.aspose.cells.Workbook;
import com.aspose.cells.examples.Utils;

public class InsertPictureCellReference {
	public static void main(String[] args) throws Exception {

		String dataDir = Utils.getSharedDataDir(InsertPictureCellReference.class) + "articles/";

		// Instantiate a new Workbook
		Workbook workbook = new Workbook();

		// Get the first worksheet's cells collection
		Cells cells = workbook.getWorksheets().get(0).getCells();

		// Add string values to the cells
		cells.get("A1").putValue("A1");
		cells.get("C10").putValue("C10");

		// Load/Read an image into stream
		String logo_url = dataDir + "school.jpg";

		// Creating the instance of the FileInputStream object to open the logo/picture in the stream
		FileInputStream inFile = new FileInputStream(logo_url);

		// Add a blank picture to the D1 cell
		Picture pic = (Picture) workbook.getWorksheets().get(0).getShapes().addPicture(0, 3, inFile, 10, 10);

		// Set the size of the picture.
		pic.setHeightCM(4.48);
		pic.setWidthCM(5.28);

		// Specify the formula that refers to the source range of cells
		pic.setFormula("A1:C10");

		// Update the shapes selected value in the worksheet
		workbook.getWorksheets().get(0).getShapes().updateSelectedValue();

		// Save the Excel file.
		workbook.save(dataDir + "IPCellReference_out.xlsx");

	}
}