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()