private void ExportDefaultStyles(object param)
{
var grid = param as RadGridView;
var exportOptions = new GridViewDocumentExportOptions()
{
ExportDefaultStyles = true,
ShowColumnFooters = grid.ShowColumnFooters,
ShowColumnHeaders = grid.ShowColumnHeaders,
ShowGroupFooters = grid.ShowGroupFooters
};
var dialog = new SaveFileDialog()
{
DefaultExt = this.SelectedExportFormat,
Filter = String.Format("(*.{0})|*.{1}", this.SelectedExportFormat, this.SelectedExportFormat)
};
if (dialog.ShowDialog() == true)
{
using (var stream = dialog.OpenFile())
{
switch (this.SelectedExportFormat)
{
case "xlsx":
grid.ExportToXlsx(stream, exportOptions);
break;
case "pdf":
grid.ExportToPdf(stream, exportOptions);
break;
}
}
}
}
private void OnExportToXlsxCommandExecuted(object parameter)
{
if (this.GridView != null)
{
var exportOptions = new GridViewDocumentExportOptions()
{
AutoFitColumnsWidth = true,
ExportDefaultStyles = true,
ShowColumnHeaders = this.GridView.ShowColumnHeaders
};
var dialog = new SaveFileDialog()
{
DefaultExt = "xlsx",
Filter = String.Format("(*.{0})|*.{1}", "xlsx", "xlsx")
};
if (dialog.ShowDialog() == true)
{
using (var stream = dialog.OpenFile())
{
this.gridView.ExportToXlsx(stream, exportOptions);
}
}
}
}
