Add full support for filters

[kevmo314]

#68 adds basic support for filters on the entire worksheet, however it would be nice to have full support for the <autoFilters> tag to allow for more complex filtering options as defined in the open office spec. Likely the binary auto_filters is still desirable to keep entire worksheet filtering simple, so this should be backwards-compatible.

[Vinci08]

Can you please show me how to use the filter from #68 ? I try to add auto_filter = True to new_sheet, then ws.auto_filter = True. Both cases returns AttributeError.

[kevmo314]

It should be auto_filters, not auto_filter.

[Vinci08]

Thanks @kevmo314 . I ended up using PyExcelerate for writing, and win32com Excel for formatting the whole table. Really love PyExcelerate since its writing time is much better than openpyxl!

[kevmo314]

Ah I actually misspoke, it should be auto_filter, however we haven't pushed that code out yet. I guess we should do that since it's been a while. Glad you're finding PyExcelerate useful :)