Jasperreport export to xlsx

0

Hi all,

Just want to ask if there any way to exclude the last page footer in the filter list in excel? For example, when we want to filter a column, I would not like to have the page footer in the options so that it won't be filtered. 

nevaran97's picture
Joined: Jul 31 2019 - 8:40pm
Last seen: 2 weeks 4 days ago

4 Answers:

-1

Hi, 

just take a look here... https://community.jaspersoft.com/wiki/how-can-i-suppress-page-headers-and-footers-when-exporting-xls

there is described, how to exclude some bands for xls(x) exporting

hth + regards

C-Box

C-Box's picture
2296
Joined: Jul 19 2006 - 5:58pm
Last seen: 1 month 1 week ago
-1

To exclude header and footer for xls and xlsx use these property shown on desc:

https://community.jaspersoft.com/wiki/how-can-i-suppress-page-headers-and-footers-when-exporting-xls

just change from xls to xlsx in property name if you need xlsx report or for xls just use same property

it will work...

imrohithsnair's picture
Joined: Jan 30 2019 - 11:45pm
Last seen: 1 month 1 week ago
-1

Guys, I'm not looking for excluding the page footer when export to xlsx format but looking for excluding the band from being filtered when i am performing a filter in excel. This is because in excel when we are going to filter a column, the field of the page footer will be show in the list and it will be filtered if it is not checked which means after filter it will not be shown at the bottom which is the scenario I not looking for.

nevaran97's picture
Joined: Jul 31 2019 - 8:40pm
Last seen: 2 weeks 4 days ago
0

To exclude the cells from your AutoFilter one possible way is indeed to exclude the whole band ... you just asked us, if such a way is possible!??!!? Anyway...

..so perhaps you could try to ignore the "stupid" AutoFilter Feature of excel but use an own filter of the correct row range (so except the last row) . 

Where should excel know if the last row should be excluded?

You could try to set a SubTotal-formula to your sum field as additinal xls export properties in page footer and look, if this is being passed correctly to excel. As far as I know the SubTotals formula is excluded by the AutoFilter (see here: https://www.extendoffice.com/documents/excel/4055-excel-filter-exclude-bottom-row.html)

hth + regards

C-Box

C-Box's picture
2296
Joined: Jul 19 2006 - 5:58pm
Last seen: 1 month 1 week ago
Feedback
randomness