title: Jasper Reports Excel Output Problems
body: <p>I am new to Jasper Reports and iReports that I am using to design the reports. 
  I am currently designing a report in iReport and want to export it in excel (xls). Here is the screen shot of what I want to design and the second screen is what I am getting. </p>
  
  <p><a href="https://i.stack.imgur.com/aW4DO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aW4DO.png" alt="Image Hosted by ImageShack.us"></a>
  <br/>Shot at 2012-08-04</p>
  
  <p>Here is what I have managed to get. As you can see there are many problems in the output.</p>
  
  <ul>
  <li>Column A is missing</li>
  <li>There are some problems with column D and E and Column C is also invisible. </li>
  <li>I dont know how to add blank rows in my design from IReports </li>
  </ul>
  
  <p><a href="https://i.stack.imgur.com/MeiFl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MeiFl.png" alt="Image Hosted by ImageShack.us"></a>
  <br/>Shot at 2012-08-04</p>
  
  <p>Here is the source to what I have done so far:</p>
  
  <pre><code>    &lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;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="report1" language="groovy" pageWidth="792" pageHeight="612" orientation="Landscape" columnWidth="792" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="1e5ee76a-b072-4f31-a1ce-d0c921d2ce55"&gt;
      &lt;property name="ireport.zoom" value="1.0"/&gt;
      &lt;property name="ireport.x" value="0"/&gt;
      &lt;property name="ireport.y" value="0"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/&gt;
      &lt;property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/&gt;
      &lt;background&gt;
          &lt;band splitType="Stretch"/&gt;
      &lt;/background&gt;
      &lt;title&gt;
          &lt;band height="21" splitType="Stretch"&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="557d6e9d-b389-4710-a66f-f15678ebb003" x="1" y="1" width="119" height="20"/&gt;
                  &lt;textElement&gt;
                      &lt;font size="14" isBold="true"/&gt;
                  &lt;/textElement&gt;
                  &lt;text&gt;&lt;![CDATA[Sample Heading]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
          &lt;/band&gt;
      &lt;/title&gt;
      &lt;pageHeader&gt;
          &lt;band height="71" splitType="Stretch"&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="3d8bfb44-a4ce-409f-a626-4bdba125b0a4" x="0" y="11" width="100" height="20"/&gt;
                  &lt;textElement verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Start Date]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="ee347fa8-037a-4fe1-8de2-98867d4903a3" x="0" y="31" width="100" height="20"/&gt;
                  &lt;textElement verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Start Date]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="beaa366e-2976-4b46-86ee-55af14249675" x="0" y="51" width="100" height="20"/&gt;
                  &lt;textElement verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Start Date]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;textField pattern="dd-MMM-yy"&gt;
                  &lt;reportElement uuid="4f4124a7-5071-4ced-ba92-c39c6f6ffc54" x="100" y="11" width="100" height="20"/&gt;
                  &lt;textElement verticalAlignment="Middle"/&gt;
                  &lt;textFieldExpression&gt;&lt;![CDATA[new java.util.Date()]]&gt;&lt;/textFieldExpression&gt;
              &lt;/textField&gt;
              &lt;textField pattern="dd-MMM-yy"&gt;
                  &lt;reportElement uuid="9492ff27-6c11-417f-8ae9-43dddfcda405" x="100" y="31" width="100" height="20"/&gt;
                  &lt;textElement verticalAlignment="Middle"/&gt;
                  &lt;textFieldExpression&gt;&lt;![CDATA[new java.util.Date()]]&gt;&lt;/textFieldExpression&gt;
              &lt;/textField&gt;
              &lt;textField pattern="dd-MMM-yy"&gt;
                  &lt;reportElement uuid="b8baea82-84c4-42fa-bccd-62abc96eeded" x="100" y="51" width="100" height="20"/&gt;
                  &lt;textElement verticalAlignment="Middle"/&gt;
                  &lt;textFieldExpression&gt;&lt;![CDATA[new java.util.Date()]]&gt;&lt;/textFieldExpression&gt;
              &lt;/textField&gt;
          &lt;/band&gt;
      &lt;/pageHeader&gt;
      &lt;columnHeader&gt;
          &lt;band height="69" splitType="Stretch"&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="1c5d41a5-a86b-4cd0-bac8-19950c3eb5b3" x="0" y="49" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                      &lt;font size="12" isBold="true"/&gt;
                  &lt;/textElement&gt;
                  &lt;text&gt;&lt;![CDATA[Heading]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="6d798309-0e10-4c11-8642-53edd66f8ed0" x="100" y="49" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                      &lt;font size="12" isBold="true"/&gt;
                  &lt;/textElement&gt;
                  &lt;text&gt;&lt;![CDATA[Heading]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="7ca5ae53-47e2-46f9-90c6-2d8f5d66dc5e" x="200" y="49" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                      &lt;font size="12" isBold="true"/&gt;
                  &lt;/textElement&gt;
                  &lt;text&gt;&lt;![CDATA[Heading]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="bae9670f-10fa-4932-9e1b-00c8e38cd009" x="300" y="49" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                      &lt;font size="12" isBold="true"/&gt;
                  &lt;/textElement&gt;
                  &lt;text&gt;&lt;![CDATA[Heading]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="bcf09004-a0ca-479f-9d6d-fe2aab932452" x="400" y="49" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                      &lt;font size="12" isBold="true"/&gt;
                  &lt;/textElement&gt;
                  &lt;text&gt;&lt;![CDATA[Heading]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
          &lt;/band&gt;
      &lt;/columnHeader&gt;
      &lt;detail&gt;
          &lt;band height="151" splitType="Stretch"&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="418012e1-fbc2-4cb9-bf7f-2740061bbfd1" x="1" y="0" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="9b6a2c68-6327-4a8a-940f-41f5be8bc7ca" x="100" y="0" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="7e7ddc5f-31e7-4b76-bbd7-a6f0a2c11169" x="200" y="0" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="5f8c4ae6-d2c0-4ded-9e3e-8f1a69995043" x="300" y="0" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="f8f51e3b-5dcc-43f0-9f56-00a1bc703ad1" x="400" y="0" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="418012e1-fbc2-4cb9-bf7f-2740061bbfd1" x="0" y="20" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="418012e1-fbc2-4cb9-bf7f-2740061bbfd1" x="100" y="20" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="418012e1-fbc2-4cb9-bf7f-2740061bbfd1" x="200" y="20" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="418012e1-fbc2-4cb9-bf7f-2740061bbfd1" x="300" y="20" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="418012e1-fbc2-4cb9-bf7f-2740061bbfd1" x="400" y="20" width="100" height="20"/&gt;
                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"/&gt;
                  &lt;text&gt;&lt;![CDATA[Data]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
          &lt;/band&gt;
      &lt;/detail&gt;
      &lt;columnFooter&gt;
          &lt;band height="45" splitType="Stretch"/&gt;
      &lt;/columnFooter&gt;
      &lt;pageFooter&gt;
          &lt;band height="54" splitType="Stretch"/&gt;
      &lt;/pageFooter&gt;
      &lt;summary&gt;
          &lt;band height="42" splitType="Stretch"/&gt;
      &lt;/summary&gt;
  &lt;/jasperReport&gt;
  </code></pre>
  
  <p>Any help in this matter would be appreciated alot. Thanks a bunch!! </p>