{
    "info": {
        "author": "spmassot",
        "author_email": "spmassot@gmail.com",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "# xlsxmetadata\nReally lightweight lib for peeking into xlsx column/row size before you try to open the file with something else\n\n### setup\n```pip install xlsxmetadata```\n\n### reading from file...\n```python\nfrom xlsxmetadata.metadata import get_dimensions, get_sheet_names\n\nmy_big_file = '/path/to/my/real_big_file.xlsx'\n\nsheet_names = get_sheet_names(my_big_file)\nprint(sheet_names)\n\n>>> {'test_sheet': 1}\n\ndimensions = get_dimensions('/path/to/my/real_big_workbook.xlsx', 'test_sheet')\nprint(dimensions['end_column'])\n\n>>> 16834\n\nprint(dimensions['end_row'])\n\n>>> 1200000\n```\n\n### reading from flask form...\n```python\nfrom io import BytesIO\nfrom xlsxmetadata.metadata import get_dimensions, get_sheet_names\n\nmy_big_file = request.files.get('my_big_file')\n\nsheet_names = get_sheet_names(BytesIO(my_big_file.read()))\nprint(sheet_names)\n\n>>> {'test_sheet': 1}\n\n# you will probably have to reset the read-head\nmy_big_file.seek(0)\n\ndimensions = get_dimensions(BytesIO(my_big_file.read()), 'test_sheet')\nprint(dimensions['end_column'])\n\n>>> 16834\n\nprint(dimensions['end_row'])\n\n>>> 1200000\n```\n\nThis information is stored as metadata in the first few bytes of `.xlsx` files. For some reason no other libraries (xlrd, openpyxl) seem to give the users access to this data directly.\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/spmassot/xlsxmetadata",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "xlsxmetadata",
        "package_url": "https://pypi.org/project/xlsxmetadata/",
        "platform": "",
        "project_url": "https://pypi.org/project/xlsxmetadata/",
        "project_urls": {
            "Homepage": "https://github.com/spmassot/xlsxmetadata"
        },
        "release_url": "https://pypi.org/project/xlsxmetadata/0.0.5/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Really lightweight lib for peeking into xlsx column/row size before you try to open the file with something else",
        "version": "0.0.5"
    },
    "last_serial": 4200504,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4742b35b7d2ddab83cff75d24125cf5f",
                    "sha256": "8f1a0fb35a8ee8628ebd9bf1ea1531382655961b2022edb4811f188ec99f1dd2"
                },
                "downloads": -1,
                "filename": "xlsxmetadata-0.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "4742b35b7d2ddab83cff75d24125cf5f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2004,
                "upload_time": "2018-08-07T01:28:32",
                "url": "https://files.pythonhosted.org/packages/53/88/79e000e472981beddb642fc569ed92dcf7b7456db927858e967580a245f7/xlsxmetadata-0.0.1.tar.gz"
            }
        ],
        "0.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "835daba47d65b767a7c78822b849dbcd",
                    "sha256": "97380d57ac9bcdcae2fbee1de95db542a697ad2604aabc56c46ad18b3e038809"
                },
                "downloads": -1,
                "filename": "xlsxmetadata-0.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "835daba47d65b767a7c78822b849dbcd",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2007,
                "upload_time": "2018-08-07T01:37:26",
                "url": "https://files.pythonhosted.org/packages/a6/36/06262fef4ec25a2171afbe39acd49b29c33b48e08c81bfd2eb998e40ac61/xlsxmetadata-0.0.2.tar.gz"
            }
        ],
        "0.0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "49710e480d3f8f2a546bbbead20b6f72",
                    "sha256": "a0c423ddef578e57d06902b6f7b09879152911777fd2ad0b934e763ed57d5d50"
                },
                "downloads": -1,
                "filename": "xlsxmetadata-0.0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "49710e480d3f8f2a546bbbead20b6f72",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2057,
                "upload_time": "2018-08-07T18:51:20",
                "url": "https://files.pythonhosted.org/packages/1d/3e/f521be70a857fc5b82a5779c09309a3743e2708b6b5a798d52766217a98f/xlsxmetadata-0.0.3.tar.gz"
            }
        ],
        "0.0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "543d8ca70749e05086e2b6fd2196f51e",
                    "sha256": "2f3086391d93011fc4291dabd8d8aac6e3c135b595056db11e2e94101bcf8ce1"
                },
                "downloads": -1,
                "filename": "xlsxmetadata-0.0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "543d8ca70749e05086e2b6fd2196f51e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2131,
                "upload_time": "2018-08-07T19:02:16",
                "url": "https://files.pythonhosted.org/packages/73/0a/b2bd81bf20cdce892566132be399879f0c3e5cde6487594675c7dfce6df4/xlsxmetadata-0.0.4.tar.gz"
            }
        ],
        "0.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "07a2410dcafa8b22e20457b3594a8bbc",
                    "sha256": "29af36783a2a220fe43392b67ff768938151f2bb24a09db68a405444e6715ea7"
                },
                "downloads": -1,
                "filename": "xlsxmetadata-0.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "07a2410dcafa8b22e20457b3594a8bbc",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2204,
                "upload_time": "2018-08-23T16:00:25",
                "url": "https://files.pythonhosted.org/packages/f7/80/f61185d6a7492ae72eb47b21d2e52368669418dd70923a27dfd796fd7689/xlsxmetadata-0.0.5.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "07a2410dcafa8b22e20457b3594a8bbc",
                "sha256": "29af36783a2a220fe43392b67ff768938151f2bb24a09db68a405444e6715ea7"
            },
            "downloads": -1,
            "filename": "xlsxmetadata-0.0.5.tar.gz",
            "has_sig": false,
            "md5_digest": "07a2410dcafa8b22e20457b3594a8bbc",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 2204,
            "upload_time": "2018-08-23T16:00:25",
            "url": "https://files.pythonhosted.org/packages/f7/80/f61185d6a7492ae72eb47b21d2e52368669418dd70923a27dfd796fd7689/xlsxmetadata-0.0.5.tar.gz"
        }
    ]
}