[Solved] While exporting data to excel from telerik RadGrid column value replaces with zeros

[Rashid]

I am using telerik RadGrid in which i am showing data like one column contain CARDNUMBERS like

 1234567894560900024

1234567894560900125

when i export this grid to excel the last three characters get replaced with zeros as shown below.

1234567894560900000

1234567894560900000

 

In the code behind data assigning code in shown below:

var cardNumber = gridRow.GetDataKeyValue("CARDNUMBER").ToString();

var lblCardNumber = (Label)e.Item.FindControl("lblCardNumber");

lblCardNumber.Text = cardNumber ;where CARDNUMBER is database column name. its datatype is varchar in the database.

[Konstantin Dikov]

Hello Rashid,

The issue that you are facing will be replicated only with the Html export format and in order to define other format for that value you will need to use the approach from the following help article:

• Excel Format (HTML-Based)

As you will notice, once you handle the server-side OnExportCellFormatting event you can get reference to the cells for the column holding the card number and apply the following:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
    if (e.FormattedColumn.UniqueName == "CardNumber")
    {
        e.Cell.Style["mso-number-format"] = @"\@";
    }
}

Hope this helps.


Regards,
Konstantin Dikov
Telerik