Merging cells in Excel using Apache POI

java android excel apache-poi
androidDev picture androidDev · Sep 10, 2013 · Viewed 148.3k times · Source

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

Sankumarsingh picture Sankumarsingh · Sep 10, 2013

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

Related questions

Apache POI insert image

I am having troubles with inserting a picture in an excel sheet im making. There are a lot of question about this subject, but I simply cannot figure out what am I doing wrong. My code runs, shows no errors …

Read More
How to import import org.apache.poi.ss.usermodel.Row error?

I am tring to write data into Excel using Apache i refer this link:https://www.mkyong.com/java/apache-poi-reading-and-writing-excel-file-in-java/ Cell and Row are not Importing This my java class code: I download Apache jar file here MY java code …

Read More
Jxl cell alignment

i want to know how can i set an alignment for cell in jxl library , it's default alignment is bottom and when i set alignment for WritableCellFormat it throws me this Exception : jxl.write.biff.JxlWriteException: Attempt to modify a …

Read More