"Export to Excel" can have two interpretations:

• "Give me an .xlsx or .xls file"
• "Give me something I can open in Excel"

In most cases, users expect the second behavior when they click "Export to Excel".

This can be achieved relatively easily using CSV. Excel will automatically apply its own formatting once any (even minor) edits are made within the spreadsheet.

Proposal:
Start with CSV support. Build this functionality directly into Blazorise.DataGrid with extensibility in mind, so that it can be easily integrated with external projects later (Blazorise.DataGrid.Excel). This will allow us to plug in full Excel export functionality (e.g., generating .xlsx) later, while satisfying the "open in excel" majority now.

I think we can add Task<string> ExportToCsv() to DataGrid. We could also pass it an argument to define what to export.

Proposal:

enum DataGridExportInfo // find better name 
{
  CurrentView,
  AllData,
}

then

Task<string> ExportToCsv(DataGridExportInfo info)