POI生成EXCEL基本用法_workbook workbook = new xssfworkbook();定义单元格格式-优快云博客

本文链接：https://blog.youkuaiyun.com/csdn1050056022/article/details/118104057

这段代码展示了如何使用Apache POI库在Java中创建并设置Excel工作簿的单元格样式。创建了三种不同样式的单元格：标题、金额和日期。标题样式设置为居中、无边框，金额样式设置了右对齐和财务格式，日期样式设置了日期格式。此外，还创建了sheet，并设置了列宽、合并单元格，以及填充了数据和公式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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)");