gridview导出excel（如何把GRIDVIEW的数据导出为EXCEL）

本文目录

• 如何把GRIDVIEW的数据导出为EXCEL
• .net中两个GRIDVIEW导出到一个excel
• 怎么将gridview里查询的结果导出Excel表中
• asp.net下如何将Gridview 表里的信息导出到一张新建的Excel表中
• asp.net gridview数据导出到excel
• c#.net 中 如何将gridview中的数据导出到excel中

如何把GRIDVIEW的数据导出为EXCEL

给你一个DataGrid的代码： // 导出列表信息到Excel public static void gSendGridInfoToExcel(DataGrid GridX) { Excel.Application excel= new Excel.ApplicationClass(); Excel._Workbook xBk = excel.Workbooks.Add(true); Excel._Worksheet xSt = (Excel._Worksheet)xBk.ActiveSheet; Excel.Range excelCell=null; try { //赋值对象 object objarr; DataTable dtTest=new DataTable();; int i,j; int iRows,iCows; int iVisable; iVisable=0; iCows=0; ArrayList list=new ArrayList(); //如果绑定数据源是DataTable和DataSet,取得行数 if (GridX.DataSource is System.Data.DataSet || GridX.DataSource is System.Data.DataTable) { dtTest=(DataTable)GridX.DataSource; iRows=dtTest.Rows.Count; } else if (GridX.DataSource is System.Data.DataView) { DataView dvTest=(DataView)GridX.DataSource; iRows=dvTest.Count; dtTest=dvTest.Table; } //如果是集合取得行数 else { System.Collections.CollectionBase ColTest; ColTest=(System.Collections.CollectionBase)GridX.DataSource; iRows=ColTest.Count; } //如果有TableStyles则根据TableStyles取得(标题行) if (GridX.TableStyles.Count》0) { iCows=GridX.TableStyles.GridColumnStyles.Count; for(i=0;i《iCows;i++) { if(GridX.TableStyles.Width》0) { iVisable++; list.Add(GridX.TableStyles.HeaderText); } } objarr = new object; objarr=list.ToArray(); excelCell = xSt.get_Range(excel.Cells); excelCell.Value2 = objarr; //数据行 for(i=0;i《iRows;i++) { objarr = new object; list.Clear(); for(j=0;j《iCows;j++) { if(GridX.TableStyles.Width》0) { list.Add("’"+GridX.ToString().Replace("\n","")); } } if (list.Equals(System.DBNull.Value)) { break; } objarr=list.ToArray(); excelCell = xSt.get_Range(excel.Cells); excelCell.Value2 = objarr; } } else { iCows=dtTest.Columns.Count; for(i=0;i《iCows;i++) { list.Add(dtTest.Columns.Caption); } objarr = new object; objarr=list.ToArray(); excelCell = xSt.get_Range(excel.Cells); excelCell.Value2 = objarr; //数据行 for(i=0;i《iRows;i++) { objarr = new object; list.Clear(); for(j=0;j《iCows;j++) { list.Add("’"+GridX.ToString().Replace("\n","")); } if (list.Equals(System.DBNull.Value)) { break; } objarr=list.ToArray(); excelCell = xSt.get_Range(excel.Cells); excelCell.Value2 = objarr; } } dtTest.Dispose(); excel.Visible=true; } catch (System.Exception e) { throw e; } finally { excelCell=null; xBk=null; xSt=null; excel=null; GC.Collect(); } } }

.net中两个GRIDVIEW导出到一个excel

你把两个GridView放在一个div里，比如这样《divrunat="server"id="divExport"》《gridview1.....》《gridview2.....》《/div》然后后台gvSelectorder.RenderControl(oHtmlTextWriter);这句改成divExport.RenderControl(oHtmlTextWriter);试一下

怎么将gridview里查询的结果导出Excel表中

你个笨蛋，先把查询的结果存在一个临表里，然后把临时表里面的内容给EXCEL就行了。

asp.net下如何将Gridview 表里的信息导出到一张新建的Excel表中

这是写在点击输出方法里面Export("application/ms-excel","Person.xls");这是输出方法Export private void Export(string FileType, string FileName) { Response.Charset = "GB2312"; Response.ContentEncoding = System.Text.Encoding.UTF7; Response.AppendHeader("Content-Disposition","attachment;filename="+HttpUtility.UrlDecode(FileName,Encoding.UTF8).ToString()); Response.ContentType =FileType; this.EnableViewState = false; StringWriter tw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); gvPerson.AllowPaging = false; Ds = FpersonOper.Get_PersonTable("and UnitID = " + Ffun_lee.QuotedStr(prUnitID), gvPerson);//绑定数据库 gvPerson.DataBind(); gvPerson.RenderControl(hw); Response.Write(tw.ToString()); Response.ContentType = "text/.xls"; Response.End(); }

asp.net gridview数据导出到excel

参考一下我做的，可以直接复制 protected void Button1_Click(object sender, EventArgs e) { ExcelOut(this.GridView1); } public void ExcelOut(GridView gv) { if (gv.Rows.Count 》 0) { Response.Clear(); Response.ClearContent(); Response.AddHeader("Content-Disposition", "attachment; filename=" + DateTime.Now.ToString("_yyyyMMdd_HHmmss") + ".xls"); Response.ContentEncoding = System.Text.Encoding.UTF8; Response.ContentType = "application/ms-excel"; StringWriter sw = new StringWriter(); HtmlTextWriter htw = new HtmlTextWriter(sw); gv.RenderControl(htw); Response.Write(sw.ToString()); Response.Flush(); Response.End(); } else { Response.Write("没有数据"); } } public override void VerifyRenderingInServerForm(Control control) { //base.VerifyRenderingInServerForm(control); }

c#.net 中 如何将gridview中的数据导出到excel中

/// 《summary》 /// 导出Datatable的数据到excel /// 《/summary》 /// 《param name="dt"》datatable《/param》 private void CreateExcel(DataTable dt) { try { string fileName = DateTime.Now.ToString("yyyyMMddHHmm") + ".xls"; HttpResponse resp; resp = Page.Response; resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); resp.AppendHeader("Content-Disposition", "attachment;filename=" + fileName); resp.ContentType = "application/ms-excel"; string colHeaders = "", ls_item = ""; //定义表对象与行对象，同时用DataSet对其值进行初始化 DataRow myRow = dt.Select(); int i = 0; int cl = dt.Columns.Count; //取得数据表各列标题，各标题之间以t分割，最后一个列标题后加回车符 colHeaders += dt.Columns.Caption.Replace("ID", "编号") + "\t"; colHeaders += dt.Columns.Caption.Replace("FuncID", "操作名称") + "\t"; colHeaders += dt.Columns.Caption.Replace("logtypes", "操作类型") + "\t"; colHeaders += dt.Columns.Caption.Replace("LogDec", "操作内容") + "\t"; colHeaders += dt.Columns.Caption.Replace("UserID", "用户名称") + "\t"; colHeaders += dt.Columns.Caption.Replace("CreateTime", "操作时间") + "\n"; resp.Write(colHeaders); //向HTTP输出流中写入取得的数据信息 //当前行数据写入HTTP输出流，并且置空ls_item以便下行数据 for (i = 0; i 《 dt.Rows.Count; i++) { //if (i == (cl - 1))//最后一列，加n ls_item += dt.Rows.ToString() + "\t"; ls_item += dt.Rows.ToString() + "\t"; ls_item += dt.Rows.ToString() + "\t"; ls_item += dt.Rows.ToString().Replace("\r\n", "") + "\t"; if (dt.Rows.ToString().Trim() == "") { ls_item += "无姓名" + "\t"; } else { ls_item += dt.Rows.ToString() + "\t"; } ls_item += dt.Rows.ToString() + "\n"; } resp.Write(ls_item); ls_item = ""; resp.End(); } catch (Exception) { throw; } } protected void btiiii_Click(object sender, EventArgs e) { try { DCExecl(Convert.ToInt32(this.txtstrPageindex.Value), Convert.ToInt32(this.txtendPageindex.Value)); new Facade.SystemLog().SaveSystemLogCode("系统日志",(int)Facade.EnumMuster.LOG_TYPE.DEVICE_OPERATION,Session.ToString()+"导出系统日志数据"); } catch (Exception) { throw; } }}适当修改就行·