java 엑셀파일 다운 코딩

SeoHW 2019. 8. 9. 11:35

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";