public void ExistingWorkbook() { XSSFWorkbook xssfWb1 = new XSSFWorkbook(); xssfWb1.CreateSheet("S1"); SXSSFWorkbook wb1 = new SXSSFWorkbook(xssfWb1); XSSFWorkbook xssfWb2 = SXSSFITestDataProvider.instance.WriteOutAndReadBack(wb1) as XSSFWorkbook; Assert.IsTrue(wb1.Dispose()); SXSSFWorkbook wb2 = new SXSSFWorkbook(xssfWb2); Assert.AreEqual(1, wb2.NumberOfSheets); ISheet sheet = wb2.GetSheetAt(0); Assert.IsNotNull(sheet); Assert.AreEqual("S1", sheet.SheetName); Assert.IsTrue(wb2.Dispose()); xssfWb2.Close(); xssfWb1.Close(); wb2.Close(); wb1.Close(); }
public void AddToExistingWorkbook() { XSSFWorkbook xssfWb1 = new XSSFWorkbook(); xssfWb1.CreateSheet("S1"); ISheet sheet = xssfWb1.CreateSheet("S2"); IRow row = sheet.CreateRow(1); ICell cell = row.CreateCell(1); cell.SetCellValue("value 2_1_1"); SXSSFWorkbook wb1 = new SXSSFWorkbook(xssfWb1); XSSFWorkbook xssfWb2 = SXSSFITestDataProvider.instance.WriteOutAndReadBack(wb1) as XSSFWorkbook; Assert.IsTrue(wb1.Dispose()); xssfWb1.Close(); SXSSFWorkbook wb2 = new SXSSFWorkbook(xssfWb2); // Add a row to the existing empty sheet ISheet sheet1 = wb2.GetSheetAt(0); IRow row1_1 = sheet1.CreateRow(1); ICell cell1_1_1 = row1_1.CreateCell(1); cell1_1_1.SetCellValue("value 1_1_1"); // Add a row to the existing non-empty sheet ISheet sheet2 = wb2.GetSheetAt(1); IRow row2_2 = sheet2.CreateRow(2); ICell cell2_2_1 = row2_2.CreateCell(1); cell2_2_1.SetCellValue("value 2_2_1"); // Add a sheet with one row ISheet sheet3 = wb2.CreateSheet("S3"); IRow row3_1 = sheet3.CreateRow(1); ICell cell3_1_1 = row3_1.CreateCell(1); cell3_1_1.SetCellValue("value 3_1_1"); XSSFWorkbook xssfWb3 = SXSSFITestDataProvider.instance.WriteOutAndReadBack(wb2) as XSSFWorkbook; wb2.Close(); Assert.AreEqual(3, xssfWb3.NumberOfSheets); // Verify sheet 1 sheet1 = xssfWb3.GetSheetAt(0); Assert.AreEqual("S1", sheet1.SheetName); Assert.AreEqual(1, sheet1.PhysicalNumberOfRows); row1_1 = sheet1.GetRow(1); Assert.IsNotNull(row1_1); cell1_1_1 = row1_1.GetCell(1); Assert.IsNotNull(cell1_1_1); Assert.AreEqual("value 1_1_1", cell1_1_1.StringCellValue); // Verify sheet 2 sheet2 = xssfWb3.GetSheetAt(1); Assert.AreEqual("S2", sheet2.SheetName); Assert.AreEqual(2, sheet2.PhysicalNumberOfRows); IRow row2_1 = sheet2.GetRow(1); Assert.IsNotNull(row2_1); ICell cell2_1_1 = row2_1.GetCell(1); Assert.IsNotNull(cell2_1_1); Assert.AreEqual("value 2_1_1", cell2_1_1.StringCellValue); row2_2 = sheet2.GetRow(2); Assert.IsNotNull(row2_2); cell2_2_1 = row2_2.GetCell(1); Assert.IsNotNull(cell2_2_1); Assert.AreEqual("value 2_2_1", cell2_2_1.StringCellValue); // Verify sheet 3 sheet3 = xssfWb3.GetSheetAt(2); Assert.AreEqual("S3", sheet3.SheetName); Assert.AreEqual(1, sheet3.PhysicalNumberOfRows); row3_1 = sheet3.GetRow(1); Assert.IsNotNull(row3_1); cell3_1_1 = row3_1.GetCell(1); Assert.IsNotNull(cell3_1_1); Assert.AreEqual("value 3_1_1", cell3_1_1.StringCellValue); xssfWb2.Close(); xssfWb3.Close(); wb1.Close(); }
public override IEvaluationSheet GetSheet(int sheetIndex) { return(new SXSSFEvaluationSheet(_xBook.GetSheetAt(sheetIndex) as SXSSFSheet)); }