Generate Reports from Excel Data in C# using GroupDocs.Assembly for .NET

GenerateReports_CSharp

Generate Reports from Excel Data using C#
1. Get Excel Data Source
2. Define Template
3. Generate Report

GenerateReports_CSharp_Generate.cs

string ExcelDataFile = "Contracts_Data.xlsx";
string strDocumentTemplate = "Template.docx";
string strDocumentReport = "Output.docx";

// Define data table from Excel file
DocumentTableOptions options = new DocumentTableOptions 
{ 
    FirstRowContainsColumnNames = true 
};
DocumentTable table = new DocumentTable(ExcelDataFile, 0, options);

// Assemble a document using the external document table as a data source.
DocumentAssembler assembler = new DocumentAssembler();
assembler.AssembleDocument(strDocumentTemplate, strDocumentReport,
    new DataSourceInfo(table, "contracts"));