Datagrid export to excel: color extends over gridlines

[tsp1lrk72]

Hi!

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!

 

[vbkris]

how exactly are you converting into excel? is it a HTML file saved as XLS???

Known is handfull, Unknown is worldfull

 

[tsp1lrk72]

Using VB.net via a button...

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

 

[vbkris]

hi,

since the output is in HTML format i would suggest that you rename the file to .html and open it in IE.

Check how it looks there...

Known is handfull, Unknown is worldfull

 

[tsp1lrk72]

It does open up correct in HTML- so how do I fix this to open correctly in Excel? I added the frm info to get around the error about not having run at server in the form tag, even though it was there....UGH!

 

[tsp1lrk72]

I got it-- I converted it to hex