Excel Export Options

[Uwe Hein]

Hi everybody,

  is there a way to silently export a excel sheet to a certain dictionary or at least to preselect an export dictionary. The offered dictionary in the save dialog is the last selected dictionary, which is not always desired.

The task I want to accomplish is:

1. Select an e-mal address in a combo-box

2. Apply a filtering in the grid by the selected address

3. Press a button and send the stored grid selection to the selected e-mail

This has to be done for 150 addresses.

Everything works fine but it is tedious to handle the save dialog which might be omitted if there were a silent grid excel export.

  regards

     Uwe

[Renjith Singh Rajendran]

Hi Uwe,  

Thanks for contacting Syncfusion support.  

Query: “Everything works fine but it is tedious to handle the save dialog which might be omitted if there were a silent grid excel export.” 

We have analyzed your requirement and as we are quite unclear about your requirement, we need some details about your query. So kindly share the following details.  

1. Do you want to export the data to Grid without prompting the user? Like local save.
2. If LocalSave option means data will be exported to Excel file into your specified folder (local directory).
3. Or do want to get the exported data in memory stream?
4. Share more details about the requirement.   

Above requested details will be helpful for us to validate the reported query at our end and provide solution as early as possible.  

Regards,
Renjith Singh Rajendran 

[Uwe Hein]

Hi Renjith,

  sorry for beeing unclear ...

1. It is a server side Blazor app

2. I have data in a grid which can be exported to excel perfectly

3. I want to send the excel table as an attachment by email (using MailKit)

Problem: If I get it right the excel export is also a download at the same time. So I would have to transfer the excel table back to the server to perform the e-mail operation from the server, because the attachment I want to send has to reside in the wwwroot directory for the e-mail module to work correctly.

So the refined question is: 

Is it possible to perform an excel export with the grid and store the excel table in wwwroot/mydir in a server side blazor app without prompting the user.

    regards

       Uwe

[Renjith Singh Rajendran]

Hi Uwe, 

Thanks for sharing the details. 

We have logged a feature request task for this requirement “Provide Local save export options support in Grid Export”. We are always trying to make our products better and feature requests like yours are a key part of our product growth efforts.   

   

You can now track the current status of this feature request here.   

https://www.syncfusion.com/feedback/17716/provide-local-save-export-options-support-in-grid-export 

   

At the planning stage for every release cycle, we review all open features and identify features for implementation based on specific parameters including product vision and technological feasibility. It will be implemented in any of our upcoming releases.   

You can communicate with us regarding the open features any time using our above Feature Report page. 

Regards, 

Renjith Singh Rajendran