private void SetWorkbook(ExcelaUnicode unicode)
{
switch (unicode)
{
case ExcelaUnicode.XLS:
workBook = new HSSFWorkbook();
unicode = ExcelaUnicode.XLS;
break;
case ExcelaUnicode.XLSX:
workBook = new XSSFWorkbook();
unicode = ExcelaUnicode.XLSX;
break;
case ExcelaUnicode.AUTO:
if (fileName.ToUpper().IndexOf(".XLSX") > 0)
{
workBook = new XSSFWorkbook();
unicode = ExcelaUnicode.XLSX;
}
else
{
workBook = new HSSFWorkbook();
unicode = ExcelaUnicode.XLS;
}
break;
default:
workBook = new XSSFWorkbook();
unicode = ExcelaUnicode.XLSX;
break;
}
}
public ExcelHelper(string path, string fileName, ExcelaUnicode unicode = ExcelaUnicode.AUTO)
: base(path, fileName)
{
SetWorkbook(unicode);
}
