DriveWorks Pro 16: Replace Images in Excel Document [send feedback...]

Replace Images in Excel Document

This Specification Flow Task inserts an image in to an excel document to replace an existing shape that has a specific title.

Replace Images in Excel Document Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
Source File NameFile Name of the excel workbook to edit (Should be rooted or relative to the specification directory).
The Source File Name is the name of the document once it has been created by a specification.
Titles of ImagesPipebar (|) delimited list of titles of images to be replaced.
This is the Title given to the inserted shape (see Set Up below).
New Images File NamesPipebar (|) delimited list of images to insert, in the order they are required to be inserted relative to titles (Must include full file paths, or paths relative to the parent file).
Show ExcelExcel application will be visible if set to True.
Extension for Saving FilePipebar (|) delimited list of extensions to save the file as (e.g. .pdf|.xps|.txt).
Export Sheet NameThe sheet name in the spreadsheet that will be exported.

Set Up

The Replace Image task works by replacing a Shape in the Excel document.

To create a shape in the master document, of the file that is to have the image replaced, follow the steps below:

Step 1In the master document...

Click the INSERT menu, select Shapes and select a rectangular shape to insert.

Draw the shape at the point the image is required to be.

The original Line, Effects and Text Box properties of the shape will be maintained.

Only the FILL property will be changed to Picture Fill when the image is replaced.

Shapes with rounded edges, thick borders etc. will be preserved when the image is inserted. Images will be cropped and scaled to suit the size and layout of the original shape.

Step 2Right Click the shape and select Format Shape from the menu.

From the Format Shape menu (usually located on the right hand side of the Microsoft Excel window) select the Layout & Properties icon.

Expand the ALT TEXT item and enter a name for the shape in the Title field.

This is the name that is to be entered into the Titles property of the task.

Table of Contents