Export Excel rows with color and other details
<p>I have an Excel file that has a special format. Some cells have color and each color comes with a special purpose. Now I want to know how can I export a line from this Excel file to a datagridview with these colors...</p>

<p><img src="https://i.stack.imgur.com/kyA5e.png" alt="excel file view"></p>

<p>With the following code I can read the cells, but just strings, and not colors...</p>

<pre><code> string str;
 int rCnt = 0;
 int cCnt = 0;
 Workbook xlWorkBook;
 Worksheet xlWorkSheet;
 Range range;
 object misValue = System.Reflection.Missing.Value;
 xlWorkBook = xlApp.Workbooks.Open("myFile.xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
 xlWorkSheet = (Worksheet)xlWorkBook.Worksheets.get_Item(23);
 range = xlWorkSheet.UsedRange;

 for (rCnt=1;rCnt &lt;= range.Rows.Count; rCnt++)
   {
       for(cCnt = 1; cCnt &lt;= range.Columns.Count; cCnt++)
          {
               str = (range.Cells[rCnt, cCnt] as Range).Value2 + "";
               MessageBox.Show(str);
          }
   }
</code></pre>

<p>It's not important where the Excel line would be exported (datagridview, textbox!, etc.), it should just work. :) How do I get the cell colors in my export?</p>