如何在Web应用程序中导出特定的工作表 [英] how to export particular sheet in web application

问题描述

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应用程序中导出特定的工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！