private void ExportToExcel(RadGridView gv)
{
string extension = "xls";
RadSaveFileDialog dialog = new RadSaveFileDialog()
{
DefaultExt = extension,
Filter = String.Format("{1} files (.{0})|.{0}|All files (.)|.", extension, "Excel"),
FilterIndex = 1
};
if (dialog.ShowDialog() == true)
{
using (Stream stream = dialog.OpenFile())
{
gv.Export(stream,
new GridViewExportOptions()
{
Format = ExportFormat.Html,
ShowColumnHeaders = true,
ShowColumnFooters = true,
ShowGroupFooters = false,
});
}
}
}
private void OnSaveAsFile(object sender, ExecutedRoutedEventArgs e)
{
var dialog = new RadSaveFileDialog();
if (dialog.ShowDialog() == true)
{
using (var stream = dialog.OpenFile()) {
Editor.Document.SaveFile(stream, Encoding.UTF8, LineTerminator.Newline);
}
FilePath = dialog.FileName;
}
}
private void SaveFile(object parameter)
{
string extension = null;
Stream outputStream = null;
RadSaveFileDialog saveDialog = new RadSaveFileDialog();
string exportFormat = parameter as string;
if (exportFormat != null && exportFormat.Contains("|"))
{
saveDialog.Filter = exportFormat;
}
else
{
var formatProviders = DocumentFormatProvidersManager.FormatProviders;
if (!string.IsNullOrEmpty(exportFormat))
{
string[] extensions = exportFormat.Split(',', ';').Select(e => e.Trim('.').ToLower()).ToArray();
formatProviders = formatProviders.Where(fp => fp.SupportedExtensions.Any(ext => extensions.Contains(ext.Trim('.').ToLower())));
}
string filter = string.Join("|", formatProviders.Where(fp => fp.CanExport)
.OrderBy(fp => fp.Name)
.Select(fp => FileHelper.GetFilter(fp))
.ToArray());
saveDialog.Filter = filter;
}
bool?dialogResult = saveDialog.ShowDialog();
if (dialogResult == true)
{
extension = System.IO.Path.GetExtension(saveDialog.FileName);
outputStream = saveDialog.OpenFile();
IDocumentFormatProvider provider = DocumentFormatProvidersManager.GetProviderByExtension(extension);
if (provider == null)
{
MessageBox.Show(LocalizationManager.GetString("Documents_SaveCommand_UnsupportedFileFormat"));
return;
}
if (provider is IConfigurablePdfFormatProvider)
{
IConfigurablePdfFormatProvider pdfFormatProvider = (IConfigurablePdfFormatProvider)provider;
pdfFormatProvider.ExportSettings.CommentsExportMode =
this.radRichTextBox.ShowComments ? PdfCommentsExportMode.NativePdfAnnotations : PdfCommentsExportMode.None;
}
try
{
using (outputStream)
{
provider.Export(this.radRichTextBox.Document, outputStream);
this.SetDocumentName(saveDialog.FileName);
}
}
catch (Exception)
{
MessageBox.Show(LocalizationManager.GetString("Documents_SaveCommand_UnableToSaveFile"));
}
}
}
