EPPlus: How to set background color for Columns and Rows to be different, expand the width and set the single cell as a name of the spreadsheet?
<p>I'm using EPPlus library to map <code>DataTable</code> to excel. This is my code:</p>

<pre><code>using (pck = new ExcelPackage())
{
        ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Demo");
        ws.Cells["A1:I1"].LoadFromDataTable(dt, true);
        using (ExcelRange rng = ws.Cells["A1:I1"])
        {
            rng.Style.Border.Top.Style = ExcelBorderStyle.Thick;
            rng.Style.Border.Bottom.Style = ExcelBorderStyle.Thick;
            rng.Style.Border.Left.Style = ExcelBorderStyle.Thick;
            rng.Style.Border.Right.Style = ExcelBorderStyle.Thick;

            rng.Style.Border.Top.Color.SetColor(System.Drawing.Color.White);
            rng.Style.Border.Bottom.Color.SetColor(System.Drawing.Color.White);
            rng.Style.Border.Left.Color.SetColor(System.Drawing.Color.White);
            rng.Style.Border.Right.Color.SetColor(System.Drawing.Color.White);

            rng.Style.Fill.PatternType = ExcelFillStyle.Solid;
            rng.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.BurlyWood);

            ws.Cells.Style.Fill.PatternType = ExcelFillStyle.Solid;
            ws.Cells.Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.Bisque);

            ws.Cells.Style.Border.Top.Style = ExcelBorderStyle.Thick;
            ws.Cells.Style.Border.Bottom.Style = ExcelBorderStyle.Thick;
            ws.Cells.Style.Border.Left.Style = ExcelBorderStyle.Thick;
            ws.Cells.Style.Border.Right.Style = ExcelBorderStyle.Thick;

            ws.Cells.Style.Border.Top.Color.SetColor(System.Drawing.Color.White);
            ws.Cells.Style.Border.Bottom.Color.SetColor(System.Drawing.Color.White);
            ws.Cells.Style.Border.Left.Color.SetColor(System.Drawing.Color.White);
            ws.Cells.Style.Border.Right.Color.SetColor(System.Drawing.Color.White);

        }
        Response.AddHeader("content-disposition", "inline;filename=" + ReportName + ".xls");
        Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
        Response.BinaryWrite(pck.GetAsByteArray());
}
</code></pre>

<p>When running the above code, I have the following result:</p>

<p><a href="https://i.stack.imgur.com/BPeRC.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/BPeRC.png" alt="enter image description here"></a></p>

<p>I need to have something like that:</p>

<p><a href="https://i.stack.imgur.com/o8UGH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/o8UGH.png" alt="enter image description here"></a></p>

<p>As you see, background colors for columns and rows are different, width of columns is bigger and the report has a name.</p>

<p>How can I achieve that effect?</p>