Datagrid export to excel - color extends over gridlines

[tsp1lrk72]

hello-

I have a datagrid that I export to excel which I have dynamically colored on export- when I export it into excel, the colors are there (the green is gray for some reason??) but the color just keeps extending out over the boundaries of the grid lines- can I have the colors just stay in the grid itself??

Thanks!

 

[Sorwen]

Depends. How are you exporting it to Excel?

-I hate Microsoft!
-Forever and always forward.

 

[tsp1lrk72]

I'm doing it via a button in the web form:

Private Sub btnExportBP_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnExportBP.Click
        RenderGridToExcelFormat(DGViewRequests, txtFilename.Text)

    End Sub
    Sub RenderGridToExcelFormat(ByVal grid As DataGrid, ByVal saveAsFile As String)
        If grid.Items.Count.ToString + 1 < 65536 Then
            HttpContext.Current.Response.Clear()
            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"
            HttpContext.Current.Response.AddHeader("content-disposition", "attachment;filename=" & saveAsFile & ".xls")
            HttpContext.Current.Response.Charset = ""
            Dim frm As HtmlForm = New HtmlForm
            grid.EnableViewState = False
            Controls.Add(frm)
            Dim tw As New System.IO.StringWriter
            Dim hw As New System.Web.UI.HtmlTextWriter(tw)
            frm.Controls.Add(DGViewRequests)
            frm.RenderControl(hw)
            HttpContext.Current.Response.Write(tw.ToString())
            HttpContext.Current.Response.End()
        Else
            HttpContext.Current.Response.Write("Too many rows - Export to Excel not possible")
        End If
    End Sub

 

[tsp1lrk72]

Any ideas?

 

[jbenson001]

Yea, don't post the same question in more than one forum. This is an ASP.NET question, not a VB.NET question.

 

[tsp1lrk72]

I posted it here first and the realized it was ASP.NET - sorry -that's why it's in 2 places. Can't delete it otherwise I would have, unless you know of a way to do that?

 

[jbenson001]

I think you have to red flag the post.. use the link in the post.. and then you can specify why it should be deleted.