Using GroupDocs.Assembly, you can insert smart lists into XLSX templates. Follow these simple steps to automate document creation.
# Insert this tag into your template to specify where the list will appear
# <<foreach [in customers]>><<[CustomerName]>><</foreach>>
import groupdocs.assembly as ga
def run():
# Define the path to your template document
template = "list_template.xlsx"
# Connect to your data source (e.g., JSON, XML)
data = ga.DataSourceInfo(GetData(), "label")
# Generate and save the final document with the list embedded
asm = ga.DocumentAssembler()
asm.assemble_document(template, "result.xlsx", data)
GroupDocs.Assembly for Python via .NET makes it easy to create rich, data-driven documents. Build templates once, and dynamically insert lists, charts, barcodes, tables, and images based on your live data sources.
Automatically transform data from JSON, XML, CSV, and other sources into structured lists and documents in industry-standard formats like DOCX, XLSX, and PDF.
Embed cleanly formatted lists alongside tables, charts, hyperlinks, barcodes, and rich text to deliver impactful and readable documents.
Use LINQ-style syntax to loop through data collections and insert lists exactly where needed, with full support for styling and conditional logic.
Build and export documents in over 50 supported formats—Microsoft Office, OpenOffice, PDF, HTML, and more—with seamless integration and rendering fidelity.
# Add a placeholder in your template to define list placement
# <<foreach [in products]>><<[NumberOf()]>>. <<[ProductName]>>
# <</foreach>>
import groupdocs.assembly as ga
def run():
# Set the file path to the document template
template = "numlist_template.xlsx"
# Retrieve or define your data source to populate the list
data_xml = ga.data("products.xml")
# Prepare the data object containing list information
data = ga.DataSourceInfo(data_xml, "products")
# Initialize DocumentAssembler to process the template
asm = ga.DocumentAssembler()
# Save the final document containing the auto-generated list
asm.assemble_document(template, "result.xlsx", data)
Download GroupDocs.Assembly for free or get a trial license for full access!
Explore documentation, code samples, and community support to enhance your experience.
Quickly generate lists and structured content using GroupDocs.Assembly — ideal for business reports, dashboards, and custom documents powered by live data.
Python via .NET lets you merge data into templates across a wide range of supported formats, making it easy to automate the creation of high-quality, structured documents.
