[Solved] Excel exporting not showing string columns

[John]

Hello,

I have a grid that i wish to export ot excel.
The code is seemingly straight forward

 

protected void Button1_Click(object sender, EventArgs e)

        {

            radDeferredIncome.ExportSettings.IgnorePaging = true;

            radDeferredIncome.ExportSettings.OpenInNewWindow = true;

            radDeferredIncome.ExportSettings.ExportOnlyData = true;

            radDeferredIncome.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML;

            radDeferredIncome.MasterTableView.ExportToExcel();

        }

The problem is any column that is of type string does not show up in excel.  All the bounnd and numeric columns that have a type of Int32 do.  Has anyone else had this issue?  Is there a fix?

Thanks

John

 

[Daniel]

Hello John,

In my opinion your code is correct and should be working as expected. You can easily verify this on our online demos:
Export to MS Excel/MS Word/CSV demo

I recommend you create a simplified version of your project which demonstrates the issue and attach it to a formal support ticket. We will debug it locally and then provide to-the-point solution/answer for you.

Kind 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.