Get HTML from Office selection

Question

Hi, I'm working on a project where I have created Office Addin's for Excel, Word, Powerpoint and Outlook. I have a button that is supposed to get the get the whatever the user has selected and import it into a WYSIWYG editor. For now this is how I get the selection and extract html.

Excel.Worksheet sheet = excelApp.ActiveSheet;
excelApp.ActiveWindow.RangeSelection.Copy();
if (Clipboard.ContainsText(TextDataFormat.Html))
   html = (Clipboard.GetData(DataFormats.Html).ToString());

Then I modify the html a bit to get rid of all the extra garbage it gives me. The issue is that if non-ASCII symbols are highlighted, for example こんにちは, then the returned html contains incorrect data in it's place. Any idea's would be greatly appreciated. (I have similar issues with Word so let me know of any ideas for that!) Thanks, Phil

Answer 1

You need to change to DataFormats.UnicodeText. Those are multi-byte characters.