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
E-ICEBLUE
E-iceblue provides a comprehensive suite of professional development libraries and APIs designed to enable developers to create, read, write, edit, convert, print, manipulate and view a wide range of document formats programmatically across multiple programming environments without relying on external applications like Microsoft Office or Adobe Acrobat. Its product range includes Spire.Office and individual components for .NET platforms (such as Spire.Doc, Spire.XLS, Spire.Presentation, Spire.PDF, Spire.Barcode, Spire.Email and Spire.OCR) that handle Word, Excel, PowerPoint, PDF, barcode generation and email operations in C#, VB.NET, ASP.NET, .NET Core, Xamarin and WPF applications, plus viewer libraries for embedded document display. E-iceblue also offers equivalent APIs for Java, C++, Python and JavaScript, as well as mobile and cloud libraries (including Spire.Cloud.Office with HTML5 browser support for Word and Excel), supporting document processing tasks.
Learn more
openpyxl
openpyxl is a Python library to read/write Excel 2010 xlsx/xlsm/xltx/xltm files. It was born from a lack of an existing library to read/write natively from Python in the Office Open XML format. All kudos to the PHPExcel team as openpyxl was initially based on PHPExcel. By default, openpyxl does not guard against quadratic blowup or billion laughs XML attacks. To guard against these attacks install defusedxml. Install openpyxl using pip. It is advisable to do this in a Python virtualenv without system packages. Sometimes you might want to work with the checkout of a particular version. This may be the case if bugs have been fixed but a release has not yet been made. There is no need to create a file on the filesystem to get started with openpyxl. Just import the Workbook class and start work. Sheets are given a name automatically when they are created. Once you gave a worksheet a name, you can get it as a key of the workbook.
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
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
Incredable is the first DLT-secured platform that allows you to save time, eliminate errors, and ensure your organization is compliant all in one place.
Incredable streamlines and simplifies the complex process of medical credentialing for hospitals and medical facilities, helping you save valuable time, reduce costs, and minimize risks. With Incredable, you can effortlessly manage all your healthcare providers and their credentials within a single, unified platform. Our state-of-the-art technology ensures top-notch data security, giving you peace of mind.
Product Details
Platforms Supported
Windows
Mac
Linux
Training
Documentation
Webinars
Videos
Support
Online
