{
    "info": {
        "author": "Pacharapol Withayasakpunt",
        "author_email": "patarapolw@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Programming Language :: Python :: 3",
            "Programming Language :: Python :: 3.5",
            "Programming Language :: Python :: 3.6",
            "Programming Language :: Python :: 3.7"
        ],
        "description": "# pyexcel-xlsxwx\n\n[![Build Status](https://travis-ci.org/patarapolw/pyexcel-xlsxwx.svg?branch=master)](https://travis-ci.org/patarapolw/pyexcel-xlsxwx)\n[![PyPI version shields.io](https://img.shields.io/pypi/v/pyexcel_xlsxwx.svg)](https://pypi.python.org/pypi/pyexcel_xlsxwx/)\n[![PyPI license](https://img.shields.io/pypi/l/pyexcel_xlsxwx.svg)](https://pypi.python.org/pypi/pyexcel_xlsxwx/)\n[![PyPI pyversions](https://img.shields.io/pypi/pyversions/pyexcel_xlsxwx.svg)](https://pypi.python.org/pypi/pyexcel_xlsxwx/)\n\nSave pyexcel data with XlsxWriter, while retaining good formatting.\n\n## Features\n\n- Allow setting column widths and word wrap.\n- A package for reading data is not included, please see [`pyexcel`'s plugins here](https://github.com/pyexcel/pyexcel#available-plugins).\n\n## Installation\n\n```commandline\n$ pip install pyexcel-xlsxwx\n```\nNote that `pyexcel` is not a dependency.\n\n## Usage\n\n```python\n>>> import pyexcel_xlsxwx\n>>> data = OrderedDict() # from collections import OrderedDict\n>>> data.update({\"Sheet 1\": [[1, 2, 3], [4, 5, 6]]})\n>>> data.update({\"Sheet 2\": [[\"row 1\", \"row 2\", \"row 3\"]]})\n>>> pyexcel_xlsxwx.save_data(\"your_file.xlsx\", data)\n```\n\nYou can also define a custom config via:\n```python\n>>> pyexcel_xlsxwx.save_data(\"your_file.xlsx\", data, config=config)\n```\nWhere config can be dictionary or path to YAML file.\n\nThe default YAML config is:\n\n```yaml\nworkbook:\n  constant_memory: true\n  strings_to_numbers: false\n  strings_to_formulas: false\n  strings_to_urls: true\nworksheet:\n  _default:\n    freeze_panes: A2\n#    column_width: 30\n    smart_fit: true\n    max_column_width: 30\nformat:\n  _default:\n    valign: top\n    text_wrap: true\n```\n`column_width` can also accept a list and a dictionary where key indicates the column.\n\n`row_height` can also be set the same way.\n\nTo cancel out `freeze_panes`, try:\n\n```python\n>>> pyexcel_xlsxwx.save_data(\"your_file.xlsx\", data, config={'worksheet': {'_default': {'freeze_panes': None}}})\n```\n\nThe settings will merge (thanks to https://stackoverflow.com/questions/20656135/python-deep-merge-dictionary-data), so that the other formattings won't be lost.\n\n## Related projects\n\n- [pyexcel-openpyxlx](https://github.com/patarapolw/pyexcel-openpyxlx) - export the styles for XlsxWriter.\n- [pyexcel-export](https://github.com/patarapolw/pyexcel-export) - operates using OpenPyXL, which seeming has bad word wrap support. However, the formatting can be well preserved.\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/patarapolw/pyexcel-xlsxwx",
        "keywords": "pyexcel,excel,xlsxwriter",
        "license": "MIT",
        "maintainer": "Pacharapol Withayasakpunt",
        "maintainer_email": "patarapolw@gmail.com",
        "name": "pyexcel-xlsxwx",
        "package_url": "https://pypi.org/project/pyexcel-xlsxwx/",
        "platform": "",
        "project_url": "https://pypi.org/project/pyexcel-xlsxwx/",
        "project_urls": {
            "Homepage": "https://github.com/patarapolw/pyexcel-xlsxwx"
        },
        "release_url": "https://pypi.org/project/pyexcel-xlsxwx/0.1.7/",
        "requires_dist": [
            "xlsxwriter (>=1.0,<2.0)",
            "ruamel.yaml (>=0.15.50,<0.16.0)",
            "importlib_resources (>=1.0,<2.0)"
        ],
        "requires_python": ">=3.5",
        "summary": "Save pyexcel data with XlsxWriter, while retaining good formatting.",
        "version": "0.1.7"
    },
    "last_serial": 4147314,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9b183ebc55882bda2412c6a90c7c18c5",
                    "sha256": "35c230293b70664af70a5056f02f5ef526e11e79d329daaf52730bf92fab606b"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "9b183ebc55882bda2412c6a90c7c18c5",
                "packagetype": "bdist_wheel",
                "python_version": "py2.py3",
                "requires_python": null,
                "size": 7093,
                "upload_time": "2018-08-06T12:50:31",
                "url": "https://files.pythonhosted.org/packages/0b/15/d2480e01a90af4534b7c89ec64477cffbdd5ddf340ac81d308b834d88358/pyexcel_xlsxwx-0.1.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "bc88e73f4c626d3288a2c364dcf12be3",
                    "sha256": "6667d4065186e06c97734b7328f4bdaa80456be6fd669bf7fe68c6df26dc6b3a"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "bc88e73f4c626d3288a2c364dcf12be3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3023,
                "upload_time": "2018-08-06T12:50:30",
                "url": "https://files.pythonhosted.org/packages/ff/74/4b45c412831bf6b6274e1a78ba534a8a433b480454595a5575e254f54005/pyexcel-xlsxwx-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ed89ec4ea8f6d3b742e17cbc5579803d",
                    "sha256": "ee10d58879fba6f52d7c0e1ffd8b313d99f204acfebdec881c86e074a0704b24"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "ed89ec4ea8f6d3b742e17cbc5579803d",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3",
                "size": 7092,
                "upload_time": "2018-08-06T12:52:04",
                "url": "https://files.pythonhosted.org/packages/ff/4f/095a7b6be39f91603e9e6fbfea97a58996620a9b9f033365a97012f5940e/pyexcel_xlsxwx-0.1.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "6a1dc0f41b6ef41636c2cef141a76ad3",
                    "sha256": "10e872065f5593600a63a78a13ec13b4d8dfc48b80c4029394be0b3cbea584b6"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "6a1dc0f41b6ef41636c2cef141a76ad3",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3",
                "size": 3037,
                "upload_time": "2018-08-06T12:52:02",
                "url": "https://files.pythonhosted.org/packages/db/cc/1b742ed192511268e5c9bb1527040f552f6322070b5a616deb8811fae0b3/pyexcel-xlsxwx-0.1.1.tar.gz"
            }
        ],
        "0.1.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "15e79909ff69d7f6292613f3e45b2951",
                    "sha256": "b786b25b8e341187c9277e25af00dbd0d684a0b95ab96d16da51278c689154ae"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "15e79909ff69d7f6292613f3e45b2951",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.5",
                "size": 8389,
                "upload_time": "2018-08-06T12:57:33",
                "url": "https://files.pythonhosted.org/packages/ea/5a/7c9702a41219cea6479cb0dc1e66987dd88c1cac73eeac5030fc9ecf3ff4/pyexcel_xlsxwx-0.1.1.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "724f8a50a0fb56a7d37db78eb408d2ae",
                    "sha256": "afb3a984bd18ab503d8b33db10e85f0206a2fbfb1b2c0f08749ef687fea4a1a5"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "724f8a50a0fb56a7d37db78eb408d2ae",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5",
                "size": 3707,
                "upload_time": "2018-08-06T12:57:31",
                "url": "https://files.pythonhosted.org/packages/ac/46/533275a494f8aae29db11d8b5bb624f4964a9fd09d2552a5a8e59f9744da/pyexcel-xlsxwx-0.1.1.1.tar.gz"
            }
        ],
        "0.1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "342048223ce4c3bb8ce9acc6a2f04012",
                    "sha256": "36c5cd0bb02fbefa06deb78f5bf9b46a5cb28244ffb045d9542d0180993a5b07"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "342048223ce4c3bb8ce9acc6a2f04012",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.5",
                "size": 9282,
                "upload_time": "2018-08-06T13:33:30",
                "url": "https://files.pythonhosted.org/packages/58/96/890a8f46f6b1826eb98facc4025db88b8d3513742dd977a7b1a46815f2b8/pyexcel_xlsxwx-0.1.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "1ba9278538633bce4a30dcf736d69995",
                    "sha256": "6b44c36dba7849af04b2b9a4b8a601a4e4e4d79b8b7fb1c39cd5ccd3b71918b7"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "1ba9278538633bce4a30dcf736d69995",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5",
                "size": 4191,
                "upload_time": "2018-08-06T13:33:28",
                "url": "https://files.pythonhosted.org/packages/f5/68/c74072f304b10cbbcc36b8cfaa1a58dade165db9cea9901f9f80a392b4bc/pyexcel-xlsxwx-0.1.2.tar.gz"
            }
        ],
        "0.1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "d05b4727cdc69d3108d2a8640ea39116",
                    "sha256": "fe3d32c2bf365dabd53dfd520553a9dc9fd4611d58a35aff763b04f57372f20f"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "d05b4727cdc69d3108d2a8640ea39116",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.5",
                "size": 9405,
                "upload_time": "2018-08-06T14:35:47",
                "url": "https://files.pythonhosted.org/packages/7a/68/5bf0438a7f88f691a786142368c61821e9a1cfa1243c5d275c1036ddb0b5/pyexcel_xlsxwx-0.1.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "cb009adb7988937675de96207c99f0ed",
                    "sha256": "edc262d76b3bb2b1696c208ea7c0747594aa640c19ba1b5b769a13c019f4a78d"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "cb009adb7988937675de96207c99f0ed",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5",
                "size": 4307,
                "upload_time": "2018-08-06T14:35:45",
                "url": "https://files.pythonhosted.org/packages/a5/af/4ae4a954e7a887bf1d59739160341abb3d5f0835b4b9dbbb10488422b842/pyexcel-xlsxwx-0.1.3.tar.gz"
            }
        ],
        "0.1.3.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "e922c1e1bf4f6d4e855c7c94e0820448",
                    "sha256": "b365e8048ef3135ec65b8c41e7d84805ff92526f6ad0abb3b26e06196adf7ba0"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.3.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "e922c1e1bf4f6d4e855c7c94e0820448",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.5",
                "size": 9428,
                "upload_time": "2018-08-06T14:47:46",
                "url": "https://files.pythonhosted.org/packages/35/a9/101272248dca07018333cc5230f31e601ffac96f47fcf5682af43dac1c0d/pyexcel_xlsxwx-0.1.3.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "ea00a1af0ce658b9980be0830cb2d124",
                    "sha256": "d311e44767c3b98605ff7b39352f8f88c8ef23155f23837002eabe6e1051cce5"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.3.1.tar.gz",
                "has_sig": false,
                "md5_digest": "ea00a1af0ce658b9980be0830cb2d124",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5",
                "size": 4321,
                "upload_time": "2018-08-06T14:47:45",
                "url": "https://files.pythonhosted.org/packages/bb/11/76d6c568f1a71eb1fc2779b4a602582355ccfdeefeac221d2f00774bef2c/pyexcel-xlsxwx-0.1.3.1.tar.gz"
            }
        ],
        "0.1.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bbff0a568ae9c25caed31e409fa94658",
                    "sha256": "b49cca5b8ff64d9e458ad6b1ebadf6471b5a807cf8a96bd3d59720ad57f129ad"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.4-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "bbff0a568ae9c25caed31e409fa94658",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.5",
                "size": 10128,
                "upload_time": "2018-08-07T03:57:02",
                "url": "https://files.pythonhosted.org/packages/05/67/28c83d91dd6afa48399e9aeccebeb61c366b895c91026e669c4fd4932abf/pyexcel_xlsxwx-0.1.4-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "bd7d56891390fdc4e6a15d252a2a4298",
                    "sha256": "d3f40ab34d41876d501f1b83093f6b7be2fd57df592bf3ffea12feae9871b6ba"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.4.tar.gz",
                "has_sig": false,
                "md5_digest": "bd7d56891390fdc4e6a15d252a2a4298",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5",
                "size": 4429,
                "upload_time": "2018-08-07T03:57:00",
                "url": "https://files.pythonhosted.org/packages/ce/c4/164b338cf0799cbf245449b61e28714b7854e13f146eb8127ab04292473d/pyexcel-xlsxwx-0.1.4.tar.gz"
            }
        ],
        "0.1.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "fec206f11ab611db3191faeb76e1b187",
                    "sha256": "3f8af296a263801643c7c7f61926c2cd561bbe5afb135b57596498fb8110daa8"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.5-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "fec206f11ab611db3191faeb76e1b187",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.5",
                "size": 10152,
                "upload_time": "2018-08-07T05:09:39",
                "url": "https://files.pythonhosted.org/packages/9c/14/621cf2c50d22198a1c418fd7bc2ca929b5658c84c7817aa9c8076c86d071/pyexcel_xlsxwx-0.1.5-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "e22d9904c89f2a9a1469a0f759ee4fe1",
                    "sha256": "e3c38fdb5c07093072fa3ff2f2481f6908bfaacfd18cd18f88f4786427ddaf2d"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.5.tar.gz",
                "has_sig": false,
                "md5_digest": "e22d9904c89f2a9a1469a0f759ee4fe1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5",
                "size": 4471,
                "upload_time": "2018-08-07T05:09:38",
                "url": "https://files.pythonhosted.org/packages/e6/f2/a2681d001e47685f9bac4af4d9c9f9a004e4d7b4118369398fcd6f8632c9/pyexcel-xlsxwx-0.1.5.tar.gz"
            }
        ],
        "0.1.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8086e444e9162add7f7ee4fa2793abf5",
                    "sha256": "5a91a098a7f8e084db2580b8d926f5dc0a75581eb557dfc9f4463dae95e225aa"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.6-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "8086e444e9162add7f7ee4fa2793abf5",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.5",
                "size": 10275,
                "upload_time": "2018-08-07T05:46:17",
                "url": "https://files.pythonhosted.org/packages/e0/0f/773341bb8f4bb898812027847c60739d1fa372444b6b30d7b2b28c1b5178/pyexcel_xlsxwx-0.1.6-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "23cceb5eace0c46cfd499852a5b4473f",
                    "sha256": "b6ee4860be5bac3c88606a5c70fc6b36e8d8201a5c4d40c90ea528ddda21321b"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.6.tar.gz",
                "has_sig": false,
                "md5_digest": "23cceb5eace0c46cfd499852a5b4473f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5",
                "size": 4508,
                "upload_time": "2018-08-07T05:46:16",
                "url": "https://files.pythonhosted.org/packages/6c/f1/2a83c07adc74c0f527e5baf145b29cfc6f38fa4646112b9358ace3b0c0f7/pyexcel-xlsxwx-0.1.6.tar.gz"
            }
        ],
        "0.1.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "99bb63c24e2b5267765a746f8dfc783f",
                    "sha256": "42ca4ddbcab02f0b4180956ac51c99fa34f2fb9cfbb94e80a2000885afcddb8a"
                },
                "downloads": -1,
                "filename": "pyexcel_xlsxwx-0.1.7-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "99bb63c24e2b5267765a746f8dfc783f",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": ">=3.5",
                "size": 10605,
                "upload_time": "2018-08-08T04:38:08",
                "url": "https://files.pythonhosted.org/packages/f6/4a/4a8049e00b4e60b3b18e3c9e6caad6308333d15f84d13fa760ab1818e7c9/pyexcel_xlsxwx-0.1.7-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "8a5584b8722a0cb4b11ea1248fa2fa7f",
                    "sha256": "75fa1a88ebdc234c3d9c46b0a272b10bb9e7d799d6ef73e9ff869c6801e8ab0b"
                },
                "downloads": -1,
                "filename": "pyexcel-xlsxwx-0.1.7.tar.gz",
                "has_sig": false,
                "md5_digest": "8a5584b8722a0cb4b11ea1248fa2fa7f",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": ">=3.5",
                "size": 4527,
                "upload_time": "2018-08-08T04:38:07",
                "url": "https://files.pythonhosted.org/packages/ae/43/99cf3577f2e051c23a38316be4b226044576102d591fedcc9b99391c3380/pyexcel-xlsxwx-0.1.7.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "99bb63c24e2b5267765a746f8dfc783f",
                "sha256": "42ca4ddbcab02f0b4180956ac51c99fa34f2fb9cfbb94e80a2000885afcddb8a"
            },
            "downloads": -1,
            "filename": "pyexcel_xlsxwx-0.1.7-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "99bb63c24e2b5267765a746f8dfc783f",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.5",
            "size": 10605,
            "upload_time": "2018-08-08T04:38:08",
            "url": "https://files.pythonhosted.org/packages/f6/4a/4a8049e00b4e60b3b18e3c9e6caad6308333d15f84d13fa760ab1818e7c9/pyexcel_xlsxwx-0.1.7-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "8a5584b8722a0cb4b11ea1248fa2fa7f",
                "sha256": "75fa1a88ebdc234c3d9c46b0a272b10bb9e7d799d6ef73e9ff869c6801e8ab0b"
            },
            "downloads": -1,
            "filename": "pyexcel-xlsxwx-0.1.7.tar.gz",
            "has_sig": false,
            "md5_digest": "8a5584b8722a0cb4b11ea1248fa2fa7f",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.5",
            "size": 4527,
            "upload_time": "2018-08-08T04:38:07",
            "url": "https://files.pythonhosted.org/packages/ae/43/99cf3577f2e051c23a38316be4b226044576102d591fedcc9b99391c3380/pyexcel-xlsxwx-0.1.7.tar.gz"
        }
    ]
}