MHT to XLSX cell content problem

Aspose.Cells Product Family
1

Hi ,

When converting MHT file with table and a single cell contains over 200 numeric characters ,
to XLSX format , the outcome is NA.

Please see attached MHT file ,

Thanks,
386.zip (4.6 KB)

2

@Austin_Powers,

Thanks for the template file.

We will evaluate your issue and get back to you soon.

3

@Austin_Powers,

After an initial test, I am able to observe the issue as you mentioned by using your template file to convert to XLSX file format. I found that when converting MHT file with table and a single cell (that contains over 200 numeric characters) to XLSX file format, the output value for the cell is ‘#N/A’:
e.g
Sample code:

HTMLLoadOptions ldps = new HTMLLoadOptions(LoadFormat.MHtml); 
var workbook = new Workbook("e:\\test2\\386.mht", ldps);
workbook.Save("e:\\test2\\out1.xlsx", SaveFormat.Xlsx);

I have logged a ticket with an id “CELLSNET-46494” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

4

@Austin_Powers,

Please try our latest version/fix: Aspose.Cells for .NET v18.11.7:

Aspose.Cells18.11.7 For .Net2_AuthenticodeSigned.Zip (4.7 MB)
Aspose.Cells18.11.7 For .Net4.0.Zip (4.7 MB)
Aspose.Cells18.11.7 For .NetStandard20.Zip (3.8 MB)

Your issue should be fixed in it.

Let us know your feedback.

5

Hi ,

i can confirm the problem is fixed using - Aspose.Cells18.11.7 For .Net4.0.Zip

Thank You for the fix & fast replay ,

Regards,

6

@Austin_Powers,

Good to know that your issue is sorted out by the new fix/version. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.

7

The issues you have found earlier (filed as ) have been fixed in Aspose.Cells for .NET v18.12. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi