CF exports to Excel and filters

Just ran across this in Ray ‘Jedi’ Camdens code for Lighthouse, something I never saw before. We use the typical HTML table export to Excel. In Ray’s export I discovered the ability to add a filter header to the export. This allows the user to quickly filter based on the data in the column. To add this, in your header row simply add the attribute filter=”all” to the td tag and bamm! So it looks like this:

<td filter="all">My Header Title </td>

DK

This entry was posted in ColdFusion, Techy. Bookmark the permalink.

One Response to CF exports to Excel and filters

  1. Patrick Whittingham says:

    cool. Same thing can be done via JavaScript on a HTML table (not Excel)