private void Import()
{
RadSpreadsheet radSpreadsheet = new RadSpreadsheet();
var editor = radSpreadsheet.ActiveWorksheetEditor;
#region radspreadprocessing-formats-and-conversion-workbookformatprovidersmanager_2
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = FileDialogsHelper.GetOpenFileDialogFilter();
if (openFileDialog.ShowDialog() == true)
{
try
{
string extension = Path.GetExtension(openFileDialog.SafeFileName);
using (Stream input = openFileDialog.OpenFile())
{
editor.Owner.Workbook = WorkbookFormatProvidersManager.Import(extension, input);
}
}
catch (IOException ex)
{
throw new IOException("The file cannot be opened. It might be locked by another application.", ex);
}
}
#endregion
#if silverlight
#region radspreadprocessing-formats-and-conversion-workbookformatprovidersmanager_4
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = FileDialogsHelper.GetOpenFileDialogFilter();
if (openFileDialog.ShowDialog() == true)
{
try
{
string extension = Path.GetExtension(openFileDialog.File.Name);
using (Stream input = openFileDialog.File.OpenRead())
{
editor.Owner.Workbook = WorkbookFormatProvidersManager.Import(extension, input);
}
}
catch (IOException ex)
{
throw new IOException("The file cannot be opened. It might be locked by another application.", ex);
}
}
#endregion
#endif
}
private void ExportCsvCustomDelimiter()
{
RadSpreadsheet radSpreadsheet = new RadSpreadsheet();
var editor = radSpreadsheet.ActiveWorksheetEditor;
#region radspreadprocessing-formats-and-conversion-workbookformatprovidersmanager_3
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = FileDialogsHelper.GetSaveFileDialogFilter();
if (saveFileDialog.ShowDialog() == true)
{
string extension = Path.GetExtension(saveFileDialog.SafeFileName);
using (Stream output = saveFileDialog.OpenFile())
{
WorkbookFormatProvidersManager.Export(editor.Owner.Workbook, extension, output);
}
}
#endregion
}
