Petl

Features

- 615 - Add improved support for working with Google Sheets (404 and 405)

Maintainability

- 614 - Improve test helpers testing

Fixes
- 575 - Fix iterrowslice() to conform with PEP 479
- 392 - Fix sortheader() to not overwrite data for duplicate column names
- 385 - Fix sorting of rows with different length

Maintainability
- 606 - Cleanup and unclutter old and unused files in repository
- 609 - Add tohtml with css styles test case
- 483 - Add NotImplementedError to IterContainer's `__iter__`

Usability
- 530 Add casting of headers to strings in toxlsx and appendxlsx

Maintainability

- Creating this release to sync package repositories PyPI and Conda-Forge
- No functional changes in petl library
- Added new PR template on 594

Fixes

- 579 - convertall does not work when table header has non-string elements
- 578 - petl todataframe() multiply run lambda function in addfield
- 552 - Aggregate is broken when supplying single key in an array

Maintainability

- 584 - Migrated to pytest
- 591 - Testing python 3.10 on Github Actions
- 585 - codacity: upgrade to latest/main github action version
- 593 - cd: publish releases to PyPI with GA

Changes

- Added Decimal to numeric types 573
- Add support for ignore_workbook_corruption parameter in xls 571
- Add support for generators in the petl.fromdicts 569
- Add function to support fromdb, todb, appenddb via clickhouse_driver 566

Fixes

- `fromdicts` header does not raise 555

Caveats

- Publishing to PyPI, conda-forge and petl.readthedocs.org currently broken.

Changes

- Use python 3.6 instead of 2.7 for deploy on travis-ci. No python changes.
- Skip doctest with python3.9 for now