GroupDocsGists
10/24/2017 - 1:43 PM

GenerateCommonMasterDetailFromXMLinSpreadsheetFormat.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 Master-Detail_DB.xlsx";
//Setting up destination document report 
const String strSpreadsheetReport = "Spreadsheet Reports/Common Master-Detail_XML 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.GetAllDataFromXML(), "ds");
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
}