web developer

[java] poi 서체(font), 셀 스타일(cellStyle) 변경 본문

Language/Java

[java] poi 서체(font), 셀 스타일(cellStyle) 변경

trueman 2024. 2. 29. 18:00
728x90
728x90

poi 라이브러리를 활용해 서체, 셀 스타일 변경하기

Font font = workbook.Font();
font.setFontName("맑은 고딕");
font.setColor(IndexedColors.BLUE.getIndex());
font.setFontHeightPoints((short) 11);
font.setItalic(true);

CellStyle yellow = workbook.createCellStyle();
yellow.setFillForegroundColor(IndexedColors.LIGHT_YELLOW.getIndex());
yellow.setFillPattern((short) 1);
yellow.setAlignment((short) HorizontalAlignment.CENTER.ordinal());
yellow.setBorderBottom((short) BorderStyle.THIN.ordinal());
yellow.setBorderTop((short) BorderStyle.THIN.ordinal());
yellow.setBorderLeft((short) BorderStyle.THIN.ordinal());
yellow.setBorderRight((short) BorderStyle.THIN.ordinal());
yellow.setFont(font);
728x90
728x90
Comments