Sheet foodComposithonSheet = outputWorkbook.cloneSheet(0);
outputWorkbook.setSheetName(18, "成分表");
outputWorkbook.setSheetOrder("成分表", 0);
- //Sheet foodComposithonSheet = outputWorkbook.createSheet("成分表");
//「成分識別子」行
Row idRow = foodComposithonSheet.getRow(10);
} //CELL
+
+
//食品群(1~18)書き込み
compRow.createCell(62).setCellValue(group);
-
//緑黄色野菜か?
- if(brightColoredVegetablesXmlFileName.length() > 0) {
- boolean isBrightColored = false;
+ boolean isBrightColored = false;
+ if(group == 6 && brightColoredVegetablesXmlFileName.length() > 0) {
String foodName = thisRow.getCell(3).getStringCellValue();
for(String aBright : this.brightColoredVegetableList) {
- if(foodName.matches(aBright + ".*")) {
+ if(foodName.matches(".*" + aBright + ".*")) {
isBrightColored = true;
break;
}