X-Git-Url: https://satomichan.jp/gitweb/?p=nucalgen;a=blobdiff_plain;f=src%2Fmain%2Fjava%2Fjp%2Fsatomichan%2Fnucalgen%2FNucalgen.java;fp=src%2Fmain%2Fjava%2Fjp%2Fsatomichan%2Fnucalgen%2FNucalgen.java;h=bb80aa3e9c1f0f236a804b3f28fe01af0c1e7d51;hp=f37b8b0dbebebaffa6402d8623e2246b283dc679;hb=ae346b58f26e920407f6abc8315068ffe6fb2579;hpb=7deca54cbc7880747faac12d9042666d78f5355f diff --git a/src/main/java/jp/satomichan/nucalgen/Nucalgen.java b/src/main/java/jp/satomichan/nucalgen/Nucalgen.java index f37b8b0..bb80aa3 100644 --- a/src/main/java/jp/satomichan/nucalgen/Nucalgen.java +++ b/src/main/java/jp/satomichan/nucalgen/Nucalgen.java @@ -122,11 +122,8 @@ public class Nucalgen { } - //摂取量 名前付き範囲 + //摂取量 範囲を記憶 String intakeArea = new CellReference(3, 3, true, true).formatAsString() + ":" + new CellReference(rowIndex -1, 3, true, true).formatAsString(); - //XSSFName intakeNamedRangeArea = (XSSFName) outputWorkbook.createName(); - //intakeNamedRangeArea.setNameName("AREA_INTAKE"); - //intakeNamedRangeArea.setRefersToFormula(intakeArea); namedAreaMap.put("AREA_INTAKE", intakeArea); @@ -139,18 +136,12 @@ public class Nucalgen { Cell thisCell = sumRow.createCell(colIndex); String sumTargetArea = new CellReference(3, colIndex, true, true).formatAsString() + ":" + new CellReference(rowIndex -1, colIndex, true, true).formatAsString(); - //名前付き範囲(alias あれば設定) + //範囲を記憶(alias あれば設定) if(aColumn.getAlias().length() > 0) { - //XSSFName namedRangeArea = (XSSFName) outputWorkbook.createName(); - //namedRangeArea.setNameName("AREA_" + aColumn.getAlias()); - //namedRangeArea.setRefersToFormula(sumTargetArea); namedAreaMap.put("AREA_" + aColumn.getAlias(), sumTargetArea); if(aColumn.isUseSum()) { - //XSSFName namedRangeSum = (XSSFName) outputWorkbook.createName(); - //namedRangeSum.setNameName("SUM_" + aColumn.getAlias()); String sumArea = new CellReference(rowIndex, colIndex, true, true).formatAsString(); - //namedRangeSum.setRefersToFormula(sumArea); namedAreaMap.put("SUM_" + aColumn.getAlias(), sumArea); } }