如何在Web应用程序中导出特定的工作表

问题描述：

Hi Developers，

将数据导出到excel以及如何在Web应用程序中导出特定工作表，

我知道如何导出到excel数据，但是我不知道如何导出特定的工作表.请在这种紧急情况下帮助我.

感谢您的提前帮助，

问候
aravind

Hi Developers,

Export Data to excel and how to export particular sheet in web application ,

here how to export to excel data i know but i don''t know how to export particular sheet.please help me on this urgent.

Thanks for advance helping,

regards
aravind

答

不确定特定工作表的含义.但是，我有将GridView数据导出到excel中的代码，如下所示:

Not sure particular sheet means. But, I''ve the code to export GridView data into excel as:

private void ExportToExcel(string strFileName, GridView dg)
  {
      Response.Clear();
      Response.Buffer = true;
      Response.ContentType = "application/vnd.ms-excel";
      Response.Charset = "";
      this.EnableViewState = false;
      System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
      System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
      oHtmlTextWriter.WriteLine("<font size="5"><font color="blue"><center> REPORT </center></font></font>");
      GridView1.RenderControl(oHtmlTextWriter);
      Response.End();
  }

如何在Web应用程序中导出特定的工作表

相关推荐