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()); }