Excel Export - Populate column from data-child-value attribute and preserving markup in cells

cedporter

I have two questions:

1) I have a data table with expandable rows populated with data from the <tr> attribute data-child-value, similar to the code here. I am hoping to export to Excel, but I don't know how to direct the data in the data attribute in each row to a column. Is that possible?

2) Whether or not the first task is possible, I'm also having trouble exporting HTML-like information to Excel. When I export with data similar to what's in the data attribute, it's lost in the resulting Excel spreadsheet. Is there a way to escape the markup that will be presented correctly in the spreadsheet? My attempts to replace the '<' '>' and '/' with entities work, but they remain entities (e.g., <) in the Excel workbook.