Conclusion in the attached HTML document is dropped from the xls file on conversion.
Please try our latest version/fix: Aspose.Cells for .NET (Latest Version):
I have tested your scenario/ case using the following sample code with latest version using your attached file and it works Ok.
Workbook workbook = new Workbook(“e:\test2\Report.xls”, new LoadOptions(LoadFormat.Html));
I have also attached the output XLS file for your reference. Could you check and let us know where you find the issue, we will check it soon.
So far on my end I am getting the same results, this is even after deleting the old .DLL to ensure it is not being referenced in my application.
I am going to continue to try with the supplied XLS (html) file but at this time after several attempts contents are still dropped.
The supplied fix does not function as needed.
Open the original document (report.xls) and look at cell [AS 2]
the word ‘Conclusion’ is wrapped in tags (open with a text editor this is an HTML file)
However, before those tags are
Everything from the
tags is still dropped, this result is also in the provided example file with the new code.
If I replace the
tags with html hex codes ( )
I get the expected results. I do not want to have to code in replacement characters into the HTML reports we receive as modifying them would not be the proper solution.
The provided screen shots
HTML File Text .png - This file shows the highlighted text, not the text BEFORE the
tags is in the outputed file, everything after is dropped. Also prior the tags makes the entire cell bold not just the one word.
HTML_Excel_File.png - This shows what the text in cell [AS] should look like
Aspose_Exported_Excel_File.png - this shows the output. note that the dropped texted, the word Conclusion and everything after is missing due to the
and everything is BOLD not just a single word like in the other example file.
tags is still dropped at the end.
Thanks for using Aspose.Cells.
Please download and try the following latest fix
and let us know your feedback.