Generate Reports from Excel Data in Java

GenerateReports_Java.md

Learn how to generate reports from Excel data using Java: https://blog.conholdate.com/2021/08/18/generate-reports-from-excel-data-in-java/

The following topics are discussed/covered in this article:

• Java API for Generating Report
• Generate Reports from Excel Data using Java

GenerateReports_Java_Generate.java

String srcDocument = "C:\\Files\\template.docx";
String docReport = "C:\\Files\\Output.docx";
String dataFilePath = "C:\\Files\\Contracts_Data.xlsx";

// Set extracting of column names from the first row.
DocumentTableOptions options = new DocumentTableOptions();
options.setFirstRowContainsColumnNames(true);

// Create document table
DocumentTable table = new DocumentTable(dataFilePath, 0, options);

// Create document assembler
DocumentAssembler assembler = new DocumentAssembler();

// Assemble data and generate report
assembler.assembleDocument(srcDocument,docReport, 
  new DataSourceInfo(new DataStorage(), null),
  new DataSourceInfo(table,"ds"));