Jasper Reports Export to Excel not starting on column A

[Niknak Cooper]

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:

 	ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
	JRXlsExporter exporterXls = new JRXlsExporter ();
	exporterXls.setParameter(JRXlsExporterParameter.JASPER_PRINT, print);
	exporterXls.setParameter(JRXlsExporterParameter.IGNORE_PAGE_MARGINS, false);
	exporterXls.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, true);
	exporterXls.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, false);
	exporterXls.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, true);
	exporterXls.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, true);
	exporterXls.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, true);
	exporterXls.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, System.currentTimeMillis() + reportName + ".xls");
	exporterXls.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, byteArrayOutputStream);
	exporterXls.exportReport();								
	
                response.setContentType("application/vnd.ms-excel");
	response.setHeader("Content-Disposition", "attachment;filename=" + System.currentTimeMillis() + ".xls");
	ServletOutputStream servletOutputStream = response.getOutputStream();
	servletOutputStream.write(byteArrayOutputStream.toByteArray());
	servletOutputStream.flush();
	servletOutputStream.close();   

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]

Fixed.

I just added

 exporterXls.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, true);  

IGNORE_PAGE_MARGINS seems to do nothing.

[Srinivasan Elangovan]

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.