c# - npoi vertical alignment center -

c# - npoi vertical alignment center -

i've tried dozen ways , nil works. seek apply vertical alignment center.

nothing seems working.

i'd appreciate help.

here code:

var workbook = new hssfworkbook(); var sheet = workbook.createsheet("zmiana " + i.tostring()); var headerrow = sheet.createrow(0); headerrow.createcell(0).setcellvalue("data"); headerrow.createcell(1).setcellvalue("maszyna"); headerrow.createcell(2).setcellvalue("zmiana"); headerrow.createcell(3).setcellvalue("brygadzista"); int rownumber = 1; list<machinestatusreport> listforoneshift = list.where(c => c.zmiana == i).tolist(); foreach (machinestatusreport elements in listforoneshift) { var row = sheet.createrow(rownumber++); row.createcell(0).setcellvalue(date.toshortdatestring()); row.createcell(1).setcellvalue(elements.stanowisko); row.createcell(2).setcellvalue("zmiana " + i.tostring()); row.createcell(3).setcellvalue(elements.brygadzista); row.createcell(4).setcellvalue(elements.kodproduktu); } npoi.ss.util.cellrangeaddress cra = new npoi.ss.util.cellrangeaddress(1, counter, 1, 5); sheet.addmergedregion(cra); } memorystream output = new memorystream(); workbook.write(output);

cheers!

c# excel npoi