title: How to color columns when exporting to Excel?
body: <p>I have the following code to export data to an Excel sheet. I need your help to know how I can color the sheet columns in other colors?</p>
  
  <pre><code>System.Data.DataTable dit = null;
  try
  {
      dit = BindGrid();
      using (XLWorkbook wb = new XLWorkbook())
      {
          wb.Worksheets.Add(dit, "Students");
          Response.Clear();
          Response.Buffer = true;
          Response.Charset = "";
          Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
          Response.AddHeader("content-disposition", "attachment;filename=Download.xlsx");
          using (MemoryStream MyMemoryStream = new MemoryStream())
          {
              wb.SaveAs(MyMemoryStream);
              MyMemoryStream.WriteTo(Response.OutputStream);
              Response.Flush();
              Response.End();
          }
      }
  }
  catch (Exception Ex)
  {
  }
  finally
  {
      dit = null;
  }
  </code></pre>