{
    "info": {
        "author": "Sebastian Matias Carreira",
        "author_email": "sebastian.m.carreira@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "# Openpyxl_utilities\n\nThis project consists of a library with functionalities to work with the popular module openpyxl (mainly used to read and write xlsx and xls files from Python) more efficiently. It was kickstarted when I found out openpyxl package does not includes sorting fucntionalities to create xlsx files already sorted (the only option available was to set a sorting button to sort the rows inside Microsoft Excel, not creating the file already sorted).\n\n### Prerequisites\n\nThis script is written in Python 3.6 using the following non-standard modules:\n* [openpyxl 2.5 or higher](https://github.com/chronossc/openpyxl)\n\n### Installing\n\nFirst, make sure you have the prerequisites installed using the following command:\n\n```\n$pip freeze\n```\n\nIf the list of installed modules does not includes openpyxl==2.5 or higher, run the following command:\n\n```\n$pip install openpyxl\n```\n\nOnce the prerequisites are fullfiled, install the module with the following command:\n\n```\n$pip install openpyxl_utilities\n```\n\nIf no errors are given, you can already import the module as any other module. To test if everything was correctly installed, run test.py, no error should rise.\n\n```\n$python test.py\n```\nIf you are sure everything was installed correctly but there were errors, feel free to open an issue and let me help you get it working. n.n\n\n### List of functions (up to dated with version 1.0)\n\n* list_values\n* adjust_col_width\n* print_sheet\n* empty_row\n* max_length_of_column\n* transpose\n* sort_sheet_by\n* apply_format\n* col_to_num\n* num_to_col\n\n### Authors\n\n* **Sebasti\u00c3\u00a1n Mat\u00c3\u00adas Carreira**\n\n### Acknowledgments\n\n* **Felipe Prenholato** - @chronossc : For his work on openpyxl, core module of these functions\n* **Nicol\u00c3\u00a1s Fusaro** - @mnfusaro : For his help in QA and debugging.\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/SebastianMCarreira/openpyxl_utils",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "openpyxl-utilities",
        "package_url": "https://pypi.org/project/openpyxl-utilities/",
        "platform": "",
        "project_url": "https://pypi.org/project/openpyxl-utilities/",
        "project_urls": {
            "Homepage": "https://github.com/SebastianMCarreira/openpyxl_utils"
        },
        "release_url": "https://pypi.org/project/openpyxl-utilities/0.5/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Library of functions with utilities for the popular xlsx Python module openpyxl",
        "version": "0.5"
    },
    "last_serial": 4235542,
    "releases": {
        "0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "f769c13d6c47ee4709c56313fc602715",
                    "sha256": "67b8a883d84be96d1ff7c02e998c65c8ac3480f1e7a8491432ac5e7405ab3010"
                },
                "downloads": -1,
                "filename": "openpyxl_utilities-0.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "f769c13d6c47ee4709c56313fc602715",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 3880,
                "upload_time": "2018-08-21T14:50:03",
                "url": "https://files.pythonhosted.org/packages/10/99/59388d28fe2a9d42c9f54d145b4a6a7503501e1e7b171260bce8a75f43f8/openpyxl_utilities-0.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "1c5f445433698dcce460d911b10a3a91",
                    "sha256": "6f91dc50038068de1844ca1f41a90eecdf4c382f26b8307d9eda0d16c6f6ef5b"
                },
                "downloads": -1,
                "filename": "openpyxl_utilities-0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "1c5f445433698dcce460d911b10a3a91",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3442,
                "upload_time": "2018-08-21T14:50:04",
                "url": "https://files.pythonhosted.org/packages/e7/6f/ab4856a418dfb3a3bce695ef73fe32cd4ce221faf41159c32d4aaddab0bd/openpyxl_utilities-0.2.tar.gz"
            }
        ],
        "0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "b6ccf22b8da533ab4ae38264f96bf27e",
                    "sha256": "ed73aaf5f5bd7d39d3aa9a7101f0f187714addd1b0a3925352505d99b52a8e77"
                },
                "downloads": -1,
                "filename": "openpyxl_utilities-0.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "b6ccf22b8da533ab4ae38264f96bf27e",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4300,
                "upload_time": "2018-08-27T13:33:52",
                "url": "https://files.pythonhosted.org/packages/46/63/76943fbe1b4910f270e035aa6be33c11dd501972152711ffd88659ac2f02/openpyxl_utilities-0.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "bf40105f64b25b4d71010a3769472921",
                    "sha256": "b2d35d858ddda255fa00c61005ee8547f44192d6e4d1d850bef8c8d95e305d99"
                },
                "downloads": -1,
                "filename": "openpyxl_utilities-0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "bf40105f64b25b4d71010a3769472921",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3985,
                "upload_time": "2018-08-27T13:33:54",
                "url": "https://files.pythonhosted.org/packages/b7/8f/20ebd98670fc331d1b77a50cc95e55427659eda59e341cde194bbc98da0c/openpyxl_utilities-0.3.tar.gz"
            }
        ],
        "0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ac35bb016f23b9adb06c775acc782af7",
                    "sha256": "1444025949fbd02f155032177c601877a2bc394211e76f4680135ee8b3cd8928"
                },
                "downloads": -1,
                "filename": "openpyxl_utilities-0.4-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "ac35bb016f23b9adb06c775acc782af7",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4303,
                "upload_time": "2018-08-27T13:53:59",
                "url": "https://files.pythonhosted.org/packages/05/1a/345ea248f4d97d54717a316bf2741a013eab3cae659aeb3158a4ad4c8a80/openpyxl_utilities-0.4-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "70c8a5eb93433e68b040d2d71190ed62",
                    "sha256": "5806791d38e310fff5b63b6117d032223917fbfa8558609847c1dae399d0e7d4"
                },
                "downloads": -1,
                "filename": "openpyxl_utilities-0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "70c8a5eb93433e68b040d2d71190ed62",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3974,
                "upload_time": "2018-08-27T13:54:02",
                "url": "https://files.pythonhosted.org/packages/a1/3a/700c28553bcac5aa076995187ad00f32e85c235cfbc1bd6a434f61f196d6/openpyxl_utilities-0.4.tar.gz"
            }
        ],
        "0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "5c53d283e4b4bfc9fb3749585ed5220c",
                    "sha256": "4d23446e6773c132c245e6d35ce8a7b565287e24877305d93134a9c7f167ffaf"
                },
                "downloads": -1,
                "filename": "openpyxl_utilities-0.5-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "5c53d283e4b4bfc9fb3749585ed5220c",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4655,
                "upload_time": "2018-09-03T20:53:42",
                "url": "https://files.pythonhosted.org/packages/af/c8/f4a1b3e93220d6413a880b98b18c6951fad374f52ac5204ca19e3e16d1a4/openpyxl_utilities-0.5-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "c72e96188026ac34695b34e9fa4f1c99",
                    "sha256": "9bc9f55ff6e1295079c4c4dacbb0348ba3bf035c9ae79267f408974fe457165b"
                },
                "downloads": -1,
                "filename": "openpyxl_utilities-0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "c72e96188026ac34695b34e9fa4f1c99",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4533,
                "upload_time": "2018-09-03T20:53:47",
                "url": "https://files.pythonhosted.org/packages/17/fe/66d09a0059fd6d4f3aafe1205bd12224cea4d1491d6b6ea40c9b5fcc0776/openpyxl_utilities-0.5.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "5c53d283e4b4bfc9fb3749585ed5220c",
                "sha256": "4d23446e6773c132c245e6d35ce8a7b565287e24877305d93134a9c7f167ffaf"
            },
            "downloads": -1,
            "filename": "openpyxl_utilities-0.5-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "5c53d283e4b4bfc9fb3749585ed5220c",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 4655,
            "upload_time": "2018-09-03T20:53:42",
            "url": "https://files.pythonhosted.org/packages/af/c8/f4a1b3e93220d6413a880b98b18c6951fad374f52ac5204ca19e3e16d1a4/openpyxl_utilities-0.5-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "c72e96188026ac34695b34e9fa4f1c99",
                "sha256": "9bc9f55ff6e1295079c4c4dacbb0348ba3bf035c9ae79267f408974fe457165b"
            },
            "downloads": -1,
            "filename": "openpyxl_utilities-0.5.tar.gz",
            "has_sig": false,
            "md5_digest": "c72e96188026ac34695b34e9fa4f1c99",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4533,
            "upload_time": "2018-09-03T20:53:47",
            "url": "https://files.pythonhosted.org/packages/17/fe/66d09a0059fd6d4f3aafe1205bd12224cea4d1491d6b6ea40c9b5fcc0776/openpyxl_utilities-0.5.tar.gz"
        }
    ]
}