#Advanced Features

#Pagination

#1. Page Number Update

#Syntax

Simply insert it in your Office software.

#Example

In Microsoft Word:

• Use the "Insert → Page Number" function
  In LibreOffice:
• Use the "Insert → Field → Page Number" function

#Result

In the generated report, the page numbers on each page will update automatically.

#2. Table of Contents Generation

#Syntax

Simply insert it in your Office software.

#Example

In Microsoft Word:

• Use the "Insert → Index and Table → Table of Contents" function

In LibreOffice:

• Use the "Insert → Table of Contents and Index → Table, Index or Bibliography" function

#Result

The report's table of contents will update automatically based on the document content.

#3. Repeating Table Headers

#Syntax

Simply insert it in your Office software.

#Example

In Microsoft Word:

• Right-click the table header → Table Properties → Check "Repeat as header row at the top of each page"

In LibreOffice:

• Right-click the table header → Table Properties → Text Flow tab → Check "Repeat heading"

#Result

When a table spans multiple pages, the header will automatically repeat at the top of each page.

#Internationalization (i18n)

#1. Static Text Translation

#Syntax

Use the {t(text)} tag for internationalizing static text:

{t(meeting)}

#Example

In the template:

{t(meeting)} {t(apples)}

JSON Data or an external localization dictionary (e.g., for "fr-fr") provides corresponding translations (for example, "meeting" → "rendez-vous" and "apples" → "Pommes").

#Result

When generating the report, the text will be replaced with the corresponding translation based on the target language.

#2. Dynamic Text Translation

#Syntax

For data content, use the :t formatter, for example:

{d.id:ifEQ(2):show({t(monday)}):elseShow({t(tuesday)})}

#Example

In the template:

{d.id:ifEQ(2):show({t(monday)}):elseShow({t(tuesday)})}

JSON Data and the localization dictionary provide the appropriate translations.

#Result

Based on the condition, the output will be either "lundi" or "mardi" (using the target language as an example).

#Key-Value Mapping

#1. Enum Conversion (:convEnum)

#Syntax

{data:convEnum(enumName)}

For example:

0:convEnum('ORDER_STATUS')

#Example

In an API options example, the following is provided:

{
  "enum": {
    "ORDER_STATUS": ["pending", "sent", "delivered"]
  }
}

In the template:

0:convEnum('ORDER_STATUS')

#Result

Outputs "pending"; if the index exceeds the enumeration range, the original value is output.

#Dynamic Images

You can insert "dynamic images" in document templates, which means placeholder images in the template will be automatically replaced with actual images during rendering based on data. This process is very simple and only requires:

1. Insert a temporary image as a placeholder

2. Edit the "Alt Text" of that image to set the field label

3. Render the document, and the system will automatically replace it with the actual image

Below we'll explain the operation methods for DOCX and XLSX through specific examples.

#Inserting Dynamic Images in DOCX Files

#Single Image Replacement

1. Open your DOCX template and insert a temporary image (can be any placeholder image, such as a solid blue image)

2. Right-click on this image, edit its "Alt Text", and fill in the image field label you want to insert, for example {d.imageUrl}:

3. Use the following example data for rendering:

{
  "name": "Apple",
  "imageUrl": "https://images.pexels.com/photos/206959/pexels-photo-206959.jpeg"
}

4. In the rendered result, the temporary image will be replaced with the actual image:

#Multiple Image Loop Replacement

If you want to insert a group of images in the template, such as a product list, you can also implement this through loops. The specific steps are as follows:

1. Assume your data is as follows:

{
  "products": [
    {
      "name": "Apple",
      "imageUrl": "https://images.pexels.com/photos/206959/pexels-photo-206959.jpeg"
    },
    {
      "name": "Banana",
      "imageUrl": "https://images.pexels.com/photos/61127/pexels-photo-61127.jpeg"
    }
  ]
}

2. Set up a loop area in the DOCX template, and insert temporary images in each loop item with Alt Text set to {d.products[i].imageUrl}, as shown below:

3. After rendering, all temporary images will be replaced with their respective data images:

#Inserting Dynamic Images in XLSX Files

The operation method in Excel templates (XLSX) is basically the same, just note the following points:

1. After inserting an image, please ensure that you select "image within cell" rather than having the image float above the cell.

2. After selecting the cell, click to view "Alt Text" to fill in the field label, such as {d.imageUrl}.

#Barcode

#Generating Barcodes (such as QR codes)

Barcode generation works the same way as Dynamic Images, requiring only three steps:

1. Insert a temporary image in the template to mark the barcode position

2. Edit the image's "Alt Text" and write in the barcode format field label, for example {d.code:barcode(qrcode)}, where qrcode is the barcode type (see the supported list below)

3. After rendering, the placeholder image will be automatically replaced with the corresponding barcode image:

#Supported Barcode Types