private void ExportDataGrid(string FileType, string FileName) //从DataGrid导出 { Response.Charset = "GB2312"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString()); Response.ContentType = FileType; this.EnableViewState = false; StringWriter tw = new StringWriter(); HtmlTextWriter hw = new HtmlTextWriter(tw); GridView11.RenderControl(hw); GridView2.RenderControl(hw); GridView3.RenderControl(hw); GridView4.RenderControl(hw); GridView5.RenderControl(hw); Response.Write(tw.ToString()); Response.End(); }
protected void btnDownloadExcelDQIBE4BVNReport_Click(object sender, EventArgs e) { hidTAB.Value = "#tab3"; Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=DQIBE4BVNReportExport.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; using (StringWriter sw = new StringWriter()) { HtmlTextWriter hw = new HtmlTextWriter(sw); //To Export all pages GridView5.AllowPaging = false; DQIBE4BVNPageDataBind();//.BindGrid(); GridView5.HeaderRow.BackColor = Color.White; foreach (TableCell cell in GridView5.HeaderRow.Cells) { cell.BackColor = GridView5.HeaderStyle.BackColor; } foreach (GridViewRow row in GridView5.Rows) { row.BackColor = Color.White; foreach (TableCell cell in row.Cells) { if (row.RowIndex % 2 == 0) { cell.BackColor = GridView5.AlternatingRowStyle.BackColor; } else { cell.BackColor = GridView5.RowStyle.BackColor; } cell.CssClass = "textmode"; } } GridView5.RenderControl(hw); //style to format numbers to string string style = @"<style> .textmode { } </style>"; Response.Write(style); Response.Output.Write(sw.ToString()); Response.Flush(); Response.End(); } }
private void Export_OE(string FileType, string FileName) { Response.Charset = "GB2312"; //避免文件名为乱码 Response.ContentEncoding = System.Text.Encoding.UTF8; //不知道干啥的,修改这行UTF8到7就出现乱码,最好别加了。 Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString()); Response.ContentType = FileType; this.EnableViewState = false; StringWriter tw1 = new StringWriter(); //实例化StringWriter; HtmlTextWriter hw1 = new HtmlTextWriter(tw1); //实例化HtmlTextWriter; //GridView1.Columns[7].Visible = false; //**!!!!**将第7列,也就是按钮列隐藏,否则无法导出来; GridView4.RenderControl(hw1); GridView5.RenderControl(hw1); Response.Write(tw1.ToString()); Response.End(); }
protected void btn4_Click(object sender, EventArgs e) { // Clear all content output from the buffer stream Response.ClearContent(); // Specify the default file name using "content-disposition" RESPONSE header Response.AppendHeader("content-disposition", "attachment; filename=homework.xls"); // Set excel as the HTTP MIME type Response.ContentType = "application/excel"; // Create an instance of stringWriter for writing information to a string System.IO.StringWriter stringWriter4 = new System.IO.StringWriter(); // Create an instance of HtmlTextWriter class for writing markup // characters and text to an ASP.NET server control output stream HtmlTextWriter htw4 = new HtmlTextWriter(stringWriter4); GridView5.RenderControl(htw4); Response.Write(stringWriter4.ToString()); Response.End(); }
public void ExcelExportSpecimenPending() { try { Response.Clear(); Response.AddHeader("content-disposition", "attachment;filename=Specimen Pending Report (" + DateTime.Today.ToString("dd-MM-yyyy") + ").xls"); Response.Charset = ""; Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); GridView5.AllowPaging = false; GridView5.CaptionAlign = TableCaptionAlign.Top; SpecimenPendingSample(); for (int i = 0; i < GridView5.HeaderRow.Cells.Count; i++) { GridView5.HeaderRow.Cells[i].Style.Add("font-size", "16px"); GridView5.HeaderRow.Cells[i].Style.Add("height", "80px"); GridView5.HeaderRow.Cells[i].Style.Add("background-color", "#00B894"); GridView5.HeaderRow.Cells[i].Style.Add("Color", "white"); } //// Footer Style: //GridView5.Rows[GridView5.Rows.Count - 1].Style.Add("font-size", "15px"); //GridView5.Rows[GridView5.Rows.Count - 1].Font.Bold = true; GridView5.RenderControl(htmlWrite); Response.Write(stringWrite.ToString()); Response.End(); } catch (Exception ex) { Response.Write("<script type=\"text/javascript\">alert(" + ex.Message + ")</script>"); } }