Sami Asmar Sami Asmar - 2 months ago 27
Apache Configuration Question

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

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

my excel file

Answer

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.