Removing default lines(background) in excel

[bibinjacob]

Hi,

When i try to export the report(crosstab data) to excel,i get lines(default lines) in back ground as shown in the attached xls(right side and below the data) eventhough iam setting JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND as true.Any idea how to remove the default lines.Please see the attachment.

Code i used:

JExcelApiExporter exporter = new JExcelApiExporter();

exporter.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint);

exporter.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM, xlsReport);

exporter.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);

exporter.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.TRUE);

exporter.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE,Boolean.TRUE);

exporter.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

exporter.setParameter(JExcelApiExporterParameter.IS_FONT_SIZE_FIX_ENABLED,Boolean.TRUE);

exporter.exportReport();

 

regards

bibin jacob

[file name=a.xls size=22528]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/a.xls[/file]

Post edited by: bibinjacob, at: 2007/05/02 05:02

[rafa.ferreira]

Hy brow!!

 

Sorry about my mediu English..

 

But you have to eliminate on iReport the spaces between your cells.

 

If you have, for example in your title, have a small line between your title-cell and your top border, the jasper is going to put a cell in THAT place.

 

So for this example put your title-cell with TOP = 0 and left = 0 position.

 

To export to xls is a pain in the balls =P

 

You are going to spend allot of time reorganizing.

 

Any doubt email-me

 

rafa.ferreira@gmail.com

 

[]'s

Rafa