Export Data Grid to Excel ........doubt........ ???

Question

Hi, For Export Data Grid to Excel am using the code given in this site. But it giving some error message "Unable to read file" from MS Excel............ but On clicking OK button values are converting to excel properly. My problem is that error message. How I can avoid that? If any one knows pls give me a replay................ Thanks, Jovin

Answer 1

Hi! I was having the same problem, but finally figured it out. Here's what I did: On my ASP page I have a datagrid and some buttons and a few textboxes. Upon clicking the Export button I wanted thecontents of the datagrid to be exported into Excel. What you need to do in order for this to work is to *only* have the datagrid on the page, otherwise Excel is trying to convert all the other stuff on your page to Excel format as well and it just doesn't work. In my Export button code I have: Response.Redirect("/DSR/Export.aspx?U=" & txtUnitID.Text & "&D=" & txtStartDate.Text) This opens the new page and passes the parameters I need to create the same datagrid. In the new page I have the following in Page_Load: 'Put user code to initialize the page here FillGrid() 'The FillGrid function does just that, fills the grid with the data. 'The rest of this code will make the browser look & function like Excel does. ' Set the content type to Excel Response.ContentType = "application/vnd.ms-excel" Dim tw As New System.IO.StringWriter() Dim hw As New System.Web.UI.HtmlTextWriter(tw) ' Get the HTML for the control. dgTemp.RenderControl(hw) ' Write the HTML back to the browser. Response.Write(tw.ToString())