GroupDocs.Assembly for Python via .NET

Build and Populate Tables in XLSX Documents with Python API

GroupDocs.Assembly for Python via .NET allows you to dynamically generate structured tables in XLSX files using real-time data sources for automated document creation.

PyPI Download

Start Free Trial

How to Auto-Populate Tables in XLSX Documents

With GroupDocs.Assembly, dynamically filling tables in XLSX templates is simple. Automate document content using structured data.

Create a template in XLSX format with placeholders inside a table structure.
Load structured data from sources such as JSON, XML, or databases.
Filter or process the data as needed before table population.
Generate the document with the fully populated and formatted table.

Example document Copy

# Insert these tags into the row of your template table
# <<foreach [c in ds]>>
# <<[c.Client]>><<[c.Manager]>><<[c.Price]>>
# <</foreach>>

import groupdocs.assembly as ga

    def run():

        # Specify the path to your table template
        template = "table_template.xlsx"

        # Retrieve dynamic data from JSON, XML, or other sources
        data = ga.DataSourceInfo(GetData(), "ds")

        # Save your document with the filled table
        asm = ga.DocumentAssembler()
        asm.assemble_document(template, "result.xlsx", data)

pip install groupdocs-assembly-net

click to copy

copied

Automatically Generate Tables in Documents

GroupDocs.Assembly for Python via .NET empowers developers to auto-fill tables using data from dynamic sources and enhance documents with charts, lists, and images through advanced templating.

Convert Data into Structured Reports

Automatically populate document tables using structured data from JSON, XML, CSV, or custom data objects for clear and accurate presentation.

Visualize Information with Tables and More

Use GroupDocs.Assembly to enrich documents with tables, lists, charts, hyperlinks, images, and styled text for professional-quality outputs.

Control Table Layout and Styling

Use LINQ-style expressions to add rows and columns dynamically. Customize cell formatting, colors, and styles programmatically to match design needs.

Output to 50+ Supported Formats

Easily export documents with filled tables to formats such as DOCX, XLSX, PPTX, PDF, HTML, OpenOffice, and more—ideal for enterprise workflows.

Code Example: Populate a Table Dynamically

Learn how to use GroupDocs.Assembly to insert a data-driven table into a XLSX document, step-by-step.

Python

Download the result Copy

# Design your document template with a placeholder for the data table
# <<foreach [c in items]>> <<[c.Client]>><<[c.Manager]>>
# <<[c.Price]>> <</foreach>>

import groupdocs.assembly as ga

    def run():

        # Define the file path to the template
        template = "table_template.xlsx"

        # Fetch your dynamic data source
        data_json = ga.data.JsonDataSource("Items.json")

        # Package the data into an object for processing
        data = ga.DataSourceInfo(data_json, "items")

        # Initialize DocumentAssembler and bind the data
        asm = ga.DocumentAssembler()

        # Save and export the final document with the completed table
        asm.assemble_document(template, "result.xlsx", data)

pip install groupdocs-assembly-net

click to copy

copied

GroupDocs.Assembly for Python via .NET Overview

GroupDocs.Assembly for Python via .NET is a robust document automation API designed to help developers create polished, data-rich documents. It enables precise insertion of tables, lists, images, and charts using data from multiple sources. With support for over 50 formats like MS Office, PDF, HTML, and email, it’s the perfect tool for streamlining report generation and document assembly.

Learn more