protected override void ReadWorkbook(string fileName)
{
string extension = Path.GetExtension(fileName);
FileStream fs = File.OpenRead(fileName);
if (extension.Equals(".xls"))
{
//把xls文件中的数据写入wk中
_npoiWorkbook = new HSSFWorkbook(fs);
}
else
{
//把xlsx文件中的数据写入wk中
_npoiWorkbook = new XSSFWorkbook(fs);
}
fs.Close();
//读取当前表数据
int num = _npoiWorkbook.NumberOfSheets;
for (int i = 0; i < num; i++)
{
ISheet sheet = _npoiWorkbook.GetSheetAt(i);
NpoiWorksheet worksheet = new NpoiWorksheet(sheet);
_workSheets.Add(worksheet);
}
//throw new NotImplementedException();
}
public override StdExcelWorkSheetBase InsertSheet(string sheetName)
{
ISheet sheet = _npoiWorkbook.CreateSheet(sheetName);
NpoiWorksheet npoiSheet = new NpoiWorksheet(sheet);
_workSheets.Add(npoiSheet);
return(npoiSheet);
}
