RadGrid Export to Excel

[Sonu]

Hi
When I export a rad grid to an excel the integer and decimal values get converted to string.User has to select all the columns and convert them to integer. Is there any way while exporting they get stored as integer?

public static void ExportingGrid(RadGridView grid, string exportFormat)
        {

            try
            {
                string extension = string.Empty;

                ExportFormat format = ExportFormat.Html;

                switch (exportFormat)
                {
                    case "Excel": extension = "xls";
                        format = ExportFormat.ExcelML;
                        break;

                    case "Csv": extension = "csv";
                        format = ExportFormat.Csv;
                        break;
                }




                SaveFileDialog dialog = new SaveFileDialog();
                dialog.DefaultExt = extension;
                dialog.Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, exportFormat);
                dialog.FilterIndex = 1;

                if (dialog.ShowDialog() == true)
                {
                    using (Stream stream = dialog.OpenFile())
                    {
                        GridViewExportOptions exportOptions = new GridViewExportOptions();
                        exportOptions.Format = format;
                        exportOptions.ShowColumnFooters = true;
                        exportOptions.ShowColumnHeaders = true;
                        exportOptions.ShowGroupFooters = true;

                        grid.Export(stream, exportOptions);

                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

[Veselin Vasilev]

Hello Sonu,

One of the approaches is to export to Html format. Then you should not have any troubles.
Attached is how to achieve your goal with the ExcelML format.

Greetings,
Veselin Vasilev
the Telerik team

[Nikhil Thaker]

Hi,

While using the code given in the first post, when I am opening the exported excel file it always shows the warning message as shown in attached screen shot (Warning Message 1.png)..

And it prompts when I try to save the file as in another attached screenshot (Warning Message 2.png)..

So how to solve these issues.

Thanks in advance.

[Veselin Vasilev]

Hi Nikhil Thaker,

This help topic explains why this happens. You can export to ExcelML format (in an .xml file) and then the Excel will not warn when it tries to open it.

Best wishes,
Veselin Vasilev
the Telerik team

[Nikhil Thaker]

Thanks for quick reply,

But even on using ExcelML format .. still Excel warns the same..while opening and saving the file..

Please suggest some other solution or work around if possible.

[Veselin Vasilev]

Hello Nikhil Thaker,

Can you please try to export to ExcelML on our online demo. I have just tested it and the Excel (2007) did not complain.

All the best,
Veselin Vasilev
the Telerik team

[ronald]

I'm having the same issue.. compatibility warning message.
I'm using the exact same code as in this link:
http://www.telerik.com/help/wpf/gridview-export.html

also, I changed the format to ExportFormat.ExcelML but no luck..

is this a bug in telerik radgridview?

[Vlad]

Hello,

If you save the output from ExcelML export with xml extension you will not get such problems. 

Kind regards,
Vlad
the Telerik team

[ronald]

but i need to use the .xls extension and not .xml... any ideas?

thanks

[Vlad]

Hi,

 MS Excel will open it even with XML extension since you will have ExcelML data. 

Best wishes,
Vlad
the Telerik team