poi 创建 Excel

最新推荐文章于 2024-04-24 16:34:23 发布

ht_00001

最新推荐文章于 2024-04-24 16:34:23 发布

阅读量200

点赞数

分类专栏：文件解析文章标签： poi excel

本文链接：https://blog.csdn.net/ht_00001/article/details/51418083

版权

文件解析专栏收录该内容

6 篇文章 0 订阅

订阅专栏

实例地址： http://download.csdn.net/detail/ht_00001/9520917

/**创建文件*/
FileOutputStream fileOutput = new FileOutputStream(path);
Workbook wb =null;
if(path.endsWith(".xls")){
wb = new HSSFWorkbook();
}else if(path.endsWith(".xlsx")){
wb = new XSSFWorkbook();
}
/**创建Sheet*/
Sheet sheet1 = wb.createSheet("sheet1");

String safeName = WorkbookUtil.createSafeSheetName("[0'Brien's sales*?]");
Sheet sheet2 = wb.createSheet(safeName);
CreationHelper createHelper = wb.getCreationHelper();

/**创建行*/
Row row = sheet1.createRow(0);
/**创建单元格*/
Cell cell = row.createCell(0);
/**单元格赋值*/
cell.setCellValue(0);

row.createCell(1).setCellValue(1.2);
/**设置样式*/
CellStyle style = wb.createCellStyle();
style.setAlignment(CellStyle.ALIGN_CENTER);
style.setVerticalAlignment(CellStyle.VERTICAL_BOTTOM);
/**给单元格设置样式*/
row.createCell(1).setCellStyle(style);