xlrd 0,4,0,0,6 travis-ci python

Library for developers to extract data from Microsoft Excel (tm) spreadsheet files

2 years after

Build Status Coverage Status Documentation Status PyPI version

xlrd

Purpose: Provide a library for developers to use to extract data from Microsoft Excel (tm) spreadsheet files. It is not an end-user tool.

Author: John Machin, Lingfo Pty Ltd ([email protected])

Licence: BSD-style (see licences.py)

Versions of Python supported: 2.6, 2.7, 3.3+.

External modules required:

The package itself is pure Python with no dependencies on modules or packages outside the standard Python distribution.

Outside the current scope: xlrd will safely and reliably ignore any of these if present in the file:

  • Charts, Macros, Pictures, any other embedded object. WARNING: currently this includes embedded worksheets.
  • VBA modules
  • Formulas (results of formula calculations are extracted, of course).
  • Comments
  • Hyperlinks
  • Autofilters, advanced filters, pivot tables, conditional formatting, data validation

Unlikely to be done:

  • Handling password-protected (encrypted) files.

Particular emphasis (refer docs for details):

  • Operability across OS, regions, platforms
  • Handling Excel's date problems, including the Windows / Macintosh four-year differential.
  • Providing access to named constants and named groups of cells (from version 0.6.0)
  • Providing access to "visual" information: font, "number format", background, border, alignment and protection for cells, height/width etc for rows/columns (from version 0.6.1)

Quick start:

import xlrd
book = 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))

Another quick start: This will show the first, second and last rows of each sheet in each file:

python PYDIR/scripts/runxlrd.py 3rows *blah*.xls

Installation:

  • On Windows: use the installer.
  • Any OS: Unzip the .zip file into a suitable directory, chdir to that directory, then do "python setup.py install".
  • If PYDIR is your Python installation directory: the main files are in PYDIR/Lib/site-packages/xlrd the docs are in the doc subdirectory, and there's a sample script: PYDIR/Scripts/runxlrd.py
  • If os.sep != "/": make the appropriate adjustments.

Acknowledgements:

  • This package started life as a translation from C into Python of parts of a utility called "xlreader" developed by David Giffin. "This product includes software developed by David Giffin [email protected]."
  • OpenOffice.org has truly excellent documentation of the Microsoft Excel file formats and Compound Document file format, authored by Daniel Rentz. See http://sc.openoffice.org
  • U+5F20 U+654F: over a decade of inspiration, support, and interesting decoding opportunities.
  • Ksenia Marasanova: sample Macintosh and non-Latin1 files, alpha testing
  • Backporting to Python 2.1 was partially funded by Journyx - provider of timesheet and project accounting solutions (http://journyx.com/).
  • Provision of formatting information in version 0.6.1 was funded by Simplistix Ltd (http://www.simplistix.co.uk/)

Related Repositories

xlutils

xlutils

Utilities for working with Excel files that require both xlrd and xlwt. ...

tutorial

tutorial

The tutorial for xlrd, xlwt and xlutils ...

pyexcel

pyexcel

Python Wrapper that provides one API for reading, manipulating and writing data ...

wxStocks

wxStocks

wxStocks: Investment Analysis for Python Programmers (*note: currently functiona ...

proton

proton

Export excel to xml, json, lua, etc., and automatically generate the read code. ...


Top Contributors

cjw296 takluyver sjmachin scop stephenlewis vog jmcnamara monokrome gthb larserikh endeepak frewsxcv xiaods scraperdragon jikamens lopuhin mlorant patrickfuller rossjones suvit yegorich icereval lrudolph1

Releases

-   1.0.0 zip tar
-   0.9.4 zip tar
-   0.9.3 zip tar
-   0.9.2 zip tar
-   0.9.1 zip tar
-   0.9.0 zip tar
-   0.8.0 zip tar
-   0.7.9 zip tar
-   0.7.8 zip tar
-   0.7.7 zip tar
-   0.7.6 zip tar
-   0.7.5 zip tar
-   0.7.4 zip tar
-   0.7.3 zip tar
-   0.7.2 zip tar
-   0.7.1 zip tar
-   0.7.0 zip tar
-   0.6.1 zip tar
-   0.6.1a4 zip tar
-   0.6.1a3 zip tar
-   0.5.2 zip tar
-   0.3a1 zip tar