Template - Excel

An Excel spreadsheet is able to be used as a template definition to generate Excel Spreadsheet file as an output. This of this as the system populating the data points in an output spreadsheet.

Create Excel Spreadsheet

Before we start this project an excel spreadsheet will have to created.

Open up Excel and follow the steps below.

How To Insert a placeholder

Method 1

1. Select a cell
2. Type the placeholder name in the Define Name text box of the cell

3. Press Enter and the placeholder will be inserted.

Method 2

1. Right click the cell where the placeholder is to be inserted and click Define Name…

The New Name box will appear

2. Enter the placeholder name in the Name: text box and click OK. The placeholder will be visible in Design under the Placeholder tab

How to Edit and Delete an existing placeholder

1. Go To Formulas tab and click Name Manager

The Name Manager box will pop up

2. To DELETE a placeholder, select the placeholder and click Delete button.

3. To EDIT a placeholder, select the placeholder and click Edit… button.

The Edit Name box will pop up

4. To change the placeholder name, enter the new name in the Name: text box and change the placeholder location enter the new cell location in the Refers to: textbox

How to create repeating placeholders

1. Select the cells to be repeated and enter the repeating placeholder name in the Define Name textbox

Insert the excel template into SmartIQ

1. Save the excel spreadsheet and create a new project in SmartIQ
   Drag and drop the Excel template question onto the question set and choose the excel file you just created to upload.

The placeholder will be visible in Design. Placeholder_Repeat is the repeating placeholder and Placeholder_Name and Placeholder_Age are the placeholders included inside the repeating placeholder.

2. Map the placeholder to the required locations and specify the repeating placeholder under the properties tab of the section/page.

📘

NOTE

The above example shows repeating a selection of cells in the excel file. For repeating the pages of the excel file, replace Placeholder_Repeat with Sheet1 placeholder in the Placeholder(s) textbox

How to publish an Excel Project

1. Open the project from Manage and click Publish button.

2. Select the folder to which the project is to be published and specify the output format required from the Spreadsheet tab.

3. Click Save button

How to run an Excel project in Produce

1. Open the project and enter the values.

2. Click Next and then Generate Document.
3. Open the generated document

From the above example

If the placeholder mention in the repeating placeholder section in design was Placeholder_Repeat then the output will be an excel file with 1 sheet and 4 rows.

If the placeholder mention in the repeating placeholder section in design was Sheet1 then the output will be an excel file with 4 sheet and each with 1 row

Keywords: excel generation generate template document repeating placeholders