title: How to format a column instead of cell in POI hssf
body: <p>I'm facing an issue when opening a excel file with hundreds/thousands of rows of data, "Too Many Different Cell Formats"</p>
  
  <p>More info about the error<br>
  <a href="http://excelzoom.com/2009/09/the-mystery-of-excels-too-many-different-cell-formats/" rel="nofollow">http://excelzoom.com/2009/09/the-mystery-of-excels-too-many-different-cell-formats/</a></p>
  
  <p>So I'm trying to format a column not a cell. The only way I can figure out how to format a column is by formating each individual cell; by implementing the code listed below. I would like to format a column instead of a row. I have hundreds/thousands of rows of data to format. Any suggestions would be very much appreciated. </p>
  
  <p>Thanks, </p>
  
  <pre><code>HSSFCellStyle cellStyle = wb.createCellStyle();
  HSSFDataFormat dataFormat = wb.createDataFormat();
  cellStyle.setDataFormat(dataFormat.getFormat("0.00"));
  
  HSSFRow row = sheet.createRow(iRow);
  HSSFCell cell = row.createCell((short)1);
  cell.setCellStyle(cellStyle);
  </code></pre>