Hi, I am facing problem using jXLS. Can you please let me know how to POST question to the user list to get the answer.
*My jXLS Problem*
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.
I am able to get the excel with out th esecond list
[educationDistribution], if i remove ${demographics.educationDistribution}
from column 'B'.
When i add '${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
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
