java POI设置Excel单元格字体

最新推荐文章于 2025-07-01 11:57:10 发布

原创最新推荐文章于 2025-07-01 11:57:10 发布 · 1.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#excel #java #poi

java poi 专栏收录该内容

17 篇文章

订阅专栏

本文介绍了如何使用Java的Apache POI库中的HSSFWorkbook类来创建包含特定格式单元格的Excel工作簿。通过实例展示了创建Excel工作表、设置字体样式、创建单元格并为其赋值的过程。

		   Workbook wb = new HSSFWorkbook();
		    Sheet sheet = wb.createSheet("new sheet");

		    // Create a row and put some cells in it. Rows are 0 based.
		    Row row = sheet.createRow(1);

		    // Create a new font and alter it.
		    Font font = wb.createFont();
		    font.setFontHeightInPoints((short)24);
		    font.setFontName("Courier New");
		    font.setItalic(true);
		    font.setStrikeout(true);

		    // Fonts are set into a style so create a new one to use.
		    CellStyle style = wb.createCellStyle();
		    style.setFont(font);

		    // Create a cell and put a value in it.
		    Cell cell = row.createCell(1);
		    cell.setCellValue("This is a test of fonts");
		    cell.setCellStyle(style);
		    // Write the output to a file
		    FileOutputStream fileOut = new FileOutputStream("E:\\standarcode\\workbook.xls");
		    wb.write(fileOut);
		    fileOut.close();

效果：