POI生成EXCEL基本用法

Workbook workbook = new XSSFWorkbook();

//单元格格式
CellStyle title = workbook.createCellStyle();
CellStyle amount = workbook.createCellStyle();
CellStyle dateStyle = workbook.createCellStyle();

Font font = workbook.createFont();
font.setFontName("微软雅黑");
font.setFontHeight((short) 180);

//标题
title.setBorderBottom(BorderStyle.NONE); //下边框
title.setBorderLeft(BorderStyle.NONE);//左边框
title.setBorderTop(BorderStyle.NONE);//上边框
title.setBorderRight(BorderStyle.NONE);//右边框
title.setVerticalAlignment(VerticalAlignment.CENTER);// 垂直
title.setAlignment(HorizontalAlignment.LEFT);// 水平
title.setWrapText(false);// 指定当单元格内容显示不下时自动换行
title.setFont(font);

//金额
amount.setBorderBottom(BorderStyle.NONE); //下边框
amount.setBorderLeft(BorderStyle.NONE);//左边框
amount.setBorderTop(BorderStyle.NONE);//上边框
amount.setBorderRight(BorderStyle.NONE);//右边框
amount.setVerticalAlignment(VerticalAlignment.CENTER);// 垂直
amount.setAlignment(HorizontalAlignment.RIGHT);// 水平
amount.setWrapText(false);// 指定当单元格内容显示不下时自动换行
amount.setFont(font);
amount.setDataFormat( HSSFDataFormat.getBuiltinFormat("#,##0.00"));//财务计数法

CreationHelper creationHelper = workbook.getCreationHelper();
//日期
dateStyle.setBorderBottom(BorderStyle.NONE); //下边框
dateStyle.setBorderLeft(BorderStyle.NONE);//左边框
dateStyle.setBorderTop(BorderStyle.NONE);//上边框
dateStyle.setBorderRight(BorderStyle.NONE);//右边框
dateStyle.setVerticalAlignment(VerticalAlignment.CENTER);// 垂直
dateStyle.setAlignment(HorizontalAlignment.LEFT);// 水平
dateStyle.setWrapText(false);// 指定当单元格内容显示不下时自动换行
dateStyle.setFont(font);
dateStyle.setDataFormat(creationHelper.createDataFormat().getFormat("yyyy-MM-dd"));

// 创建sheet
Sheet sheet = workbook.createSheet("XXXXX表");

//设置对应单元格宽度12个字符
sheet.setColumnWidth(7,12*256);

//合并单元格
sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 2));

//行
Row row;
//列
Cell cell;
//赋值
row = sheet.createRow(0);
cell = row.createCell(0);
cell.setCellStyle(title);
cell.setCellValue("XX");

//设定EXCEL函数
cell = row.createCell(14);
cell.setCellStyle(amount);
cell.setCellFormula("SUM(C7:N7)");