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