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

Export Excel functionality from Radgrid silverlight

2 Answers 57 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Kumar
Top achievements
Rank 1
Kumar asked on 18 Jan 2014, 05:11 PM
I have beeen using export to excel function from the radgrid control for silverlight. Now I do have a requirement to show up a drop down in excel as one of the columns with some predefined values. Is that possible to do it.
code snippet:
private void ButtonExport_Click(object sender, RoutedEventArgs e)
        {
            string extension = "xls";
            SaveFileDialog dialog = new SaveFileDialog()
            {
                DefaultExt = extension,
                Filter = String.Format("{1} files (*.{0})|*.{0}|All files (*.*)|*.*", extension, "Excel"),
                FilterIndex = 1
            };

            if (dialog.ShowDialog() == true)
            {
                using (Stream stream = dialog.OpenFile())
                {
                    gridView.Export(stream,
                        new GridViewExportOptions()
                        {
                            Format = ExportFormat.Html,
                            ShowColumnHeaders = true,
                            ShowColumnFooters = false,
                            ShowGroupFooters = false
                        });
                }
            }
        }

2 Answers, 1 is accepted

Sort by
0
Kumar
Top achievements
Rank 1
answered on 21 Jan 2014, 07:38 AM
Any suggestions on this or can i write html in exported event but keeping the export format to ExcelML.
0
Ivan Ivanov
Telerik team
answered on 23 Jan 2014, 01:11 PM
Hi,

Unfortunately, as far as I know drop down options are not supported in the ExcelML specification, so that such behavior will be impossible to achieve.

Regards,
Ivan Ivanov
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
Tags
GridView
Asked by
Kumar
Top achievements
Rank 1
Answers by
Kumar
Top achievements
Rank 1
Ivan Ivanov
Telerik team
Share this question
or