Grid export to excel - how to format cells as text?

[Kelly]

Is there a setting I can change so that the columns are formatted as text in the exported Excel document?

I'm exporting the RadGrid to excel using the following settings.  When I have a large number without dashes (for example a 13-digit ISBN like 9780071447997, it shows up as scientific format in the excel file (9.78007E+12).   It would be a lot more user-friendly if the value is exported without any modification (i.e., format all values as text). 

 <ExportSettings ExportOnlyData="true">
            <Excel Format="Html" />
        </ExportSettings>

 

string filename = "OrderImport";

 

MessageGrid.ExportSettings.FileName = filename;

MessageGrid.ExportSettings.IgnorePaging =

true;

 

MessageGrid.ExportSettings.OpenInNewWindow =

true;

 

MessageGrid.MasterTableView.ExportToExcel();

[Daniel]

Hiello Kelly,
 
You can either add &nbsp; (as shown below) or use the ExcelExportCellFormatting event to format your data.

<telerik:GridBoundColumn
    DataFormatString="&nbsp;{0}"
    DataField="Id">
</telerik:GridBoundColumn>

mso-number-format

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Kelly]

Thanks, the &nbsp; trick worked.  Is the cell formatting event new?  I don't see it in Intellisense (I am using Telerik.Web.UI version 2008.2.723.20)

[Daniel]

Hello Kelly,

The mentioned event was added in RadControls for ASP.NET AJAX Q2 2008 SP1 (version 2008.2.826) .

Let us know if you need more information.

Best regards,
Daniel
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.