why it is have no lines

[1021866588]

configuration.setShowGridLines(Boolean.TRUE);configuration.setSheetTabColor(Color.red);configuration.setOnePagePerSheet(Boolean.FALSE);configuration.setRemoveEmptySpaceBetweenColumns(Boolean.TRUE);[/code]

 

[hozawa]

Do you have grid lines in your jrxml text elements? The property just shows grid lines when there is one in the report layout.

[szaharia]

By default, generated sheets come with whitePageBackground property set to true, which will make sheet's content to appear as drawn on a white page. To  avoid this behavior you need to use the following setting:

configuration.setWhitePageBackground(Boolean.FALSE);[/code]

Another way would be to set the following property in your JRXML file, if available:

<property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>[/code]

I hope this helps,

Sanda