I was writing an application that needed to convert text in a cell in an Excel workbook to HTML. It is fairly trivial to get formatting for the entire cell, but each individual character in the cell could have different formatting itself, so I needed something more specific than cell-level formatting info.<\/p>\n\n\n\n
At first, I started using the Excel.Range.get_Characters( pos, len )<\/strong> method to get info out of the cell. The code would loop through all characters, get them one by one, and check the formatting. For example:<\/p>\n\n\n\n However, that method proved to be incredibly slow for cells that have more than just a few characters. For cells that have 1000+ characters, it would take several minutes to run the test across all characters. I kept playing around with different ways to speed up the whole process, but it just became apparent that making the call to Excel to get all of this information was not going to be acceptable.<\/p>\n\n\n\n Finally, I think I\u2019ve found the solution. It is possible to copy the text from a cell to the clipboard, and then use the Clipboard class to retrieve the formatted text, and parse it with C#. I ended up using the System.Windows.DataFormats.Rtf format to extract the data from the clipboard in the following way:<\/p>\n\n\n\n Then, I create a System.Windows.Forms.RichTextBox, and use that to parse the data. The following is a sample of the solution, and it is reasonably quick. <\/p>\n\n\n\n I was also asked about getting the color in the comments. To get the color, you can use: <\/p>\n\n\n\nMicrosoft.Office.Interop.Excel.Range Range = (Microsoft.Office.Interop.Excel.Range)Cell;\nint TextLength = Range.Text.ToString().Length;\nfor (int CharCount = 1; CharCount <= TextLength; CharCount++)\n{\n Microsoft.Office.Interop.Excel.Characters charToTest = Range.get_Characters(CharCount, 1);\n bool IsBold = (bool)charToTest.Font.Bold;\n bool IsItalic = (bool)charToTest.Font.Italic;\n \/\/ other formatting tests here\n}<\/code><\/pre>\n\n\n\nstring rtf = (string)System.Windows.Clipboard.GetData(System.Windows.DataFormats.Rtf);<\/code><\/pre>\n\n\n\nMicrosoft.Office.Interop.Excel.Range Range = (Microsoft.Office.Interop.Excel.Range)Cell;\nRange.Copy(System.Reflection.Missing.Value);\n \nstring rtf = (string)System.Windows.Clipboard.GetData(System.Windows.DataFormats.Rtf);\nSystem.Windows.Forms.RichTextBox rtb = new System.Windows.Forms.RichTextBox();\nrtb.Rtf = rtf;\n \nint CharCount = rtb.Text.Length;\n \nfor (int CharNum = 0; CharNum < CharCount; CharNum++)\n{\n rtb.Select(CharNum, 1);\n System.Drawing.Font Font = rtb.SelectionFont;\n bool IsCharBold = Font.Bold;\n bool IsCharUnderline = Font.Underline;\n bool IsCharItalic = Font.Italic;\n\n \/\/ other code here<\/code><\/pre>\n\n\n\nSystem.Drawing.Color color = rtb.SelectionColor;<\/code><\/pre>\n\n\n\n