I don’t understand Jxls error – Failed to find last cell ref attribute ‘lastCell’
use library: jxls 2.11.0 / jxls-poi 2.11.0 / apahce poi and poi-ooxml 4.1.2
Jxls warnning :
[WARN ] : lsCommentAreaBuilder : Failed to find last cell ref attribute 'lastCell' for command 'area' in cell MSSEET!A1 [WARN ] : lsCommentAreaBuilder : Failed to find last cell ref attribute 'lastCell' for command 'each' in cell MSSEET!A4
Code:
try {
InputStream is = new ClassPathResource(templatePath).getInputStream();
ClassPathResource cpr = new ClassPathResource(filePath);
try {
OutputStream os = new FileOutputStream(filePath);
Context context = new Context();
context.putVar("invoice", excelParam);
context.putVar("list", excelParam.getList());
context.putVar("file_path", filePath);
// Context context1 = PoiTransformer.createInitialContext();
// context1.putVar("invoice", excelParam);
JxlsHelper.getInstance().processTemplate(is, os, context);
os.flush();
os.close();
} catch (Exception e) {
log.error("error", e);
}
} catch (Exception e1) {
log.error("error", e1);
}
excel:
enter image description here
A1 cell memo ; jx:area(lastCell=“N4”)
A4 cell memo : jx:each(items=“list” var=“c” lastCell=“N4”)
Someone help me
I don’t understand Jxls error – Failed to find last cell ref attribute ‘lastCell’
Juno Lee is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.