export excel with httpcontext

 private void ExporttoExcel(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//TR””>”);
        HttpContext.Current.Response.AddHeader(“Content-Disposition”, “attachment;filename=MusteriPortfoy.xls”);
        HttpContext.Current.Response.Charset = “utf-8”;
        HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding(“windows-1254”);
        //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 = dgMusteriPortfoyDetay.Columns.Count;
        for (int j = 0; j < columnscount; j++)
        {      //write in new column
            HttpContext.Current.Response.Write(“<Td>”);
            //Get column headers  and make it as bold in excel columns
            HttpContext.Current.Response.Write(“<B>”);
            HttpContext.Current.Response.Write(dgMusteriPortfoyDetay.Columns[j].HeaderText.ToString());
            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 < 21; i++) //table.Columns.Count
            {
                HttpContext.Current.Response.Write(“<Td>”);
                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();
    }
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: