A function to add auto filters to the spreadsheet.

spreadsheetAddAutoFilter(SpreadsheetObj, autofilter) → returns void

This function requires Adobe ColdFusion 11 and up. Not supported on Lucee, OpenBD, etc.

Argument Reference for the spreadsheetAddAutoFilter function


Required: Yes
Excel spreadsheet object


Required: Yes
The Excel filter that needs to be applied to the sheet. Note that the vale should not contain spaces or invalid characters.

Fork me on GitHub