private void ExportCsvCustomDelimiter() { #region radspreadsheet-model-import-export-csvformatprovider-wpf_4 Workbook workbook = new Workbook(); workbook.Worksheets.Add(); string fileName = "SampleFile.csv"; IWorkbookFormatProvider formatProvider = new CustomCsvFormatProvider(); using (FileStream output = new FileStream(fileName, FileMode.Create)) { formatProvider.Export(workbook, output); } #endregion }
private void ImportWorkbookFromCsvUsingOpenFileDialogCuctomDelimiter() { #region radspreadsheet-model-import-export-csvformatprovider-silverlight_4 Workbook workbook; OpenFileDialog openFileDialog = new OpenFileDialog(); CustomCsvFormatProvider formatProvider = new CustomCsvFormatProvider(); openFileDialog.Filter = "CSV (comma delimited) (*.csv)|*.csv|All Files (*.*)|*.*"; if (openFileDialog.ShowDialog() == true) { using (Stream input = openFileDialog.File.OpenRead()) { workbook = formatProvider.Import(input); } } #endregion }
private void ImportCsvCustomDelimiter() { #region radspreadsheet-model-import-export-csvformatprovider-wpf_3 string fileName = "FileName.csv"; if (!File.Exists(fileName)) { throw new FileNotFoundException(String.Format("File {0} was not found!", fileName)); } Workbook workbook; IWorkbookFormatProvider formatProvider = new CustomCsvFormatProvider(); using (FileStream input = new FileStream(fileName, FileMode.Open)) { workbook = formatProvider.Import(input); } #endregion }
public void ExportWorkbookToCsvCustomDelimiter() { #region radspreadsheet-model-import-export-csvformatprovider-silverlight_5 Workbook workbook = new Workbook(); workbook.Worksheets.Add(); SaveFileDialog saveFileDialog = new SaveFileDialog(); CustomCsvFormatProvider formatProvider = new CustomCsvFormatProvider(); saveFileDialog.Filter = "CSV (comma delimited) (*.csv)|*.csv|All Files (*.*)|*.*"; if (saveFileDialog.ShowDialog() == true) { using (Stream output = saveFileDialog.OpenFile()) { formatProvider.Export(workbook, output); } } #endregion }