I am evaluating Aspose Cells and wondering if it’s possible to open an HTML file and retain the formatting.
Here is my situation: I have an existing reporting application that generates a large number of reports in HTML format. Most reports are simple tables, however there is a fair amount of formatting with regards to column widths, coloring, formatting of headers, etc. In the past, we have faked an “export to Excel” by simply appending an .xls extension onto our generated HTML files and letting Excel open them. This would retain the formatting and allow our users to manipulate their report data and save as a proper Excel-formatted file. This approach, however, is no longer viable because modern Excel versions regard HTML files as a potential security risk.
I’d like to user Aspose Cells to “convert” HTML reports into proper Excel files without losing the aesthetic formatting of the data. So far, it appears to have no problem open these HTML files and saving them as .xlsx files, however all formatting is lost and I’m left with a generically formatted sheet of data.