title: HTML Formatted Cell value to Excel using Apache POI 1
body: <p>I want to display the Html Formatted value in to Excel cell. the html tag contains unordered, ordered and bullets, italic and underline and paragraph. </p>
  
  <p>I want to pass the html markup tag to something which shows the formatted value in apache poi excel's cell value. </p>
  
  <pre><code>XSSFWorkbook workBook = null; 
  String value = "&lt;html&gt;My String&lt;/html&gt;"; 
  workBook = new XSSFWorkbook (); 
  XSSFCell cell = row.createCell(columnIndex); 
  XSSFRichTextString textString = new XSSFRichTextString (value); 
  cell.setCellValue(value); 
  </code></pre>
  
  <p>Input data: </p>
  
  <pre><code>   &lt;ul&gt;
      &lt;li&gt; Iam &lt;strong&gt;Bold &lt;/strong&gt; and Iam &lt;u&gt;Underlined &lt;/u&gt; &lt;/li&gt;
      &lt;li&gt; Just a Normal Text &lt;/li&gt;
      &lt;li&gt; Iam &lt;b&gt; Bold &lt;/b&gt; &lt;em&gt;and italic &lt;/em&gt; &lt;u&gt; and underlined &lt;/u&gt; &lt;/li&gt;
    &lt;/ul&gt;
  </code></pre>
  
  <p>Expected output:</p>
  
  <p><strong>.</strong> Iam  <strong>Bold</strong> and Iam <em>Italic</em> <br/>
    <strong>.</strong> Iam  <strong>Bold</strong> and Iam <em>Italic</em> and Underlined <br/>
    <strong>.</strong> Just a normal text</p>
  
  <p>Any api provides that, Aspose or Itext or Some other api. </p>