Remove first empty column in Excel Export

[rapthor]

Hello,

I am exporting a JasperPrint to Excel inside my Java application. The file always contains an empty first column and an empty narrow column after the last data column (like a margin to the left and right of my actual data).

How do I remove these blank column automatically?

I attached the code that exports my report to Excel.

Code:

          ByteArrayOutputStream baos = new ByteArrayOutputStream();               JRXlsExporter exporterXLS = new JRXlsExporter();        exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, print);        exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, baos);        exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,                Boolean.FALSE);        exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE,                Boolean.FALSE);        exporterXLS.setParameter(                JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);        exporterXLS.setParameter(                JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,                Boolean.TRUE);        exporterXLS.setParameter(                JRXlsExporterParameter.IS_IGNORE_GRAPHICS,                Boolean.TRUE);               exporterXLS.setParameter(                JRXlsExporterParameter.IS_IGNORE_CELL_BORDER,                Boolean.TRUE);               exporterXLS.setParameter(                JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,                Boolean.TRUE);        exporterXLS.setParameter(                JRXlsExporterParameter.SHEET_NAMES,                sheetNames);               exporterXLS.exportReport();        return baos.toByteArray();

[Teodor Danciu]

Hi,

 

Try the IGNORE_PAGE_MARGINS exporter parameter.

 

I hope this helps.
Teodor