Export to Excel Failure

Question

My challenge is that I’m not able to get a grid to export to
Excel.  When I look at the errors in the Edge console on the button I have
calling the export function I see the error below .  I see the DLL it’s
looking for in my debug folder, but when I go to details on it I see version 18.4.0.35
so I’m at a bit of a loss if that’s the issue or if it’s just me coding
something improperly.  Thanks for any thoughts!

blazor.server.js:19 [2021-01-22T19:51:29.713Z] Error: System.IO.FileNotFoundException: Could not load file or assembly 'Syncfusion.ExcelExport.Net, Version=18.4200.0.35, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89'. The system cannot find the file specified.File name: 'Syncfusion.ExcelExport.Net, Version=18.4200.0.35, Culture=neutral, PublicKeyToken=3d67ed1f87d44c89'   at Syncfusion.Blazor.Grids.ExcelExportProperties..ctor()   at Elvis.Pages.Index.ExcelExport() in D:\OneDrive\Documents\Visual Studio 2019\Projects\Elvis\Elvis\Pages\Index.razor:line 886   at Microsoft.AspNetCore.Components.ComponentBase.CallStateHasChangedOnAsyncCompletion(Task task)   at Syncfusion.Blazor.Internal.SfBaseUtils.InvokeEvent[T](Object eventFn, T eventArgs)   at Syncfusion.Blazor.Buttons.SfButton.OnClickHandler(MouseEventArgs args)   at Microsoft.AspNetCore.Components.ComponentBase.CallStateHasChangedOnAsyncCompletion(Task task)   at Microsoft.AspNetCore.Components.RenderTree.Renderer.GetErrorHandledTask(Task taskToHandle) 

Joe

Vignesh Natarajan · Accepted Answer

Hi Michaël, 
 
We are glad to inform you that we have resolved the reported issue (exporting the grid data with individual Nuget package) in our 2020 Volume 4 Service Pack release. So we kindly request you to update your NuGet (Syncfusion.Blazor.Grids) to our latest version or minimum of 18.4.0.39 version to resolve the reported issue. 
 
Please find the Nuget package and release notes from below 
 
Nuget: https://www.nuget.org/packages/Syncfusion.Blazor/ 
 
We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.  
 
Regards, 
Vignesh Natarajan

Vignesh Natarajan · Answer

Hi Joe,  
 
Thanks for contacting Syncfusion support.  
 
Query: “ I’m not able to get a grid to export to Excel.” 
 
We have analyzed your query and we understand that are facing exception when exporting the Grid data. We are able to reproduce the reported issue at our end when referring the individual Nuget package Syncfusion.Blazor.Grid with version 18.4.0.35. If you are facing this issue, we have fixed the issue internally and it will be included in our 2020 Volume 4 Service pack release which is expected to be rolled out by month end of January 2021.  
 
Till then we appreciate your patience. If you are facing the reported in different scenario, kindly get back to us with more details.  
 
Regards, 
Vignesh Natarajan

Michaël Collard · Answer

Hi, Thank you for your rapid solution.First we are facing the same issue with individual nugget 18.4.0.35 but for each export available with DataGrid component.The second reason is that we have similar issue with Pivot Table.By now in our app export and pivot are no longer available because we need to get FileManager and S3Provider updated in 18.4.0.35 .. these working great right now.We are in difficult position as you can understand.Best regards.

Vignesh Natarajan · Answer

Hi Michaël,  
 
Sorry for the trouble you are facing.  
 
We have resolved the issue related to exporting in 18.4.0.35 while using individual Nuget packages internally and it will be included in our upcoming 2020 Volume 4 Service Pack release. We understand that you overcome the query by removing the export feature. We will get back to you once the reported issue is fixed and included in our 2020 Volume 4 Service pack release which is scheduled to be rolled out by end of January 2021. 
 
Please get back to us if you have further queries.     
 
Regards, 
Vignesh Natarajan