设置单元格的对齐方式
1.注意:
1.如果每个单元格(cell)的样式都不一样,必须每个单元格都创建一个CellStyle,否则不生效;
2.day03关闭流的方式, 采用了JDK 7的try(),,写在try括号里的资源会自动关闭。
/**
* 设置对齐方式
*/
@Test
public void setAlignment() {
// 创建Excel工作簿
Workbook workbook = new XSSFWorkbook();
// 创建sheet
Sheet sheet = workbook.createSheet(WorkbookUtil.createSafeSheetName("第一页?"));
// 创建行和单元格并设置对齐方式
generateRowAndCell(sheet, workbook, 0, 0, HorizontalAlignment.CENTER, VerticalAlignment.CENTER);
generateRowAndCell(sheet, workbook, 1, 0, HorizontalAlignment.LEFT, VerticalAlignment.BOTTOM);
generateRowAndCell(sheet, workbook, 2, 0, HorizontalAlignment.RIGHT, VerticalAlignment.TOP);
generateRowAndCell(sheet, workbook, 3, 0, HorizontalAlignment.CENTER_SELECTION, VerticalAlignment.DISTRIBUTED);
generateRowAndCell(s