{ "info": { "author": "William Turner", "author_email": "willtur.will@gmail.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 5 - Production/Stable", "License :: OSI Approved :: GNU Lesser General Public License v3 or later (LGPLv3+)", "Programming Language :: Python :: 2", "Programming Language :: Python :: 2.7", "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6" ], "description": "pyxlsb\n======\n\n|PyPI|\n\n``pyxlsb`` is an Excel 2007-2010 Binary Workbook (xlsb) parser for\nPython. The library is currently extremely limited, but functional\nenough for basic data extraction.\n\nInstall\n-------\n\n.. code:: bash\n\n pip install pyxlsb\n\nUsage\n-----\n\nThe module exposes an ``open_workbook(name)`` method (similar to Xlrd\nand OpenPyXl) for opening XLSB files. The Workbook object representing\nthe file is returned.\n\n.. code:: python\n\n from pyxlsb import open_workbook\n with open_workbook('Book1.xlsb') as wb:\n # Do stuff with wb\n\nThe Workbook object exposes a ``get_sheet(idx)`` method for retrieving a\nWorksheet instance.\n\n.. code:: python\n\n # Using the sheet index (1-based)\n with wb.get_sheet(1) as sheet:\n # Do stuff with sheet\n\n # Using the sheet name\n with wb.get_sheet('Sheet1') as sheet:\n # Do stuff with sheet\n\nTip: A ``sheets`` property containing the sheet names is available on\nthe Workbook instance.\n\nThe ``rows()`` method will hand out an iterator to read the worksheet\nrows.\n\n.. code:: python\n\n # You can use .rows(sparse=True) to skip empty rows\n for row in sheet.rows():\n print(row)\n # [Cell(r=0, c=0, v='TEXT'), Cell(r=0, c=1, v=42.1337)]\n\nDo note that dates will appear as floats. You must use the\n``convert_date(date)`` method from the ``pyxlsb`` module to turn them\ninto ``datetime`` instances.\n\n.. code:: python\n\n from pyxlsb import convert_date\n print(convert_date(41235.45578))\n # datetime.datetime(2012, 11, 22, 10, 56, 19)\n\n.. |PyPI| image:: https://img.shields.io/pypi/v/pyxlsb.svg\n :target: https://pypi.python.org/pypi/pyxlsb\n\n\n", "description_content_type": "", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/wwwiiilll/pyxlsb", "keywords": "", "license": "LGPLv3+", "maintainer": "", "maintainer_email": "", "name": "pyxlsb", "package_url": "https://pypi.org/project/pyxlsb/", "platform": "", "project_url": "https://pypi.org/project/pyxlsb/", "project_urls": { "Homepage": "https://github.com/wwwiiilll/pyxlsb" }, "release_url": "https://pypi.org/project/pyxlsb/1.0.5/", "requires_dist": null, "requires_python": "", "summary": "Excel 2007-2010 Binary Workbook (xlsb) parser", "version": "1.0.5" }, "last_serial": 5239399, "releases": { "1.0.1": [ { "comment_text": "", "digests": { "md5": "40723ff5594d06825c0c0f1d2ff62088", "sha256": "03607407f3284496450fa1b0c5fbfef311fcde71c9faddfbf83d394d483180f0" }, "downloads": -1, "filename": "pyxlsb-1.0.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "40723ff5594d06825c0c0f1d2ff62088", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9668, "upload_time": "2017-09-27T15:13:29", "url": "https://files.pythonhosted.org/packages/dc/7c/6a8a13dbedc3ae23553f6742dfccc8c52d0d23ceee0219b4bdafeb194ef1/pyxlsb-1.0.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "33e6a57b352194177cdf0ec2961a342a", "sha256": "c3ca3597bec46527c064f970fe50f826fa6494a740c8a5f5c34bc932cfbe391e" }, "downloads": -1, "filename": "pyxlsb-1.0.1.tar.gz", "has_sig": false, "md5_digest": "33e6a57b352194177cdf0ec2961a342a", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6810, "upload_time": "2017-09-27T15:13:31", "url": "https://files.pythonhosted.org/packages/e6/2c/9a5f52049afa7d25712ed5cedd8fc1844572537cb20cbb829e36a67f8135/pyxlsb-1.0.1.tar.gz" } ], "1.0.2": [ { "comment_text": "", "digests": { "md5": "3b00e12ad183892397a64c44a47460b0", "sha256": "e9d119c62e0e2df5376c6bce8409a2e09acb6b804855e1f4d80de10a21e71b35" }, "downloads": -1, "filename": "pyxlsb-1.0.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "3b00e12ad183892397a64c44a47460b0", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9853, "upload_time": "2017-11-22T07:02:44", "url": "https://files.pythonhosted.org/packages/18/13/7af2714a7bf29165522496f31d3972bbc999abf694cc3acbe424d8ad3d95/pyxlsb-1.0.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "aee0eb59930071c266c3db5c9885a2c7", "sha256": "b6eaa8ef4a7cb5c4a9eb879b240fca3cfc469591a767892b40f98efe46916720" }, "downloads": -1, "filename": "pyxlsb-1.0.2.tar.gz", "has_sig": false, "md5_digest": "aee0eb59930071c266c3db5c9885a2c7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21667, "upload_time": "2017-11-22T07:02:47", "url": "https://files.pythonhosted.org/packages/d0/5a/085ba2b89354426284dde1fffa2fef5c2f2665c18b1edb6dfddba746f15c/pyxlsb-1.0.2.tar.gz" } ], "1.0.3": [ { "comment_text": "", "digests": { "md5": "e7da5d690e13c88ed47c291ba9344f04", "sha256": "0f45b1884dd9514fe017b879786c5ea55428153191c588b4c81ae1bb7336df83" }, "downloads": -1, "filename": "pyxlsb-1.0.3-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "e7da5d690e13c88ed47c291ba9344f04", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 10143, "upload_time": "2017-11-23T18:14:59", "url": "https://files.pythonhosted.org/packages/b6/be/758cfeab566ee18c4ac1ec8a084eaf996a5cee4ceed31bd0ac4f84a1827a/pyxlsb-1.0.3-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b011d406417a55a26c52717944f74541", "sha256": "d73b2e73b80882629777d653f8895f4fb52cee9f4fac0c780077dd2eb583d238" }, "downloads": -1, "filename": "pyxlsb-1.0.3.tar.gz", "has_sig": false, "md5_digest": "b011d406417a55a26c52717944f74541", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 22426, "upload_time": "2017-11-23T18:15:00", "url": "https://files.pythonhosted.org/packages/02/41/fc530289d75f27dc4ebf60c1a7312aad6157cecebbff9a87032026500eee/pyxlsb-1.0.3.tar.gz" } ], "1.0.4": [ { "comment_text": "", "digests": { "md5": "250d20fbd99337f205e660ea931fbc84", "sha256": "ab5a5cce3c18a200483260c051dc1bda24e404e64d68f0f8dc2987c8ba58d8d1" }, "downloads": -1, "filename": "pyxlsb-1.0.4-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "250d20fbd99337f205e660ea931fbc84", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 23577, "upload_time": "2018-10-31T23:30:48", "url": "https://files.pythonhosted.org/packages/37/f0/6dff9a359b7e82550fa565b38fdf1f21fea67ec8e02aee4162df0e0cc759/pyxlsb-1.0.4-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "ad777ded0aa7649955a929de98680bf5", "sha256": "c489d71fb301cf8aefd31968cd1f0068bceda109cbfabfdfb388bdbc4c7e507a" }, "downloads": -1, "filename": "pyxlsb-1.0.4.tar.gz", "has_sig": false, "md5_digest": "ad777ded0aa7649955a929de98680bf5", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21128, "upload_time": "2018-10-31T23:30:49", "url": "https://files.pythonhosted.org/packages/4d/55/403e12f6146284baad38eb95f9a7802bf3edadc59c5f1ed993840a12c19c/pyxlsb-1.0.4.tar.gz" } ], "1.0.5": [ { "comment_text": "", "digests": { "md5": "47104925f32c7216775085aab300d987", "sha256": "b8755bdf0b0fd6ac4a52c04fd102a81972370f73d9621e6ec232fd23c8aa8dfc" }, "downloads": -1, "filename": "pyxlsb-1.0.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "47104925f32c7216775085aab300d987", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 23579, "upload_time": "2019-05-07T18:42:42", "url": "https://files.pythonhosted.org/packages/9f/b3/229b713cc0897c0902cb6a3fee76f4eec4b659d9028d4dc515d4930b5daa/pyxlsb-1.0.5-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b86b533f5b9b170a8fb18b28bffe3cd2", "sha256": "de222defee2460958bbdc42e803c5b92ead569ff1d9c730b4176a398ef917030" }, "downloads": -1, "filename": "pyxlsb-1.0.5.tar.gz", "has_sig": false, "md5_digest": "b86b533f5b9b170a8fb18b28bffe3cd2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21116, "upload_time": "2019-05-07T18:42:43", "url": "https://files.pythonhosted.org/packages/28/3e/184c0b5d1c7b94595c9b65bbd1f5e5aed305b2369f83924119ad414cd02e/pyxlsb-1.0.5.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "47104925f32c7216775085aab300d987", "sha256": "b8755bdf0b0fd6ac4a52c04fd102a81972370f73d9621e6ec232fd23c8aa8dfc" }, "downloads": -1, "filename": "pyxlsb-1.0.5-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "47104925f32c7216775085aab300d987", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 23579, "upload_time": "2019-05-07T18:42:42", "url": "https://files.pythonhosted.org/packages/9f/b3/229b713cc0897c0902cb6a3fee76f4eec4b659d9028d4dc515d4930b5daa/pyxlsb-1.0.5-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b86b533f5b9b170a8fb18b28bffe3cd2", "sha256": "de222defee2460958bbdc42e803c5b92ead569ff1d9c730b4176a398ef917030" }, "downloads": -1, "filename": "pyxlsb-1.0.5.tar.gz", "has_sig": false, "md5_digest": "b86b533f5b9b170a8fb18b28bffe3cd2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 21116, "upload_time": "2019-05-07T18:42:43", "url": "https://files.pythonhosted.org/packages/28/3e/184c0b5d1c7b94595c9b65bbd1f5e5aed305b2369f83924119ad414cd02e/pyxlsb-1.0.5.tar.gz" } ] }