ApacheMergeCells.java

package featurescomparison.workingwithcellsrowscolumns.mergecells.java;

import java.io.FileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.util.CellRangeAddress;

public class ApacheMergeCells
{
	public static void main(String[] args) throws Exception
	{
		String dataPath = "src/featurescomparison/workingwithcellsrowscolumns/mergecells/data/";
		
		Workbook wb = new HSSFWorkbook();
		Sheet sheet = wb.createSheet("new sheet");
		
		Row row = sheet.createRow((short) 1);
		Cell cell = row.createCell((short) 1);
		cell.setCellValue("This is a test of merging");
		
		sheet.addMergedRegion(new CellRangeAddress(
		        1, //first row (0-based)
		        1, //last row  (0-based)
		        1, //first column (0-based)
		        2  //last column  (0-based)
		));
		
		// Write the output to a file
		FileOutputStream fileOut = new FileOutputStream(dataPath + "merge_Apache_Out.xls");
		wb.write(fileOut);
		fileOut.close();
		
		// Print message
		System.out.println("Process completed successfully");
	}
}