//导出gridview protected void btnSave0_Click(object sender, EventArgs e) { if (this.GridView1.Rows.Count > 0) { StringWriter sw = new StringWriter(); for (int i = 0; i < this.GridView1.Columns.Count; i++) { sw.Write(this.GridView1.Columns[i].HeaderText.ToString()); sw.Write("/t"); } sw.Write("/r/n"); for (int i = 0; i < this.GridView1.Rows.Count; i++) { for (int a = 0; a < this.GridView1.Columns.Count; a++) { sw.Write(this.GridView1.Rows[i].Cells[a].Text.ToString().Trim()); sw.Write("/t"); } sw.Write("/r/n"); } sw.Close(); //csv Response.AddHeader("Content-Disposition", "attachment; filename=report.xls"); Response.ContentType = "application/ms-excel"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.Write(sw); Response.End(); } } //导出datagrid private void ExportButton_Click(object sender, System.EventArgs e) { if(this.DataGrid2.Items.Count>0) { StringWriter sw=new StringWriter(); for(int i=0;i
AS.NET eXCEL
最新推荐文章于 2024-08-10 15:11:50 发布