Hello everyone, I work on apache poi through xml I need to get the style of the cells, namely the 'union'. Made it this way

<Cells wrap_text="true" mergeR="0" mergeR1="0" mergeC="0" mergeC1="8" font_size="11" font="Calibri" font_bold="true" text_align="2" vertical_align="1" border_top="0" border_left="0" border_right="0" border_bottom="0"> <width>21</width> <cell_value>3. Жыл соңына жылжымалы құрам</cell_value> </Cells>

And in the classroom itself

 spreadsheet.addMergedRegion(new CellRangeAddress( records.getMergeR(), records.getMergeR1(), records.getMergeC(), records.getMergeC1()) );

Is there an alternative way to do this ?!

    1 answer 1

      // Объединить ячейки(startRow, endRow, startColumn, endColumn) sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 2));

    http://www.programru.com/blog/MYTO0ADMwITz.html