Skip to content

xlrd==1.2.0#744

Merged
Piranias merged 2 commits intodevfrom
fix_xlrd
Jan 5, 2021
Merged

xlrd==1.2.0#744
Piranias merged 2 commits intodevfrom
fix_xlrd

Conversation

@Piranias
Copy link
Copy Markdown
Collaborator

@Piranias Piranias commented Jan 4, 2021

Fix #716

Changes proposed in this pull request:

  • fix requirement to xlrd==1.2.0 in default.txt

The following steps were realized, as well (if applies):

  • [:x:] Use in-line comments to explain your code
  • [:x:] Write docstrings to your code (example docstring)
  • [:x:] For new functionalities: Explain in readthedocs
  • [:x:] Write test(s) for your new patch of code (pytests, assertion debug messages)
  • Update the CHANGELOG.md
  • Apply black (black . --exclude docs/)
  • Check if benchmark tests pass locally (EXECUTE_TESTS_ON=master pytest)

Please mark above checkboxes as following:

  • Open
  • Done

❌ Check not applicable to this PR

For more information on how to contribute check the CONTRIBUTING.md.

@Piranias Piranias requested a review from Bachibouzouk January 4, 2021 15:07
-
### Changed
-
- fix xlrd to xlrd==1.2.0 in requirements/default.txt (#716)
Copy link
Copy Markdown
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

maybe you can add a hint on the reason which lead to freezing the version number?

Copy link
Copy Markdown
Collaborator Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

xlrd has explicitly removed support for anything other than xls files.
https://stackoverflow.com/questions/65254535/xlrd-biffh-xlrderror-excel-xlsx-file-not-supported

When reading the xlsx files saved by mvs we get an error without the version downgrade because panda is using xlrd by default. This does not show within mvs, because you are not reading the xlsx files, but might for other users.
Another possibility would of course be to change the type to xls, but I guess that's a bigger task.

Copy link
Copy Markdown
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I meant hint in the changelog entry :) so that someone reading this in 4 month and wondering why we frooze the version gets an answer immediately. Don't worry, I'll add it in my next PR if I don't forget :)

Copy link
Copy Markdown
Collaborator Author

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

ah ok, didn't gat that ;)

Copy link
Copy Markdown
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This will be added in #722

@Piranias Piranias merged commit 4f2031f into dev Jan 5, 2021
@Piranias Piranias deleted the fix_xlrd branch January 5, 2021 08:38
Bachibouzouk added a commit that referenced this pull request Jan 8, 2021
Add description from PR #744
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

downgrade to xlrd==1.2.0

2 participants