Applying styles to the merged regions

[Vinny Bhat]

Hi all,

I am creating an excel sheet using the Apache's POI method. I am stuck with applying the styles to the merged regions here.

The code I am using is as follows:

Am creating a cell and adding the merged region from the cell 1 to 6.

newHeaderCells = headerRow.createCell((short)1);
newHeaderCells.setCellValue("Composite Deere Fiscal Year Estimate");	
newHeaderCells.setCellStyle(restEstCellStyle);
annualCurrentYrSheet.setColumnWidth(1, 8500);
annualCurrentYrSheet.addMergedRegion(new CellRangeAddress(12,12,1,6));

Cell style used in the above code is as follows:

HSSFCellStyle restEstCellStyle= aHSSFWorkbook.createCellStyle();
		restEstCellStyle.setFont(restEstFont);
		restEstCellStyle.setFillForegroundColor(hssfColorHeader.getIndex());
		restEstCellStyle.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
		restEstCellStyle.setWrapText(true);	
		restEstCellStyle.setVerticalAlignment((short)0);
		restEstCellStyle.setAlignment((short)2);	
		restEstCellStyle.setBorderBottom((short)1);
		restEstCellStyle.setBorderLeft((short)1);
		restEstCellStyle.setBorderRight((short)1);
		restEstCellStyle.setBorderTop((short)1);

How can I specify this cell style to all 1 to 6 cells that I have merged? Right now it applies only to one cell i.e first cell.

Any help would be greatly appreciated.