C#导出GridView数据到Excel文件类实例

本文实例讲述了C#导出GridVie数据到Excel文件类。分享给大家供大家参考。具体如下

这段C#代码自定义了一个封装类，用于将GridVie数据导出到Excel文件

using System;
using System.Web;
using System.Web.UI;
using System.IO;
using System.Web.UI.WebControls;
namespace DotNet.Utilities
{
  public class ExportExcel
  {
 protected void ExportData(string strContent, string FileName)
 {
   FileName = FileName + DateTime.No.Year.ToString() + DateTime.No.Month.ToString() + DateTime.No.Day.ToString() + DateTime.No.Hour.ToString() + DateTime.No.Minute.ToString() + DateTime.No.Second.ToString() + DateTime.No.Millisecond.ToString();
   HttpContext.Current.Response.Clear();
   HttpContext.Current.Response.Charset = "gb2312";
   HttpContext.Current.Response.ContentType = "application/ms-excel";
   HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
   //this.Page.EnableVieState = false;
   // 添加头信息，为"文件下载/另存为"对话框指定默认文件名
   HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + FileName + ".xls");
   // 把文件流发送到客户端
   HttpContext.Current.Response.Write("");
   HttpContext.Current.Response.Write(strContent);
   HttpContext.Current.Response.Write("");
   // 停止页面的执行
   //Response.End();
 }
 /// 

 /// 导出Excel
 /// 
 /// 
 public void ExportData(GridVie obj)
 {
   try
   {
 string style = "";
 if (obj.Ros.Count > 0)
 {
   style = @" .text { mso-number-format:@; }  ";
 }
 else
 {
   style = "no data.";
 }
 HttpContext.Current.Response.ClearContent();
 DateTime dt = DateTime.No;
 string filename = dt.Year.ToString() + dt.Month.ToString() + dt.Day.ToString() + dt.Hour.ToString() + dt.Minute.ToString() + dt.Second.ToString();
 HttpContext.Current.Response.AddHeader("content-disposition", "attachment; filename=ExportData" + filename + ".xls");
 HttpContext.Current.Response.ContentType = "application/ms-excel";
 HttpContext.Current.Response.Charset = "GB2312";
 HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
 StringWriter s = ne StringWriter();
 HtmlTextWriter ht = ne HtmlTextWriter(s);
 obj.RenderControl(ht);
 HttpContext.Current.Response.Write(style);
 HttpContext.Current.Response.Write(s.ToString());
 HttpContext.Current.Response.End();
   }
   catch
   {
   }
 }
  }
}

电脑维修网希望本文所述对大家的C#程序设计有所帮助。