xlrd | Please use openpyxl

 by   python-excel Python Version: 2.0.1 License: Non-SPDX

kandi X-RAY | xlrd Summary

kandi X-RAY | xlrd Summary

xlrd is a Python library. xlrd has no bugs, it has no vulnerabilities, it has build file available and it has high support. However xlrd has a Non-SPDX License. You can download it from GitHub.

Please use openpyxl where you can...

            kandi-support Support

              xlrd has a highly active ecosystem.
              It has 2072 star(s) with 444 fork(s). There are 98 watchers for this library.
              It had no major release in the last 6 months.
              xlrd has no issues reported. There are no pull requests.
              It has a positive sentiment in the developer community.
              The latest version of xlrd is 2.0.1

            kandi-Quality Quality

              xlrd has 0 bugs and 0 code smells.

            kandi-Security Security

              xlrd has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.
              xlrd code analysis shows 0 unresolved vulnerabilities.
              There are 0 security hotspots that need review.

            kandi-License License

              xlrd has a Non-SPDX License.
              Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

            kandi-Reuse Reuse

              xlrd releases are not available. You will need to build from source code and install.
              Build file is available. You can build the component from source.
              xlrd saves you 3531 person hours of effort in developing the same functionality from scratch.
              It has 7557 lines of code, 298 functions and 27 files.
              It has high code complexity. Code complexity directly impacts maintainability of the code.

            Top functions reviewed by kandi - BETA

            kandi has reviewed xlrd and discovered the below as its top functions. This is intended to give you an instant insight into xlrd implemented functionality, and help decide if they suit your requirements.
            • Read data from a SHEET
            • Unpack a string into a unicode string
            • Unpack cell range address list
            • Dump the object to f
            • Generate xldate from a tuple of datetime objects
            • Leapian
            • Convert a tuple into a xld date object
            • Convert a tuple to a Julian date
            • Return the area of the result
            • Return the sheet corresponding to the given index
            • Return a sheet
            • Read a BOF record from the stream
            • Return a list of all rows in colx
            • Return a Cell object for the given row and column index
            • Return the cell index for row and column index
            • Get a stream by name
            • Return a DirNode instance or None
            • Get a stream from memory
            • Display a cell address
            • Dump file to outfile
            • Counts the number of records in a file
            • Check if fmt is a date format string
            • Compute the column width
            • Returns the cell reference to the formula
            • Return a list of rows from rowx
            • Dump the contents of the node
            Get all kandi verified functions for this library.

            xlrd Key Features

            No Key Features are available at this moment for xlrd.

            xlrd Examples and Code Snippets

            No Code Snippets are available at this moment for xlrd.

            Community Discussions


            Extract particular values from Excel file, place it into static text and generate .txt files
            Asked 2022-Mar-09 at 06:35

            I am trying to read cells from .xls file and place them into particular spots in a static text and then have that generated as .txt file.

            I managed to write code that generates what I need, but it only works for the first row in the .xls file. It generates 4 files according to the number of rows, but every file has values from the first row. I understand that I have static cell values for the first row in the code, but I am not sure how to amend this and get the code to go row by row/cell by cell and generate relevant .txt file for each row. My guess is that it needs to be incorporated into the for loop somehow?

            For context, each row represents one printer, and these files are then used to import the printers into a system.

            I'll be glad for any help/suggestions.

            This is what my test .xls file looks like



            Answered 2022-Mar-08 at 21:19

            The following code works fine on my computer after creating an Excel file with your sample data. Here's what I changed to make it work: The second for loop wasn't necessary so I removed it and outdented the code that was formerly in that loop. I changed the range() invocation to start at one and go one past the number of rows since the row numbers start at zero in xlrd. And I changed the .cell method calls to use the row variable instead of always getting values from row one.

            Source https://stackoverflow.com/questions/71401070


            Cannot find conda info. Please verify your conda installation on EMR
            Asked 2022-Feb-05 at 00:17

            I am trying to install conda on EMR and below is my bootstrap script, it looks like conda is getting installed but it is not getting added to environment variable. When I manually update the $PATH variable on EMR master node, it can identify conda. I want to use conda on Zeppelin.

            I also tried adding condig into configuration like below while launching my EMR instance however I still get the below mentioned error.



            Answered 2022-Feb-05 at 00:17

            I got the conda working by modifying the script as below, emr python versions were colliding with the conda version.:

            Source https://stackoverflow.com/questions/70901724


            read xls file in pandas / python: Unsupported format, or corrupt file: Expected BOF record; found b'\xef\xbb\xbf
            Asked 2022-Feb-02 at 20:35

            I am trying to open an xls file (with only one tab) into a pandas dataframe.

            It is a file that i can normally read in excel or excel for the web, in fact here is the raw file itself: https://www.dropbox.com/scl/fi/zbxg8ymjp8zxo6k4an4dj/product-screener.xls?dl=0&rlkey=3aw7whab78jeexbdkthkjzkmu .

            I notice that the top two rows have merged cells and so do some of the columns.

            I have tried several methods (from stack), which all fail.



            Answered 2022-Feb-02 at 15:36

            Not a complete solution but it should get you started. The "xls" file is actually a plain xml file in the SpreadsheetML format. Change the file extension to .xml an view it in your internet browser, the structure (at least of the give file) is rather straightforward.

            The following reads the data contents into a pandas DataFrame:

            Source https://stackoverflow.com/questions/70954509


            Excel general numbers into date with empty cell with Pandas
            Asked 2022-Jan-18 at 05:01

            This piece of code work good to convert the excel general number into date as long as there is no empty value in the column, when the column contain any empty value then it throw any error that i described below. Could anyone help me out how to ignore the empty cell? on the other hand i also need to keep the empty cell as empty because i don't want to drop them, in the data frame other columns contain some data as well.



            Answered 2022-Jan-15 at 12:45

            Use indexing to remove bad rows:

            Source https://stackoverflow.com/questions/70721371


            How to merge multiple .xls files with hyperlinks in python?
            Asked 2021-Dec-29 at 08:37

            I am trying to merge multiple .xls files that have many columns, but 1 column with hyperlinks. I try to do this with Python but keep running into unsolvable errors.

            Just to be concise, the hyperlinks are hidden under a text section. The following ctrl-click hyperlink is an example of what I encounter in the .xls files: ES2866911 (T3).

            In order to improve reproducibility, I have added .xls1 and .xls2 samples below.


            Title Publication_Number P_A ES2866911 (T3) P_B EP3887362 (A1)


            Title Publication_Number P_C AR118706 (A2) P_D ES2867600 (T3)

            Desired outcome:

            Title Publication_Number P_A ES2866911 (T3) P_B EP3887362 (A1) P_C AR118706 (A2) P_D ES2867600 (T3)

            I am unable to get .xls file into Python without losing formatting or losing hyperlinks. In addition I am unable to convert .xls files to .xlsx. I have no possibility to acquire the .xls files in .xlsx format. Below I briefly summarize what I have tried:

            1.) Reading with pandas was my first attempt. Easy to do, but all hyperlinks are lost in PD, furthermore all formatting from original file is lost.

            2.) Reading .xls files with openpyxl.load



            Answered 2021-Dec-24 at 15:29

            Without a clear reproducible example, the problem is not clear. Assume I have two files called tmp.xls and tmp2.xls containing dummy data as in the two screenshots below.

            Then pandas can easily, load, concatenate, and convert to .xlsx format without loss of hyperlinks. Here is some demo code and the resulting file:

            Source https://stackoverflow.com/questions/70472885


            Running odoo in Debugging VSCode and found error ModuleNotFoundError: No module named 'stdnum' - - -
            Asked 2021-Dec-27 at 17:01

            i using VSCode as my IDE for development odoo and for now run using Start > Debugging ( F5)

            While running at web browser localhost:8069 ( default ) then appear Internal Server Error and in terminal VSCode there are errors :



            Answered 2021-Dec-27 at 17:01

            After trying for a few days and just found out that pip and python in the project are not pointing to .venv but to anaconda due to an update. when error

            no module stdnum

            actually there is a problem with pip so make sure your pip path with which pip or which python

            1. to solve .venv that doesn't work by deleting the .venv folder, create venv in python, and install all requirements again

            Source https://stackoverflow.com/questions/70457690


            Encoding issue during reading excel file in Python
            Asked 2021-Dec-20 at 01:40

            I use read_excel from pandas library to read excel content and convert it to JSON. I am struggling with encoding issue. Non english characters are encoded like "u652f\u63f4\u8cc7\u8a0a". How can I resolve this issue? I tried



            Answered 2021-Dec-20 at 01:40

            From the docs of the json module:

            The RFC requires that JSON be represented using either UTF-8, UTF-16, or UTF-32, with UTF-8 being the recommended default for maximum interoperability.

            As permitted, though not required, by the RFC, this module’s serializer sets ensure_ascii=True by default, thus escaping the output so that the resulting strings only contain ASCII characters.

            Maybe surprising that in this day-and-age the module defaults to escaping non-ASCII (probably for backwards compatibility), so just override that behavior with ensure_ascii=false:

            Source https://stackoverflow.com/questions/70408252


            UnsatisfiableError on importing environment pywin32==300 (Requested package -> Available versions)
            Asked 2021-Dec-03 at 14:58

            Good day

            I am getting an error while importing my environment:



            Answered 2021-Dec-03 at 09:22

            Build tags in you environment.yml are quite strict requirements to satisfy and most often not needed. In your case, changing the yml file to

            Source https://stackoverflow.com/questions/70209921


            pip install custom package from BitBucket with SSH without entering SSH password during Docker build
            Asked 2021-Nov-29 at 21:25

            I'm trying to pip install (via a conda env create command) a custom python package from BitBucket during a docker build command without entering the SSH password/passphrase. This question is similar to this other question, but different because the error is occurring during the docker build command.

            The environment.yml file for the conda env create command (during the docker build) looks something like this:



            Answered 2021-Nov-29 at 20:09

            SSH needs access to your private RSA key for the authentication. Your private key is not shared with any command which runs inside a Docker image. Docker has a builtin feature to solve this issue, which is documented here.

            Essentially what you want to do is to download your PUBLIC key to the Docker image:

            Source https://stackoverflow.com/questions/70160034


            I can't read excel file using dt.fread from datatable AttributeError
            Asked 2021-Nov-19 at 15:28

            Hello I'm trying to read an excel file 'myFile.xlsx' using datatable.fread (version 1.0.0) function to speedup data manipulation.

            The problem is I had an AttributeError: module 'xlrd' has no attribute 'xlsx'.

            The command I used is:



            Answered 2021-Nov-19 at 15:28

            The issue is that datatable package is not updated yet to make use of xldr>1.2.0, so in order to make it work you have to install xldr = 1.2.0

            Source https://stackoverflow.com/questions/70035997

            Community Discussions, Code Snippets contain sources that include Stack Exchange Network


            No vulnerabilities reported

            Install xlrd

            You can download it from GitHub.
            You can use xlrd like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.


            For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .
            Find more information at:

            Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items

            Find more libraries
          • HTTPS


          • CLI

            gh repo clone python-excel/xlrd

          • sshUrl


          • Stay Updated

            Subscribe to our newsletter for trending solutions and developer bootcamps

            Agree to Sign up and Terms & Conditions

            Share this Page

            share link