Just Put this function and Pass argument as datatable in Your code
private void ExporttoExcelFast(DataTable
table)
{
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.ClearContent();
HttpContext.Current.Response.ClearHeaders();
HttpContext.Current.Response.Buffer
= true;
HttpContext.Current.Response.ContentType
= "application/ms-excel";
HttpContext.Current.Response.Write(@"<!DOCTYPE HTML PUBLIC ""-//W3C//DTD
HTML 4.0 Transitional//EN"">");
HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=DAS.xls");
HttpContext.Current.Response.Charset
= "utf-8";
HttpContext.Current.Response.ContentEncoding
= System.Text.Encoding.GetEncoding("windows-1250");
//sets font
HttpContext.Current.Response.Write("<font style='font-size:10.0pt;
font-family:Calibri;'>");
HttpContext.Current.Response.Write("<BR><BR><BR>");
//sets the
table border, cell spacing, border color, font of the text, background,
foreground, font height
HttpContext.Current.Response.Write("<Table border='1' bgColor='#ffffff' "
+
"borderColor='#000000'
cellSpacing='0' cellPadding='0' " +
"style='font-size:10.0pt;
font-family:Calibri; background:white;'> <TR>");
//am getting
my grid's column headers
int
columnscount = table.Columns.Count;
for (int j = 0; j < columnscount; j++)
{
//write in new column
HttpContext.Current.Response.Write("<Td
bgcolor='#6699cc'>");
//Get column
headers and make it as bold in excel
columns
HttpContext.Current.Response.Write("<B>");
HttpContext.Current.Response.Write(table.Columns[j].ColumnName);
HttpContext.Current.Response.Write("</B>");
HttpContext.Current.Response.Write("</Td>");
}
HttpContext.Current.Response.Write("</TR>");
foreach
(DataRow row in
table.Rows)
{//write in
new row
HttpContext.Current.Response.Write("<TR>");
for (int i = 0; i < table.Columns.Count; i++)
{
if
(row[i].ToString() == "01/01/1754")
{
if
(table.Rows.IndexOf(row) % 2 == 0)
{
HttpContext.Current.Response.Write("<Td>");
HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("</Td>");
}
else
{
HttpContext.Current.Response.Write("<Td bgcolor='#dcf2f8'>");
HttpContext.Current.Response.Write("
");
HttpContext.Current.Response.Write("</Td>");
}
}
else
{
if
(table.Rows.IndexOf(row) % 2 == 0)
{
HttpContext.Current.Response.Write("<Td>");
HttpContext.Current.Response.Write(row[i].ToString());
HttpContext.Current.Response.Write("</Td>");
}
else
{
HttpContext.Current.Response.Write("<Td
bgcolor='#dcf2f8'>");
HttpContext.Current.Response.Write(row[i].ToString());
HttpContext.Current.Response.Write("</Td>");
}
}
}
HttpContext.Current.Response.Write("</TR>");
}
HttpContext.Current.Response.Write("</Table>");
HttpContext.Current.Response.Write("</font>");
HttpContext.Current.Response.Flush();
HttpContext.Current.Response.End();
}
No comments:
Post a Comment