Java生成Excel文档-优快云博客

本文介绍了一个使用Java进行Excel文件操作的例子，展示了如何创建Excel工作簿、设置单元格样式及写入数据等基本操作。

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


HSSFWorkbook workBook = new HSSFWorkbook();
HSSFSheet sheet = workBook.createSheet();
HSSFRow row = sheet.createRow(0);
//样式

HSSFFont workFont = workBook.createFont();
workFont.setFontName("微软雅黑");
workFont.setFontHeightInPoints((short)14);
workFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

HSSFCellStyle cellStyle = workBook.createCellStyle();
cellStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);
cellStyle.setBorderLeft(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderTop(HSSFCellStyle.BORDER_THIN);
cellStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);
cellStyle.setFont(workFont);

HSSFCell cell = row.createCell(0);
cell.setCellValue("001");
cell.setCellStyle(cellStyle);

cell = row.createCell(1);
cell.setCellValue("华家乐");
cell.setCellStyle(cellStyle);


cell = row.createCell(2);
cell.setCellValue("1981-08-17");
cell.setCellStyle(cellStyle);

workBook.setSheetName(0, "新建工作薄");

FileOutputStream fos = new FileOutputStream("d:/test.xls");
workBook.write(fos);
fos.flush();
fos.close();