/// <summary>
/// Export GridView content to XLS
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ExportToXslButtonItem_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.DefaultExt = "xls";
sfd.Filter = "Excel sheet (*.xls)|*.xls";
sfd.InitialDirectory = System.Environment.SpecialFolder.MyDocuments.ToString();
DialogResult result = sfd.ShowDialog();
if (sfd != null && result == DialogResult.OK && sfd.FileName != null && sfd.FileName != string.Empty)
{
MainGridView.ExportToXls(sfd.FileName);
}
}
catch
{
ShowErrorMessage(Properties.Resources.ErrorDuringSavingXls);
}
}