Hi guys,
I created a simple list and after i wanted to export it to excel i faced this exception
18:30:48,238 FATAL [application] org.jboss.seam.excel.ExcelWorkbookException: A worksheet's value must be an Iterable, DataModel or Query javax.faces.el.EvaluationException: org.jboss.seam.excel.ExcelWorkbookException: A worksheet's value must be an Iterable, DataModel or Query
Code
public List<Movie> movies;
public String doSearch() {
FullTextQuery query;
try {
query = searchQuery(searchQuery);
movies = query.getResultList();
} catch (ParseException pe) {
return null;
}
//System.out.println(query.getResultSize());
return null;
}
.xhtml
<h:form id="excelExportMovie">
<rich:dataTable id="movieTable">
..
</rich:dataTeble>
<h:commandLink action="#{excelExporter.export('excelExportMovie:movieTable')}" >
<h:graphicImage value="/img/spreadsheet.png" />
</h:commandLink>
</h:form>
any help appreciated
Thanks in advanced