MLog

String temp[] = null; temp = {"aaa", "bbb", "ccc"};

cell.getCellType(); - Cell.class - public static final int CELL_TYPE_NUMERIC = 0; public static final int CELL_TYPE_STRING = 1; public static final int CELL_TYPE_FORMULA = 2; public static final int CELL_TYPE_BLANK = 3; public static final int CELL_TYPE_BOOLEAN = 4; public static final int CELL_TYPE_ERROR = 5;

CellStyle style= rstWb.createCellStyle(); style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER); //세로 가운데 정렬 - CellStyle.class - public static final short VERTICAL_TOP = 0; public static final short VERTICAL_CENTER = 1; public static final short VERTICAL_BOTTOM = 2; public static final short VERTICAL_JUSTIFY = 3;

CellStyle style= rstWb.createCellStyle(); style.setAlignment(HSSFCellStyle.ALIGN_CENTER); //가운데 정렬 - CellStyle.class - public static final short ALIGN_GENERAL = 0; public static final short ALIGN_LEFT = 1; public static final short ALIGN_CENTER = 2; public static final short ALIGN_RIGHT = 3;

sheet.getPrintSetup().setLandscape(true);

메뉴 -> Window -> Preferences -> Web -> HTML Files -> Editor -> Syntax Coloring Attrobute Values 클릭 후 Italic 체크 해제. 완료

private void appExe() { String homePath = System.getProperty("user.home"); String filePath = homePath + "\\" + fileName; try { Runtime.getRuntime().exec("rundll32 url.dll, FileProtocolHandler " + filePath); System.exit(0); } catch (Exception e) { e.printStackTrace(); } } filePath의 확장자에 연결된 프로그램이 실행되게 된다. ex. filePath = "test.xls"; -> 엑셀 실행

Help -> Install New Software... 클릭 Add 버튼 클릭 네임은 아무거나 하고 Location은http://subclipse.tigris.org/update_1.6.x/ Subclipse 체크후 다음 다음 라이센스 동의하고 피니쉬를 누르면 설치된다.

import java.io.FileOutputStream; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.CellRangeAddress; public class Write { public Write() { HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet st = wb.createSheet("Test Sheet"); st.addMergedRegion(new CellRangeAddress( 0, //시작 행번호 2, //마지막 행번호 2, //시작 열번호 4 //마지막 열번호 )); F..

import java.io.FileOutputStream; import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.util.CellRangeAddress; public class Write { public Write() { HSSFWorkbook wb = new HSSFWorkbook(); //엑셀 파일 생성 HSSFSheet st = wb.createSheet("Test Sheet"); //엑셀 시트 생성 HSSFRow row = st.createRow(0); //행 생성 HSSFCell cell = row.createCell(0); ..