PhpSpreadsheet
PhpSpreadsheet copied to clipboard
Table Xlsx Reader and Autofilter
This is:
- [ ] a bugfix
- [x] a new feature
- [x] refactoring
- [x] additional unit tests
Checklist:
- [x] Changes are covered by unit tests
- [x] Changes are covered by existing unit tests
- [x] New unit tests have been added
- [x] Code style is respected
- [x] Commit message explains why the change is made (see https://github.com/erlang/otp/wiki/Writing-good-commit-messages)
- [ ] CHANGELOG.md contains a short summary of the change
- [ ] Documentation is updated as necessary
Why this change is needed?
Implement Table when an XLSX spreadsheet is loaded
In this Commit:
- Added Table Xlsx reader.
- Covered with unit tests.
- [new] Autofilter inside Tables
To be done:
- ~Take action on failed AutoFilter's Filter expressions test (testLoadOffice365AutoFilter).~
- ~Plan Table Filter expressions.~
@MarkBaker
I have just added a reference to the worksheet autofilter inside the table. That enables a complete autofilter support to tables. Please share your thought on this.
@MarkBaker
Any update on this
Sorry that it's taken me so long to get round to assessing this PR, but providing that support for pivot tables is an incredibly useful feature. Thank you for working on this