Original Text Format: gridviewfont
1) Text: vnd. ms-excel.numberformat :@
2) Date: vnd. ms-excel.numberformat: yyyy/mm/dd
3) number: vnd. ms-excel.numberformat: #,## 0.00
4) Currency: vnd. ms-excel.numberformat: ¥ #, #0.00
5) percentage: vnd. ms-excel.numberformat: # 0.00%
Usage: Add code e. Row. Cells [0]. Attributes. Add ("style", "vnd. ms-excel.numberformat: @") in the RowDataBound event of the GridView :@");
Articles you may be interested in:
- Three methods for exporting asp.net dview to Excel [test]
- Export asp.net GridView to Excel Code
- How to export Excel using GridView
- Select Excel export solution for GridView
- Export data from the DataGridView to Excel using the clipboard
- C # How to Use RenderControl to export the GridView control to EXCEL
- ASP. NET using the GridView to export Excel Implementation Method
- C # export the GridView data to an Excel file instance