title: Apache POI- formatting
body: <p>I am trying to provide colors to my headers(first row) to all of my excel sheets, but it's not working. Am i missing something? Can you please provide your feedback</p>
  <pre><code>val workbook = XSSFWorkbook(inputStream)
  val style: CellStyle = workbook.createCellStyle();
  style.setFillForegroundColor(IndexedColors.GREEN.getIndex())
  style.setFillPattern(FillPatternType.SOLID_FOREGROUND)
  val font: Font = workbook.createFont()
  font.color = IndexedColors.YELLOW.getIndex()
  style.setFont(font)
  val Sheet1 = workbook.createSheet(&quot;Sheet1&quot;)
  </code></pre>