文件列表:

运行结果截图.png (15117, 2017-09-26)
autohome_20170915.py (4406, 2017-09-26)
xlrd-1.1.0\.travis.yml (707, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\biffh.py (16680, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\book.py (56967, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\compdoc.py (20975, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\examples\namesdemo.xls (22528, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\examples\xlrdnameAPIdemo.py (7132, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\formatting.py (45085, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\formula.py (94683, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\info.py (22, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\sheet.py (106178, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\timemachine.py (1756, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\xldate.py (7942, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\xlsx.py (34179, 2017-08-22)
xlrd-1.1.0\build\lib\xlrd\__init__.py (6347, 2017-08-22)
xlrd-1.1.0\build\scripts-2.7\runxlrd.py (16674, 2017-08-26)
xlrd-1.1.0\dist\xlrd-1.1.0-py2.7.egg (219471, 2017-08-26)
xlrd-1.1.0\docs\acknowledgements.rst (859, 2017-08-22)
xlrd-1.1.0\docs\api.rst (881, 2017-08-22)
xlrd-1.1.0\docs\changes.rst (17629, 2017-08-22)
xlrd-1.1.0\docs\conf.py (741, 2017-08-22)
xlrd-1.1.0\docs\dates.rst (3989, 2017-08-22)
xlrd-1.1.0\docs\development.rst (1700, 2017-08-22)
xlrd-1.1.0\docs\formatting.rst (4441, 2017-08-22)
xlrd-1.1.0\docs\index.rst (723, 2017-08-22)
xlrd-1.1.0\docs\installation.rst (472, 2017-08-22)
xlrd-1.1.0\docs\licenses.rst (3791, 2017-08-22)
xlrd-1.1.0\docs\make.bat (4691, 2017-08-22)
xlrd-1.1.0\docs\Makefile (4903, 2017-08-22)
xlrd-1.1.0\docs\on_demand.rst (2514, 2017-08-22)
xlrd-1.1.0\docs\references.rst (1832, 2017-08-22)
xlrd-1.1.0\docs\unicode.rst (1452, 2017-08-22)
xlrd-1.1.0\docs\vulnerabilities.rst (1638, 2017-08-22)
xlrd-1.1.0\PKG-INFO (1189, 2017-08-22)
xlrd-1.1.0\requirements.txt (128, 2017-08-22)
xlrd-1.1.0\scripts\runxlrd.py (16256, 2017-08-22)
xlrd-1.1.0\setup.cfg (67, 2017-08-22)
... ...

[](https://travis-ci.org/python-excel/xlrd) [](https://coveralls.io/github/python-excel/xlrd?branch=master) [](http://xlrd.readthedocs.io/en/latest/?badge=latest) [](https://badge.fury.io/py/xlrd) ### xlrd Please read this before using this library: https://groups.google.com/d/msg/python-excel/P6TjJgFVjMI/g8d0eWxTBQAJ **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 (sjmachin@lexicon.net) **Licence**: BSD-style (see licences.py) **Versions of Python supported**: 2.7, 3.4+. **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**: ```python 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 ." * 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/)

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：