biolab / biolab/orange3

Excel reader does not work for files with just features (no classes) with 3-line header

Open
#7,276 2 comments 0 reactions 0 assignees View on GitHub
bug
Dominant language
Python
Stars
5.7k
Forks
1.1k
Avg merge
12d 2h
Merged PRs (30d)
1

Description

**What's wrong and how can we reproduce the problem?**

I took the iris data set, removed the class in select rows, and saved it as Excel with "Add type annotations to header".

Image

Loading the file then shows something really strange.

Image

File was written correctly - looks the same as a written file `.tab` file. I guess the empty line causes issues. A file without this Orange's header works well.

Here is the file: [iris.xlsx](https://github.com/user-attachments/files/26838468/iris.xlsx)

Contributor guide

Open the contributing guide

Research direction

Start by loading the attached iris.xlsx through Orange's Excel reader and compare the result with the correctly loaded .tab version. Trace how the reader handles the empty class column in the three-line header; done means feature-only Excel files with that header load without the reported strange output.

Written by the indexing model from the issue text.

Assessment

Tech stack
python
Domain
data
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
55/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.