When we import data on DataGrid into Excel, if you encounter a longer numeric string, such as the ID number, you will be used as a digital look, and convert it into a scientific counting method, resulting in loss of data The following method solves this problem and examples how to make other formatting.
View example
OutputExcel.aspx
<% @ Page language = "c #" codebehind = "outputExcel.aspx.cs" autoeventwireup = "false" inherits = "EMENG.EXAM.OUTPUTEXCEL"%>
OutputExcel title> head>