Creating a header with two line in excel file with apache POI

Question

How can I get this header from java code with apache POI?

my excel file

Same way you would in Excel, i.e. merged cells? – Gagravarr Sep 07 '16 at 16:45 — Gagravarr, Sep 07 '16 at 16:45

score 1 · Accepted Answer · edited May 23 '17 at 12:08

Usually you do that by merging two cells for all the "Projets" items.

See https://poi.apache.org/spreadsheet/quick-guide.html#MergedCells

Basically you define all the merged areas with calls like this

sheet.addMergedRegion(new CellRangeAddress(
        0, //first row (0-based)
        0, //last row  (0-based)
        0, //first column (0-based)
        1  //last column  (0-based)
));

See also Setting value to cells after merging in POI and Merging cells in Excel using Apache POI for more discussion around this.

Creating a header with two line in excel file with apache POI

1 Answers1