+ //計算式中の文字列(名前付き範囲)置換
+ private static String replaceFormula(String formula, String target, String replacement) {
+ formula = "<" + formula + ">";
+ replacement = Matcher.quoteReplacement(replacement);
+ formula = formula.replaceAll("([^A-Za-z0-9_])" + target + "([^A-Za-z0-9_])", "$1" + replacement + "$2");
+ formula = formula.replaceAll("^<", "");
+ formula = formula.replaceAll(">$", "");
+ return formula;
+ }
+
+ //計算式中の 文字列(名前付き範囲)→セル座標 置換
+ private static String replaceFormula(String formula, String target, int cellRow, int cellCol) {
+ return replaceFormula(formula, target, new CellReference(cellRow, cellCol).formatAsString());
+ }
+
+