I am new to jXLS. I have a bean with java object and collections Like
public class DemographicsExcelBo {
private DemographicsReportCallOuts reportCallOuts;
private List<String> educationLevel;
private List<String> educationDistribution;
I am using the above bean in jXLS transformation with template.I have
attached my template.
If i remove ${demographics.educationDistribution} from column 'B',I am
able to get the excel with out the second list [educationDistribution],
When I add '${demographics.educationDistribution}' adjacent to
${demographics.educationDistribution}, the parser is throwing NPE.
*Stack Trace*DEBUG (net.sf.jxls.transformer.BaseRowTransformer):
----collection-property--------->demographics.educationLevel
java.lang.NullPointerException
at net.sf.jxls.util.Util.shiftColumnUp(Util.java:358)
at net.sf.jxls.util.Util.shiftUncoupledCellsUp(Util.java:336)
at net.sf.jxls.util.Util.duplicateRow(Util.java:264)
at
net.sf.jxls.controller.SheetTransformationControllerImpl.duplicateRow(SheetTransformationControllerImpl.java:140)
at
net.sf.jxls.transformer.CollectionRowTransformer.processRowCollections(CollectionRowTransformer.java:106)
at
net.sf.jxls.transformer.CollectionRowTransformer.transform(CollectionRowTransformer.java:66)
at
net.sf.jxls.transformer.SheetTransformer.transformSheet(SheetTransformer.java:88)
at
net.sf.jxls.transformer.XLSTransformer.transformWorkbook(XLSTransformer.java:248)
at
net.sf.jxls.transformer.XLSTransformer.transformXLS(XLSTransformer.java:221)
at
net.sf.jxls.transformer.XLSTransformer.transformXLS(XLSTransformer.java:201)
Can you help me to get the desired excel based on the attached excel
template.
Thanks & Regards
Debabrat Panda
<https://mail.google.com/mail/u/0/?ui=2&ik=6ca6b30a2c&view=att&th=1470e44abd5ce2db&attid=0.1&disp=safe&realattid=f_hxb2cju41&zw>
demographics_template.xlsx
Description: MS-Excel 2007 spreadsheet
------------------------------------------------------------------------------ Open source business process management suite built on Java and Eclipse Turn processes into business applications with Bonita BPM Community Edition Quickly connect people, data, and systems into organized workflows Winner of BOSSIE, CODIE, OW2 and Gartner awards http://p.sf.net/sfu/Bonitasoft
_______________________________________________ jXLS-user mailing list jXLS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jxls-user
