「日本食品標準成分表2020年版（八訂）」の「2021年2月3日修正」に対応（表形式に変更があった）。

[nucalgen] / src / main / java / jp / satomichan / nucalgen / MextStdFoodCompTable.java

diff --git a/src/main/java/jp/satomichan/nucalgen/MextStdFoodCompTable.java b/src/main/java/jp/satomichan/nucalgen/MextStdFoodCompTable.java
index ec6718833c3765974ded7283ff01fe8db574502c..246f5c01bba7a8b9e34fef378c57f3ef9e34a73d 100644 (file)
--- a/src/main/java/jp/satomichan/nucalgen/MextStdFoodCompTable.java
+++ b/src/main/java/jp/satomichan/nucalgen/MextStdFoodCompTable.java
@@ -34,12 +34,11 @@ public class MextStdFoodCompTable {
 
        //変換
        void processInto(Workbook outputWorkbook) {
-               Sheet foodComposithonSheet = outputWorkbook.cloneSheet(0);
-               outputWorkbook.setSheetName(18, "成分表");
-               outputWorkbook.setSheetOrder("成分表", 0);
+               Sheet foodComposithonSheet = outputWorkbook.getSheetAt(0);
+               outputWorkbook.setSheetName(0, "成分表");
 
                //「成分識別子」行
-               Row idRow = foodComposithonSheet.getRow(10);
+               Row idRow = foodComposithonSheet.getRow(11);
                for(int i = 4; i <= 61; i++) {
                        Cell idCell = idRow.getCell(i);
                        idCell.setCellValue(idCell.toString().replaceAll(" ", ""));
@@ -47,76 +46,70 @@ public class MextStdFoodCompTable {
                idRow.createCell(62).setCellValue("GROUP");
                idRow.createCell(63).setCellValue("BRIGHT_COLORED_VEGETABLE");
 
-               int compSheetRowIndex = 11;
 
-               //18 の食品群ごとの処理
-               for(int group = 1; group <= 18; group++) {
-                       Sheet thisSheet = outputWorkbook.getSheetAt(group);
-
-                       int rowCount = 0;
-                       for (Row thisRow : thisSheet) {
-                               rowCount++;
-                               if(rowCount < 12) {continue;}
-
-                               Row compRow = foodComposithonSheet.createRow(compSheetRowIndex);
+               //セル加工
+               for(int compSheetRowIndex = 12; compSheetRowIndex <= 9999; compSheetRowIndex++) {
+                       Row compRow = foodComposithonSheet.getRow(compSheetRowIndex);
+                       if(compRow == null) {
+                               break;
+                       }
 
-                               for (int cellCount = 1; cellCount <= 61; cellCount++) {
-                                       Cell thisCell = thisRow.getCell(cellCount);
+                       int group = Integer.parseInt(compRow.getCell(1).toString()) / 1000;
 
-                                       String cellString = thisCell.toString();
+                       for (int cellCount = 1; cellCount <= 61; cellCount++) {
+                               Cell thisCell = compRow.getCell(cellCount);
 
-                                       cellString = cellString.replaceAll("\\(", "");
-                                       cellString = cellString.replaceAll("\\)", "");
-                                       cellString = cellString.replaceAll("-", "0");
-                                       cellString = cellString.replaceAll("Tr", "0");
+                               String cellString = thisCell.toString();
 
-                                       //セル値・書式 コピー
-                                       //Cell compCell = foodComposithonSheet.getRow(compSheetRowIndex).getCell(cellCount);
-                                       Cell compCell = compRow.createCell(cellCount);
-                                       compCell.setCellValue(cellString);
-                                       compCell.setCellStyle(thisCell.getCellStyle());
-                                       compCell.setCellType(thisCell.getCellTypeEnum());
+                               cellString = cellString.replaceAll("\\(", "");
+                               cellString = cellString.replaceAll("\\)", "");
+                               cellString = cellString.replaceAll("-", "0");
+                               cellString = cellString.replaceAll("Tr", "0");
 
-                                       if(cellString.matches("^[\\d\\.]+$")) {
-                                               compCell.setCellValue(Double.parseDouble(cellString));
-                                               CellStyle aCellStyle = compCell.getCellStyle();
-                                               aCellStyle.setDataFormat((short) 0);
-                                               compCell.setCellStyle(aCellStyle);
-                                       }
+                               //セル値・書式 コピー
+                               //Cell compCell = foodComposithonSheet.getRow(compSheetRowIndex).getCell(cellCount);
+                               Cell compCell = compRow.createCell(cellCount);
+                               compCell.setCellValue(cellString);
+                               compCell.setCellStyle(thisCell.getCellStyle());
+                               compCell.setCellType(thisCell.getCellTypeEnum());
 
+                               if(cellString.matches("^[\\d\\.]+$")) {
+                                       compCell.setCellValue(Double.parseDouble(cellString));
+                                       CellStyle aCellStyle = compCell.getCellStyle();
+                                       aCellStyle.setDataFormat((short) 0);
+                                       compCell.setCellStyle(aCellStyle);
+                               }
 
-                               } //CELL
 
+                       } //for cellCount
 
 
-                               //食品群（１～１８）書き込み
-                               compRow.createCell(62).setCellValue(group);
 
-                               //緑黄色野菜か？
-                               boolean isBrightColored = false;
-                               if(group == 6 && brightColoredVegetablesXmlFileName.length() > 0) {
-                                       String foodName = thisRow.getCell(3).getStringCellValue();
-                                       for(String aBright : this.brightColoredVegetableList) {
-                                               if(foodName.matches(".*" + aBright + ".*")) {
-                                                       isBrightColored = true;
-                                                       break;
-                                               }
-                                       }
+                       //食品群（１～１８）書き込み
+                       compRow.createCell(62).setCellValue(group);
 
-                                       if(isBrightColored) {
-                                               compRow.createCell(63).setCellValue(1);
+                       //緑黄色野菜か？
+                       boolean isBrightColored = false;
+                       if(group == 6 && brightColoredVegetablesXmlFileName.length() > 0) {
+                               String foodName = compRow.getCell(3).getStringCellValue();
+                               for(String aBright : this.brightColoredVegetableList) {
+                                       if(foodName.matches(".*" + aBright + ".*")) {
+                                               isBrightColored = true;
+                                               break;
                                        }
                                }
 
+                               if(isBrightColored) {
+                                       compRow.createCell(63).setCellValue(1);
+                               }
+                       }
 
-                               compSheetRowIndex++;
 
-                       } //ROW
+               } //for compSheetRowIndex
 
-               } //GROUP
 
                //元の表 削除
-               for(int i = 18; i > 0; i--) {
+               for(int i = outputWorkbook.getNumberOfSheets() - 1; i > 0; i--) {
                        outputWorkbook.removeSheetAt(i);
                }
        }