OpenDocument Spreadsheets File Reader for DuckDB(github.com)

2 pointsby redraiment9 mesi fa3 comments

Rusty-Sheet: An Excel/WPS/OpenDocument Spreadsheets File Reader for DuckDB

https://github.com/redraiment/rusty-sheet

3 comments

[rusty-sheet](https://github.com/redraiment/rusty-sheet) is a DuckDB extension written in Rust:

* File Formats: Excel, WPS, OpenDocument. * Remote Access: HTTP(S), S3, GCS, Hugging Face. * Batch Reading: Multiple files & sheets. * Schema Merging: By name or by position. * Type Inference: Automatic + manual override. * Excel Range: `range=’C3:E10'` syntax. * Provenance: File & sheet tracking. * Performance: Optimized Rust core.

tobwen9 mesi fa

“When using wildcard patterns, this function analyzes the column structure and data types from the first matching worksheet only.”

Meh… I think I should work on a PR to fix this…

redraiment9 mesi fa

Oh, my bad! I forgot to update the documentation: Actually, in union by name mode, all worksheets are now analyzed; otherwise, it remains limited to the first sheet only.