title: Apache POI & colors
body: <p>I've some problems with Apache POI, some help would be nice!!</p>
  
  <p>I would like to remove the colors in a subpart of an Excel sheet.
  To do so, the first thing I tried is to render the cells I want to clean (let say the one of the first row only) and to set their color to white:</p>
  
  <pre><code>cell.getCellStyle().setFillForegroundColor(IndexedColors.WHITE.index);
  </code></pre>
  
  <p>But if i do that, the color of some cells that are not rendered (let say the one of the second row) are also changed to white cells. It's strange, because the cells that are changed do not have the same foreground color, so I thought they would have different  styles ... </p>
  
  <p>Therefore, I've tried another way:</p>
  
  <pre><code>CellStyle style = workbook.createCellStyle();
  style.setFillForegroundColor(IndexedColors.WHITE.index);
  cell.setCellStyle(style);
  </code></pre>
  
  <p>The idea, is to avoid changing a style that may be common to different cells in the Excel sheet. Actually, it solves the color problem, but if I do that, I loose the different styles in the Excel sheet, while I only want to remove some colors...</p>
  
  <p>I'm using a generic Workbook, and I'm reading a xlsx (same problem with a xls)
  Do you know how to do it ?
  Thx a lot,
  regards, </p>