public static void SaveDocument(Workbook workbook, string selectedFormat)
{
IWorkbookFormatProvider formatProvider = GetFormatProvider(selectedFormat);
if (formatProvider == null)
{
return;
}
SaveFileDialog dialog = new SaveFileDialog();
dialog.Filter = String.Format("{0} files|*{1}|All files (*.*)|*.*", selectedFormat,
formatProvider.SupportedExtensions.First());
if (dialog.ShowDialog() == true)
{
using (var stream = dialog.OpenFile())
{
formatProvider.Export(workbook, stream);
}
}
}
private void Open(object obj)
{
OpenFileDialog dialog = new OpenFileDialog();
dialog.Filter = "Xlsx files|*.xlsx|Csv files|*.Csv|Text files|*.txt|All files (*.*)|*.*";
dialog.FilterIndex = 1;
if (dialog.ShowDialog() == true)
{
string extension = Path.GetExtension(dialog.FileName);
IWorkbookFormatProvider provider = this.providers
.FirstOrDefault(p => p.SupportedExtensions
.Any(e => string.Compare(extension, e, StringComparison.InvariantCultureIgnoreCase) == 0));
if (provider != null)
{
using (Stream stream = dialog.OpenFile())
{
try
{
this.Workbook = provider.Import(stream);
this.FileName = Path.GetFileName(dialog.FileName);
}
catch (Exception)
{
MessageBox.Show("Could not open file.");
this.Workbook = null;
this.FileName = null;
}
}
}
else
{
MessageBox.Show("Could not open file.");
}
}
}
