As originally mentioned in #15160 , DataFrame.to_excel() should support an optional parameter that would turn Excel's AutoFilter on.
Comment From: mroeschke
Given the rejected PR in https://github.com/pandas-dev/pandas/pull/42560 this feature specifically isn't likely to be moved forward to closing