ASP.NET(C#) DataSet数据导出到Excel

今天给客户做了个功能需要把网格数据（Gridview）导出成Excel，所以我去网上找了个代码 private void Export(string FileType, string FileName) ...{ try ...{ Response.Charset = "GB2312"; Response.ContentEncoding = System.Text.Encoding.UTF7; Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString()); Response.ContentType = FileType; this.EnableViewState = false; StringWriter tw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); grdSearch.RenderControl(hw); Response.Write(tw.ToString()); Response.End(); } catch (Exception err) ...{ DOMUtility.PopAlertWindow("导出Excel出错！错误原因：" + err.Message); //return false; } }

但是这种方法的话只是把当前Gridview页导出到Excel，而客户需要把当前所以分页的数据导出到Excel，并且在客户端打开，所以想了想有几种方案：

1）将execl文件导出到服务器上，再下载。这样的话服务器中有