Apache POI SXSSFWorkbook - border for merged cells -


i use sxssfworkbook() create workbook. have requirement merge few cells across rows/columns , give border.

my problem is: merging of cells out applying border works fine, however, moment try merge cells , apply border application runs exception.

error view - java.lang.illegalargumentexception: attempting write row[2] in range [0,204] written disk. java.lang.illegalargumentexception: attempting write row[2] in range [0,204] written disk. @ org.apache.poi.xssf.streaming.sxssfsheet.createrow(sxssfsheet.java:113) @ org.apache.poi.ss.util.cellutil.getrow(cellutil.java:90) @ org.apache.poi.ss.util.regionutil.setrightbordercolor(regionutil.java:139) 

my code:

cellrangeaddress rangeadd = new cellrangeaddress(2, 41, 0, 0); sheet.addmergedregion(rangeadd); regionutil.setrightbordercolor(indexedcolors.black.getindex(), rangeadd, sheet, mwb); regionutil.settopbordercolor(indexedcolors.black.getindex(), rangeadd, sheet, mwb); regionutil.setleftbordercolor(indexedcolors.black.getindex(), rangeadd, sheet, mwb); regionutil.setbottombordercolor(indexedcolors.black.getindex(), rangeadd, sheet, mwb);  regionutil.setborderbottom(cellstyle.border_thin, rangeadd, sheet, mwb); regionutil.setborderleft(cellstyle.border_thin, rangeadd, sheet, mwb); regionutil.setborderright(cellstyle.border_thin, rangeadd, sheet, mwb); regionutil.setbordertop(cellstyle.border_thin, rangeadd, sheet, mwb); 

any help/pointers around great.


Comments