Devexpress EXCEL导出

最新推荐文章于 2025-04-14 10:36:25 发布

weixin_34342992

最新推荐文章于 2025-04-14 10:36:25 发布

阅读量244

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/xuzai/p/4723340.html

本文介绍了一个使用C#将Grid视图数据导出至Excel文件的方法，包括设置保存对话框、创建导出链接和处理进度条。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

      #region EXCEL导出

        /// <summary>
        /// EXCEL导出
/// </summary>
        /// <param name="saveFileName">文件名称</param>
        /// <param name="gridView">待导出的gridView数据</param>
        public void ExportToExcel(string saveFileName, DevExpress.XtraGrid.Views.Base.BaseView gridView)
        {
            try
            {
                SaveFileDialog saveDialog = new SaveFileDialog();
                saveDialog.DefaultExt = "xls";
                saveDialog.Filter = "导出Excel(*.xls)|*.xls";
                saveDialog.FileName = saveFileName + DateTime.Now.ToString("yyyyMMddHHmmss");
                if (saveDialog.ShowDialog() != DialogResult.OK)
                    return;
                saveFileName = saveDialog.FileName;
                Cursor.Current = Cursors.WaitCursor;
                DevExpress.XtraExport.IExportXlsProvider provider = new DevExpress.XtraExport.ExportXlsProvider(saveFileName);
                this.FindForm().Refresh();
                DevExpress.XtraGrid.Export.BaseExportLink link = gridView.CreateExportLink(provider);
                link.ExportAll = true;
                link.Progress += new DevExpress.XtraGrid.Export.ProgressEventHandler(Export_Progress);//进度条事件           
                link.ExportTo(true);
                provider.Dispose();
                link.Progress -= new DevExpress.XtraGrid.Export.ProgressEventHandler(Export_Progress);
                Cursor.Current = Cursors.Default;
                MessageUtil.ShowTips("导出成功！");
            }
            catch (Exception ex)
            {
　　　　　　　　 MessageUtil.ShowError("导出失败！");
            }
        }
        /// <summary>
        /// 进度条事件      
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void Export_Progress(object sender, DevExpress.XtraGrid.Export.ProgressEventArgs e)
        {
            if (e.Phase == DevExpress.XtraGrid.Export.ExportPhase.Link)
            {
              //  progressBarControl1.Position = e.Position;
                this.Update();
            }
        }


        #endregion