private void Open(string fileName)
{
string extension = Path.GetExtension(fileName);
IWorkbookFormatProvider provider = this.providers
.FirstOrDefault(p => p.SupportedExtensions
.Any(e => string.Compare(extension, e, StringComparison.InvariantCultureIgnoreCase) == 0));
if (provider != null)
{
using (Stream stream = File.OpenRead(fileName))
{
try
{
this.Workbook = provider.Import(stream);
}
catch (Exception)
{
Console.WriteLine("Could not open file.");
this.Workbook = null;
}
}
}
else
{
Console.WriteLine("Could not open file.");
}
}
private static Workbook ImportWorkbook()
{
Assembly assembly = typeof(ConvertViewModel).Assembly;
string fileName = assembly.GetManifestResourceNames().First(n => n.Contains("SpreadProcessingDocument1.xlsx"));
string fileFormat = XlsxFormat;
using (Stream stream = assembly.GetManifestResourceStream(fileName))
{
IWorkbookFormatProvider provider = GetProvider(fileFormat);
Workbook workbook = provider.Import(stream);
return(workbook);
}
}
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)
{
#if SILVERLIGHT
string fileName = dialog.File.Name;
#else
string fileName = dialog.FileName;
#endif
string extension = Path.GetExtension(fileName);
IWorkbookFormatProvider provider = this.providers
.FirstOrDefault(p => p.SupportedExtensions
.Any(e => string.Compare(extension, e, StringComparison.InvariantCultureIgnoreCase) == 0));
if (provider != null)
{
#if SILVERLIGHT
using (Stream stream = dialog.File.OpenRead())
#else
using (Stream stream = dialog.OpenFile())
#endif
{
try
{
this.Workbook = provider.Import(stream);
this.FileName = Path.GetFileName(fileName);
}
catch (Exception)
{
MessageBox.Show("Could not open file.");
this.Workbook = null;
this.FileName = null;
}
}
}
else
{
MessageBox.Show("Could not open file.");
}
}
}