Export .xlsx from Gridview in vb.net using asp.net

Senorita

hi i am trying to export gridview data in xlsx file using below code, but when i open file its showing error,

Response.Clear()

Response.AddHeader("content-disposition", "attachment;filename=Report.xlsx")

Response.Charset = ""

Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

Dim stringWrite As System.IO.StringWriter = New System.IO.StringWriter()

Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)

For Each r As GridViewRow In GridView1.Rows

If r.RowType = DataControlRowType.DataRow Then

For columnIndex As Integer = 0 To r.Cells.Count - 1

r.Cells(columnIndex).Attributes.Add("class", "text")

End If

GridView1.RenderControl(htmlWrite)

Dim style As String = "<style> .text { mso-number-format:\@; } "

Response.Write(style)

Response.Write(stringWrite.ToString())

Response.[End]()

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
Hi Senorita,
Please try below thread, it is given detailed solution of your problem
https://www.c-sharpcorner.com/article/export-data-to-excel-file-in-asp-net-using-epplus/
0
Senorita6y ago
hi have check "Free version is limited to 5 sheets per workbook and 200 rows per sheet " in my application i n number of user download n number of data. so please can you preovide and simple solution for export gridview data in .xlsx file.
0
Senorita6y ago
Yes @salman beg i tried .xlsx on the place of .xls. i tried lots of solution but no one is working
0
Leon D6y ago
You can read data into a data table, then use free Spire.XLS library (available on nuget) and the below code to export data table to excel.
//export datatable to excel
Workbook book = new Workbook();
Worksheet sheet = book.Worksheets[0];
sheet.InsertDataTable(dataTable, true, 1, 1);
book.SaveToFile("insertTableToExcel.xlsx",ExcelVersion.Version2013);
For more information, visit this link:
https://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html
0
Salman Beg6y ago
Hey.
Can you try xlsx in place of xls in the below link.
Thanks.
0
Senorita6y ago
i already tried this but my problm is i am creating .XLSX file.
0
Salman Beg6y ago
Hi. You can follow up with this link which contains working example, https://www.aspsnippets.com/Articles/Export-GridView-to-Excel-in-ASPNet-with-Formatting-using-C-and-VBNet.aspx
0