Error exporting grid to excel

[Danferd Lan]

I was trying to export the Grid to excel that bind to datatable but i'm getting the error, "Thread was being aborted".

Private Sub SqReadBonusComm()

        Try

            GV.gvSql = "SELECT * " &

                        "FROM dbo.Bonus_Summary (NOLOCK) " &

                        "WHERE MEMBER_ID = '" & USR.ID & "' " &

                        "AND Type <> 'Payout'"

            GV.CreateDataTable(DB, GV.gvSql, cnnMain)

            Session(MsFg1SesBonusComm) = GV.gvDataTable.DefaultView.ToTable

            gBonusComm.DataSource = Session(MsFg1SesBonusComm)

            gBonusComm.DataBind()

        Catch ex As Exception

            SystemErrorsAlert("SqReadBonusComm", ex.Message, Me.Page)

        End Try

    End Sub

Protected Sub FlatGrid_ServerExcelExporting(sender As Object, e As Syncfusion.JavaScript.Web.GridEventArgs)

        Try

            Dim exp As New ExcelExport()

            Dim dt As DataTable = DirectCast(Session(MsFg1SesBonusComm), DataTable)

            exp.Export(gBonusComm.Model, dt, "Export.xlsx", ExcelVersion.Excel2010, True, True, "flat-lime")

        Catch ex As Exception

            SystemErrorsAlert("FlatGrid_ServerExcelExporting", ex.Message, Me.Page)

        End Try

    End Sub

[Jayaprakash Kamaraj]

Hi Danferd, 

Thank you for contacting Syncfusion support. 

We have created a sample with custom button to export grid data. Please refer to the below link.    

http://www.syncfusion.com/downloads/support/forum/128993/ze/SyncfusionASPNETApplication291380621665 

Also, we have provided “DataTable Support for exporting” from v14.1.0.41. So if you are using older version, please upgrade to the new version.   

Please download the latest version from the below link.  

https://www.syncfusion.com/forums/128853/essential-studio-2017-volume-1-release-v15-1-0-33-is-available-for-download  

Please follow the below steps. 

1)      Download and install the Essential Studio v15.1.0.33 .  

 

2)      Replace the Syncfusion scripts, CSS and DLL’s in your project from the following location. 

            Scripts and CSS: C:\Program Files (x86)\Syncfusion\Essential Studio\XX.X.X.XX\JavaScript\assets 

            Dlls: C:\Program Files (x86)\Syncfusion\Essential Studio\ XX.X.X.XX \Assemblies 

Here XX.X.X.XX denotes the product version(15.1.0.33). 

And also after upgrading please ensure to clear the browser cache to avoid accidental reference of the old scripts/CSS. 

If the issue has still not resolved, please provide the following details,  

1.       Attach a screenshot of your stack trace.      

2.       Share the video to show the issue. 

3.       Essential studio version and Browser details.   

4.       Issue replication procedure. 

Regards, 

Jayaprakash K.