Export To Excel for DataSet

#region
//public static void ExportToExcel1(DataTable dt,string fileName,HttpResponse response)
public static void ExportToExcel1(DataTable dt,HttpResponse response)
{
response.Clear();
//response.AddHeader("content-disposition", "attachment;filename="+ fileName + ".xls");
response.AddHeader("content-disposition", "attachment;filename=File1.xls");
//response.Charset = "";
//response.Cache.SetCacheability(HttpCacheability.NoCache);
response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);
DataGrid dg = new DataGrid();
dg.DataSource = dt;
dg.DataBind();
dg.RenderControl(htmlWrite);
response.Write(stringWrite.ToString());
response.End();
}
#endregion

ExportToExcelFromstring

#region

public static void ExportToExcelFromstring(string fileName, HttpResponse response, string str)
{
response.Clear();
response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");
response.Charset = "";
response.Cache.SetCacheability(HttpCacheability.NoCache);
response.ContentType = "application/vnd.xls";
response.Write(str);
response.End();
}
#endregion

Export To Excel for WEB Table

public static void ExportToExcelFromWebTable(string fileName, HttpResponse response, Table Wtable)

{

response.Clear();

response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");

response.Charset = "";

//Htable.Border = 1;

//Htable.BorderColor = "Black";

response.Cache.SetCacheability(HttpCacheability.NoCache);

response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);

DataSet ds = new DataSet("Wtable");

// ds = ((System.Data.DataSet)Wtable).Copy();

DataGrid dg = new DataGrid();

dg.DataSource = ds;

dg.DataBind();
dg.RenderControl(htmlWrite);
response.Write(stringWrite.ToString());
//response.Write(Wtable.ToString());

response.End();

}

Export To Excel for HTML Table

public static void ExportToExcelFromTable(string fileName, HttpResponse response, HtmlTable Htable)

{

response.Clear();

response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");

response.Charset = "";

Htable.Border = 1;

Htable.BorderColor = "Black";

response.Cache.SetCacheability(HttpCacheability.NoCache);

response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter();

System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);

Htable.RenderControl(htmlWrite);

response.Write(stringWrite.ToString());

response.End();

}

Export To Excel for TD

public static void ExportToExcel(string fileName, HttpResponse response, HtmlTableCell tc) {
response.Clear();
response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");
response.Charset = "";
response.Cache.SetCacheability(HttpCacheability.NoCache);
response.ContentType = "application/vnd.xls";
System.IO.StringWriter stringWrite = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);

//DataGrid dg = new DataGrid();
//dg.DataSource = dt;
//dg.DataBind();
tc.RenderControl(htmlWrite);
response.Write(stringWrite.ToString());
response.End();
}

Export To Excel for HTML Table

#region

public static void ExportToExcelFromTable(string fileName, HttpResponse response, HtmlTable Htable)

{

response.Clear();

response.AddHeader("content-disposition", "attachment;filename=" + fileName + ".xls");

response.Charset = "";

Htable.Border = 1;

Htable.BorderColor = "Black";

response.Cache.SetCacheability(HttpCacheability.NoCache);

response.ContentType = "application/vnd.xls";

System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new System.Web.UI.HtmlTextWriter(stringWrite);

Htable.RenderControl(htmlWrite);

response.Write(stringWrite.ToString());

response.End();

}

#endregion

Export from Code to Excel and Genrate Chart

add using .....

using System.IO;
using Microsoft.Office.Interop.Excel;

On Button click......................
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.ApplicationClass();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
//add data
string Year = DateTime.Now.Year.ToString();
DataSet ds = SeverityRating.SelectSeverity_Chart(Year, ddlQuarter.SelectedValue, ddlSeverity.SelectedValue, SessionInfo.UserId, SessionInfo.CityId, ddlCompany.SelectedValue, Conn);
if (ds != null)
{
if (ds.Tables[1].Rows.Count > 0)
{
//xlWorkSheet.Cells[1, 1] = "Name";
xlWorkSheet.Cells[1, 2] = "Severity Rating " + " " + DateTime.Now.Year.ToString();
for (int i = 1; i <= ds.Tables[1].Rows.Count; i++)

{

xlWorkSheet.Cells[i + 1, 1] = ds.Tables[1].Rows[i - 1]["SeverityRating"].ToString();

xlWorkSheet.Cells[i + 1, 2] = ds.Tables[1].Rows[i - 1]["CatCount"].ToString();

}

}

} Excel.Range chartRange; Excel.ChartObjects xlCharts = (Excel.ChartObjects)xlWorkSheet.ChartObjects(Type.Missing);

Excel.ChartObject myChart = (Excel.ChartObject)xlCharts.Add(30, 150, 500, 250);

Excel.Chart chartPage = myChart.Chart;

string cellNumber = "B" + (ds.Tables[0].Rows.Count + 1);

chartRange = xlWorkSheet.get_Range("A1", cellNumber);

chartPage.SetSourceData(chartRange, misValue); chartPage.ChartType = Excel.XlChartType.xl3DPie;

//xlWorkBook.SaveAs("RootCauseAnalysis.xls");

if (File.Exists(Server.MapPath("~/Common/Uploads/SeverityRating.xls")))

{

File.Delete(Server.MapPath("~/Common/Uploads/SeverityRating.xls"));

}

xlWorkBook.SaveAs(Server.MapPath("Common/Uploads/SeverityRating.xls"), Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue);

xlApp.Quit();

releaseObject(xlWorkSheet);

releaseObject(xlWorkBook);

releaseObject(xlApp);

Response.ContentType = "application/ms-excel";

Response.AddHeader("content-disposition", "inline; filename=" + Server.MapPath("Common/Uploads/SeverityRating.xls"));

Response.TransmitFile(Server.MapPath("Common/Uploads/SeverityRating.xls"));

Response.Flush();