将gridview数据导入到Exccl里
来源:百度文库 编辑:神马文学网 时间:2024/04/28 23:37:00
///
///这是导入方法
///
private void ExportExcelFromDataGrid(string filename, System.Web.UI.WebControls.GridView ToExcelGrid)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(filename));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
ToExcelGrid.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
///只有重写这个方法。。才不会报Gridview 必须放在runat=server的控件里
public override void VerifyRenderingInServerForm(Control control)
{
// Confirms that an HtmlForm control is rendered for
//里边不写任何的东西
}
///
/// 到入按钮2
///
///
///
protected void btn_Click(object sender, EventArgs e)
{
ExportExcelFromDataGrid("TestExcel.xls", this.GridView1);
}
///这是导入方法
///
private void ExportExcelFromDataGrid(string filename, System.Web.UI.WebControls.GridView ToExcelGrid)
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(filename));
Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8");//设置输出流为简体中文
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
this.EnableViewState = false;
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN", true);
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
ToExcelGrid.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
///只有重写这个方法。。才不会报Gridview 必须放在runat=server的控件里
public override void VerifyRenderingInServerForm(Control control)
{
// Confirms that an HtmlForm control is rendered for
//里边不写任何的东西
}
///
/// 到入按钮2
///
///
///
protected void btn_Click(object sender, EventArgs e)
{
ExportExcelFromDataGrid("TestExcel.xls", this.GridView1);
}
将gridview数据导入到Exccl里
将OE里的信件导入到GMAIL的方法
点击GridView模版列里的按钮取GridView当前被操作行的数据
asp代码实现EXCEL数据导入到
将excel数据导入oracle中- -
将excel数据导入oracle中- -
将sqlserver的数据导入Mysql中
一个将文件数据(汉字)导入到mysql的C程序_原创文档_论坛_PHPChina 开源社区...
将网页表格导入到Excel中
asp代码实现EXCEL数据导入到SQL数据库
Excel 数据导入到 Access、Sql Server 中示例代码
如何将透明flash导入进作品里
如何将透明flash导入进作品里
【将数码照片导入到电脑之后第一步做什么
MySQL数据导入导出
CNKI数据导入EndNote
HOW TO:将数据从 Microsoft SQL Server 导入 Microsoft Excel
MySQL数据导入与导出
用有啊助手导入淘宝数据
ASP.NET2.0中用Gridview控件操作数据
声明式数据绑定教程-SqlDataSource 与 GridView
MySQL数据导入导出工具mysqlimport简介
VB 实现 数据快速导入EXCEL
VB 实现 数据快速导入EXCEL