I'm extracting from an SQL database in XML format and looking to format the output in Excel. Some columns were entered as rich text and contain HTML formatting; I would like to retain that formatting.
I could write a parser in VBA - but is there an easier way to transform the HTML so that Excel can understand it? I've tried solutions that use IE in the back ground (not supported as I use IE11) and the DataObject from MS Forms 2.0 (Paste Special with Unicode text is not supported).
The HTML tags are mostly style - font name, bold, underline, etc - with or without spanning.