/// <summary>Read an Excel file into memory.</summary>
/// <param name="inputStream">The workbook to read.</param>
/// <param name="type">The version of file being read.</param>
/// <returns>A facade over the specific Excel libraries.</returns>
public static ExcelFile Read(System.IO.Stream inputStream, ExcelFileType type)
{
ExcelFile file;
switch (type)
{
case ExcelFileType.XLS:
file = new NpoiExcelFile(inputStream);
break;
case ExcelFileType.XLSX:
file = new EPPlusExcelFile(inputStream);
break;
default:
throw new InvalidOperationException();
}
return(file);
}
/// <summary>Create a new Workbook.</summary>
/// <param name="type">The version of Excel to target.</param>
/// <returns>A facade over the specific Excel libraries.</returns>
public static ExcelFile Create(ExcelFileType type)
{
ExcelFile newFile;
switch (type)
{
case ExcelFileType.XLS:
newFile = new NpoiExcelFile();
break;
case ExcelFileType.XLSX:
newFile = new EPPlusExcelFile();
break;
default:
throw new InvalidOperationException();
}
return(newFile);
}
/// <summary>Read an Excel file into memory.</summary>
/// <param name="inputStream">The workbook to read.</param>
/// <param name="type">The version of file being read.</param>
/// <returns>A facade over the specific Excel libraries.</returns>
public static ExcelFile Read(System.IO.Stream inputStream, ExcelFileType type)
{
ExcelFile file;
switch (type)
{
case ExcelFileType.XLS:
file = new NpoiExcelFile(inputStream);
break;
case ExcelFileType.XLSX:
file = new EPPlusExcelFile(inputStream);
break;
default:
throw new InvalidOperationException();
}
return file;
}
/// <summary>Create a new Workbook.</summary>
/// <param name="type">The version of Excel to target.</param>
/// <returns>A facade over the specific Excel libraries.</returns>
public static ExcelFile Create(ExcelFileType type)
{
ExcelFile newFile;
switch (type)
{
case ExcelFileType.XLS:
newFile = new NpoiExcelFile();
break;
case ExcelFileType.XLSX:
newFile = new EPPlusExcelFile();
break;
default:
throw new InvalidOperationException();
}
return newFile;
}