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.

spreadsheetAddAutoFilter Argument Reference

spreadsheetObj any

Excel spreadsheet object

autofilter string

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