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
}
