/// <summary>
/// Called when [execute export all to excel].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteExportAllToExcel(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl grid = args.Source as GridDataControl;
try
{
grid.ExportToExcel("Sample.xls", ExcelVersion.Excel97to2003);
System.Diagnostics.Process.Start("Sample.xls");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// Called when [execute export selected to excel].
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The <see cref="System.Windows.Input.ExecutedRoutedEventArgs"/> instance containing the event data.</param>
private static void OnExecuteExportSelectedToExcel(object sender, ExecutedRoutedEventArgs args)
{
GridDataControl grid = args.Source as GridDataControl;
if (grid != null && !grid.Model.SelectedRanges.ActiveRange.IsEmpty)
{
try
{
grid.ExportToExcel(grid.Model.SelectedRanges.ActiveRange, "Sample.xls", ExcelVersion.Excel97to2003);
System.Diagnostics.Process.Start("Sample.xls");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
}