{ "info": { "author": "Kevin Ryan", "author_email": "ktr@26ocb.com", "bugtrack_url": null, "classifiers": [ "Development Status :: 3 - Alpha", "Intended Audience :: Developers", "License :: OSI Approved :: MIT License", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7", "Topic :: Office/Business", "Topic :: Software Development :: Build Tools", "Topic :: Software Development :: Libraries" ], "description": "============\nsxl Overview\n============\n\nThis library is intended to help you deal with big Excel files from within\nPython. After trying pandas_, openpyxl_, xlwings_, and even win32com_ it seems\nthat none have the ability to iterate over large Excel files without loading\nthem completely into memory. So when you are dealing with files that are\nextremely large, this can be burdensome (especially if you only want to examine\na bit of the file - the first 10 rows say). This library solves that by parsing\nthe SpreadsheetML / XML xlsx files using a streaming parser. So you can see the\nfirst ten rows of any tab within any Excel file extremely quickly.\n\nGetting Started\n===============\n\nThere are no dependancies to install. You just need to::\n\n pip install sxl\n\nOnce installed, you can iterate through the entire file without using much\nmemory by doing the following::\n\n from sxl import Workbook\n wb = Workbook(\"filepath\")\n ws = wb.sheets['sheet name'] # or, for example, wb.sheets[1]\n for row in ws.rows:\n print(row)\n\nIf you are only interested in a few rows::\n\n head = ws.head(5)\n print(head)\n\n\nRunning Tests\n=============\n\nTo run tests::\n\n python -m tests.test_sxl\n\nLicense\n=======\n\nThe project is licensed under the MIT License - see the LICENSE.md_ file for\ndetails\n\n.. _openpyxl: https://openpyxl.readthedocs.io/en/stable/\n.. _xlwings: http://docs.xlwings.org/en/stable/quickstart.html\n.. _win32com: http://docs.activestate.com/activepython/2.4/pywin32/html/com/win32com/HTML/docindex.html\n.. _pandas: https://pandas.pydata.org/\n.. _license.md: /LICENSE.txt\n.. _lax: http://www.dictionary.com/browse/lax?s=t\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/ktr/sxl", "keywords": "data excel xlsx", "license": "MIT", "maintainer": "", "maintainer_email": "", "name": "sxl", "package_url": "https://pypi.org/project/sxl/", "platform": "", "project_url": "https://pypi.org/project/sxl/", "project_urls": { "Homepage": "https://github.com/ktr/sxl" }, "release_url": "https://pypi.org/project/sxl/0.0.1a3/", "requires_dist": null, "requires_python": "", "summary": "A python module to deal with (very) big Excel files.", "version": "0.0.1a3" }, "last_serial": 4369551, "releases": { "0.0.1a1": [ { "comment_text": "", "digests": { "md5": "a44bfe8f6ed2c1c901a812f0618ac131", "sha256": "4d7909ee9063547a08c988be295b82b85b291990880c193ef6f7631b8c72e808" }, "downloads": -1, "filename": "sxl-0.0.1a1-py3-none-any.whl", "has_sig": false, "md5_digest": "a44bfe8f6ed2c1c901a812f0618ac131", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8089, "upload_time": "2018-05-06T18:49:10", "url": "https://files.pythonhosted.org/packages/93/50/5c31ba28663f927084e026d47f92da7794f76a59d527f5aaf640088bb991/sxl-0.0.1a1-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "cf5348e2b8d878cda31e8cae05ee4f4b", "sha256": "c626a686fa4dafb325082ccf791865c46ce93d4efee8d0e533509603ff4cb8b7" }, "downloads": -1, "filename": "sxl-0.0.1a1.tar.gz", "has_sig": false, "md5_digest": "cf5348e2b8d878cda31e8cae05ee4f4b", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6388, "upload_time": "2018-05-06T18:49:11", "url": "https://files.pythonhosted.org/packages/ef/da/40b4cd7e8e75a423c22719baa5be2ed8070dd9b3b39ccc93f94666b1397d/sxl-0.0.1a1.tar.gz" } ], "0.0.1a2": [ { "comment_text": "", "digests": { "md5": "bcbb9cef897dfabfb64e262fec4874fa", "sha256": "a69d5ba2414b2822b39b92f6e14caea2827b19c905c14e6b90fa53c903358742" }, "downloads": -1, "filename": "sxl-0.0.1a2-py3-none-any.whl", "has_sig": false, "md5_digest": "bcbb9cef897dfabfb64e262fec4874fa", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8129, "upload_time": "2018-05-07T01:51:52", "url": "https://files.pythonhosted.org/packages/5e/e4/a8ddbf9263f848c48b5b8bc557906f7e4fbb770dfdbee94ce98ac4341be0/sxl-0.0.1a2-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "e3f0edda105c6557b61c08b74e288e56", "sha256": "00ecbfb7a92f751cb74a94047c839a38b951d2917a3c81b2163ec2691dd8407f" }, "downloads": -1, "filename": "sxl-0.0.1a2.tar.gz", "has_sig": false, "md5_digest": "e3f0edda105c6557b61c08b74e288e56", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6432, "upload_time": "2018-05-07T01:51:54", "url": "https://files.pythonhosted.org/packages/60/59/6bb4f2a564c0a0e75054bca28e0ec9e35977ba914363f6ed729ba7423465/sxl-0.0.1a2.tar.gz" } ], "0.0.1a3": [ { "comment_text": "", "digests": { "md5": "b5da9eaa13adac11fa3b2e59aa8edc25", "sha256": "a704e91182d77665101983a70368ba33a9f58f194712326822d671d824a8af4c" }, "downloads": -1, "filename": "sxl-0.0.1a3-py3-none-any.whl", "has_sig": false, "md5_digest": "b5da9eaa13adac11fa3b2e59aa8edc25", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8206, "upload_time": "2018-10-12T17:38:46", "url": "https://files.pythonhosted.org/packages/88/3c/a79d157068155c1347f27f196e90424b03e30d1a48fc2b77e2524e6d064e/sxl-0.0.1a3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b88dc559dca07b1829891a63e12a225d", "sha256": "373e8de8b5d9699a57bd13513f5166d627bf99e9199c1c9bb19c71d4c6b5e4e6" }, "downloads": -1, "filename": "sxl-0.0.1a3.tar.gz", "has_sig": false, "md5_digest": "b88dc559dca07b1829891a63e12a225d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6519, "upload_time": "2018-10-12T17:39:01", "url": "https://files.pythonhosted.org/packages/62/ab/cc029c2c5a345f2039fdefc3963490457ff64c49552219d2111db09688ec/sxl-0.0.1a3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "b5da9eaa13adac11fa3b2e59aa8edc25", "sha256": "a704e91182d77665101983a70368ba33a9f58f194712326822d671d824a8af4c" }, "downloads": -1, "filename": "sxl-0.0.1a3-py3-none-any.whl", "has_sig": false, "md5_digest": "b5da9eaa13adac11fa3b2e59aa8edc25", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 8206, "upload_time": "2018-10-12T17:38:46", "url": "https://files.pythonhosted.org/packages/88/3c/a79d157068155c1347f27f196e90424b03e30d1a48fc2b77e2524e6d064e/sxl-0.0.1a3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "b88dc559dca07b1829891a63e12a225d", "sha256": "373e8de8b5d9699a57bd13513f5166d627bf99e9199c1c9bb19c71d4c6b5e4e6" }, "downloads": -1, "filename": "sxl-0.0.1a3.tar.gz", "has_sig": false, "md5_digest": "b88dc559dca07b1829891a63e12a225d", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6519, "upload_time": "2018-10-12T17:39:01", "url": "https://files.pythonhosted.org/packages/62/ab/cc029c2c5a345f2039fdefc3963490457ff64c49552219d2111db09688ec/sxl-0.0.1a3.tar.gz" } ] }