CODEWITHSUNDEEP
jasper-reportsexport-to-excel
uGONNA die
uGONNA die

Reputation: 11

How to remove background cells from the excel report generated through jasper reports

I'm trying to generate an excel report using the jasper studio, the data is getting populated correctly but the empty rows and columns are also coming in the excel report. I want something like this desired output

this is what I'm getting presently, the background cells should be removed from entire report

This is what I'm getting this is what I'm getting

I have tried a bunch of different properties but the expected thing was not achieved by them. Any help is appreciated

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Blank_A4" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1a1e3695-aaf3-47eb-b517-747f98005114">
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/>
    <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/>
    <property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/>
    <property name="detectCellType" value="true"/>
    <property name="onePagePerSheet" value="false"/>
    <property name="whitePageBackground" value="false"/>
    <property name="ignoreGraphics" value="false"/>
    <property name="collapseRowSpan" value="true"/>
    <property name="ignoreCellBorder" value="true"/>

Upvotes: 1

Views: 1187

Answers (1)

Gustavo
Gustavo

Reputation: 1418

Set this property to false: net.sf.jasperreports.export.xls.white.page.background

as well as this net.sf.jasperreports.export.xls.show.gridlines

Upvotes: 1

Related Questions