Insert RichText or Html in Aspose.Cell document

Aspose.Cells Product Family
1

Is there a way to insert RTF text or HTML document in a workbook starting with specific cell?

It should be something similar to Excel’s right click on cell and Paste functionality…

To reproduce Excel behavior : copy html doc text from attached file, open Excel, right click on any cell, select ‘Paste Special’ and choose ‘Unicode text’ in a following dialog - and you will get 3 formatting lines appeared in Excel…




2

Hi,

Thanks for your posting and using Aspose.Cells.

Please see this document if it is helpful for you. Let us know your feedback.

( Adding HTML Rich Text inside the Cell|Documentation )

3

Unfortunately, it does not work since HTML contains multi line and multi format options, so using HtmlString does not achieve expected result - it shows just html doc as ASCI text instead of converting it…

4

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to convert your Html to Xlsx format but the results are not good. Please see the attached screenshot that shows the difference of Microsoft Excel and Aspose.Cells output. We have tested this issue with the following sample code and also attached the output excel file for a reference.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-44336 - Unable to convert Html to Xlsx properly

C#
HTMLLoadOptions opts = new HTMLLoadOptions(LoadFormat.Html);
opts.Encoding = Encoding.UTF8;

Workbook workbook = new Workbook(“test.html”, opts);
workbook.Save(“output.xlsx”);

5

Hi again,


This is to update you that we are working to provide the fix for CELLSNET-44336. As soon as the fix is available for your testing, we will post the updates here for your reference.
6
Hi there,

This is to inform you that the ticket logged earlier as CELLSNET-44336 has been marked resolved. We will shortly share the fix here for your testing.
7

Hi,

Thanks for using Aspose.Cells.

Please download and try the following latest fix

Aspose.Cells for .NET v17.1.6 (.NET 2.0) compiled in .NET Framework 2.0.
Aspose.Cells for .NET v17.1.6 (.NET 4.0) compiled in .NET Framework 4.0.

and let us know your feedback.

8

The issues you have found earlier (filed as CELLSNET-44336) have been fixed in Aspose.Cells for .NET 17.2.0.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.