- Sheet mainSheet = outputWorkbook.getSheet("本表");
- int rowCount = 0;
- int lastCol = mainSheet.getRow(5).getLastCellNum();
- mainSheet.getRow(5).getCell(4).setCellValue("廃棄率");
- mainSheet.getRow(5).createCell(lastCol + 1).setCellValue("食品群");
- mainSheet.getRow(5).createCell(lastCol + 2).setCellValue("緑黄色野菜");
+ Sheet foodComposithonSheet = outputWorkbook.cloneSheet(0);
+ outputWorkbook.setSheetName(18, "成分表");
+ outputWorkbook.setSheetOrder("成分表", 0);
+ //Sheet foodComposithonSheet = outputWorkbook.createSheet("成分表");
+
+ //「成分識別子」行
+ Row idRow = foodComposithonSheet.getRow(10);
+ for(int i = 4; i <= 61; i++) {
+ Cell idCell = idRow.getCell(i);
+ idCell.setCellValue(idCell.toString().replaceAll(" ", ""));
+ }
+ idRow.createCell(62).setCellValue("GROUP");
+ idRow.createCell(63).setCellValue("BRIGHT_COLORED_VEGETABLE");