We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Wrong formatting when opening HTML as Workbook

Hi, we have an html file containing a table (Test.html). If we open this file with Microsoft Excel or a browser we see the table correctly.

But if we open the file and save it as a workbook using the following code with Aspose.Cells, we see the table with a messed up formatting (see Test.xlsx).

var wb = new Workbook("Test.html");
wb.Save("Test.xlsx");

The font formatting (bold, underline, italics, color) is lost and some fonts are changed (Calibri instead of Book Antiqua or Comic Sans). Also we see “-1” instead of “(€ 1,000)”.

Could you please provide a fix?

Attachments.zip (8.3 KB)

@davidepedrocca,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47382 – Html to Excel conversion loses formatting

@davidepedrocca,

This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Keep in touch.

The issues you have found earlier (filed as CELLSNET-47382) have been fixed in Aspose.Cells for .NET v20.6. you may also get the version @ NuGet repos. here (https://www.nuget.org/packages/Aspose.Cells/20.6.0).This message was posted using Bugs notification tool by Amjad_Sahi

The issues you have found earlier (filed as CELLSNET-47382) have been fixed in Aspose.Cells for .NET v20.6. you may also get the version @ NuGet repos. here (https://www.nuget.org/packages/Aspose.Cells/20.6.0).This message was posted using Bugs notification tool by Amjad_Sahi

A post was split to a new topic: Vertical alignment of text changed while converting HTML to XLSX