Creating excel by code

Hi,

Sometimes you might need to create an export of a table as an excel file.
Of course there are thousands of tools for that but if you d like to do it manually, here is the code you need:

Sorry I have got the code from one of my collegues, I can not share the source link.


Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=Export" + DateTime.Now.ToString("yyyy_MM_dd") + ".xls");
            Response.Charset = "";
            // If you want the option to open the Excel file without saving than
            // comment out the line below
            //Response.Cache.SetCacheability(HttpCacheability.NoCache);
            Response.ContentType = "application/vnd.xls";
            System.IO.StringWriter stringWrite = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter htmlWrite =
            new HtmlTextWriter(stringWrite);
Table tbl = //Create your table in here !


tbl.RenderControl(htmlWrite);

//These both line are needed if you like to format the cells as text and number
            string style = @"<style>.text{mso-number-format:\@;text-align:left;};.Nums{mso-number-format:0\.00;};.unwrap{wrap:false}</style>";
            Response.Write(style);

            Response.Write(stringWrite);
            //Response.Write(stringWrite.ToString().Replace(".", ","));
            Response.End();


While you were creating the table you d like to render as excel, you can give the format as below:
row.Cells[0].Attributes.Add("class", "text");
row.Cells[1].Attributes.Add("class", "Nums");

"text" and "Nums" classes should be set after you have rendered your control. (Comments can be found on the first code fragment)