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

Argument Reference

spreadsheetObj any
Required

Excel spreadsheet object

autofilter string
Required

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

Examples
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