GroupDocsGists
10/24/2017 - 1:49 PM

GenerateCommonListFromDatabaseinSpreadsheetFormat.cs

// For complete examples and data files, please go to https://github.com/groupdocsassembly/GroupDocs_Assembly_NET
//Setting up source spreadsheet template
const String strSpreadsheetTemplate = "Spreadsheet Templates/Common List.xlsx";
//Setting up destination document report 
const String strSpreadsheetReport = "Spreadsheet Reports/Common List Report.xlsx";
try
{
    //Instantiate DocumentAssembler class
    DocumentAssembler assembler = new DocumentAssembler();
    //Call AssembleDocument to generate Common List Report in spreadsheet format
    assembler.AssembleDocument(CommonUtilities.GetSourceDocument(strSpreadsheetTemplate), CommonUtilities.SetDestinationDocument(strSpreadsheetReport), DataLayer.GetCustomersDataDB(), "customers");
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
}