GroupDocs.Assembly for .NET

Add data-driven lists to XLSX documents using our .NET API

GroupDocs.Assembly for .NET offers powerful tools to dynamically generate and embed lists in XLSX documents.

Steps to add a data-filled list to a XLSX document

GroupDocs.Assembly makes it simple to insert data-driven lists into XLSX templates. Create and customize lists with ease.

Prepare a XLSX template with placeholders for the list.
Set path to the template.
Retrieve data from supported sources like JSON or XML.
Save the final document with the embedded list.

Example document Copy

// Add this tag to your template to mark where the list will appear
// <<foreach [in customers]>><<[CustomerName]>><</foreach>>

// Specify the path to the template file
string template = "list_template.xlsx";

// Retrieve data from your chosen source
DataSourceInfo data 
    = new DataSourceInfo(GetData(), "label");

// Save the document with the generated list
DocumentAssembler asm = new DocumentAssembler();
asm.AssembleDocument(template, "result.xlsx", data);

dotnet add package GroupDocs.Assembly

click to copy

copied

Create documents by filling templates with structured data

GroupDocs.Assembly for .NET simplifies building data-driven documents. Add lists, tables, barcodes, charts, images, and other elements dynamically with advanced templates.

Generate reports from business data

The API populates documents in popular formats using data from sources like JSON, XML, CSV, etc. with accuracy and efficiency.

Use lists and other elements to present data

GroupDocs.Assembly enables you to embed lists, tables, and charts along with text, barcodes, hyperlinks, and images to create well-structured documents.

Insert data precisely where needed

Leverage LINQ-based syntax to position lists and other data elements with precision. Use loops to populate lists dynamically and apply custom formatting programmatically.

Supports multiple document formats

Generate and manage documents in various formats such as MS Office, OpenOffice, PDF, HTML, and email files. Easily integrate multiple documents into one.

How to generate a list dynamically

This example demonstrates how to embed a dynamically generated list into a XLSX document.

C#

Download the result Copy

// Add a placeholder tag to your template for the list
// <<foreach [in products]>><<[NumberOf()]>>. <<[ProductName]>>
// <</foreach>>

// Specify the path to the template file
string template = "numlist_template.xlsx";

// Retrieve the data to populate the list
XmlDataSource data_xml =
    new XmlDataSource("products.xml");

// Create a data source object with the necessary information
DataSourceInfo data 
    = new DataSourceInfo(data_xml, "products");

// Initialize DocumentAssembler
DocumentAssembler asm = new DocumentAssembler();

// Save the final document with the generated list
asm.AssembleDocument(template, "result.xlsx", data);

dotnet add package GroupDocs.Assembly

click to copy

copied

Overview of GroupDocs.Assembly for .NET

GroupDocs.Assembly for .NET is designed to streamline the creation of documents and reports by seamlessly integrating data from various sources. Populate templates with lists, charts, tables, barcodes, or text, and place content precisely using advanced markup. With support for over 50 formats—including PDFs, MS Office files, and emails—it’s ideal for automating document workflows.

Learn more