Send a datagrid to the browser in excel format.....
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Response.Clear()
Me.EnableViewState = False
Dim sw As New StringWriter()
Dim hw As New HtmlTextWriter(sw)
Me.DataGrid1.RenderControl(hw)
Response.Write(sw)
Response.End()