HTML is not rendered properly in ASPOSE Excel Cells

Aspose.Cells Product Family
1

hi,

While adding below mentioned html to Aspose.Cells, we seeing the html coming as distorted in excel.

<ol><li><p><strong>Testing</strong><br>Define the project&#8217;s purpose, goals, and stakeholders.</p></li><li><p>Abc<br>def</p></li></ol>

Output:

image.png (4.2 KB)

Could you please look into this issue.

Thanks,
Srinivas

2

@SrinivasReddyYella

It seems that you are experiencing issues with rendering HTML content properly in Aspose.Cells. To address this, you can utilize the HtmlLoadOptions class, which allows you to specify options for loading HTML content, including support for div tag layouts.

Here’s a sample code snippet that demonstrates how to load HTML content into an Excel workbook while ensuring that the layout is preserved:

using System.IO;
using Aspose.Cells;

namespace Aspose.Cells.Examples
{
    public class HtmlToExcel
    {
        public static void Run()
        {
            // Sample HTML content
            string htmlContent = @"<ol>
                                    <li><p><strong>Testing</strong><br>Define the project&#8217;s purpose, goals, and stakeholders.</p></li>
                                    <li><p>Abc<br>def</p></li>
                                   </ol>";

            // Convert HTML string to a MemoryStream
            MemoryStream ms = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(htmlContent));

            // Specify HTML load options
            HtmlLoadOptions loadOptions = new HtmlLoadOptions(LoadFormat.Html);
            loadOptions.SupportDivTag = true; // Enable support for div tags

            // Create a workbook object from the HTML using load options
            Workbook workbook = new Workbook(ms, loadOptions);

            // Auto fit rows and columns of the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];
            worksheet.AutoFitRows();
            worksheet.AutoFitColumns();

            // Save the workbook in xlsx format
            workbook.Save("output.xlsx", SaveFormat.Xlsx);
        }
    }
}

In this example, the HTML content is loaded into a MemoryStream, and the HtmlLoadOptions is configured to support div tags. After loading the HTML into a workbook, the rows and columns are auto-fitted to ensure proper display.

Make sure to adjust the HTML content as needed for your specific use case. If you continue to experience issues, please provide more details about the specific distortions you are encountering, and I can assist you further.

3

We are only rendering html in a specific cell, not to the entire workbook. Please find the code example below.

AsposeCell - Code.zip (81.4 KB)

4

@SrinivasReddyYella
We can reproduce the issue by testing on the latest version v25.3 using the following sample code. HTML is not rendered properly in result file after setting Cell.HtmlString property.

Workbook wb = new Workbook();
Cell a1 = wb.Worksheets[0].Cells["A1"];
a1.HtmlString = "<ol><li><p><strong>Testing</strong><br>Define the project&#8217;s purpose, goals, and stakeholders.</p></li><li><p>Abc<br>def</p></li></ol>";
wb.Save(filePath + "out_net.xlsx");

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-58110

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

5

@SrinivasReddyYella ,

We are pleased to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v25.4) that we plan to release in the first half of April 2025. You will be notified when the next version is released.
Attached is the result after fix for your reference:
output.zip (6.1 KB)