Example usage for org.apache.poi.hssf.usermodel HSSFSheet removeMergedRegion

Introduction

In this page you can find the example usage for org.apache.poi.hssf.usermodel HSSFSheet removeMergedRegion.

Prototype

@Override
public void removeMergedRegion(int index) 

Source Link

Document

removes a merged region of cells (hence letting them free)

Usage

From source file:com.haulmont.yarg.formatters.impl.XLSFormatter.java

License:Apache License

protected void removeMergedRegions(HSSFSheet resultSheet) {
    for (int i = 0, size = resultSheet.getNumMergedRegions(); i < size; i++) {
        resultSheet.removeMergedRegion(0);//each time we remove region - they "move to left" so region 1 become region 0
    }/*from w  ww. j  a  v a 2 s  .  c  om*/
}

---