Jump to content

Adding Filter to Excel Column Header


Chad Smith

Recommended Posts

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

>

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...