import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import java.io.FileOutputStream;

public class XslxCreator {

    public  static void main(String[] args) {
        try{
            Workbook wb = new XSSFWorkbook();
            CreationHelper ch = wb.getCreationHelper();
            Sheet sh = wb.createSheet("mySheet");
            CellStyle cs1 = wb.createCellStyle();
            CellStyle cs2 = wb.createCellStyle();
            DataFormat df = wb.createDataFormat();
            Font f1 = wb.createFont();
            Font f2 = wb.createFont();
            f1.setFontHeight((short)12);
            f1.setColor(IndexedColors.RED.getIndex());
            f1.setBold(true);
            f2.setFontHeight((short)15);
            f2.setColor(IndexedColors.BLUE.getIndex());
            f2.setItalic(true);
            cs1.setFont(f1);
            cs1.setDataFormat(df.getFormat("#,##0.0"));
            cs2.setFont(f2);
            cs2.setDataFormat(df.getFormat("text"));
            cs2.setBorderBottom(BorderStyle.THIN);
            for(int rown = 0; rown < 10; rown++) {
                Row row = sh.createRow(rown);
                for(int celln = 0; celln < 10; celln+=2) {
                    Cell c1 = row.createCell(celln);
                    c1.setCellStyle(cs1);
                    Cell c2 = row.createCell(celln + 1);
                    c2.setCellStyle(cs2);
                    c1.setCellValue((double)rown + (celln/10));
                    c2.setCellValue(ch.createRichTextString("Hello! " + celln));
                }
            }
            String fileName = "src\\main\\resources\\xml\\Ex1.xlsx";
            FileOutputStream out = new FileOutputStream(fileName);
            wb.write(out);
        } catch (Exception e) {
            System.out.println(e);
        }

    }

}