read_excel (calamine engine) Boolean schema override not working

[darrylthom]

Checks

• I have checked that this issue has not already been reported.
• I have confirmed this bug exists on the latest version of Polars.

Reproducible example

   read_excel('Test.xlsx', engine='calamine', sheet_name='Sheet1', infer_schema_length=None, schema_overrides={'NAME': pl.String, 'IS_ACTIVE': pl.Boolean})

Log output

_fastexcel.InvalidParametersError: invalid parameters: unsupported dtype: "bool"

Issue description

When reading in an Excel column that is TRUE/FALSE (booleans used within an Excel workbook) and explicitly defining it as a pl.Boolean, it throws an unsupported dtype error. I've had to instead read this in as a pl.UInt8 and cast it to a Boolean after its read in as a workaround.

Expected behavior

I would expect it to allow me to explicitly define a column as a boolean when reading in the Excel file without throwing an error.

Installed versions

Replace this line with the output of pl.show_versions(). Leave the backticks in place.

polars 1.0 Also broken in 0.2 as well

[alexander-beedie]

@KingDarule: fixed - available in the just-released Polars 1.1.0.
Give it a go?

[darrylthom]

It works -- thanks for the quick fix!