Export numbers from GridHyperLinkColumn to Excel

[Elena]

Dear Telerik,

We have a problem with exporting numbers from GridHyperLinkColumn to Excel (Biff). They do get transferred to Excel but are stored as Text.
How can I make sure the values are converted to numbers (column.DataType is Int32)?

Thanks,
Elena.

[Shinu]

Hi,

I tried to export numbers from GridHyperlinkcolum in excel and it worked as expected at my end. To make sure whether the data is number just take the sum of values/check the alignment (number:right aligned and text:left aligned) in xls sheet.

Hope this will help you.
Thanks,
Shinu.

[Shinu]

Hi,

I tried to export numbers from GridHyperlinkcolum in excel and it worked as expected at my end. To make sure whether the data is number just take the sum of values/check the alignment (number:right aligned and text:left aligned) in xls sheet.
Also please have a look into Number formats / Formulas portion in the following help documentation.
Excel Format

Hope this will help you.
Thanks,
Shinu.

[Elena]

Hi Shinu,

The sum of the values work and they are formatted correctly, but if I enable filtering, I see the green triangle to the left of each number with warning that 'number is stored as text' and only text sort/filters can be applied to the column.
I could not find anything in GridBiffExportingEventArgs to convert values to numbers.
Please let me know how I can do it.

Thanks,
Elena.

[Kostadin]

Hello Elena,

You could hook OnBiffExporting event handler and modify the cells values. Check out the following help article.

protected void RadGrid1_BiffExporting(object sender, Telerik.Web.UI.GridBiffExportingEventArgs e)
{
    xls.Table table = e.ExportStructure.Tables[0] as xls.Table;
    for (int i = 2; i <= table.Rows.Count; i++)
    {
        table.Cells[4, i].Value = Int32.Parse(table.Cells[4, i].Text);
    }
}

Regards,
Kostadin
Telerik

[Elena]

Thank you Kostadin, now it works correctly!