Two Laptop Bag*
The moose likes Other Java Products and Servers and the fly likes Jasper Reports Export to Excel not starting on column A Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Java Products and Servers
Bookmark "Jasper Reports Export to Excel not starting on column A" Watch "Jasper Reports Export to Excel not starting on column A" New topic
Author

Jasper Reports Export to Excel not starting on column A

Niknak Cooper
Greenhorn

Joined: Mar 05, 2010
Posts: 2
Hi,

I am successfully using Jasper Reports, but for one major show stopper! The export reports to excel is giving me issues,
as the report starts in column B and not A

I am wondering if it is possible in jasper report to export to xls with the resulting data starting in column A and not B.
I have tried setting different JRXlsExporterParameter's but with no luck.

My code:



example

| A | B | C | D |
------------------------------------------------------------------------
| 1 | 2009/01 | true |
| 2 | 2009/02 | false |

I would like to know if anyone is getting the excel export in column A. I have a feeling this is just how Jasper Reports is.

If your exports arrive in colum b please state too.

Many thanks for any help!
Niknak Cooper
Greenhorn

Joined: Mar 05, 2010
Posts: 2
Fixed.

I just added



IGNORE_PAGE_MARGINS seems to do nothing.
Srinivasan Elangovan
Greenhorn

Joined: Apr 11, 2012
Posts: 3

RESOLVED.

To solve this issue you need to format your page width and height to be short remove page margins.

For old Jasper tool(1.2.7)

EDIT --> Remove Margins.

For New Jasper tool (3.5.7)

Format --> remove Report Margin.

By doing like this you can remove the blank empty first column.

 
jQuery in Action, 2nd edition
 
subject: Jasper Reports Export to Excel not starting on column A