반응형

JAVA -

List<Map<String, Object>> excelList = new ArrayList<Map<String,Object>>();

excelList = testService.selectList(testVo);

 

List<Object> titleList = new ArrayList<Object>();

 

titleList.add("순위" );

titleList.add("순위2" );

titleList.add("순위3" );

titleList.add("순위4" );

titleList.add("순위5" );

titleList.add("순위6" );

titleList.add("순위7" );

 

List<Object> dataList = new ArrayList<Object>();

 

for(int i = 0; excelList .size(); i++;)

{

    List<Object> subList = new ArrayList<Object>();' 

    subList .add(excelList.get(i).get("rank1") == null ? "" :  subList .add(excelList.get(i).get("rank1"));

    subList .add(excelList.get(i).get("rank2") == null ? "" :  subList .add(excelList.get(i).get("rank2"));

    subList .add(excelList.get(i).get("rank3") == null ? "" :  subList .add(excelList.get(i).get("rank3"));

    subList .add(excelList.get(i).get("rank4") == null ? "" :  subList .add(excelList.get(i).get("rank4"));

    subList .add(excelList.get(i).get("rank5") == null ? "" :  subList .add(excelList.get(i).get("rank5"));

    subList .add(excelList.get(i).get("rank6") == null ? "" :  subList .add(excelList.get(i).get("rank6"));

    subList .add(excelList.get(i).get("rank7") == null ? "" :  subList .add(excelList.get(i).get("rank7"));

 

    dataList .add(subList);

}

 

model.put("titleList ",titleList )

model.put("list",dataList)

model.put("name","rank")

model.put("sheetName","순위")

return "excelView";

 

반응형

+ Recent posts