List of cloneSheet() Examples

Examples of cloneSheet()

loxia.support.excel.definition.ExcelSheet.cloneSheet()
org.apache.poi.hssf.usermodel.HSSFWorkbook.cloneSheet()
create an HSSFSheet from an existing sheet in the HSSFWorkbook. @return HSSFSheet representing the cloned sheet.
org.apache.poi.ss.usermodel.Workbook.cloneSheet()
Create an Sheet from an existing sheet in the Workbook. @return Sheet representing the cloned sheet.

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

      Sheet sheet = wb.getSheetAt(0);
      sheet.shiftRows(2, sheet.getLastRowNum(), 1, true, false);
      Row newRow = sheet.getRow(2);
      if (newRow == null) newRow = sheet.createRow(2);
      newRow.createCell(0).setCellValue(" Another Header");
      wb.cloneSheet(0);


      assertSheetOrder(wb, "Sheet1", "Sheet1 (2)");


      //        FileOutputStream fileOut = new FileOutputStream("/tmp/bug48495.xlsx");
//        try {

View Full Code Here

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

  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.cloneSheet()


    @Test
    public void bug46250(){
        Workbook wb = openSample("46250.xls");
        Sheet sh = wb.getSheet("Template");
        Sheet cSh = wb.cloneSheet(wb.getSheetIndex(sh));


        HSSFPatriarch patriarch = (HSSFPatriarch) cSh.createDrawingPatriarch();
        HSSFTextbox tb = (HSSFTextbox) patriarch.getChildren().get(2);


        tb.setString(new HSSFRichTextString("POI test"));

View Full Code Here

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

      Sheet sheet = wb.getSheetAt(0);
      sheet.shiftRows(2, sheet.getLastRowNum(), 1, true, false);
      Row newRow = sheet.getRow(2);
      if (newRow == null) newRow = sheet.createRow(2);
      newRow.createCell(0).setCellValue(" Another Header");
      wb.cloneSheet(0);


      assertSheetOrder(wb, "Sheet1", "Sheet1 (2)");


      //        FileOutputStream fileOut = new FileOutputStream("/tmp/bug48495.xlsx");
//        try {

View Full Code Here

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

  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.cloneSheet()

      Sheet sheet = wb.getSheetAt(0);
      sheet.shiftRows(2, sheet.getLastRowNum(), 1, true, false);
      Row newRow = sheet.getRow(2);
      if (newRow == null) newRow = sheet.createRow(2);
      newRow.createCell(0).setCellValue(" Another Header");
      wb.cloneSheet(0);


      assertSheetOrder(wb, "Sheet1", "Sheet1 (2)");


      //        FileOutputStream fileOut = new FileOutputStream("/tmp/bug48495.xlsx");
//        try {

View Full Code Here

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

  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.cloneSheet()


    @Test
    public void bug46250(){
        Workbook wb = openSample("46250.xls");
        Sheet sh = wb.getSheet("Template");
        Sheet cSh = wb.cloneSheet(wb.getSheetIndex(sh));


        HSSFPatriarch patriarch = (HSSFPatriarch) cSh.createDrawingPatriarch();
        HSSFTextbox tb = (HSSFTextbox) patriarch.getChildren().get(2);


        tb.setString(new HSSFRichTextString("POI test"));

View Full Code Here

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

      Sheet sheet = wb.getSheetAt(0);
      sheet.shiftRows(2, sheet.getLastRowNum(), 1, true, false);
      Row newRow = sheet.getRow(2);
      if (newRow == null) newRow = sheet.createRow(2);
      newRow.createCell(0).setCellValue(" Another Header");
      wb.cloneSheet(0);


      assertSheetOrder(wb, "Sheet1", "Sheet1 (2)");


      //        FileOutputStream fileOut = new FileOutputStream("/tmp/bug48495.xlsx");
//        try {

View Full Code Here

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

  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

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.