configuration.setShowGridLines(Boolean.<span style="color:#660e7a;font-weight:bold;font-style:italic;">TRUE</span>); configuration.setSheetTabColor(Color.<span style="color:#660e7a;font-weight:bold;font-style:italic;">red</span>); configuration.setOnePagePerSheet(Boolean.<span style="color:#660e7a;font-weight:bold;font-style:italic;">FALSE</span>); configuration.setRemoveEmptySpaceBetweenColumns(Boolean.<span style="color:#660e7a;font-weight:bold;font-style:italic;">TRUE</span>);
2 Answers:
Posted on May 10, 2016 at 5:23am
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);
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"/>
I hope this helps,
Sanda