Insert a Linked Picture from Web Address

Sometimes you need to insert a picture from the web (http://) into a worksheet. To do so, specify the picture’s URL and the picture will be downloaded every time the spreadsheet is opened in Microsoft Excel. The image is not physically embedded into the Excel document, but points to a web resource.

Inserting a Linked Picture from Web Address

Using Microsoft Excel

In Microsoft Excel (for example 2007):

1. Click the Insert menu and select Picture.

1. Specify the web address for the picture in the Insert Picture dialog.

The image is inserted.

Using Aspose.Cells for Java

Aspose.Cells for Java supports adding a linked image using the method ShapeCollection.addLinkedPicture(int upperLeftRow, int upperLeftColumn, int height, int width, java.lang.String sourceFullName).

The method returns a Picture object.

The following example shows how to add linked picture from web address to a worksheet.

After running the code, the generated Excel file contains a linked image on the first worksheet.

The output file

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getDataDir(InsertLinkedPicturefromWebAddress.class);
// Instantiate a new Workbook.
Workbook workbook = new Workbook();
// Insert a linked picture (from Web Address) to B2 Cell.
Picture pic = (Picture) workbook.getWorksheets().get(0).getShapes().addLinkedPicture(1, 1, 100, 100,
		"http://www.aspose.com/Images/aspose-logo.jpg");
// Set the source of the inserted image.
pic.setSourceFullName("http://www.aspose.com/images/aspose-logo.gif");

// Set the height and width of the inserted image.
pic.setHeightInch(1.04);
pic.setWidthInch(2.6);

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