List of removeSheetAt() Examples

Examples of removeSheetAt()

org.apache.poi.hssf.usermodel.HSSFWorkbook.removeSheetAt()
removes sheet at the given index @param index of the sheet (0-based)
org.apache.poi.ss.usermodel.Workbook.removeSheetAt()
Removes sheet at the given index @param index of the sheet to remove (0-based)
org.zkoss.zss.model.Book.removeSheetAt()

Examples of org.apache.poi.ss.usermodel.Workbook.removeSheetAt()


    @Test
  public void bug47090c() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
      assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.removeSheetAt(0);
    assertSheetOrder(workbook, "Sheet2");
      workbook.cloneSheet(0);  
    assertSheetOrder(workbook, "Sheet2", "Sheet2 (2)");
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet2", "Sheet2 (2)");

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Workbook.removeSheetAt()

  public void bug47090d() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
      assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.createSheet();
    assertSheetOrder(workbook, "Sheet1", "Sheet2", "Sheet0");
      workbook.removeSheetAt(0);
    assertSheetOrder(workbook, "Sheet2", "Sheet0");
      workbook.createSheet();  
    assertSheetOrder(workbook, "Sheet2", "Sheet0", "Sheet1");
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet2", "Sheet0", "Sheet1");

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Workbook.removeSheetAt()

  }
  
  public void testBug47090a() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
    assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.removeSheetAt(0);
    assertSheetOrder(workbook, "Sheet2");
      workbook.createSheet();
    assertSheetOrder(workbook, "Sheet2", "Sheet1");
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet2", "Sheet1");

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Workbook.removeSheetAt()

  }
  
  public void testBug47090b() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
      assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.removeSheetAt(1);
    assertSheetOrder(workbook, "Sheet1");
      workbook.createSheet();
    assertSheetOrder(workbook, "Sheet1", "Sheet0");    // Sheet0 because it uses "Sheet" + sheets.size() as starting point!
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet1", "Sheet0");

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Workbook.removeSheetAt()

  }


  public void testBug47090c() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
      assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.removeSheetAt(0);
    assertSheetOrder(workbook, "Sheet2");
      workbook.cloneSheet(0);  
    assertSheetOrder(workbook, "Sheet2", "Sheet2 (2)");
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet2", "Sheet2 (2)");

View Full Code Here

Examples of org.apache.poi.ss.usermodel.Workbook.removeSheetAt()

  public void testBug47090d() {
      Workbook workbook = XSSFTestDataSamples.openSampleWorkbook("47090.xlsx");
      assertSheetOrder(workbook, "Sheet1", "Sheet2");
      workbook.createSheet();
    assertSheetOrder(workbook, "Sheet1", "Sheet2", "Sheet0");
      workbook.removeSheetAt(0);
    assertSheetOrder(workbook, "Sheet2", "Sheet0");
      workbook.createSheet();  
    assertSheetOrder(workbook, "Sheet2", "Sheet0", "Sheet1");
      Workbook read = XSSFTestDataSamples.writeOutAndReadBack(workbook);
    assertSheetOrder(read, "Sheet2", "Sheet0", "Sheet1");

View Full Code Here

Examples of org.zkoss.zss.model.Book.removeSheetAt()

            final int sheetCount = book.getNumberOfSheets();
            if (sheetCount == 1) {
              Messagebox.show("A workbook must contain at least one visible worksheet");
            }
            final String delSheetName = _sheet.getSheetName(); //must getName before remove
            book.removeSheetAt(index);
            final int newIndex =  index < (sheetCount - 1) ? index : (index - 1);
            final String newSheetName = book.getSheetName(newIndex);
            BookHelper.notifyDeleteSheet(ref, new Object[] {delSheetName, newSheetName});
          }
        }

View Full Code Here

Examples of org.zkoss.zss.model.Book.removeSheetAt()

      int sheetCount = book.getNumberOfSheets();
      if (sheetCount == 1)
        return -1;
      
      int index = book.getSheetIndex(spreadsheet.getSelectedSheet());
      book.removeSheetAt(index);
      sheetCount = book.getNumberOfSheets();
      
      if (index < sheetCount) {
        //shift right
        return index;

View Full Code Here

0 1 2

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.