티스토리 뷰

Java/POI

[POI] 셀 합치기

M_막심 2011. 12. 6. 16:20
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  //마지막 열번호
		    ));
		  
		  FileOutputStream fs = null;

		  try {
			  fs = new FileOutputStream("C:\\test.xls");
			  
			  wb.write(fs);
			  
			  fs.close();
		  } catch (Exception e) {e.printStackTrace();}
	}
}

댓글