Devexpress Excel Export

      #regionExcel Export/// <summary>        ///Excel Export
        /// </summary>        /// <param name= "Savefilename" >file name</param>        /// <param name= "GridView" >GridView data to export</param>         Public voidexportToExcel (stringSavefilename, DevExpress.XtraGrid.Views.Base.BaseView GridView) {            Try{SaveFileDialog Savedialog=NewSaveFileDialog (); Savedialog.defaultext="xls"; Savedialog.filter="export 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 =NewDevExpress.XtraExport.ExportXlsProvider (savefilename);  This. Findform ().                Refresh (); DevExpress.XtraGrid.Export.BaseExportLink Link=Gridview.createexportlink (provider); Link. Exportall=true; Link. Progress+=NewDevExpress.XtraGrid.Export.ProgressEventHandler (export_progress);//Progress bar EventLink. Exportto (true); Provider.                Dispose (); Link. Progress-=NewDevExpress.XtraGrid.Export.ProgressEventHandler (export_progress); Cursor.current=Cursors.Default;Messageutil.showtips ("Export Success! "); }            Catch(Exception ex) {
Messageutil.showerror ("Export failed! "); }        }        /// <summary>        ///Progress bar Event/// </summary>        /// <param name= "Sender" ></param>        /// <param name= "E" ></param>        Private voidExport_progress (Objectsender, DevExpress.XtraGrid.Export.ProgressEventArgs e) {            if(E.phase = =DevExpress.XtraGrid.Export.ExportPhase.Link) {//progressbarcontrol1.position = e.position;                 This.            Update (); }        }        #endregion

Devexpress Excel Export