ExcelExport doesn't work (Object reference not set to an instance of an object.)

[Unknown]

Hi,

when I try to execute an export via the function ExcelExport() then an exception is thrown with the following details:

"Object reference not set to an instance of an object."

"   at Syncfusion.Blazor.Grids.Internal.GridExcelExport`1.ExecuteResult(SfGrid`1 GridModel, Object dataSource)\n   at Syncfusion.Blazor.Grids.Internal.GridExcelExport`1.ExportHelper(SfGrid`1 gridModel, Object dataSource)\n   at Syncfusion.Blazor.Grids.Internal.GridExcelExport`1.ExcelExport(SfGrid`1 GridModel, ExcelExportProperties ExportProperties)\n   at Syncfusion.Blazor.Grids.SfGrid`1.ExcelExport(ExcelExportProperties excelExportProperties, Nullable`1 isMultipleExport, Object workbook, Nullable`1 isBlob)\n   at HQSB.Web.Ui.Components.BaseControls.HQGrid`2.ExcelExport() in /Users/svenborisbornemann/Documents/hqlabs/repositories/hq-blazor-solution/hq-blazor/Components/BaseControls/Grid/HQGrid.razor:line 446"

I think it's related to the data, because the Read function of the Custom DataAdaptor we use works. I wasn't able to create an example, but I collect all data which might help you.

In the DataAdaptor we use an IQueryable to fetch the data out of our DB. And I serialized the data into the Json file you can find in the attachment. There you can find the Grid, DataAdaptor and the models as well.

Thanks for your support.

Best regards.

Attachment: Syncfusion_Grid_Export_968cbc6d.zip

[Unknown]

Hi, any chance you can check this? Causing us a lot of trouble with our customers.

Thanks

[Unknown]

It also not work with the newest version 18.3.52.

[Renjith Singh Rajendran]

Hi Nils, 

 

Greetings from Syncfusion support. 

 

We have confirmed this as a bug and logged the defect report “Problem with ExcelExport when bind CustomAdaptor in Grid” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle) and including the defect fix in our upcoming bi-weekly release which is expected to be rolled out by the mid of December 2020.  

    

You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.    

https://www.syncfusion.com/feedback/20303/problem-with-excelexport-when-bind-customadaptor-in-grid 

Until then as a workaround, we suggest you to add the below highlighted codes in your application to overcome the problem. 

 

public async Task ExcelExport() 

{ 

    ExcelExportProperties ExcelProp = new ExcelExportProperties(); 

    await Grid.ExcelExport(ExcelProp); 

} 

Regards, 

Renjith Singh Rajendran 

[Unknown]

Thank you, the workaround works.

[Renjith Singh Rajendran]

Hi Nils, 

Thanks for your update. 

Please follow up on the provided feedback link on future updates regarding this issue.  

https://www.syncfusion.com/feedback/20303/problem-with-excelexport-when-bind-customadaptor-in-grid 

Regards, 

Renjith R