private static IWorkbookFormatProvider GetFormatProvider(string extension)
{
IWorkbookFormatProvider formatProvider;
switch (extension)
{
case XlsxFormat:
formatProvider = WorkbookFormatProvidersManager.GetProviderByName("XlsxFormatProvider");
break;
case CsvFormat:
formatProvider = WorkbookFormatProvidersManager.GetProviderByName("CsvFormatProvider");
(formatProvider as CsvFormatProvider).Settings.HasHeaderRow = true;
break;
case TxtFormat:
formatProvider = WorkbookFormatProvidersManager.GetProviderByName("TxtFormatProvider");
break;
case PdfFormat:
formatProvider = WorkbookFormatProvidersManager.GetProviderByName("PdfFormatProvider");
break;
default:
formatProvider = null;
break;
}
return(formatProvider);
}
public MainPage()
{
WorkbookFormatProvidersManager.RegisterFormatProvider(new PdfFormatProvider());
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
InitializeComponent();
this.radSpreadsheet.Loaded += radSpreadsheet_Loaded;
}
static FileHelper()
{
ExportFormats = new string[] { XlsxFormat, CsvFormat, TxtFormat, PdfFormat };
WorkbookFormatProvidersManager.RegisterFormatProvider(new PdfFormatProvider());
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
}
public MainPage()
{
StyleManager.ApplicationTheme = new Windows8Theme();
WorkbookFormatProvidersManager.RegisterFormatProvider(new PdfFormatProvider());
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
InitializeComponent();
}
public MainPage()
{
InitializeComponent();
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
this.RegisterCustomFunctions();
this.LoadResourceFile("Resources/CustomFunctions.xlsx");
}
public MainPage()
{
this.highlightFill = new PatternFill(PatternType.Solid, Colors.Yellow, Colors.Transparent);
InitializeComponent();
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
this.AddCustomContextMenuItem();
}
private void UnregisterTxtFormatProvider()
{
#region radspreadprocessing-formats-and-conversion-workbookformatprovidersmanager_1
IWorkbookFormatProvider provider = WorkbookFormatProvidersManager.GetProviderByName("TxtFormatProvider");
if (provider != null)
{
WorkbookFormatProvidersManager.UnregisterFormatProvider(provider);
}
#endregion
}
private void UnregisterTxtFormatProvider()
{
#region radspreadsheet-model-import-export-format-providers-manager_1
IWorkbookFormatProvider provider = WorkbookFormatProvidersManager.GetProviderByName("TxtFormatProvider");
if (provider != null)
{
WorkbookFormatProvidersManager.UnregisterFormatProvider(provider);
}
#endregion
}
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()
{
Workbook workbook = new Workbook();
#region radspreadprocessing-formats-and-conversion-format-providers-manager_3
SaveFileDialog saveFileDialog = new SaveFileDialog();
if (saveFileDialog.ShowDialog() == true)
{
string extension = Path.GetExtension(saveFileDialog.SafeFileName);
using (Stream output = saveFileDialog.OpenFile())
{
WorkbookFormatProvidersManager.Export(workbook, extension, output);
}
}
#endregion
}
private void Import()
{
#region radspreadprocessing-formats-and-conversion-format-providers-manager_2
Workbook workbook;
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == true)
{
try
{
string extension = Path.GetExtension(openFileDialog.SafeFileName);
using (Stream input = openFileDialog.OpenFile())
{
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-format-providers-manager_4
Workbook workbook;
OpenFileDialog openFileDialog = new OpenFileDialog();
if (openFileDialog.ShowDialog() == true)
{
try
{
string extension = Path.GetExtension(openFileDialog.File.Name);
using (Stream input = openFileDialog.File.OpenRead())
{
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
}
public MainPage()
{
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
InitializeComponent();
}
private void RegisterXlsxFormatProvider()
{
#region radspreadprocessing-formats-and-conversion-workbookformatprovidersmanager_0
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
#endregion
}
public ExcelSpreadSheet()
{
WorkbookFormatProvidersManager.RegisterFormatProvider(new PdfFormatProvider());
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
}
private void RegisterXlsxFormatProvider()
{
#region radspreadsheet-model-import-export-format-providers-manager_0
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
#endregion
}
static FileHelper()
{
WorkbookFormatProvidersManager.RegisterFormatProvider(new XlsxFormatProvider());
}
