셀 합치기

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();}

    }

}