Make the entire row bold using Apache POI

Question

I am using Apache POI's HSSFWorkbook to write data to Excel spreadsheets.

I want to make an entire row bold. Can someone please suggest how to do it?

Answer 1

Would something like this work with what you have:

public static void makeRowBold(Workbook wb, Row row){
    CellStyle style = wb.createCellStyle();//Create style
    Font font = wb.createFont();//Create font
    font.setBold(true);//Make font bold
    style.setFont(font);//set it to bold

    for(int i = 0; i < row.getLastCellNum(); i++){//For each cell in the row 
        row.getCell(i).setCellStyle(style);//Set the style
    }
}

It basically goes over each cell in the row passed in, setting the style to a bold one. Should result in the whole row being set to the desired style.

Good Luck!

EDIT

A more complete example:

public static void main(String[] args) {
    Path myFile = Paths.get(System.getProperty("user.home"), "Desktop", "tester.xlsx");

        try {
            XSSFWorkbook wb = new XSSFWorkbook(new FileInputStream(myFile.toFile()));
            XSSFSheet sheet = wb.getSheetAt(0);
            makeRowBold(wb, sheet.getRow(0));

            wb.write(new FileOutputStream(myFile.toFile()));
        } catch (IOException e) {
            e.printStackTrace();
        }
}


public static void makeRowBold(Workbook wb, Row row){
    CellStyle style = wb.createCellStyle();//Create style
    Font font = wb.createFont();//Create font
    font.setBold(true);//Make font bold
    style.setFont(font);//set it to bold

    for(int i = 0; i < row.getLastCellNum(); i++){//For each cell in the row 
        row.getCell(i).setCellStyle(style);//Set the sty;e
    }
}

This was tested on an xlsx file with data in row 1, the resulting file had bold data afterwards.

Answer 2

Using the non-deprecated API:

public static void makeBold(Workbook workbook, Row row)
{
    CellStyle cellStyle = cell.getCellStyle();
    cellStyle.setFont(font);

    for (int rowIndex = 0; rowIndex < row.getLastCellNum(); rowIndex++)
    {
        Cell cell = row.getCell(rowIndex);
        XSSFFont font = (XSSFFont) workbook.createFont();
        font.setBold(true);
        cell.setCellStyle(cellStyle);
    }
}