title: Rename column names in Excel
body: <p>I have columns with names as <code>SSS-01\01\2015, SSS-01\02\2015</code> and so on.</p>
  
  <p>I want to rename these cols as <code>01\01\2015, 01\02\2015</code> and so on by removing <code>"SSS-"</code>.  Below is the code that I am using.</p>
  
  <p>I have all the required values in the List.  Now how do I save those as column names from cell E to H.</p>
  
  <pre><code>chartRange = ws.get_Range("e7", "h7");
  int colCount=chartRange.Columns.Count;
  List&lt;string&gt; colNames=new List&lt;string&gt;();
  for(int c=1;c&lt;colCount;c++)
   {
   if(chartRange!=null)
   {
    string colName = chartRange.Columns[c].Value2;
    string colVal = colName.Remove(0, 10);
    colNames.Add(colVal);
   }
  }
  </code></pre>