[. Net] Export the resolution of digital strings such as IDs in Excel

 Public Static voidDatatabletoexcel (System.Data.DataTable dtdata, String FileName) {GridView Dgexport=NULL; HttpContext Curcontext=HttpContext.Current; StringWriter Strwriter=NULL; HtmlTextWriter HTMLWriter=NULL; if(Dtdata! =NULL) {Httputility.urlencode (FileName, System.Text.Encoding.UTF8); CurContext.Response.AddHeader ("content-disposition","attachment;filename="+ Httputility.urlencode (FileName, System.Text.Encoding.UTF8) +". xls"); CurContext.Response.ContentType="Application/vnd.ms-excel"; CurContext.Response.ContentEncoding= System.Text.Encoding.GetEncoding ("utf-7"); CurContext.Response.Charset="GB2312"; Strwriter=NewStringWriter (); HTMLWriter=NewHtmlTextWriter (Strwriter); Dgexport=NewGridView (); Dgexport.rowdatabound+ = (Gridviewformat);//when the GridView binds data, the data is formattedDgexport.datasource=Dtdata.defaultview; Dgexport.allowpaging=false;            Dgexport.databind ();            Dgexport.rendercontrol (HTMLWriter);            CurContext.Response.Write (Strwriter.tostring ());         CurContext.Response.End (); }} protected Static voidGridviewformat (Objectsender, GridViewRowEventArgs e) {//1) Text: vnd.ms-excel.numberformat:@//2) Date: Vnd.ms-excel.numberformat:yyyy/mm/dd//3) Number: vnd.ms-excel.numberformat:#,# #0. xx//4) Currency: vnd.ms-excel.numberformat:￥#,# #0. xx//5) Percentage: Vnd.ms-excel.numberformat: #0.00%         for(inti =0; i < E.row.cells.count; i++)        {            if(E.row.rowtype = =datacontrolrowtype.datarow) {e.row.cells[i]. Attributes.Add ("style","vnd.ms-excel.numberformat:@"); }        }    }

[. Net] Export the resolution of digital strings such as IDs in Excel