24,923
社区成员
发帖
与我相关
我的任务
分享
for (int i = 0; i < list.size(); i++) {
HSSFRow newRow = sheet.createRow(i + startRow);
for (int j = 0; j < 49; j++) {
HSSFCell newCell = newRow.createCell(j);
newCell.setCellStyle(firstRow.getCell(j).getCellStyle());
}
Object buff = null;
newRow.getCell(2).setCellFormula("VLOOKUP($D"+(4+i)+",別紙_班マスタ!$A$2:$B$65536,2,FALSE)");
newRow.getCell(3).setCellFormula((sheet1.getSheetName()+"!A3"));
sheet.setForceFormulaRecalculation(true);
buff=list.get(i).get("SDA_SetsubiID");
newRow.getCell(1).setCellValue(buff == null ? "" : buff.toString());