Merging cells in Excel using Apache POI

Question

Is there any other way to merge cells in Excel using Apache POI library?

I was trying using the following, but its not working

// selecting the region in Worksheet for merging data CellRangeAddress region = CellRangeAddress.valueOf("A" + rowNo + ":D"             + rowNo);  // merging the region sheet1.addMergedRegion(region); 

Answer 1

You can use sheet.addMergedRegion(rowFrom,rowTo,colFrom,colTo);

example sheet.addMergedRegion(new CellRangeAddress(1,1,1,4)); will merge from B2 to E2. Remember it is zero based indexing (ex. POI version 3.12).

for detail refer BusyDeveloper's Guide

Answer 2

You can use :

sheet.addMergedRegion(new CellRangeAddress(startRowIndx, endRowIndx, startColIndx,endColIndx)); 

Make sure the CellRangeAddress does not coincide with other merged regions as that will throw an exception.

• If you want to merge cells one above another, keep column indexes same
• If you want to merge cells which are in a single row, keep the row indexes same
• Indexes are zero based

For what you were trying to do this should work:

sheet.addMergedRegion(new CellRangeAddress(rowNo, rowNo, 0, 3));