-
Notifications
You must be signed in to change notification settings - Fork 6
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support for Reading Excel Tables #204
Comments
Hi @aersam , could you please provide a bit more details on what you have in mind ? And maybe provide a few examples on how that parameter is passed in other libraries (for example pandas) ? A file with the issue you are encountering would also be great |
Hi there! |
Thanks! This seems to be doable through calamine's APIs (https://docs.rs/calamine/latest/calamine/struct.Xlsx.html#method.table_by_name) but will require quite some work, so I don't know when/if we will ship it... We might pritoritize this if a lot of people ask for this feature 🙂 |
As a minor FYI, we always write "real" Excel table objects from Polars' |
@alexander-beedie ah good to know, thanks! How do you handle tables on read ? Is there a parameter to read a specific table ? |
At the moment I don't, heh 😎 However, I was thinking about adding a (You may also want an option to skip the final row when reading table objects, as that can contain totals that are not part of the data - they also may or may not have a header row, so the existing parameters to determine that can be respected). |
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 and get the table data as arrow/pandas like with the sheets
The text was updated successfully, but these errors were encountered: