Audience
Any user looking for a solution to extract data from Microsoft Excel spreadsheet files
About xlrd
xlrd is a library for developers to extract data from Microsoft Excel (tm) .xls spreadsheet files. xlrd is a library for reading data and formatting information from Excel files in the historical .xls format. This library will no longer read anything other than .xls files. Ignores charts, macros, pictures, any other embedded object, including embedded worksheets, VBA modules, and formulas, but results of formula calculations are extracted, comments, hyperlinks, auto filters, advanced filters, pivot tables, conditional formatting, and data validation. Password-protected files are not supported and cannot be read by this library. From the command line, this will show the first, second, and last rows of each sheet in each file. xlrd is licensed under the BSD license.
Other Popular Alternatives & Related Software
Pillow
The Python Imaging Library adds image processing capabilities to your Python interpreter. This library provides extensive file format support, an efficient internal representation, and fairly powerful image processing capabilities. The core image library is designed for fast access to data stored in a few basic pixel formats. It should provide a solid foundation for a general image processing tool. Pillow for enterprise is available via the Tidelift subscription. The Python Imaging Library is ideal for image archival and batch processing applications. You can use the library to create thumbnails, convert between file formats, print images, etc. The current version identifies and reads a large number of formats. Write support is intentionally restricted to the most commonly used interchange and presentation formats. The library contains basic image processing functionality, including point operations, filtering with a set of built-in convolution kernels, and color space conversions.
Learn more
WebDataRocks
WebDataRocks is a simple free JS library for creating functional and easy-to-use pivot tables. It can be used with Angular, Vue, React or any other framework.
Free
Flexible in customization
JavaScript based client-side component
Loads 1MB of JSON or CSV data files
Full set of enterprise features
Integration with 3rd party charting libraries
Full set of enterprise features
Features like filtering, sorting, grouping, conditional and number formatting, calculated values, totals are available for efficient work with your data. It supports printing or exporting web report to PDF, Excel or HTML with just one click.
Ready-to-use modern UI
The tool offers a classy spreadsheet-like interface optimized both for browsers and apps. All principles of reliability and excellent user experience are already implemented in this web reporting tool.
Learn more
BuildVu
With BuildVu, you’ll unlock precise PDF-to-HTML/SVG conversion, giving you greater control and added functionality over PDF in your web application.
-Optimized Content: BuildVu intelligently converts PDFs, optimizing for smaller file sizes and fast rendering in browsers.
-File Metadata: Access PDF data in JSON format, including metadata, word lists, outlines (bookmarks), and annotations.
-Thumbnails: Generate high-quality page thumbnails with customizable dimensions.
-Annotations: Enjoy support for various annotation types (Links, Popups, Sound/Video, Text, Highlight, Underline) in easy-to-use JSON format.
-search.json: Extract all text from the document alongside the HTML content.
-Font Conversion: Restructure embedded fonts for compatibility across web browsers.
-Office Conversion: Combine BuildVu with LibreOffice for seamless conversion from Office formats (Word, PowerPoint, Excel).
Learn more
warcat
Tool and library for handling Web ARChive (WARC) files. Naively join archives into one. Extract files from archive. List commands available. List contents of archive. Load archive and write it back out. Split archives into individual records. Verify digest and validate conformance. The library may not be entirely thread-safe yet. The goal of the Warcat project is to create a tool and library as easily and fast as manipulating any other archive such as tar and zip archives. Warcat is designed to handle large, gzip-ed files by partially extracting them as needed. Warcat is provided without warranty and cannot guarantee the safety of your files. Remember to make backups and test them! A WARC file contains one or more records concatenated together. Each record contains named fields, newline, a content block, newline, and newline. A Content Block may be two types, {binary data} or {Named Fields, newline, and binary data}.
Learn more
Pricing
Starting Price:
Free
Free Version:
Free Version available.
Integrations
Company Information
Python Software Foundation
United States
pypi.org/project/xlrd/
Videos and Screen Captures
Other Useful Business Software
Simplify IT and security with a single endpoint management platform
NinjaOne automates the hardest parts of IT, delivering visibility, security, and control over all endpoints for more than 20,000 customers.
The NinjaOne automated endpoint management platform is proven to increase productivity, reduce security risk, and lower costs for IT teams and managed service providers. The company seamlessly integrates with a wide range of IT and security technologies. NinjaOne is obsessed with customer success and provides free and unlimited onboarding, training, and support.
Product Details
Platforms Supported
Windows
Mac
Linux
Training
Documentation
Webinars
Videos
Support
Online