Examples

Use Case 1: Invoice line items

Generate one row per line item with quantity, description, price, and total.

Example data:

{
    Invoice: {
        LineItems: [
            { Quantity: 1, Description: "Consulting", Price: 100, Total: 100 },
            { Quantity: 2, Description: "Licenses", Price: 150, Total: 300 }
        ]
    }
}

Template Document:

Output:

Use Case 2: Nested tables for regions

An outer FOR creates one table per region. Inside each table, an inner FOR lists monthly revenue and expenses.

Example data:

{
    Company: {
        Regions: [
            {
                Name: "North",
                Months: [
                    { Name: "Jan", Revenue: 1000, Expenses: 500 },
                    { Name: "Feb", Revenue: 1200, Expenses: 600 }
                ]
            },
            {
                Name: "South",
                Months: [
                    { Name: "Jan", Revenue: 750, Expenses: 400 },
                    { Name: "Feb", Revenue: 2000, Expenses: 800 }
                ]
            }
        ]
    }
}

Template Document:

Output:

Notes

• Tables that are repeated within a FOR command do not support formulas.
• Rows that contain a start or end FOR command are completely removed from the document unless both the start and end for are in the same cell.
• A FOR loop that starts and ends within a single cell cannot be nested inside another FOR.

• You can populate data in an excel table and reference that table in formulas and other excel features, however, populating data in excel ranges and referencing those ranges elsewhere is currently unsupported.

  • For example, most charts utilize excel ranges instead of tables, so charts are unsupported.

Next Steps

• About FOR

• FOR in Word

• FOR in PowerPoint