EasyXLS

How to create Excel file in Java

package testexceljava;

import EasyXLS.*;

/* ------------------------------------------------------------
 | Tutorial 03
 |
 | This tutorial shows how to create an Excel file (1) that has
 | multiple sheets (2) in Java. The created Excel file is empty
 | and the next tutorial shows how to add data into sheets.
 * ------------------------------------------------------------ */
 Click here to see the Excel file

public class Tutorial03 {

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

            // Create an instance of the class that creates Excel files, having two sheets (1) 
            ExcelDocument workbook = new ExcelDocument(2);
      
            // Set the sheet names (2) 
            workbook.easy_getSheetAt(0).setSheetName("First tab");
            workbook.easy_getSheetAt(1).setSheetName("Second tab");
      
            // Create the Excel file
            System.out.println("Writing file: C:\\Samples\\Tutorial03.xls");
            workbook.easy_WriteXLSFile("C:\\Samples\\Tutorial03.xls");

            // Confirm the creation 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