<!---
[](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)
--->
### xlrd3
A fork of original archived [xlrd](https://github.com/python-excel/xlrd) project.
This fork aims to fix bugs that existing in `xlrd` and improve it features.
As the name of this fork implies, python2 support is dropped.
At version 1.0.0, xlrd3 on pair with xlrd version 1.2.0 with following bugs fixed:
* MemoryError: `on_demand` with `mmap` still causes some `xls` to be read the whole file into memory.
* `on_demand` not supported for `xlsx`
* Parsing comments failed for `xlsx` on Windows platform.
### When to use xlrd3
If you just need to **read** and deal with both `xlsx` and `xls`, use `xlrd3`.
Then if you want to export your data to other excel files, use [OpenPyXL](https://openpyxl.readthedocs.io/en/stable/) or [xlsxWriter](https://github.com/jmcnamara/XlsxWriter).
If you need to **edit** `xlsx` (read and write) and are sure that `xls` never appear in your workflow, you are advised to use [OpenPyXL](https://openpyxl.readthedocs.io/en/stable/) instead.
**Purpose**: Provide a library for developers to use to extract data from Microsoft Excel (tm) spreadsheet files. It is not an end-user tool.
**Original Author**: John Machin
**Licence**: BSD-style (see licences.py)
**Versions of Python supported**: 3.6+.
**Outside scope**: xlrd3 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
* Handling password-protected (encrypted) files.
**Installation**:`$pip install xlrd3`
**Quick start**:
```python
import xlrd3 as 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
**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 <david@giffin.org>."
* 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/)
Raw data
{
"_id": null,
"home_page": "https://github.com/Dragon2fly/xlrd3",
"name": "xlrd3",
"maintainer": "Nguyen Ba Duc Tin",
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": "nguyenbaduc.tin@gmail.com",
"keywords": "xls,xlsx,excel,spreadsheet,workbook",
"author": "John Machin",
"author_email": "sjmachin@lexicon.net",
"download_url": "https://files.pythonhosted.org/packages/79/db/88d8d49ddacc203956ecb98dc86c6ffeee6e933ef1f50da9b369de518f7f/xlrd3-1.1.0.tar.gz",
"platform": "Any platform -- don't need Windows",
"description": "<!---\n[](https://travis-ci.org/python-excel/xlrd)\n[](https://coveralls.io/github/python-excel/xlrd?branch=master)\n[](http://xlrd.readthedocs.io/en/latest/?badge=latest)\n[](https://badge.fury.io/py/xlrd)\n--->\n### xlrd3\nA fork of original archived [xlrd](https://github.com/python-excel/xlrd) project. \nThis fork aims to fix bugs that existing in `xlrd` and improve it features. \nAs the name of this fork implies, python2 support is dropped. \n\nAt version 1.0.0, xlrd3 on pair with xlrd version 1.2.0 with following bugs fixed:\n\n* MemoryError: `on_demand` with `mmap` still causes some `xls` to be read the whole file into memory.\n* `on_demand` not supported for `xlsx`\n* Parsing comments failed for `xlsx` on Windows platform.\n\n### When to use xlrd3\nIf you just need to **read** and deal with both `xlsx` and `xls`, use `xlrd3`. \nThen if you want to export your data to other excel files, use [OpenPyXL](https://openpyxl.readthedocs.io/en/stable/) or [xlsxWriter](https://github.com/jmcnamara/XlsxWriter).\nIf you need to **edit** `xlsx` (read and write) and are sure that `xls` never appear in your workflow, you are advised to use [OpenPyXL](https://openpyxl.readthedocs.io/en/stable/) instead.\n\n\n**Purpose**: Provide a library for developers to use to extract data from Microsoft Excel (tm) spreadsheet files. It is not an end-user tool.\n\n**Original Author**: John Machin\n\n**Licence**: BSD-style (see licences.py)\n\n**Versions of Python supported**: 3.6+.\n\n**Outside scope**: xlrd3 will safely and reliably ignore any of these if present in the file:\n\n* Charts, Macros, Pictures, any other embedded object. WARNING: currently this includes embedded worksheets.\n* VBA modules\n* Formulas (results of formula calculations are extracted, of course).\n* Comments\n* Hyperlinks\n* Autofilters, advanced filters, pivot tables, conditional formatting, data validation\n* Handling password-protected (encrypted) files.\n\n**Installation**:`$pip install xlrd3`\n\n**Quick start**:\n\n```python\nimport xlrd3 as xlrd\nbook = xlrd.open_workbook(\"myfile.xls\")\nprint(\"The number of worksheets is {0}\".format(book.nsheets))\nprint(\"Worksheet name(s): {0}\".format(book.sheet_names()))\nsh = book.sheet_by_index(0)\nprint(\"{0} {1} {2}\".format(sh.name, sh.nrows, sh.ncols))\nprint(\"Cell D30 is {0}\".format(sh.cell_value(rowx=29, colx=3)))\nfor rx in range(sh.nrows):\n print(sh.row(rx))\n```\n\n**Another quick start**: This will show the first, second and last rows of each sheet in each file:\n\n python PYDIR/scripts/runxlrd.py 3rows *blah*.xls\n\n**Acknowledgements**:\n\n* 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 <david@giffin.org>.\"\n* 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\n* U+5F20 U+654F: over a decade of inspiration, support, and interesting decoding opportunities.\n* Ksenia Marasanova: sample Macintosh and non-Latin1 files, alpha testing\n* Backporting to Python 2.1 was partially funded by Journyx - provider of timesheet and project accounting solutions (http://journyx.com/).\n* Provision of formatting information in version 0.6.1 was funded by Simplistix Ltd (http://www.simplistix.co.uk/)\n\n\n",
"bugtrack_url": null,
"license": "BSD",
"summary": "Library for developers to extract data from Microsoft Excel (tm) spreadsheet files",
"version": "1.1.0",
"project_urls": {
"Homepage": "https://github.com/Dragon2fly/xlrd3"
},
"split_keywords": [
"xls",
"xlsx",
"excel",
"spreadsheet",
"workbook"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "5d08fce745025e58f160e7dcb5a45d4d43eb0bd44c0d8851425be87ef90271fa",
"md5": "73600d7544e2def5aa0de2cdabc9929a",
"sha256": "8e8e808f938144e7936a6e07c1d57be7a0f6c6f5b37c9c67974b43246d8aacb6"
},
"downloads": -1,
"filename": "xlrd3-1.1.0-py2.py3-none-any.whl",
"has_sig": false,
"md5_digest": "73600d7544e2def5aa0de2cdabc9929a",
"packagetype": "bdist_wheel",
"python_version": "py2.py3",
"requires_python": ">=3.6",
"size": 105268,
"upload_time": "2021-04-25T12:26:55",
"upload_time_iso_8601": "2021-04-25T12:26:55.264872Z",
"url": "https://files.pythonhosted.org/packages/5d/08/fce745025e58f160e7dcb5a45d4d43eb0bd44c0d8851425be87ef90271fa/xlrd3-1.1.0-py2.py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "79db88d8d49ddacc203956ecb98dc86c6ffeee6e933ef1f50da9b369de518f7f",
"md5": "ea7632f4e79250b643b39656eaae1e0e",
"sha256": "20e6ed2e5f7f8b4ab61e30faffebceff6fab348332b4c915373f0a72742dc177"
},
"downloads": -1,
"filename": "xlrd3-1.1.0.tar.gz",
"has_sig": false,
"md5_digest": "ea7632f4e79250b643b39656eaae1e0e",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 58919847,
"upload_time": "2021-04-25T12:27:10",
"upload_time_iso_8601": "2021-04-25T12:27:10.030497Z",
"url": "https://files.pythonhosted.org/packages/79/db/88d8d49ddacc203956ecb98dc86c6ffeee6e933ef1f50da9b369de518f7f/xlrd3-1.1.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2021-04-25 12:27:10",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Dragon2fly",
"github_project": "xlrd3",
"travis_ci": true,
"coveralls": false,
"github_actions": false,
"tox": true,
"lcname": "xlrd3"
}
JSON
