Drop fileDownloadActionListener tag on button , set content type to application/vnd.ms-excel and bind it to bean method.
In Bean code get desired rows append attribute value with '\t' for next cell and '\n' next line for next row in excel
private static final String LINEBREAK = "\n";
private static final String NEXTCELL = "\t";
public void exportToExcel(FacesContext facesContext, OutputStream outputStream) throws IOException {
DCBindingContainer dc = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
DCIteratorBinding binding = dc.findIteratorBinding("EmployeesVO1Iterator");
ViewObject vo = binding.getViewObject();
StringBuilder sb = new StringBuilder();
sb.append("First Name").append(NEXTCELL).append("last Name").append(NEXTCELL).append("Email").append(LINEBREAK);
vo.setCurrentRow(vo.first());
Row current = vo.getCurrentRow();
while (current != null) {
String firstName = (String)current.getAttribute("FirstName");
String lastName = (String)current.getAttribute("LastName");
String email = (String)current.getAttribute("Email");
sb.append(firstName).append(NEXTCELL).append(lastName).append(NEXTCELL).append(email).append(NEXTCELL).append(LINEBREAK);
current = vo.next();
}
outputStream.write(sb.toString().getBytes());
outputStream.flush();
}
Output
Employees table will show only 3 rows
Click on export results button will export data into excel ,below is result
Happy Learning !!
