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

Class org.apache.poi.ss.usermodel.Workbook

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

org.apache.poi.ss.usermodel.Workbook.removeSheetAt()
Removes sheet at the given index @param index of the sheet to remove (0-based)

        // clone sheet corrupts it
        Sheet sheet = wb.cloneSheet(0);
        writeTemp53691(wb, "bbad");


        // removing the sheet makes it good again
        wb.removeSheetAt(wb.getSheetIndex(sheet));
        writeTemp53691(wb, "cgood");
        
        // cloning again and removing the conditional formatting makes it good again
        sheet = wb.cloneSheet(0);
        removeConditionalFormatting(sheet);

View Full Code Here

  }
  
  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

  }
  
  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

  }


  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

  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

  
    @Test
  public void bug47090a() {
      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

  
    @Test
  public void bug47090b() {
      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


    @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

  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


        // demonstrate adding/naming and deleting a sheet
        // create a sheet, set its title then delete it
        s = wb.createSheet();
        wb.setSheetName(1, "DeletedSheet");
        wb.removeSheetAt(1);
        //end deleted sheet


        // write the workbook to the output stream
        // close our file (don't blow out our file handles)
        wb.write(out);

View Full Code Here

0 1

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.