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.

Argument Reference for the spreadsheetAddAutoFilter function

spreadsheetObj

Required: Yes
Excel spreadsheet object

autofilter

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