안녕하세요 그레이프시티입니다.
setDataSource() 메소드 안에 {key : value} 형태로 곧바로 넣지 마시고, JsonDataSource 객체를 이용하여 넣어 보시기 바랍니다.
아래는 간단 예제입니다.
workbook.open("C:\\...\\template_sample.ssjson");
IWorksheet worksheet = workbook.getWorksheets().get(0);
String dataJson = "{"
+ " \"date\":\"2021-01-12\", "
+ " \"name\":\"Lucas\","
+ " \"product\":["
+ " {\"code\":\"SJS15DM\", \"name\":\"SpreadJS 15 Developer License with Maintenance - New License\", \"quantity\": 1, \"amount\": 1999000, \"netprice\": 1999000, \"vat\": 199900, \"sum\": 2198900},"
+ " {\"code\":\"SJS15DM01\", \"name\":\"SpreadJS 15 Distribution License with Maintenance - New License\", \"quantity\": 2, \"amount\": 2332000, \"netprice\": 4664000, \"vat\": 466400, \"sum\": 5130400},"
+ " {\"code\":\"SJS15DCM\", \"name\":\"SpreadJS 15 Designer Component with Maintenance - New License\", \"quantity\": 1, \"amount\": 5833000, \"netprice\": 5833000, \"vat\": 583300, \"sum\": 6416300},"
+ " {\"code\":\"GEJ5PM\", \"name\":\"GcExcel Java 5 Project License with Maintenance - New License\", \"quantity\": 1, \"amount\": 1500000, \"netprice\": 1500000, \"vat\": 150000, \"sum\": 1650000}"
+ " ]"
+ "}";
worksheet.setDataSource(
new JsonDataSource(dataJson)
);
workbook.save("C:\\...\\template.pdf");
감사합니다.