This is a migrated thread and some comments may be shown as answers.

[Solved] Export As String not Int

3 Answers 190 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Daniel Pålsson asked on 07 Oct 2009, 07:23 AM

Have a grid whit following column:

    
            <telerik:GridBoundColumn DataField="ArticleCode" UniqueName="ArticleCode" HeaderText="ArtikelID" ReadOnly="true" DataType="System.String"></telerik:GridBoundColumn>

In this column I insert values tha look like "001", "002" etc

But when I export it to Excel it formats the column to Integer values so it only displays 1,2 etc

How do I make the Excel sheet accept the value as a string and not an Integer?

    
            protected void ButtonExportToExcel_Click(object sender, EventArgs e)  
        
            {  
        
               RadGridMembers.ExportSettings.ExportOnlyData = false;  
        
               RadGridMembers.ExportSettings.IgnorePaging = true;  
        
               RadGridMembers.ExportSettings.OpenInNewWindow = true;  
        
               RadGridMembers.Page.Response.ClearHeaders();  
        
               RadGridMembers.Page.Response.Cache.SetCacheability(HttpCacheability.Private);  
        
               RadGridMembers.MasterTableView.ExportToExcel();  
        
            }

3 Answers, 1 is accepted

Accepted