Click here to Skip to main content
16,023,339 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
-- file is saving in excel but not open
VB
Public Sub btnexportexe_Click(sender As Object, e As EventArgs)

    Response.Clear()
    Response.Buffer = True
    Response.Charset = ""
    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
    Response.AddHeader("content-disposition", "attachment;filename=SqlExport.xlsx")

    Using sw As New StringWriter()
        Dim tw As New HtmlTextWriter(sw)

        Dim dt As DataTable
        divdet.RenderControl(tw)

        Using wb As New XLWorkbook()
            wb.Worksheets.Add(dt, "Customers")

            Response.Clear()
            Response.Buffer = True
            Response.Charset = ""
            Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
            Response.AddHeader("content-disposition", "attachment;filename=SqlExport.xlsx")
            Using MyMemoryStream As New MemoryStream()
                wb.SaveAs(MyMemoryStream)
                MyMemoryStream.WriteTo(Response.OutputStream)
                Response.Flush()
                Response.End()
            End Using
        End Using
Posted
Updated 14-Dec-15 0:18am
v4

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900