kz26 / PyExcelerate

Accelerated Excel XLSX Writing Library for Python 2/3

https://pypi.org/project/PyExcelerate/

BSD 2-Clause "Simplified" License

530 stars 60 forks source link

Add full support for filters #69

Open kevmo314 opened 6 years ago

kevmo314 commented 6 years ago

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 commented 5 years ago

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 commented 5 years ago

It should be auto_filters, not auto_filter.

Vinci08 commented 5 years ago

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 commented 5 years ago

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 :)