Salve,
ho fatto un esportazione in xls della mia GridView.
Volevo sapere se era possibile eliminare delle colonne in esportazione.
Sotto riportato il codice che utilizzo per esportare:

Response.Clear()
Response.Buffer = True
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls")
Response.Charset = ""
Response.ContentType = "application/vnd.ms-excel"

Dim sw As New StringWriter()
Dim hw As New HtmlTextWriter(sw)
GRDcodici.AllowPaging = False
GRDcodici.AllowSorting = False
GRDcodici.DataBind()
'Change the Header Row back to white color
GRDcodici.HeaderRow.Style.Add("background-color", "#FFFFFF")
'Apply style to Individual Cells
GRDcodici.HeaderRow.Cells(0).Style.Add("background-color", "green")
GRDcodici.HeaderRow.Cells(1).Style.Add("background-color", "green")
GRDcodici.HeaderRow.Cells(2).Style.Add("background-color", "green")
GRDcodici.HeaderRow.Cells(3).Style.Add("background-color", "green")
For i As Integer = 0 To GRDcodici.Rows.Count - 1
Dim row As GridViewRow = GRDcodici.Rows(i)
'Change Color back to white
row.BackColor = System.Drawing.Color.White
'Apply text style to each Row
row.Attributes.Add("class", "textmode")
'Apply style to Individual Cells of Alternating Row
If i Mod 2 <> 0 Then
row.Cells(0).Style.Add("background-color", "#C2D69B")
row.Cells(1).Style.Add("background-color", "#C2D69B")
row.Cells(2).Style.Add("background-color", "#C2D69B")
row.Cells(3).Style.Add("background-color", "#C2D69B")
End If
Next
GRDcodici.RenderControl(hw)
'style to format numbers to string
'Dim style As String = "<style>.textmode{mso-number-format:\@;}</style>"
'Response.Write(style)
Response.Output.Write(sw.ToString())
Response.Flush()
Response.End()

Grazie in anticipo!