title: Is there any way to add color to cell from hex value like '#72fe9c' in my excel doc using NPOI
body: <p>As I am new with NPOI, and I want to add color to a cell in my excel sheet. I am having a hex value like '#ffeeff' and in <code>ICellStyle.FillForegroundColor</code> only short int value can be assigned.</p>
  
  <blockquote>
    <p>System.OverflowException: Value was either too large or too small for an Int16.</p>
  </blockquote>
  
  <p>I have tried code like this and it is working </p>
  
  <pre><code>style.FillForegroundColor = HSSFColor.Grey25Percent.Index;
  </code></pre>
  
  <p>but I only have hex value that can be converted to int, but it supports only short int values.</p>
  
  <pre><code>//it is working
  style.FillForegroundColor = HSSFColor.Grey25Percent.Index;
  
  // not working for me as '#ffeeff' canot be converted to short, it can only be converted to int
  style.FillForegroundColor = short.Parse(fontcolorCode.Substring(1), NumberStyles.HexNumber)
  
  style.FillForegroundColor = short.Parse(fontcolorCode.Substring(1), NumberStyles.HexNumber) 
  </code></pre>
  
  <p>It should not throw an error and in the excel sheet, the same color(fontcolorCode) must be applied to the cell</p>