求一个程序把datagrid里面的记录导入到Excel表格
求一个程序把datagrid里面的记录导入到Excel表格 问题点数：100、回复次数：3Top
1 楼hbzy123（DemoHunter）回复于 2006-04-02 18:33:36 得分 50
public void exportToexcel(DataGrid Dg,string FileName)
{
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
StringWriter Sw=new StringWriter(myCItrad);
HtmlTextWriter Ht=new HtmlTextWriter(Sw);
HttpResponse Rst=HttpContext.Current.Response;
Dg.RenderControl(Ht);
//添加
Rst.Clear();
Rst.ContentEncoding=System.Text.Encoding.UTF8;
//Rst.ContentEncoding=System.Text.Encoding.GetEncoding("UTF-8");;
Rst.ContentType="application/ms-excel";
Rst.AddHeader("Content-Disposition","attachment;filename="+System.Web.HttpUtility.UrlEncodeUnicode(FileName)+".xls");
Rst.Charset="gb2312";
Rst.Write(Sw.ToString());
Rst.End();
}Top
2 楼aliketen（继续学习NET！）回复于 2006-04-02 18:34:21 得分 50
前段时间做过，看看罗
http://aliketen.cnblogs.com/articles/363650.htmlTop
3 楼bbqqfdl（旅行中の狗）回复于 2006-04-02 18:40:28 得分 0
谢谢2位Top
