From the Configuration Wizard follow the next steps:
1. Upload the Excel template.
To upload a template click on the Plus icon.
In the new window click the Browse button, select the template for upload and click Open. Ensure the template is not opened elsewhere in order to successfully upload it.
If desired, change the template name. Click Next.
A new window will display a preview of the template along with the list of tags found in the template. Click Finish.
2. Define the document name.
This field contains the name of the actual document that is generated in the Work Portal.
If the property Replace existing documents is turned off, and the end user click on Generate several times multiple documents of the same template will be generated. These will be named with the Document name followed by a sequential number.
For example if Invoice is the Document name, when creating a second document of the same template it will be named Invoice1 as shown below.
3. Map the information from the Process data model.
This option allows relating the Template Tags with the data model of the Process.
Click the Add Mapping button to open the mapping wizard
A new window will display.
In this window you will find the attributes of the Process Data model on the left and the Template Tags on the right.
You can easily relate a Data source to a Tag by tracing a line between the desired elements.
To do so, click on an element of the Data Model and then click on the corresponding Tag. You can also drag and drop the relation. This procedure must be repeated for each tag.
Take into account that mapped information will keep the format of the template.
Note that for excel spreadsheets children nodes are created for the document. These child nodes depicts the sheets of the excel template. DO NOT MAP THESE ELEMENTS.
For the Invoice template this would be the complete mapping.
Note that in the Tags table a group of Products was created containing the values of the Products collection.
•You can include filtered collections, today's date and some case information to your mappings. Please refer to Advanced functions in mapping
•When mapping parameter entities, expand their attribute nodes and map the Display Attribute.
4. Define the export format.
Select the format in which the generated document will be exported.
Available formats are:
•PDF: Exports the document in PDF format to ensure the aspect and structure of the original document is not modified.
•Same as template: Exports the document in the same format of the Template. Currently only .xlsx files are supported.
•PDF/A-1a: Exports the document in PDF/A -1a format to ensure that document content can be searched and reproduced.
•PDF/A-1b: Exports the document in PDF/A -1b format to ensure reliable reproduction of the visual appearance of the document.
Generating an Excel Document
Once configured you are ready to generate documents.
Go to the Work Portal and open the Activity where the document is generated.
Include the necessary information in the fields of the form. When finished click the Generate Document button.
If you generated automatically make sure the expression has been executed.
Once generated, click on the document link to open it.
This is how the document looks. Note how the information entered in the Form is included and how the last column is calculated.
If you would had chosen PDF as export format, the document would look as follow:
Take into account that when generating pdf format, you must set page configuration for the excel template, otherwise, the generated document might be split.