[办公软件] Wijmo 更优美的jQuery UI部件集：导出Wijmo的GridView到Excel

Public Function DataGridToExcel(ByVal dgExport As C1.Web.Wijmo.Controls.C1GridView.C1GridView) As String    '创建一个stringwriter    Dim stringWrite As New System.IO.StringWriter()    '创建一个使用该stringwriter的htmltextwriter    Dim htmlWrite As New System.Web.UI.HtmlTextWriter(stringWrite)    Dim dg As C1.Web.Wijmo.Controls.C1GridView.C1GridView    'just set the input datagrid = to the new dg grid    dg = dgExport    '将header的字体加粗    dg.HeaderStyle.Font.Bold = True    '如果需要，这里是在组件级别改变颜色/格式    dg.HeaderStyle.ForeColor = System.Drawing.Color.Black    dg.RowStyle.ForeColor = System.Drawing.Color.Black    '绑定修改后的datagrid    '告诉datagrid将自己呈现到我们提供的htmltextwriter    dg.AllowSorting = False    dg.AllowPaging = False    dg.AllowCustomPaging = False    '新的代码    Dim parent As Control = dg.Parent    parent.Controls.Remove(dg)    dg.RenderControl(htmlWrite)    '新的代码    parent.Controls.Add(dg)    '输出HTML    Return stringWrite.ToString()  End Function

Public Sub DownloadToExcel(ByVal content As String, ByVal response As HttpResponse)  '清理 response.object  response.Clear()  response.Buffer = True  response.Charset = ""  '设置响应的MIME类型为excel  response.ContentType = "application/vnd.ms-excel"  response.ContentEncoding = New System.Text.UTF8Encoding()  response.Write(content)  response.End()  End Sub

• 你可以向下面的文章描述的那样，重载VerifyRenderingInServerForm 方法：
  

• 为了避免收到“RegisterForEventValidation 只能在Render()过程中被调用；”异常，可以关闭Page.EnableEventValidation 或者将RenderControl方法调用放置在一个try-catch块中。