JasperReport Exports to Excel and format

Export informaction to excel with formatted data, on string and numbers.

[JoseAngelesSoftware]

this is the properties you must add to the source report.

<property value="pageHeader"/>
<property value="pageFooter"/>
<property value="lastPageFooter"/>
<property value="true"/>
<property value="true"/>
<property value="false"/>
<property value="true"/>
<property value="false"/>
<property value="true"/>

[sriharshasurapaneni]

Hello Jose, nice video that talks about preserving number/text format. Do you know which property I have to set in order to preserve padding in excel exports? The padding works fine in pdf exports, but is missing from excel exports. Thanks in advance!

[sopanlavhale]

Hi Sir, I have multiple sheets and I want to hide one sheet from report. Can you please guide me here? how to hide sub-report.

[ainigma]

Can we create different excel sheets using jasper report and spring boot? Assume that we have an excel with 2 sheets. Can we use jasper to populate 1 sheet with one query and another sheet with another query? Eventually, we should have 1 excel file with 2 sheets

[RohitMamidwar-mxet]

can we give excel sheet tab name dynamically

[bhanusudheer]

Form which format you created sir, its really good when Iam creating i am only able to select 4 to 5 columns

[savithak]

In excel after downloading I'm not able to do filter can anyone help me on this??

[savithak]

In Excel after downloading from jasper I'm not able to do date filter can anybody help me on this??

[HappyYourSelf]

How to creat a file excel multiple sheet by code java jasperreport

[niketsharma]

How can I add multiple sheets in one excel using jasper report?