xlrd 2.0.2

Meta

• License: BSD License (BSD)
• Author: Chris Withers
• Tags xls , excel , spreadsheet , workbook
• Requires: Python !=3.0.*, !=3.1.*, !=3.2.*, !=3.3.*, !=3.4.*, !=3.5.*, >=2.7
• Provides-Extra: build , docs , test

Classifiers

• Development Status
  • 5 - Production/Stable
• Intended Audience
  • Developers
• License
  • OSI Approved :: BSD License
• Operating System
  • OS Independent
• Programming Language
  • Python
  • Python :: 2
  • Python :: 2.7
  • Python :: 3
  • Python :: 3.6
  • Python :: 3.7
  • Python :: 3.8
  • Python :: 3.9
• Topic
  • Database
  • Office/Business
  • Software Development :: Libraries :: Python Modules

👁 Build Status
👁 Coverage Status
👁 Documentation
👁 PyPI version

xlrd is a library for reading data and formatting information from Excel files in the historical .xls format.

The following are also not supported but will safely and reliably be ignored:

• Charts, Macros, Pictures, any other embedded object, including embedded worksheets.

• VBA modules

• Formulas, but results of formula calculations are extracted.

• Comments

• Hyperlinks

• Autofilters, advanced filters, pivot tables, conditional formatting, data validation

Password-protected files are not supported and cannot be read by this library.

Quick start:

pipinstallxlrd

importxlrdbook = xlrd.open_workbook("myfile.xls")print("The number of worksheets is {0}".format(book.nsheets))print("Worksheet name(s): {0}".format(book.sheet_names()))sh = book.sheet_by_index(0)print("{0}{1}{2}".format(sh.name, sh.nrows, sh.ncols))print("Cell D30 is {0}".format(sh.cell_value(rowx=29, colx=3)))for rx in range(sh.nrows): print(sh.row(rx))

From the command line, this will show the first, second and last rows of each sheet in each file:

pythonPYDIR/scripts/runxlrd.py3rows*blah*.xls

Verified details

These details have been verified by PyPI

Maintainers

👁 Avatar for carthorse-python-excel from gravatar.com
carthorse-python-excel 👁 Avatar for chrisw from gravatar.com
chrisw 👁 Avatar for sjmachin from gravatar.com
sjmachin

Unverified details

These details have not been verified by PyPI

Project links

• Homepage

• Download URL: xlrd-2.0.2.tar.gz
• Upload date: Jun 14, 2025
• Size: 100.2 kB
• Tags: Source
• Uploaded using Trusted Publishing? No
• Uploaded via: twine/6.1.0 CPython/3.9.9

Hashes for xlrd-2.0.2.tar.gz

Algorithm	Hash digest
SHA256	08b5e25de58f21ce71dc7db3b3b8106c1fa776f3024c54e45b45b374e89234c9
MD5	8afbdf48d53472530471a66e0978752d
BLAKE2b-256	075a377161c2d3538d1990d7af382c79f3b2372e880b65de21b01b1a2b78691e

See more details on using hashes here.

• Download URL: xlrd-2.0.2-py2.py3-none-any.whl
• Upload date: Jun 14, 2025
• Size: 96.6 kB
• Tags: Python 2, Python 3
• Uploaded using Trusted Publishing? No
• Uploaded via: twine/6.1.0 CPython/3.9.9

Hashes for xlrd-2.0.2-py2.py3-none-any.whl

Algorithm	Hash digest
SHA256	ea762c3d29f4cca48d82df517b6d89fbce4db3107f9d78713e48cd321d5c9aa9
MD5	9c7c92b37169d2d6df5b84fe3e48c771
BLAKE2b-256	1a62c8d562e7766786ba6587d09c5a8ba9f718ed3fa8af7f4553e8f91c36f302

See more details on using hashes here.