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

Replace Images in Excel Document

This Specification Task inserts an image into an Excel document to replace an existing shape that has a specific title.

This Task will only work with versions of Office up to and including version 1803 (Build 9126.2275).


Property NameDescription
TitleChanges the Title (not the name) of the Task.
Source File NameFile Name of the document 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.
Export Sheet NameThe sheet name in the spreadsheet that will be exported.
Extension for Saving FilePipebar (|) delimited list of extensions to save the file as (e.g. .pdf|.xps|.txt).

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.


When this Task is added the properties are static. To be able to build rules on a static properties see How To: Change A Static Property To A Dynamic Property.

Property NameExample RuleExample ResultMeaning
Source File NameDWSpecificationfullPath&"\TableMaster.xlsx"C:\MyDocuments\Project 9999\TableMaster.xlsxThis is the Full File Path location of the Excel document to replace images for.
Titles Of Images"Logo"LogoThis is a pipebar (|) delimited list of Titles of images to be replaced. These are the Titles of the shapes that you have set Titles for using Alt Text.
New Images File Names"C:\MyDocuments\MyPictures\Logo.JPG"C:\MyDocuments\MyPictures\Logo.JPGThis is a pipebar (|) delimited list of images to insert, in the order they are required to be inserted relative to the Titles of the images order.
Show ExcelTRUETRUETRUE will make the Excel application visible. FALSE will not.
Export Sheet Name"Sheet1"Sheet1Sheet1 is the name of the spreadsheet that will be exported.
Extension For Saving File".xlsx".xlsxThis will save the Excel document as a docx file.

Table of Contents