import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
-public class MoeStdFoodCompTable {
+public class MextStdFoodCompTable {
private String brightColoredVegetablesXmlFileName = "";
private List<String> brightColoredVegetableList = new ArrayList<String>();
- MoeStdFoodCompTable(String brightColoredVegetablesXmlFileName_){
+ MextStdFoodCompTable(String brightColoredVegetablesXmlFileName_){
this.brightColoredVegetablesXmlFileName = brightColoredVegetablesXmlFileName_;
try {
Sheet foodComposithonSheet = outputWorkbook.cloneSheet(0);
outputWorkbook.setSheetName(18, "成分表");
outputWorkbook.setSheetOrder("成分表", 0);
- //Sheet foodComposithonSheet = outputWorkbook.createSheet("成分表");
//「成分識別子」行
Row idRow = foodComposithonSheet.getRow(10);
CommandLineParser parser = new DefaultParser();
CommandLine cmd = parser.parse(options, args);
- final String moeStdFoodCompTableFileName = cmd.getOptionValue("std-food-comp-table");
+ final String mextStdFoodCompTableFileName = cmd.getOptionValue("std-food-comp-table");
final String columnsXmlFileName = cmd.getOptionValue("columns");
final String outputXlsxFileName = cmd.getOptionValue("output");
final int lines = Integer.parseInt(cmd.getOptionValue("lines"));
NutritionColumnHolder nc = new NutritionColumnHolder(config);
//Book生成
- Workbook outputWorkbook = WorkbookFactory.create(new FileInputStream(moeStdFoodCompTableFileName));
+ Workbook outputWorkbook = WorkbookFactory.create(new FileInputStream(mextStdFoodCompTableFileName));
if(cmd.hasOption("use-processed-table") == false) {
//成分表 変換
- MoeStdFoodCompTable moe = new MoeStdFoodCompTable(cmd.getOptionValue("bright-colored-vegetables-list"));
+ MextStdFoodCompTable moe = new MextStdFoodCompTable(cmd.getOptionValue("bright-colored-vegetables-list"));
moe.processInto(outputWorkbook);
}
}
- //摂取量 名前付き範囲
+ //摂取量 名前付き範囲
String intakeArea = new CellReference(calcSheet.getSheetName(), 3, 3, true, true).formatAsString() + ":" + new CellReference(calcSheet.getSheetName(), rowIndex -1, 3, true, true).formatAsString();
XSSFName intakeNamedRangeArea = (XSSFName) outputWorkbook.createName();
intakeNamedRangeArea.setNameName("AREA_INTAKE");