Export Grid to Excel in AspNetCore

[Diego Hoyos]

With version14.2600.0.28-preview2-final how to export grid in Excel Format.

[Karthick Kuppusamy]

Hi Diego, 

 

Thanks for Contacting Syncfusion support. 

 

We have analyzed your requirement and we have created a sample for your requirement. 

Please find the code example excel export. 

 

 

public IActionResult ExportToExcel(string GridModel) 

        { 

            ExcelExport exp = new ExcelExport(); 

            var DataSource = order; 

            GridProperties obj = ConvertGridObject(GridModel); 

            GridExcelExport exc = new GridExcelExport(); 

            exc.Theme = "flat-saffron"; 

            exc.FileName = "Export.xlsx"; 

            return exp.Export(obj, DataSource, exc); 

        } 

 

 

Sample link: 

http://www.syncfusion.com/downloads/support/directtrac/156754/ze/SyncfusionMvc-1925279289. 

 

Regards, 

K.Karthick. 

[Gary Whiteside]

I've currently got the following packages added to my project.json

"Syncfusion.EJ.AspNet.Core": "14.3600.0.49-preview2-final",
"Syncfusion.Pdf.AspNet.Core": "14.3600.0.49-preview2-final",

What additional packages do I need to add to get the export to Word, Excel and PDF to work?

Thanks

[Mohammed Farook J]

Hi Diego,  

 

If you need to export option , please includes the following dll’s in your project. 

 

 

"Syncfusion.EJ.AspNet.Core": " 14.3600.0.49-preview2-final", 

    "Syncfusion.Pdf.AspNet.Core": " 14.3600.0.49-preview2-final", 

    "Syncfusion.DocIO.AspNet.Core": " 14.3600.0.49preview2-final", 

    "Syncfusion.XlsIO.AspNet.Core": " 14.3600.0.49-preview2-final", 

    "Syncfusion.EJ.Export": " 14.3600.0.49-preview2-final" 

 

 

 

 

Regards, 

J.Mohammed Farook