Excel Extension fails to load all data even though stop_at_empty = false
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 42/100
Research direction
Start by running the provided Python query against the reproduced D:/test.xlsx input and inspect the read_xlsx entry point used by the Excel extension. Compare the result when an empty column separates populated cells with the expected three-column output, then add coverage showing that stop_at_empty=false preserves the later data and run the relevant tests.
Written by the indexing model from the issue text.
Description
What happens?
When there is an empty column in the sheet, duckdb stops at that column.
To Reproduce
Code:
import duckdb
print(
duckdb.sql(
"SELECT * FROM read_xlsx('D:/test.xlsx', all_varchar=true, header=false, stop_at_empty=false, ignore_errors = true);"
).fetchall()
)
Content of D:/test.xlsx:
| A | B | C | |
|---|---|---|---|
| 1 | X | ||
| 2 | |||
| 3 | X |
Result:
[('X',), (None,)]
Expected:
[('X', None, None), (None, None, None), (None, None, X)], or at least [('X',), (None,), (None,)]
OS:
Windows x86_64
DuckDB Package Version:
1.3.2
Python Version:
3.13.7
Full Name:
Luna Yao
Affiliation:
Self
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a stable release
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include all code required to reproduce the issue?
- Yes, I have
Did you include all relevant configuration to reproduce the issue?
- Yes, I have
- Dominant language
- Python
- Stars
- 186
- Forks
- 113
- Avg merge
- 20h 58m
- Merged PRs (30d)
- 11
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from duckdb/duckdb-python
-
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
duckdb/duckdb-python#627 ·
-
needs triage
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
duckdb/duckdb-python#576 · 3 comments ·
-
needs triage
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
duckdb/duckdb-python#534 ·
-
needs triage
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
duckdb/duckdb-python#386 ·
-
needs triage
Difficulty 4/5 3-5 days Newbie friendliness 48/100
duckdb/duckdb-python#622 ·
All issues in duckdb/duckdb-python
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 82/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
enhancement
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100