multi sheet template lose image

[poem-love]

when use multi sheet template with image ,it will lose image on every page

[SoltauFintel]

Would be nice if you could post a template and sourcecode.

jx:image ( http://jxls.sourceforge.net/reference/image_command.html ) can probably be used as a workaround.

[poem-love]

image command may be not work for image width and height had adjusted on excel like attachmennt file(not full fill in a cell).

can i use poi cloneSheet in jxls?

TEST CODE

String json = "[{\r\n" + 
                "        \"id\": \"registered_user\",\r\n" + 
                "        \"country_code\": \"JP\",\r\n" + 
                "        \"app_type\": \"ANDROID\"\r\n" + 
                "    }, {\r\n" + 
                "        \"id\": \"registered_user1\",\r\n" + 
                "        \"country_code \": \"KO \",\r\n" + 
                "        \"app_type \": \"ANDROID\"\r\n" + 
                "    }, {\r\n" + 
                "        \"id\": \"registered_user2\",\r\n" + 
                "        \"country_code\": \"US\",\r\n" + 
                "        \"app_type\": \"ANDROID\"\r\n" + 
                "    }]";
        List<Map<String, Object>> datas = null;
        System.out.println(json);
        if(json!=null && json.length()>0) {
            ObjectMapper mapper = new ObjectMapper();
            if(json.startsWith("{")) { 
                JavaType jt = mapper.getTypeFactory().constructMapType(HashMap.class, String.class, Object.class);
                Map<String, Object> aMap = mapper.readValue(json, jt);
                datas = new ArrayList<Map<String, Object>>(1);
                datas.add(aMap);
            } else {
                JavaType jt = mapper.getTypeFactory().constructCollectionType(ArrayList.class, HashMap.class);
                datas = mapper.readValue(json, jt);
            }
        }
        if(datas== null ) return;
        String templatePath ="d:/test/test.xlsx";
        String reportPath = "d:/test/report.xlsx";
        Map<String, Object> sheets = new HashMap<String, Object>();
        sheets.put("sheets", datas);
        try (InputStream is = new FileInputStream(templatePath)) {
            try (OutputStream os = new FileOutputStream(reportPath)) {
                Context context = new Context(sheets);
                JxlsHelper.getInstance().setEvaluateFormulas(true)
                    .processTemplate(is, os, context);
            }
        } 

test.xlsx

[SoltauFintel]

Because of Corona, we are currently spending significantly less time on JXLS. Therefore an answer or processing can take longer.

[SoltauFintel]

@leonate I have squashed the testcase (PR #18). But the issue is still unresolved. It's waiting for your fix. ;-)

[mcheung610]

bump - i just ran into this exact bug

[SoltauFintel]

similar to #242