EasyXLS

How to export data to XLSX file in Java

package testexceljava;

import EasyXLS.*;
import EasyXLS.Constants.*;

/* -------------------------------------------------------------
 | Tutorial 28
 |
 | This tutorial shows how to export data to XLSX file that has
 | multiple sheets in Java. The first sheet is filled with data.	  
 * ------------------------------------------------------------- */
 Click here to see the Excel file

public class Tutorial28{

    public static void main(String[] args) {
        try {
            System.out.println("Tutorial 28");
            System.out.println("----------");

            // Create an instance of the class that exports Excel files, having two sheets
            ExcelDocument workbook = new ExcelDocument(2);

            // Set the sheet names
            workbook.easy_getSheetAt(0).setSheetName("First tab");
            workbook.easy_getSheetAt(1).setSheetName("Second tab");

            // Get the table of data for the first worksheet
            ExcelTable xlsFirstTable = ((ExcelWorksheet)workbook.easy_getSheetAt(0)).easy_getExcelTable();

            // Add data in cells for report header
            for (int column=0; column<5; column++)
            {
                xlsFirstTable.easy_getCell(0,column).setValue("Column " + (column + 1));
                xlsFirstTable.easy_getCell(0,column).setDataType(DataType.STRING);
            }

            // Add data in cells for report values
            for (int row=0; row<100; row++)
            {
                for (int column=0; column<5; column++)
                {
                    xlsFirstTable.easy_getCell(row+1,column).setValue("Data " + (row + 1) + ", " + (column + 1));
                    xlsFirstTable.easy_getCell(row+1,column).setDataType(DataType.STRING);
                }
            }

            // Export the XLSX file
            System.out.println("Writing file: C:\\Samples\\Tutorial28.xlsx");
            workbook.easy_WriteXLSXFile("C:\\Samples\\Tutorial28.xlsx");

            // Confirm export of Excel file
            if (workbook.easy_getError().equals(""))
                System.out.println("File successfully created.");
            else
                System.out.println("Error encountered: " + workbook.easy_getError());

            // Dispose memory
            workbook.Dispose();
        }
        catch (Exception ex) {
            ex.printStackTrace();
        }
    }
}

EasyXLS Excel libraries:

Java
Excel Library for Java
full Java version to import, export or convert Excel files
Excel Writer for Java
Java version to create and export Excel files
Download EasyXLS™ Excel Library for Java

File formats:

MS Excel 97 - 2003
MS Excel 2007 - 2010
MS Excel 2013
MS Excel 2016
MS Excel 2019
XLSX XLSM XLSB XLS
XML HTML CSV TXT