MVVM Excel Export

[Minh]

I currently implemented Excel Export behind code, I'm trying to have it be implemented in the ViewModel Instead. How abouts would I do that?

 

 

 

        private void MenuItem_OnClick(object sender, RoutedEventArgs e)
        {
            try
            {
                string content;

                var extension = "xml";
                content = DrillThroughGridView.ToExcelML(true);

                string path = String.Format("Export.{0}", extension);

                if (File.Exists(path))
                {
                    File.Delete(path);
                }

                using (FileStream fs = File.Create(path))
                {
                    Byte[] info = Encoding.Default.GetBytes(content);
                    fs.Write(info, 0, info.Length);
                }

                Process.Start(path);
            }
            catch (Exception)
            {
                Notification.Error("Process Busy", "Please exit excel instance.");
            }
        }​

 

 

[Petya]

Hello Minh,

You can create a command in your view model and bind it to the MenuItem's Command property, so it will be executed when the item is clicked.

Regards,
Petya
Telerik

[Minh]

Hi Petya, 

I the viewmodel command part is relatively easy, how would I get "content = DrillThroughGridView.ToExcelML(true)" on the ViewModel side? 

[Petya]

Hi Minh,

You can pass the RadGridView instance as a parameter to the command. There are several examples using this approach in our demos, for example, Customizing ExcelML export. I also encourage you to take a look at the ExportToXlsx option we introduced in one of our recent releases in this article and the Exporting to Xlsx and Pdf demo.

Regards,
Petya
Telerik

[Marco]

Dear all,

 

can you please help me to find out one of these examples?

[Dinko | Tech Support Engineer]

Hi Marco,

As Petya suggested you can download the WPF Control Demo application. Then you can navigate to the GridView section and take a look at the Exporting and Printing demos.

There is a Silverlight online version of this application. Here is a link for the Customizing ExcelML export demo.

Regards,
Dinko
Progress Telerik