Luka Peschke

@armgabrielyan No, that's currently not possible, but feel free to open a different issue if you'd like support for that :slightly_smiling_face:

@noctuid unfortunately, the percentage edge case would require some work in calamine to properly support the excel Percent type, as it is not supported there for now: https://github.com/tafia/calamine/blob/master/src/datatype.rs#L23-L44 . Are...

@noctuid Right now, dates will be coerced to strings only if the dtype of the column is explicitly set to `string`. Implicit coercion will fail, as we did not want...

With #245 mixed dtypes and string columns are now automatically coerced to strings. Since this can be unexpected behaviour for some users, there will be an option to completely disable...

Some work is still required in calamine: https://github.com/tafia/calamine/pull/409

Okay well just noticed that the API changed so we actually need to use [`workshet_range_ref`](https://docs.rs/calamine/latest/calamine/struct.Xlsx.html#method.worksheet_range_ref) in case `Sheets` are the `Xlsx` variant

# new data ## `main` ```python import argparse from time import sleep import fastexcel def get_args() -> argparse.Namespace: parser = argparse.ArgumentParser() parser.add_argument("file") parser.add_argument("-c", "--column", type=str, nargs="+", help="the columns to use")...

Good news, looks like we should be able to have lazy-by-ref once a new calamine version is out :partying_face: Benchmarks with the latest version: |iterations|owned|by ref| |---|---|---| |1||| |20|||

calamine 0.25.0 should be released soon, meaning I should finally be able to finish this :slightly_smiling_face: https://github.com/tafia/calamine/issues/435

### latest measurements with this branch | iterations | master | this branch (lazy) | this branch (eager) | |---|---|---|---| |1| ||| |20|| |