v0.12.0

What's new

fastexcel 0.12.0 adds the following features:

• Support for excel tables
• A single dtype that will be used for all columns can now be specified when loading a sheet
• Sheets now have a visible attribute indicating wether they're visible, hidden or very hidden

Breaking changes

• The header_row parameter now represents the exact index of a row in a sheet. It is more explicit this way, but may break existing code relying on calamine's legacy row skipping behaviour (if empty rows were found at the beginning of the sheet)

All changes

• chore(deps): bump pretty_assertions from 1.4.0 to 1.4.1 in the prod-deps group by @dependabot in #286
• feat(ExcelSheet): added a "visible" attribute by @lukapeschke in #285
• feat(ci): publish sdist to PyPI as well by @lukapeschke in #284
• feat: table support for Excel (XLSX) sheets by @wdoppenberg in #282
• feat: introduce ExcelTable object by @lukapeschke in #287
• chore(deps): bump rstest from 0.22.0 to 0.23.0 in the prod-deps group by @dependabot in #291
• build: add license and other stuff by @PrettyWood in #290
• chore(deps): update pre-commit requirement from <4,>=2.20.0 to >=2.20.0,<5 by @dependabot in #294
• feat: mimic excel behavior to convert float to string by @PrettyWood in #292
• chore(deps): bump calamine from 0.25.0 to 0.26.0 in the prod-deps group by @dependabot in #295
• chore(deps): bump calamine from 0.26.0 to 0.26.1 in the prod-deps group by @dependabot in #296
• build(deps): bump arrow to 53.1.0 and pyo3 to 0.22.3 by @PrettyWood in #298
• build(deps): clean Cargo.toml and update lock file by @PrettyWood in #300
• feat!: header_row is now the exact index of the row when loading a sheet by @PrettyWood in #297
• feat: add support for one dtype for all columns by @PrettyWood in #299
• chore: v0.12.0 by @lukapeschke in #301

New Contributors

• @wdoppenberg made their first contribution in #282

Full Changelog: v0.11.6...v0.12.0

v0.11.6

What's Changed

• chore(deps): bump arrow from 52.1.0 to 52.2.0 in the prod-deps group by @dependabot in #272
• chore(deps): bump rstest from 0.21.0 to 0.22.0 in the prod-deps group by @dependabot in #274
• chore(deps): update ruff requirement from <0.6,>=0.5.0 to >=0.5.0,<0.7 by @dependabot in #276
• fix: null column should be nullable by @PrettyWood in #279
• chore: v0.11.6 by @lukapeschke in #280

Full Changelog: v0.11.5...v0.11.6

v0.11.5

Full Changelog: v0.11.4...v0.11.5

v0.11.2

What's Changed

• fix: respect provided column ordering in use_columns when loading a sheet eagerly by @lukapeschke in #262
• chore: v0.11.2 by @lukapeschke in #264

Full Changelog: v0.11.1...v0.11.2

v0.11.1

What's Changed

• fix: take use_columns into account when loading a sheet eagerly by @lukapeschke in #260
• docs: tweak header_row and skip_rows description by @deanm0000 in #258
• chore: v0.11.1 by @PrettyWood in #261

New Contributors

• @deanm0000 made their first contribution in #258

Full Changelog: v0.11.0...v0.11.1

v0.11.0

What's Changed

• chore(deps): bump rstest from 0.18.2 to 0.19.0 in the prod-deps group by @dependabot in #230
• chore(deps): bump chrono from 0.4.37 to 0.4.38 in the prod-deps group by @dependabot in #231
• chore(deps): update ruff requirement from <0.4,>=0.2.0 to >=0.2.0,<0.5 by @dependabot in #234
• chore(deps): bump calamine from 0.24.0 to 0.25.0 in the prod-deps group by @dependabot in #237
• chore(deps): bump rstest from 0.19.0 to 0.21.0 in the prod-deps group across 1 directory by @dependabot in #239
• chore(deps): update ruff requirement from <0.5,>=0.2.0 to >=0.5.0,<0.6 by @dependabot in #242
• feat: introduce eager loading functions by @lukapeschke in #147
• chore(deps): bump pyo3 0.20.3 -> 0.21.2 by @lukapeschke in #241
• feat: use_columns can now be a callable by @PrettyWood in #243
• fix: treat #REF! cells as nulls by @lukapeschke in #244
• fix(tests): compat with polars 1.0.0 by @lukapeschke in #246
• refactor(dtype): automatically cast mixed string and date columns to strings by @lukapeschke in #245
• feat: add an option to disable automatic type coercion by @lukapeschke in #248
• chore(deps): bump arrow from 52.0.0 to 52.1.0 in the prod-deps group by @dependabot in #249
• feat: cast bools to strings if mixed types by @PrettyWood in #251
• chore: v0.11.0 by @lukapeschke in #253

Full Changelog: v0.10.4...v0.11.0

v0.10.4

What's Changed

• fix(ci/release): make the final release step depend on the windows build step as well by @lukapeschke in #225
• fix: add typing-extensions to dependencies by @jlondonobo in #227
• chore: v0.10.4 by @PrettyWood in #228

New Contributors

• @jlondonobo made their first contribution in #227

Full Changelog: v0.10.3...v0.10.4

v0.10.3

What's Changed

• fix: raise SheetNotFoundError when reading a missing sheet name by @PrettyWood in #222
• fix: consider cells with invalid values as nulls by @lukapeschke in #223
• chore: v0.10.3 by @lukapeschke in #224

Full Changelog: v0.10.2...v0.10.3

v0.10.2

What's Changed

• chore: cleanup by @lukapeschke in #213
• chore(deps): bump the prod-deps group with 1 update by @dependabot in #216
• fix(excelsheet): column_names should work with use_columns by @lukapeschke in #217
• chore: v0.10.2 by @lukapeschke in #218

Full Changelog: v0.10.1...v0.10.2

v0.10.1

What's Changed

• ci(release): also build arm64 wheels by @lukapeschke in #211
• chore: v0.10.1 by @lukapeschke in #212

Full Changelog: v0.10.0...v0.10.1