Repository navigation
v0.2.3
π₯ Add Feature List Grid Excel Writer
how to use
@Controller
public class ExcelController {
@GetMapping(value = "/member/excel/list")
public void listExcelDownload(HttpServletResponse response) {
List<List<String>> header = new ArrayList<>();
List<String> headerRow = new ArrayList<>();
headerRow.add("ν€λ1");
headerRow.add("ν€λ2");
headerRow.add("ν€λ3");
headerRow.add("ν€λ4");
header.add(headerRow);
List<List<Object>> body = new ArrayList<>();
int loopCount = 4;
for (int i=0; i<loopCount;i++) {
List<Object> bodyRow = new ArrayList<>();
bodyRow.add((i+1) + "-λ°λ1");
bodyRow.add((i+1) + "-λ°λ2");
bodyRow.add((i+1) + "-λ°λ3");
bodyRow.add((i+1) + "-λ°λ4");
body.add(bodyRow);
}
GridExcelWriter<List<Object>> temp = new ListGridExcelWriter(header);
temp.setDataList(body);
temp.download(response, "리μ€νΈ_그리λ_μμ
_λΌμ΄ν°.xlsx");
}
}What's Changed
Full Changelog: v0.1.0...v0.2.3