[FIX] ExcelReader - Use openpyxl to read xlsx and xlrd for xls

[PrimozGodec]

Issue

• Tests started to fail since xlrd cannot read xlsx files on newer Pythons. It is also documented in the library that it supports only historic xls files. While writing tests for the historical version of xls, I noticed that the version of xlrd pinned in requirements doesn't work with Pandas anymore, so data cannot be loaded from xls.
• With the newest scipy (1.12.0) mtx loading started to fail since they implemented the module.

Description of changes

• Use Openpyxl to get info on xlsx and xlrd for gen info for xls. Adding openpyxl to requirements. It is already an Orange3 requirement. Updating the version of xlrd to work with Pandas
• It seems that mtx file opened as "rb" failed. Instead of opening it manually, pass the filename to the module, and it will open itself.

Includes

• [X] Code changes
• [X] Tests
• [ ] Documentation

[codecov-commenter]

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 80.59%. Comparing base (40341cd) to head (68edf7a).

Additional details and impacted files

[](https://app.codecov.io/gh/biolab/orange3-single-cell/pull/400?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=biolab) ```diff @@ Coverage Diff @@ ## master #400 +/- ## ========================================== + Coverage 80.56% 80.59% +0.03% ========================================== Files 21 21 Lines 5474 5479 +5 ========================================== + Hits 4410 4416 +6 + Misses 1064 1063 -1 ``` | [Files](https://app.codecov.io/gh/biolab/orange3-single-cell/pull/400?dropdown=coverage&src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=biolab) | Coverage Δ | | |---|---|---| | [orangecontrib/single\_cell/widgets/load\_data.py](https://app.codecov.io/gh/biolab/orange3-single-cell/pull/400?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=biolab#diff-b3JhbmdlY29udHJpYi9zaW5nbGVfY2VsbC93aWRnZXRzL2xvYWRfZGF0YS5weQ==) | `93.12% <100.00%> (+0.24%)` | :arrow_up: | ------ [Continue to review full report in Codecov by Sentry](https://app.codecov.io/gh/biolab/orange3-single-cell/pull/400?dropdown=coverage&src=pr&el=continue&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=biolab). > **Legend** - [Click here to learn more](https://docs.codecov.io/docs/codecov-delta?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=biolab) > `Δ = absolute (impact)`, `ø = not affected`, `? = missing data` > Powered by [Codecov](https://app.codecov.io/gh/biolab/orange3-single-cell/pull/400?dropdown=coverage&src=pr&el=footer&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=biolab). Last update [40341cd...68edf7a](https://app.codecov.io/gh/biolab/orange3-single-cell/pull/400?dropdown=coverage&src=pr&el=lastupdated&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=biolab). Read the [comment docs](https://docs.codecov.io/docs/pull-request-comments?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=biolab).