How to Create Different Data Format of Cells in a Spreadsheet Using Java?

// Java Program to Apply Different Data Formats to
// a Cell in a Spreadsheet

// Importing required classes
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import org.apache.poi.ss.usermodel.DataFormat;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFCellStyle;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

// Main class
class GFG {

    // Main driver method
    public static void main(String[] args) throws Exception
    {
        // Naming of WorkBook
        String excelfilename = "GeeksForGeeks.xlsx";

        // Creating a WorkBook
        XSSFWorkbook workbook = new XSSFWorkbook();

        // Create a Spread Sheet by creating an object of
        // XSSFSheet and also give name
        XSSFSheet spreadsheet
            = workbook.createSheet("Sheet1");

        // Create a row and put some cells in it. Rows are 0
        // based.
        XSSFRow row;

        // Creating a cell
        XSSFCell cell;

        // style
        XSSFCellStyle style;

        // Creating format to format style
        DataFormat format = workbook.createDataFormat();
        int rowNum = 0;
        int colNum = 0;

        // Creating a row in Spread Sheet
        row = spreadsheet.createRow(rowNum++);

        // Creating a cell in row
        cell = row.createCell(colNum);

        // Setting a value
        cell.setCellValue(11111.25);

        style = workbook.createCellStyle();

        // Setting a Format to a cell using style
        style.setDataFormat(format.getFormat("0.0"));
        cell.setCellStyle(style);

        row = spreadsheet.createRow(rowNum++);
        cell = row.createCell(colNum);
        cell.setCellValue(11111.25);
        style = workbook.createCellStyle();

        // Creating another format using style
        style.setDataFormat(format.getFormat("#,##0.0000"));
        cell.setCellStyle(style);

        // Try block to check for exceptions
        try {

            // Place the output file in default location and
            // also kept in try catch block
            FileOutputStream outputfile
                = new FileOutputStream(excelfilename);

            // Writing to workbook
            workbook.write(outputfile);

            // Closing the output file
            // using close() method
            outputfile.close();

            // Display message for console window when
            // program is successfully executed
            System.out.println(excelfilename
                               + " is written successfully");
        }

        // Catch block to handle exceptions
        catch (FileNotFoundException e) {

            // Display error message for console window when
            // program is not successfully executed
            System.out.println("ERROR!! " + e.getMessage());
        }
    }
}