Send Excel File on mail from ejsgrid

[Nitin Pawar]

how to send ejs grid data in excel format as mail attachment where i have multiple grid on the page with different id's

[Balaji Sekar]

Hi Nitin, 

 

Based on your query we suspect that you need to export multiple Grids on a single excel file. So, please refer the below code example and sample for more information. 

 

[index.cshtml] 

 

<ejs-grid id="Grid1" dataSource="ViewBag.DataSource" allowPaging="true" allowExcelExport="true" toolbar="@(new List<string>() {"ExcelExport"})" toolbarClick="toolbarClick"> 

    <e-grid-columns> 

     .     .     .      . 

    </e-grid-columns> 

</ejs-grid> 

 

<ejs-grid id="Grid2" dataSource="ViewBag.DataSource" allowExcelExport="true"  allowPaging="true"> 

    <e-grid-columns> 

     .     .     .      . 

    </e-grid-columns> 

</ejs-grid> 

 

<ejs-grid id="Grid3" dataSource="ViewBag.DataSource" allowExcelExport="true"  allowPaging="true"> 

    <e-grid-columns> 

     .     .     .      . 

    </e-grid-columns> 

</ejs-grid> 

 

<ejs-grid id="Grid4" dataSource="ViewBag.DataSource" allowExcelExport="true"  allowPaging="true"> 

    <e-grid-columns> 

     .     .     .      . 

    </e-grid-columns> 

</ejs-grid> 

   function toolbarClick(args) {         

        if (args.item.text == "Excel Export") { 

            var appendExcelExportProperties = { 

                multipleExport: { type: 'NewSheet' } 

            }; 

 

            var grid1 = document.getElementById("Grid1").ej2_instances[0]; 

            var grid2 = document.getElementById("Grid2").ej2_instances[0]; 

            var grid3 = document.getElementById("Grid3").ej2_instances[0]; 

            var grid4 = document.getElementById("Grid4").ej2_instances[0]; 

 

            grid1.excelExport(appendExcelExportProperties, true).then(function (props) { 

                grid2.excelExport(appendExcelExportProperties, true, props).then(function (fdata) { 

                    grid3.excelExport(appendExcelExportProperties, true, fdata).then(function (data) { 

                        grid4.excelExport(appendExcelExportProperties, false, data); 

                    }) 

                }) 

            }) 

        } 

    } 

 

Sample link:  https://www.syncfusion.com/downloads/support/forum/158051/ze/MultipleGridsExportInSingleExcelFile-187601342.zip  

 

If we misunderstood your query, please provide the video demonstration of your requirement it will help us to provide the proper solution. 

 

Regards, 

Balaji Sekar 

[Nitin Pawar]

Thanks for your support.

But i don't want to download the excel but i want to attached excel file with multiple grid data  dynamically on mail without downloading

[Balaji Sekar]

Hi Nitin, 

 

We could not understand your requirement with the provided information. Please share more details regarding your query and we would like to know the following details to validate further on reported your requirement.  

1. Share the complete grid code example.  

2. Explain your exact requirement briefly. 

3. If you possible to share the host sample link or local sample.  

Regards,  

Balaji Sekar  

[Nitin Pawar]

As per the example you show below for export to excel with multiple grid is ok.But my requirement is that i don't wont to export data but i want to send the data in excel file on email from grid without export.

[Balaji Sekar]

Hi Nitin,  

Thanks for your valuable patience. 

   

Currently we do not have support for sending Excel file in email attachment.  

   

Regards,  

Balaji Sekar