private void ExportGridToExcel()
{
try
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=ExportGridData.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (System.IO.StringWriter StringWriter = new System.IO.StringWriter())
{
HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);
GridTicketData.AllowPaging = false;
this.TicketDataGrid();
GridTicketData.CssClass = "rounded_corners";
foreach (GridViewRow row in GridTicketData.Rows)
{
foreach (TableCell cell in row.Cells)
{
cell.Attributes.CssStyle["text-align"] = "center";
List <Control> controls = new List <Control>();
//Add controls to be removed to Generic List
foreach (Control control in cell.Controls)
{
controls.Add(control);
}
foreach (Control control in controls)
{
switch (control.GetType().Name)
{
case "Label":
cell.Controls.Add(new Literal {
Text = (control as Label).Text
});
break;
}
cell.Controls.Remove(control);
}
}
}
GridTicketData.RenderControl(HtmlTextWriter);
Response.Write(StringWriter.ToString());
Response.End();
}
}
catch (Exception ex)
{
throw ex;
}
}
private void ExportGridToExcel()
{
GridTicketData.AllowPaging = true;
this.TicketDataGrid();
Response.Clear();
Response.AddHeader("content-disposition", "attachment;filename= " + DropDownList1.SelectedValue + "" + "Data.xls");
Response.ContentType = "File/Data.xls";
StringWriter StringWriter = new System.IO.StringWriter();
HtmlTextWriter HtmlTextWriter = new HtmlTextWriter(StringWriter);
GridTicketData.RenderControl(HtmlTextWriter);
Response.Write(StringWriter.ToString());
Response.End();
}
protected void ExportToExcel(object sender, EventArgs e)
{
Response.Clear();
Response.Buffer = true;
Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls");
Response.Charset = "";
Response.ContentType = "application/vnd.ms-excel";
using (StringWriter sw = new StringWriter())
{
HtmlTextWriter hw = new HtmlTextWriter(sw);
//To Export all pages
GridTicketData.AllowPaging = false;
this.BindGrid();
foreach (TableCell cell in GridTicketData.HeaderRow.Cells)
{
cell.BackColor = GridTicketData.HeaderStyle.BackColor;
}
foreach (GridViewRow row in GridTicketData.Rows)
{
foreach (TableCell cell in row.Cells)
{
if (row.RowIndex % 2 == 0)
{
cell.BackColor = GridTicketData.AlternatingRowStyle.BackColor;
}
else
{
cell.BackColor = GridTicketData.RowStyle.BackColor;
}
cell.CssClass = "textmode";
}
}
GridTicketData.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 ExportGridToword()
{
Response.Clear();
Response.Buffer = true;
Response.ClearContent();
Response.ClearHeaders();
Response.Charset = "";
string FileName = "Report" + DateTime.Now + ".doc";
StringWriter strwritter = new StringWriter();
HtmlTextWriter htmltextwrtter = new HtmlTextWriter(strwritter);
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = "application/msword";
Response.AddHeader("Content-Disposition", "attachment;filename=" + FileName);
GridTicketData.GridLines = GridLines.Both;
GridTicketData.HeaderStyle.Font.Bold = true;
GridTicketData.RenderControl(htmltextwrtter);
Response.Write(strwritter.ToString());
Response.End();
}
