-
Export GridView to Excel
I am exporting a grid view to Excel and it works fine. My question is: Is there a property that let's me pre-define an excel column prior to export. In my case, column number 6 is numeric with 2 decimals. In case there are whole numbers, the decimal will not show. User always wants to see the decimal regardless. Thank you.
Code:
Protected Sub Excel_Button_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Excel_Button.Click
Export1_Clicked = True ' used to bypass switching from ASC to DESC and vice versa
GridView2.AllowPaging = False
GridViewSortExpression1 = Session("SortExpression")
ItemDetailDataTable = Session("ItemDetailDataTable")
Dim pageIndex2 As Integer = GridView2.PageIndex
GridView2.DataSource = SortDataTable1(ItemDetailDataTable, False)
GridView2.DataBind()
GridView2.PageIndex = pageIndex2
GridViewExportUtil.Export("EquipmentHours.xls", GridView2)
GridView2.AllowPaging = True
Export1_Clicked = False
End Sub