把数据导出到EXCEL Response.Clear(); Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Today.Year + DateTime.Today.Month + DateTime.Today.Day + "NonAcceptanceReport1.xls"); Response.ContentType = "application/vnd.ms-excel"; Response.Charset = "UTF-7"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-7"); this.EnableViewState = false; System.IO.StringWriter sw = new System.IO.StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(sw); gdvNonAcceptanceReport.RenderControl(hw); gdvNonAcceptanceReport.Visible = false; Response.Write(sw.ToString()); Response.End(); 把有圖片的数据导出到EXCEL <script> var idTmr = ""; function copy(tabid) { var oControlRange = document.body.createControlRange(); oControlRange.add(tabid,0); oControlRange.select(); document.execCommand("Copy"); } function toExcel(tabid) { copy(tabid); try { var xls = new ActiveXObject( "Excel.Application" ); } catch(e) { alert( "Excel没有安装或浏览器设置不正确.请启用所有Active控件和插件"); return false; } xls.visible = true; var xlBook = xls.Workbooks.Add; var xlsheet = xlBook.Worksheets(1); xlBook.Worksheets(1).Activate; for(var i=0;i
把数据导出到EXCEL
最新推荐文章于 2024-04-18 16:56:07 发布