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); }