Available from Infiniti V8.5 or later
 

One of the new features on the latest version of the Infiniti application (8.5) is the facility to generate Excel Spreadsheet files.

Design

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 Infiniti
 
   1.     Save the excel spreadsheet and create a new project in Infiniti.

Drag and drop the 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

Manage

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

Produce

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


 

Related Articles

 

 

Keywords

 

excel generation generate template document repeating placeholders