fastexcel
fastexcel copied to clipboard
ToucanToco
A Python wrapper around calamine
From my experience it's usually much safer to load data from an excel table than from a sheet. would be nice if one could get the table names per sheet...
If I put expect the header on e.g. row index 15, but there are blank rows (at least at the beginning of the sheet), I cannot do `header_row=15`. It looks...
I want to be able to e.g. read all columns after A. There is not skipcols, and usecols requires a start and end to the range. I'd like to be...
Hi team, in excel, we have special symbols like #VALUE!, #DIV/0! etc. As of now, these symbols are turned into **null**. Can we have an option to retain them as...
There is a similar [issue](#200), which is closed without, as it appears, any fix (with v`0.9.1` being actual). Expected behaviour is outlined in [examples](https://github.com/dimastbk/python-calamine#example) of `python-calamine` for an option `skip_empty_area`:...
I was hoping to benchmark `fastexcel` vs `xlsx2csv` to determine if I'd benefit from the performance in the context of `polars`. I haven't found any discussion mentioning `conda-forge`, but they...
See https://github.com/ToucanToco/fastexcel/issues/181#issue-2136125477 and https://github.com/ToucanToco/fastexcel/issues/158#issuecomment-1952777001 - [TEST_FASTEXCEL_MIXED_DATA.xlsx](https://github.com/ToucanToco/fastexcel/files/14295251/TEST_FASTEXCEL_MIXED_DATA.xlsx) - Same as the prior one, but introducing two additional columns with mixed data types (integer plus string, date plus string, no "NULL" string...
It'd be great to have a section explaining a bit how type inference works in the docs. Specifically: * How dtypes are inferred * Which type combinations get coerced to...
Currently the docs on https://fastexcel.toucantoco.dev are built from the main branch. It would be nice to have versioned docs _à la_ RTD so users can see the docs for their...
# What This introduces eager loading functions that make use of the calamine's new `DataTypeRef`. This prevents some allocations, resulting in a lower memory footprint. # Caveats * The API...