This Specification Flow Task inserts an image in to an excel document to replace an existing shape that has a specific title.
|Title||Changes the Title (not the name) of the task.|
|Source File Name||File 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 Images||Pipebar (|) 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 Names||Pipebar (|) 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 Excel||Excel application will be visible if set to True.|
|Extension for Saving File||Pipebar (|) delimited list of extensions to save the file as (e.g. .pdf|.xps|.txt).|
|Export Sheet Name||The sheet name in the spreadsheet that will be exported.|
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 1||In 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 2||Right 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.