List of updateSheetName() Examples

Examples of updateSheetName()

org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()
Update sheet name in all formulas and named ranges. Called from {@link XSSFWorkbook#setSheetName(int,String)}

The idea is to parse every formula and render it back to string with the updated sheet name. This is done by parsing into Ptgs, looking for ones with sheet references in them, and changing those
@param sheetIndex the 0-based index of the sheet being changed @param oldName the old sheet name @param newName the new sheet name

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()


        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()

        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        // Update references to the name
        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, oldSheetName, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()


        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()

        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        // Update references to the name
        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, oldSheetName, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()


        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()


        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()


        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()

        WorkbookUtil.validateSheetName(name);
        if (containsSheet(name, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, name);


        workbook.getSheets().getSheetArray(sheetIndex).setName(name);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()

        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        // Update references to the name
        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, oldSheetName, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName()


        if (containsSheet(sheetname, sheetIndex ))
            throw new IllegalArgumentException( "The workbook already contains a sheet of this name" );


        XSSFFormulaUtils utils = new XSSFFormulaUtils(this);
        utils.updateSheetName(sheetIndex, sheetname);


        workbook.getSheets().getSheetArray(sheetIndex).setName(sheetname);
    }


    /**

View Full Code Here

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.