颜色Excel标题

Question

我正在写一个工作正常的Excel电子表格，但我需要为标题着色深蓝色，并使字体颜色为白色，但即时通讯有一点问题想出如何实现此目的。 ....这是我的代码到目前为止：

foreach (DataColumn c in DT.Columns) 
{ 
    iColumnCount++; 
    if(iRowCount == 0) 
     Worksheet.Cells[1, iColumnCount] = c.ColumnName; 
    else 
     Worksheet.Cells[iRowCount, iColumnCount] = c.ColumnName; 

    Worksheet.Columns.AutoFit(); //Correct the width of the columns 
    //THIS IS WHERE I WANT TO COLOR THE HEADERS 
} 

foreach (DataRow r in DT.Rows) 
{ 
    iRowCount++; 
    iColumnCount = 0; 
    foreach (DataColumn c in DT.Columns) 
    { 
     iColumnCount++; 
     if(iRowCount == 1) 
      Worksheet.Cells[iRowCount + 1, iColumnCount] = r[c.ColumnName].ToString(); 
     else 
      Worksheet.Cells[iRowCount, iColumnCount] = r[c.ColumnName].ToString(); 

     Worksheet.Columns.AutoFit(); //Correct the width of the columns 
    } 
} 

任何人都可以帮助我实现这一目标吗？

Answer 1

试试这个，它的工作

Worksheet.Range["A1","G1"].Interior.Color = Excel.XlRgbColor.rgbDarkBlue; 
Worksheet.Range["A1","G1"].Font.Color = Excel.XlRgbColor.rgbWhite; 
// where "A1" to "G1" is your header range