DevExpress GridControl 导出为Excel

最新推荐文章于 2024-01-20 09:59:57 发布

大Y

最新推荐文章于 2024-01-20 09:59:57 发布

阅读量5.2k

点赞数 1

分类专栏： winForm 文章标签： excel object html

winForm 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

private void btnExport_ItemClick(object sender, EventArgs e)
        {
            SaveFileDialog saveFileDialog = new SaveFileDialog();
            saveFileDialog.Title = "导出Excel";
            saveFileDialog.Filter = "Excel文件(*.xls)|*.xls";
            DialogResult dialogResult = saveFileDialog.ShowDialog(this);
            if (dialogResult == DialogResult.OK)
            {
                DevExpress.XtraPrinting.XlsExportOptions options = new DevExpress.XtraPrinting.XlsExportOptions();
                gridControl1.ExportToXls(saveFileDialog.FileName);
                DevExpress.XtraEditors.XtraMessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);            }
        }