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, etc.

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.

Sample code invoking the spreadsheetAddAutoFilter function

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub