fastexcel

fastexcel copied to clipboard

schema_sample_rows=0 results in a table filled with null values

6

When reading a excel file and setting the schema_sample_rows to 0 results in a table of the correct height, but all values are set to null. If the schema_sample_rows is...

niekrongen

This is just an alternative approach to dealing with the issue outlined [here](https://github.com/ToucanToco/fastexcel/issues/256) The idea being that any type _can_ be casted to a string this would allow a file...

deanm0000

Coercing dates to strings adds time of the form '00:00:00'

2

## How to reproduce Suppose you have an Excel file with the following mixed-type data: | Header | |--------| | `=DATE(2024, 7, 1)` | | `=DATE(2024, 7, 2)` | |...

severinh

PrettyWood

29.02 cell cast to 29.020000000000003 string

7

## Steps to reproduce See the Excel file [decimal-numbers.xlsx](https://github.com/user-attachments/files/17162995/decimal-numbers.xlsx). It contains a column with two decimals: | Decimals | |--------| | 28.14 | | 29.02 | Read the Excel file...

severinh

closes #289

PrettyWood

I just ran into the issue from #208 with someone I'm helping learn python. In fact that's actually the only reason we realised anything was wrong, because it was a...

D3SL