protected void img_ExportToExcel6_Click(object sender, ImageClickEventArgs e) { if (txt_CodeOstad.Text == string.Empty) { txt_CodeOstad.Text = "0"; } dtResault = FRB.TeachingExperienceMoreThanADay(ddl_Term.SelectedValue, int.Parse(txt_CodeOstad.Text), int.Parse(ddl_Daneshkade.SelectedValue), int.Parse(ddl_Departman.SelectedValue), int.Parse(ddl_Cooperation.SelectedValue), int.Parse(txt_ListSavabeghRuz.Text)); if (dtResault.Rows.Count == 0) { } else { GridView6.DataSource = dtResault; GridView6.DataBind(); Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=ReportTeachingExperienceMoreThanADay.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; using (StringWriter sw = new StringWriter()) { HtmlTextWriter hw = new HtmlTextWriter(sw); //To Export all pages ////gv_Show.AllowPaging = false; ////this.BindGrid(); //gv_Show.HeaderRow.BackColor = Color.White; foreach (TableCell cell in GridView6.HeaderRow.Cells) { cell.BackColor = GridView6.HeaderStyle.BackColor; } foreach (GridViewRow row in GridView6.Rows) { //row.BackColor = Color.White; foreach (TableCell cell in row.Cells) { if (row.RowIndex % 2 == 0) { cell.BackColor = GridView6.AlternatingRowStyle.BackColor; } else { cell.BackColor = GridView6.RowStyle.BackColor; } cell.CssClass = "textmode"; } } GridView6.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(); } } }
protected void btnDownloadExcelDQIAfterBVNReport_Click(object sender, EventArgs e) { hidTAB.Value = "#tab3"; Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment;filename=DQIAfterBVNReportExport.xls"); Response.Charset = ""; Response.ContentType = "application/vnd.ms-excel"; using (StringWriter sw = new StringWriter()) { HtmlTextWriter hw = new HtmlTextWriter(sw); //To Export all pages GridView6.AllowPaging = false; DQIAfterBVNPageDataBind();//.BindGrid(); GridView5.HeaderRow.BackColor = Color.White; foreach (TableCell cell in GridView6.HeaderRow.Cells) { cell.BackColor = GridView6.HeaderStyle.BackColor; } foreach (GridViewRow row in GridView6.Rows) { row.BackColor = Color.White; foreach (TableCell cell in row.Cells) { if (row.RowIndex % 2 == 0) { cell.BackColor = GridView6.AlternatingRowStyle.BackColor; } else { cell.BackColor = GridView6.RowStyle.BackColor; } cell.CssClass = "textmode"; } } GridView6.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(); } }
protected void btn5_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=fees.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 stringWriter5 = 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 htw5 = new HtmlTextWriter(stringWriter5); GridView6.RenderControl(htw5); Response.Write(stringWriter5.ToString()); Response.End(); }