Microsoft.Office.Interop.Excel.Range range;
for (int i = ; i < dt.Columns.Count; i++)
{
worksheet.Cells[, i + ] = dt.Columns[i].ColumnName;
range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[, i + ];
//设置区域背景色
range.Interior.ColorIndex = ;
}