Adding Filter to Excel Column Header

[Chad Smith]

I'm currently on version 8.2, is there any new code that will turn on the column filters within Excel output without having to hard-code via the old method?

 

Old method:

<

DEFINE FILE CAR
 AUTOFILTER/A162 = '</td></tr><tr><td x:autofilter="all" x:autofilterrange="$A$2:$C$2">COUNTRY</td>'
                 | '<td class=xl100 x:autofilter="all">CAR</td>'
                 | '<td class=xl100 x:autofilter="all">MODEL' ;
END
TABLE FILE CAR
HEADING
"<AUTOFILTER "
PRINT COUNTRY AS ''
      CAR     AS ''
      MODEL   AS ''
ON TABLE PCHOLD FORMAT EXL07
END

>

[Clayton Peacock]

Hi @Chad Smith I've logged a NFR with TechSupport for this a while back- would love to see this functionality available for XLSX output. 

[Angela Hildack]

Hi Chad and Clayton - 

WebFOCUS 9.0.0 added a feature in Designer for Excel Tables that will enable sorting and filtering on the column titles of the report. This video shows both how to add it and the resulting output - but keep in mind it will only work in a WF 9.x release

 

[Clayton Peacock]

Hi @Angela Hildack thanks for sharing this is wonderful feature, we are on 9.3.0 and will definitely start using it. 

Code:

 

TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET STYLE *
TYPE=DATA, IN-XLSXTABLE='My Table', $
ENDSTYLE
END 

[David Beagan]

Thanks Angela and Clayton. This just came in very handy.

[ZELDA LOUW]

On 7/1/2024 at 1:24 PM, Clayton Peacock said:

Hi @Chad Smith I've logged a NFR with TechSupport for this a while back- would love to see this functionality available for XLSX output. 

Thanks for sharing, this is really awesome. Will definitely use this at our customer. 

[Rob Boncoddo]

This is a great feature! Does anyone know how to make it work with compound Excel files?