spreadsheetAddAutoFilter

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
Required

Excel spreadsheet object

autofilter
Required

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