java - How to migration JXLS from version 1 to 2 -

jxls 2 not backward compatible version 1. there no upgrade instructions , while can things working version 2 i'm having 2 issues.

• version 1 did not require use of comment tags, cant output generate without them.

• java code must specify worksheet location write results, in version 1, output written on top of template did not require duplication of template settings in excel , java code.

if cannot find workaround these 2 issues, i'll have go change every single template use comments. worse, i'll have make java code aware of template worksheet layout. dont understand why default behavior. there way version 2 behave more version 1?

version 1 did not require use of comment tags, cant output generate without them.

this not true. can choose not use xlscommentareabuilder. in case have 3 options

1. use xmlareabuilder (probably not way want)

2. use java api build commands (probably not way want)

3. create own jxls1tagcommandareabuilder build commands jxls-1 tag notation (and contribute jxls core)

the 3 option best because able use jxls-1 templates jxls-2 without changes. sure not trivial should possible.

java code must specify worksheet location write results, in version 1, output written on top of template did not require duplication of template settings in excel , java code.

to jxls-1 behaviour here can this

        (area xlsarea : xlsarealist) {             xlsarea.applyat(                      new cellref(xlsarea.getstartcellref().getcellname()), context);         } 

so apply area @ starting cell.

if wish default behavior can raise improvement in jxls issue tracker