Apache POI is a powerful Java library that allows developers to work with various Microsoft Office file formats, including Word (.docx) and Excel (.xlsx) files. In this blog post, we will explore how to use Apache POI and Gradle to generate separate Word documents with unique filenames from Excel data. This can be especially useful in scenarios where you need to create personalized documents, such as certificates, letters, or reports for a large number of recipients.

Before we begin, ensure you have the following installed:

Java Development Kit (JDK): Apache POI requires Java to run. Install the latest JDK version from Oracle or OpenJDK.

Gradle: Gradle is a build automation tool that simplifies managing dependencies and building projects. Install Gradle from the official website.

Microsoft Excel: You will need Microsoft Excel or an equivalent software to create the Excel file containing the data.

Create a new directory for your project and set up the following folder structure:

In the project root, create a build.gradle file, and add the following dependencies:

    implementation 'org.apache.poi:poi:5.1.0'

    implementation 'org.apache.poi:poi-ooxml:5.1.0'

The above build.gradle file adds the Apache POI dependencies to our project.

Step 3: Read Excel Data and Create Word Documents

In the main/java folder, create a Java class (e.g., DocumentGenerator.java) to handle the data processing and document creation:

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

    public static void main(String[] args) {

            FileInputStream excelFile = new FileInputStream("data.xlsx");

            Workbook workbook = new XSSFWorkbook(excelFile);

            Sheet sheet = workbook.getSheetAt(0);

                String recipientName = row.getCell(0).getStringCellValue();

                String content = row.getCell(1).getStringCellValue();

                XWPFDocument document = new XWPFDocument();

                XWPFParagraph paragraph = document.createParagraph();

                XWPFRun run = paragraph.createRun();

                run.setText("Dear " + recipientName + ",\n\n" + content);

                FileOutputStream output = new FileOutputStream(recipientName + ".docx");

            System.out.println("Documents generated successfully!");

Create a new Excel file (e.g., data.xlsx) in the resources folder. In the first column, add the names of the recipients, and in the second column, add the content for each recipient's document.

Open your terminal, navigate to the project root, and run the following command:

The program will read the data from the Excel file, create separate Word documents for each recipient, and save them with filenames matching the recipients' names.

In this blog post, we demonstrated how to use Apache POI and Gradle to generate separate Word documents with unique filenames from Excel data. By leveraging the power of Apache POI's libraries, we were able to efficiently read Excel data and create personalized documents for each recipient. This approach can be extended and customized to suit various use cases, such as automating certificate generation, creating personalized reports, or generating customized letters.

Automate document generation with Apache POI & Gradle. Extract data from Excel, create personalized Word docs with unique filenames. Efficient and versatile solution.

apache poi

Trending Blogposts on apache poi

Generating Separate Word Documents with Unique Filenames from Excel Data using Apache POI and Gradle

Popular Discussions on apache poi

PRODUCTS

QUICK LINKS

LEGAL

apache poi

Trending Blogposts on apache poi

Generating Separate Word Documents with Unique Filenames from Excel Data using Apache POI and Gradle

Popular Discussions on apache poi