Tuesday 24 March 2015

Show Number formate Columns to Text formate in excel export in asp.net, C#



            string datestyle = @"<style> .nf{mso-number-format:\@;}</style>";

//add this string to your export data table
            HttpResponse Response = HttpContext.Current.Response;
            string filename = "Test" + "_" + System.DateTime.Now.ToString("MMddyy_hhmmss") + ".doc";
            Response.Clear();
            Response.AddHeader("content-disposition""attachment;filename=" + filename);
            Response.Charset = "";
            Response.ContentType = "application/xls";
            System.IO.StringWriter WriteItem = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter htmlText = newHtmlTextWriter(WriteItem);

            Response.Write(datestyle);
            Response.Write(strBuilder.ToString());
            Response.End();

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...