[how to create a multi worksheet excel jasper repor]

 

Hello I modified the XML file in iReport of my report, I add the property net.sf.jasperreports.export.xls.one.page.per.sheet and I set it to true like this 

<?xml version="1.0" encoding="UTF-8"?>

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report2" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="83797c14-49fe-467a-97ad-c4f02395acf3">

<property name="ireport.zoom" value="1.0"/>

<property name="ireport.x" value="0"/>

<property name="ireport.y" value="22"/>

 <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/>

<style name="Title" fontName="Times New Roman" fontSize="50" isBold="true" pdfFontName="Times-Bold"/>

<style name="SubTitle" forecolor="#736343" fontName="Arial" fontSize="18"/>

<style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/>

<style name="Detail" fontName="Arial" fontSize="12"/>

<style name="Row" mode="Transparent">

And when I test it in my JSF proyect it works.