fang1004tw

        private void gridView1_PopupMenuShowing(object sender, DevExpress.XtraGrid.Views.Grid.PopupMenuShowingEventArgs e)
        {           
            if (e.MenuType != DevExpress.XtraGrid.Views.Grid.GridMenuType.Column) return;
            DevExpress.Utils.Menu.DXMenuItem item = new DevExpress.Utils.Menu.DXMenuItem("Export", new EventHandler(MenuItemExport));
            item.Tag = e.Menu;
            e.Menu.Items.Add(item);
        }

        private void MenuItemExport(object sender, EventArgs e)
        {           
            SaveFileDialog f = new SaveFileDialog();
            f.FileName = "~tmp1.xlsx";
            f.Filter = "Excel files (*.xlsx)|*.xlsx";
            if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                gridView1.OptionsView.ShowViewCaption = true;
                Application.DoEvents();
                gridView1.OptionsPrint.AutoWidth = false;            
                gridView1.ExportToXlsx(f.FileName);
                gridView1.OptionsView.ShowViewCaption = false;
            }
        }