What is xlrd?

The xlrd library serves as a valuable resource for developers aiming to extract data from .xls files, a specific format used by Microsoft Excel for spreadsheets. This library is primarily focused on reading the data itself along with the formatting details found in these legacy Excel file formats. It's crucial to understand that xlrd is now restricted to handling only .xls files. The library does not support the processing of elements such as charts, macros, images, or any embedded components like additional worksheets, VBA modules, or formulas; however, it can access results from formula evaluations, comments, hyperlinks, and various filters, including auto, advanced, pivot tables, along with conditional formatting and data validation. Additionally, files that are password-protected cannot be accessed or read through this library. When utilized from the command line, xlrd allows users to view the first, second, and last rows of every sheet within the specified files. Moreover, it's important to highlight that xlrd is made available under the BSD license, granting developers the freedom to use and modify the library according to their requirements. This flexibility makes it a preferred choice among developers who need a straightforward solution for handling older Excel file formats.

Pricing

Price Starts At:
Free
Free Version:
Free Version available.

Integrations

Screenshots and Video

xlrd Screenshot 1

Company Facts

Company Name:
Python Software Foundation
Company Location:
United States
Company Website:
pypi.org/project/xlrd/

Product Details

Deployment
Windows
Mac
Linux
Training Options
Documentation Hub
Webinars
Video Library
Support
Web-Based Support

Product Details

Target Company Sizes
Individual
1-10
11-50
51-200
201-500
501-1000
1001-5000
5001-10000
10001+
Target Organization Types
Mid Size Business
Small Business
Enterprise
Freelance
Nonprofit
Government
Startup
Supported Languages
English

xlrd Categories and Features