DataGrid to excel not showing automatic gridlines

Question

Wondering if anyone can assist. I have an .ashx file which creates an excel document which is populated with a C# DataGrid. This all works well the only problem is when I open the excel document the automatic gridlines are turned off. Is there a way to enable them?

Thanks in advance, Air

HttpResponse response = HttpContext.Current.Response;

            response.Clear();
            response.Charset = "";
            response.ContentEncoding = System.Text.Encoding.Default;
            response.ContentType = "application/vnd.ms-excel";
            response.AddHeader("Content-Disposition", "attachment;filename=\"dataImportTemplate.xls\"");
            using (StringWriter sw = new StringWriter())
            {
                using (HtmlTextWriter htw = new HtmlTextWriter(sw))
                {
                    System.Web.UI.WebControls.DataGrid dg = new System.Web.UI.WebControls.DataGrid();
                    dg.DataSource = ds.Tables[0];
                    dg.ShowHeader = false;
                    dg.DataBind();                    
                    dg.RenderControl(htw);
                    response.Write(sw.ToString());
                }
            }

Try to set the datagrid's BorderColor, BorderStyle & BorderWidth before you pass it to response.write — HatSoft, Jul 11 '12 at 10:10
Hi, tried that and it only set the borders on the datagrid. It did not enable the automatic grid lines on the excel document :( — Jebanisa, Jul 11 '12 at 10:15

score 0 · Answer 1 · edited May 23 '17 at 12:20

0

If you export to a csv it keeps the gridlines. This is a pretty simple workaround that a lot of people opt to use.

See similear post Here

That post includes a helper function that supposedly can add the gridlines to your export.

Hope this helps.

edited May 23 '17 at 12:20

Community

1
1

answered Jul 11 '12 at 19:12

danielpiestrak

5,279
3
30
29

DataGrid to excel not showing automatic gridlines

1 Answers1