We are currently working on implementing Aspose into our application for the purpose of converting data into various formats for reporting purposes. We are having an issue related to the conversion of HTML to Excel where the inline formatting in the table tags (TR, TH, etc) seem to be processed or partially processed but all other CSS related information is ignored completely. Our CSS File is fully qualified in the HTML so it can be found, as we discovered we’d have to do this when we implemented conversion of HTML to PDF.
I’ve also attempted to download our CSS Code into a CSS file and use the option to tell Aspose.Cells what directory has the CSS to no avail.
Attached is my XLSX file I got when converting and the HTML file I used as my source. We updated our Aspose.Cells from NuGet yesterday afternoon to 8.5.1 and it did not resolve the issue.
The code I am using to convert the HTML is as follows, please note that in this method I’m returning back the MemoryStream as it might be immediately saved to disk or shipped back if the request was done via one of our REST services. Either way the result is the same.
var htmlOptions = new HTMLLoadOptions();
Workbook workbook;
//If we are given raw HTML in a string, then we need to process it.
//Results have been identical when we use ASCII or UTF8, but we are using
//UTF8 as that is what is used in the Aspose.Cells Documentaiton examples.
if (isHtml)
{
workbook = new Workbook(new MemoryStream(Encoding.ASCII.GetBytes(source)), htmlOptions);
}
else
{
//We’ve got a file path, just pull the file up from Disk
workbook = new Workbook(source, htmlOptions);
}
var memoryStream = new MemoryStream();
workbook.Save(memoryStream, SaveFormat.Xlsx);
result.Value = memoryStream;
If any additional information is needed please let me know and I will do my best to provide what is required.