{
    "info": {
        "author": "team useblocks",
        "author_email": "groundwork@useblocks.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 3 - Alpha",
            "Environment :: Console",
            "Intended Audience :: Developers",
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python",
            "Programming Language :: Python :: 2",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6"
        ],
        "description": "groundwork-spreadsheets\n-----------------------\n\nGroundwork patterns to read and write spreadsheet documents. Excel 2010 (xlsx, xlsm) is supported at the moment.\nThe full documentation is available at https://groundwork-spreadsheets.readthedocs.io/\n\nFor more information regarding groundwork, see `here <https://groundwork.readthedocs.io.>`_.\n\n**ExcelValidationPattern**\n\n*   Uses the library `openpyxl <https://openpyxl.readthedocs.io/en/default/>`_\n*   Can read Excel 2010 files (xlsx, xlsm)\n*   Configure your sheet using a json file\n*   Auto detect columns by names\n*   Layout can be\n\n    *   column based: headers are in a single *row* and data is below\n    *   row based: headers are in a single *column* and data is right of the headers\n\n*   Define column types and verify cell values against them\n\n    *   Date\n    *   Enums (e.g. only  the values 'yes' and 'no' are allowed)\n    *   Floating point numbers with optional min/max check\n    *   Integer numbers with optional min/max check\n    *   String with optional regular expression pattern check\n\n*   Exclude data row/columns based on filter criteria\n*   Output is a dictionary of the following form ``row or column number`` -> ``header name`` -> ``cell value``\n*   Extensive logging of problems\n\nHere is how an example json config file looks like::\n\n    {\n        \"sheet_config\": \"last\",\n        \"orientation\": \"column_based\",\n        \"headers_index_config\": {\n            \"row_index\": {\n                \"first\": 1,\n                \"last\": \"automatic\"\n            },\n            \"column_index\": {\n                \"first\": \"automatic\",\n                \"last\": \"severalEmptyCells:3\"\n            }\n        },\n        \"data_index_config\": {\n            \"row_index\": {\n                \"first\": 2,\n                \"last\": \"automatic\"\n            },\n            \"column_index\": {\n                \"first\": \"automatic\",\n                \"last\": \"automatic\"\n            }\n        },\n        \"data_type_config\": [\n            {\n                \"header\": \"hex number\",\n                \"fail_on_type_error\": true,\n                \"fail_on_empty_cell\": false,\n                \"fail_on_header_not_found\": true,\n                \"type\": {\n                    \"base\": \"string\",\n                    \"pattern\": \"^0x[A-F0-9]{6}$\"\n                }\n            },\n            {\n                \"header\": \"int number\",\n                \"type\": {\n                    \"base\": \"integer\",\n                    \"minimum\": 2\n                }\n            }\n        ]\n    }",
        "description_content_type": null,
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "http://groundwork-spreadsheets.readthedocs.io",
        "keywords": "",
        "license": "MIT license",
        "maintainer": "",
        "maintainer_email": "",
        "name": "groundwork-spreadsheets",
        "package_url": "https://pypi.org/project/groundwork-spreadsheets/",
        "platform": "any",
        "project_url": "https://pypi.org/project/groundwork-spreadsheets/",
        "project_urls": {
            "Homepage": "http://groundwork-spreadsheets.readthedocs.io"
        },
        "release_url": "https://pypi.org/project/groundwork-spreadsheets/0.3.0/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Patterns for reading writing spreadsheet documents",
        "version": "0.3.0"
    },
    "last_serial": 3120598,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7cd74e9be15706ab4928e33f5f0ab82e",
                    "sha256": "be9f28bc5363cb9dd142f6c58e46bae466a090d9f59755692e372ca0c6e1d245"
                },
                "downloads": -1,
                "filename": "groundwork_spreadsheets-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "7cd74e9be15706ab4928e33f5f0ab82e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8073,
                "upload_time": "2017-08-21T08:58:49",
                "url": "https://files.pythonhosted.org/packages/3c/6f/094788f1a7b40039ff0a68b7a72f03c2835d8d8f27cabade74d5c900e2f3/groundwork_spreadsheets-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9835c9b8b52320e6bf25a903a221fdb5",
                    "sha256": "c3ddfb4ff07c5e49026ed6ca8e1a68869bcd64b2fa1d8aa05433ec431c5e5d81"
                },
                "downloads": -1,
                "filename": "groundwork_spreadsheets-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "9835c9b8b52320e6bf25a903a221fdb5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8268,
                "upload_time": "2017-08-21T09:19:30",
                "url": "https://files.pythonhosted.org/packages/28/14/5d9e588d17ee117cb497d1678384ab6ed684f41fe380abfdf27943655b76/groundwork_spreadsheets-0.1.1.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "d9b4479d395b86867aca134a557ea512",
                    "sha256": "941cfc0974c9439d352945dbd9a7d16e01cc24cfb1cbafd225d26c7055bd0241"
                },
                "downloads": -1,
                "filename": "groundwork_spreadsheets-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "d9b4479d395b86867aca134a557ea512",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 8502,
                "upload_time": "2017-08-22T14:15:47",
                "url": "https://files.pythonhosted.org/packages/29/ca/950b1195d1df4abc393621473b05b3408ebbe5e024253c2b6b9c2630c67d/groundwork_spreadsheets-0.1.2.tar.gz"
            }
        ],
        "0.2.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "d191ebef38bad36e60207f9251dd6d42",
                    "sha256": "3711753d053d05d2d801a1531119140521edffd902369f39763e715140d9d1b8"
                },
                "downloads": -1,
                "filename": "groundwork_spreadsheets-0.2.0.tar.gz",
                "has_sig": false,
                "md5_digest": "d191ebef38bad36e60207f9251dd6d42",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9233,
                "upload_time": "2017-08-23T15:46:18",
                "url": "https://files.pythonhosted.org/packages/78/cf/9576431ecf4e79d708153fa69fecee9481b8152cc5cd1a215f3abcfc56df/groundwork_spreadsheets-0.2.0.tar.gz"
            }
        ],
        "0.3.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "6fe87d7d339938e1c4b9c8f2fb486c1d",
                    "sha256": "e3712f771b08550f62b7ae1f2458a513465b18f4eaaeaff005b50de1a2785b50"
                },
                "downloads": -1,
                "filename": "groundwork_spreadsheets-0.3.0.tar.gz",
                "has_sig": false,
                "md5_digest": "6fe87d7d339938e1c4b9c8f2fb486c1d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 9761,
                "upload_time": "2017-08-24T14:38:17",
                "url": "https://files.pythonhosted.org/packages/36/82/bac84025329bb1e4ea46fb826f7b08ecde86798a031d0e9a28ff2b55863e/groundwork_spreadsheets-0.3.0.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "6fe87d7d339938e1c4b9c8f2fb486c1d",
                "sha256": "e3712f771b08550f62b7ae1f2458a513465b18f4eaaeaff005b50de1a2785b50"
            },
            "downloads": -1,
            "filename": "groundwork_spreadsheets-0.3.0.tar.gz",
            "has_sig": false,
            "md5_digest": "6fe87d7d339938e1c4b9c8f2fb486c1d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 9761,
            "upload_time": "2017-08-24T14:38:17",
            "url": "https://files.pythonhosted.org/packages/36/82/bac84025329bb1e4ea46fb826f7b08ecde86798a031d0e9a28ff2b55863e/groundwork_spreadsheets-0.3.0.tar.gz"
        }
    ]
}