public void TestRemoveRow() { HSSFWorkbook workbook = new HSSFWorkbook(); NPOI.SS.UserModel.Sheet sheet = workbook.CreateSheet("Test boolean"); Row row = sheet.CreateRow(2); sheet.RemoveRow(row); }
public void TestWriteModifySheetSimple() { string filepath = TempFile.GetTempFilePath("TestWriteSheetSimple", ".xls"); FileStream out1 = new FileStream(filepath, FileMode.OpenOrCreate); HSSFWorkbook wb = new HSSFWorkbook(); NPOI.SS.UserModel.Sheet s = wb.CreateSheet(); Row r = null; Cell c = null; for (int rownum = 0; rownum < 100; rownum++) { r = s.CreateRow(rownum); for (int cellnum = 0; cellnum < 50; cellnum += 2) { c = r.CreateCell(cellnum); c.SetCellValue(rownum * 10000 + cellnum + (((double)rownum / 1000) + ((double)cellnum / 10000))); c = r.CreateCell(cellnum + 1); c.SetCellValue(new HSSFRichTextString("TEST")); } } for (int rownum = 0; rownum < 25; rownum++) { r = s.GetRow(rownum); s.RemoveRow(r); } for (int rownum = 75; rownum < 100; rownum++) { r = s.GetRow(rownum); s.RemoveRow(r); } wb.Write(out1); out1.Close(); sanityChecker.CheckHSSFWorkbook(wb); Assert.AreEqual(74, s.LastRowNum, "LAST ROW == 74"); Assert.AreEqual(25, s.FirstRowNum, "FIRST ROW == 25"); }
public void TestRemoveZeroRow() { HSSFWorkbook workbook = new HSSFWorkbook(); NPOI.SS.UserModel.Sheet sheet = workbook.CreateSheet("Sheet1"); Row row = sheet.CreateRow(0); try { sheet.RemoveRow(row); } catch (ArgumentException e) { if (e.Message.Equals("Invalid row number (-1) outside allowable range (0..65535)")) { throw new AssertFailedException("Identified bug 45367"); } throw e; } }