Excel Export Controller

Radzen.Blazor Components
1

Hi,

I'm trying to use your ExportController to do excel export.
I'm using EntityFramework.
I get a trouble with the 'ApplyQuery' method
i get this message :

image
image1253×394 65.7 KB

I think it comes fom my entity but did you have already get this kind of trouble ?

Regards,

2

pls post the .cs code which calls the ApplyQuery method to comment further

3

HI,

here is :
using DBAccessEFCore;
using DBAccessEFCore.Models.ElectionCentral;
using DBAccessEFCore.Models.Stage;
using DBAccessEFCore.Reports;
using Election_Manager.Services;
using System.Reflection;
using System.Resources;
using System.Text.RegularExpressions;

namespace Election_Manager.Controllers
{
public partial class ExportEFDataFactoryController : ExportController
{
private readonly EFDataFactory eFDataFactory;
private readonly ECSession _sess;
private readonly ElectionCentralContext _context;
private readonly StageContext _contextstage;
public ExportEFDataFactoryController(EFDataFactory eFDataFactory, ECSession _sess, ElectionCentralContext context, StageContext contextstage)
{
this.eFDataFactory = eFDataFactory;
this._sess = _sess;
this._context = context;
this._contextstage = contextstage;
}
ResourceManager rm = new ResourceManager("Election_Manager.Language.Resource", Assembly.GetExecutingAssembly());
[HttpGet("/export/exportefdatafactory/voter/excel/{sessionGuid}/{languageCode}/{currentElectionEventID}/{ownerid}/{adminid}/{filename}")]
public FileStreamResult ExportVoterToExcel(string sessionGuid, string languageCode, string currentElectionEventID, string ownerid, string adminid, string filename)
{

        return ToExcel(ApplyQuery(_contextstage.VoterData, Request.Query), filename);
    }

}
}

4

For more information, i get this error message :

image
image921×858 50.2 KB

5

pls refer to this sample for further details
Blazor DataGrid Component - Export to Excel and CSV | Free UI Components by Radzen

6

Hi,
I implement this sample in my solution like that :

image
image1038×205 32.3 KB

image
image1112×441 46.5 KB

image

Unfortunately, i get the same result :

image
image700×762 42.8 KB

7

Apparently something in the $select argument causes the problem. Try investigating what that is.

8

Hi,
In point of fact, my grid is based on dictionnary datasource like in your sample :Blazor DataGrid Component - Dynamic Data | Free UI Components by Radzen.
Maybe it's a trouble to export in excel ?

Regards,

9

Yes, definitely that’s the problem. You can remove Select definitions from the Query.