Java Check if the Text in a Cell is Bolded Using Apache POI HSSF

Question

Using Java and Hssf to get Excel data, how to check if a cell is bolded? I am iterating through all sheets, all rows, and all cells of an Excel workbook. I want to perform an action if the cell is bolded.

//Iterate through excel sheets    
for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
    HSSFSheet excelSheet = workbook.getSheetAt(i);
    HSSFRow row;
    Iterator rows = excelSheet.rowIterator();

    //Iterate through rows        
    while (rows.hasNext()) {
        row = (HSSFRow) rows.next();
        HSSFCell cell;
        Iterator cells = row.cellIterator();

        //Iterate through cells            
        while (cells.hasNext()) {
            cell = (HSSFCell) cells.next();

            //If cell contains all bolded text
            //DO Something
        }
    }
}

Using HSSFFont's method getBold()? – Yev May 22 '16 at 21:29 — Yev, May 22 '16 at 21:29
How to do that? I cannot find a good example. – pseudorandom May 22 '16 at 21:35 — pseudorandom, May 22 '16 at 21:35

score 1 · Answer 1 · answered May 22 '16 at 23:28

1

Ok, so this is how you could use it:

//Iterate through cells            
  while (cells.hasNext()) {
        cell = (HSSFCell) cells.next();
        HSSFCellStyle style = (HSSFCellStyle) cell.getCellStyle();
        HSSFFont font = style.getFont(workbook);
        boolean isBold = font.getBold();
        System.out.println("Cell value : " + cell + ". Is bold? - " + isBold);
  }

answered May 22 '16 at 23:28

Yev

321
3
9

Did this help you? If so, please don't forget to accept the answer. – Yev May 24 '16 at 23:40

Java Check if the Text in a Cell is Bolded Using Apache POI HSSF

1 Answers1