Remove formatting integer data in gridview when exporting to excel

See more:

C#

C#4.0

Hi,

I am developing a web application with c# in which there there is a page which containins a grodview.Gridview is having integer data and there is also a button to export the gridview data to excel file. Exporting to excel is working fine. But when the gridview is having large integer values, the number is getting formatted in the excel sheet. Can anyone tell me how to preent the formatting of numbers in excel.Please find the code below.

Code to export:

/// <summary>
        /// Export To Excel
        /// </summary>
public static void Export(string fileName, GridView gv)
        {
            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.AddHeader(
                "content-disposition", string.Format(CultureInfo.CurrentCulture, "attachment; filename={0}", fileName));
            HttpContext.Current.Response.ContentType = "application/ms-excel";

            using (StringWriter sw = new StringWriter(CultureInfo.CurrentCulture))
            {
                using (HtmlTextWriter htw = new HtmlTextWriter(sw))
                {                   
                    Table table = new Table();
                    table.GridLines = gv.GridLines;                   
                    if (gv.HeaderRow != null)
                    {
                        GridViewExportUtility.PrepareControlForExport(gv.HeaderRow);
                        table.Rows.Add(gv.HeaderRow);
                    }                  
                    foreach (GridViewRow row in gv.Rows)
                    {
                        GridViewExportUtility.PrepareControlForExport(row);
                        table.Rows.Add(row);
                    }
                   
                    if (gv.FooterRow != null)
                    {
                        GridViewExportUtility.PrepareControlForExport(gv.FooterRow);
                        table.Rows.Add(gv.FooterRow);
                    }
                   
                    table.RenderControl(htw);
                  
                    HttpContext.Current.Response.Write(sw.ToString());
                    HttpContext.Current.Response.End();
                }
            }
        }

/// <summary>
        /// Replace any of the contained controls with literals
/// </summary>
private static void PrepareControlForExport(Control control)
        {
            for (int i = 0; i < control.Controls.Count; i++)
            {
                Control current = control.Controls[i];
                if (current is LinkButton)
                {
                    control.Controls.Remove(current);
                    control.Controls.AddAt(i, new LiteralControl((current as LinkButton).Text));
                }
                else if (current is Image)
                {
                    control.Controls.Remove(current);
                }
                else if (current is ImageButton)
                {
                    control.Controls.Remove(current);
                    control.Controls.AddAt(i, new LiteralControl((current as ImageButton).AlternateText));
                }
                else if (current is HyperLink)
                {
                    control.Controls.Remove(current);
                    control.Controls.AddAt(i, new LiteralControl((current as HyperLink).Text));
                }
                else if (current is DropDownList)
                {
                    control.Controls.Remove(current);
                    control.Controls.AddAt(i, new LiteralControl((current as DropDownList).SelectedItem.Text));
                }
                else if (current is CheckBox)
                {
                    control.Controls.Remove(current);
                }
               
                if (current.HasControls())
                {
                    GridViewExportUtility.PrepareControlForExport(current);
                }
            }
        }

Gridview Data:

Status Matter Number

Sent 637
Saved 3409009408908908

Excel Data:

Status Matter Number

Sent 637
Saved 3.40901E+15

Please help.

Thanks in advance,
Sruthi