Jump to content
Changes to the Jaspersoft community edition download ×

Removing default lines(background) in excel


bibinjacob

Recommended Posts

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

Link to comment
Share on other sites

  • 4 weeks later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...