title: Get color name out of Excel tab color in Visual Studio Add-in VB.net
body: <p>I'm trying to fill a treeview with all sheets in a larger file, where sheets are grouped by color, so the tree structure would be: Root node - Colors - Sheets.</p>
  <p>I'm loading the sheet information in dSheets dictionary, and unique colors in dColors.</p>
  <p>Is there any way I can get the actual color Name instead of the code from a Sheet.Tab.Color?
  If there is not a simpler way, is there a list of Excel color names and codes that I can compare against? And how would I approximate if the color is not the exact color code in the list?</p>
  <pre><code>        For Each SH In WB.Worksheets
              dSHeets.Add(SH.Name.ToString(), SH.Tab.ColorIndex)
              colorName = &quot;&quot;    'HOW CAN I GET THE COLOR CODE
              If Not dColors.ContainsKey(SH.Tab.ColorIndex) Then
                  dColors.Add(SH.Tab.ColorIndex, &quot;&quot;)
              End If
          Next
  </code></pre>