XlsxWriter


NameXlsxWriter JSON
Version 3.2.2 PyPI version JSON
download
home_pagehttps://github.com/jmcnamara/XlsxWriter
SummaryA Python module for creating Excel XLSX files.
upload_time2025-01-28 20:23:14
maintainerNone
docs_urlNone
authorJohn McNamara
requires_python>=3.6
licenseBSD-2-Clause
keywords
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            XlsxWriter
==========

**XlsxWriter** is a Python module for writing files in the Excel 2007+ XLSX
file format.

XlsxWriter can be used to write text, numbers, formulas and hyperlinks to
multiple worksheets and it supports features such as formatting and many more,
including:

* 100% compatible Excel XLSX files.
* Full formatting.
* Merged cells.
* Defined names.
* Charts.
* Autofilters.
* Data validation and drop down lists.
* Conditional formatting.
* Worksheet PNG/JPEG/GIF/BMP/WMF/EMF images.
* Rich multi-format strings.
* Cell comments.
* Integration with Pandas and Polars.
* Textboxes.
* Support for adding Macros.
* Memory optimization mode for writing large files.

It supports Python 3.4+ and PyPy3 and uses standard libraries only.

Here is a simple example:

.. code-block:: python

   import xlsxwriter

   # Create an new Excel file and add a worksheet.
   workbook = xlsxwriter.Workbook("demo.xlsx")
   worksheet = workbook.add_worksheet()

   # Widen the first column to make the text clearer.
   worksheet.set_column("A:A", 20)

   # Add a bold format to use to highlight cells.
   bold = workbook.add_format({"bold": True})

   # Write some simple text.
   worksheet.write("A1", "Hello")

   # Text with formatting.
   worksheet.write("A2", "World", bold)

   # Write some numbers, with row/column notation.
   worksheet.write(2, 0, 123)
   worksheet.write(3, 0, 123.456)

   # Insert an image.
   worksheet.insert_image("B5", "logo.png")

   workbook.close()

.. image:: https://raw.github.com/jmcnamara/XlsxWriter/master/dev/docs/source/_images/demo.png

See the full documentation at: https://xlsxwriter.readthedocs.io

Release notes: https://xlsxwriter.readthedocs.io/changes.html


            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/jmcnamara/XlsxWriter",
    "name": "XlsxWriter",
    "maintainer": null,
    "docs_url": null,
    "requires_python": ">=3.6",
    "maintainer_email": null,
    "keywords": null,
    "author": "John McNamara",
    "author_email": "jmcnamara@cpan.org",
    "download_url": "https://files.pythonhosted.org/packages/a1/08/26f69d1e9264e8107253018de9fc6b96f9219817d01c5f021e927384a8d1/xlsxwriter-3.2.2.tar.gz",
    "platform": null,
    "description": "XlsxWriter\n==========\n\n**XlsxWriter** is a Python module for writing files in the Excel 2007+ XLSX\nfile format.\n\nXlsxWriter can be used to write text, numbers, formulas and hyperlinks to\nmultiple worksheets and it supports features such as formatting and many more,\nincluding:\n\n* 100% compatible Excel XLSX files.\n* Full formatting.\n* Merged cells.\n* Defined names.\n* Charts.\n* Autofilters.\n* Data validation and drop down lists.\n* Conditional formatting.\n* Worksheet PNG/JPEG/GIF/BMP/WMF/EMF images.\n* Rich multi-format strings.\n* Cell comments.\n* Integration with Pandas and Polars.\n* Textboxes.\n* Support for adding Macros.\n* Memory optimization mode for writing large files.\n\nIt supports Python 3.4+ and PyPy3 and uses standard libraries only.\n\nHere is a simple example:\n\n.. code-block:: python\n\n   import xlsxwriter\n\n   # Create an new Excel file and add a worksheet.\n   workbook = xlsxwriter.Workbook(\"demo.xlsx\")\n   worksheet = workbook.add_worksheet()\n\n   # Widen the first column to make the text clearer.\n   worksheet.set_column(\"A:A\", 20)\n\n   # Add a bold format to use to highlight cells.\n   bold = workbook.add_format({\"bold\": True})\n\n   # Write some simple text.\n   worksheet.write(\"A1\", \"Hello\")\n\n   # Text with formatting.\n   worksheet.write(\"A2\", \"World\", bold)\n\n   # Write some numbers, with row/column notation.\n   worksheet.write(2, 0, 123)\n   worksheet.write(3, 0, 123.456)\n\n   # Insert an image.\n   worksheet.insert_image(\"B5\", \"logo.png\")\n\n   workbook.close()\n\n.. image:: https://raw.github.com/jmcnamara/XlsxWriter/master/dev/docs/source/_images/demo.png\n\nSee the full documentation at: https://xlsxwriter.readthedocs.io\n\nRelease notes: https://xlsxwriter.readthedocs.io/changes.html\n\n",
    "bugtrack_url": null,
    "license": "BSD-2-Clause",
    "summary": "A Python module for creating Excel XLSX files.",
    "version": "3.2.2",
    "project_urls": {
        "Homepage": "https://github.com/jmcnamara/XlsxWriter"
    },
    "split_keywords": [],
    "urls": [
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "9b07df054f7413bdfff5e98f75056e4ed0977d0c8716424011fac2587864d1d3",
                "md5": "508abf735526e464ab5e27217ac67fc8",
                "sha256": "272ce861e7fa5e82a4a6ebc24511f2cb952fde3461f6c6e1a1e81d3272db1471"
            },
            "downloads": -1,
            "filename": "XlsxWriter-3.2.2-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "508abf735526e464ab5e27217ac67fc8",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.6",
            "size": 165121,
            "upload_time": "2025-01-28T20:23:11",
            "upload_time_iso_8601": "2025-01-28T20:23:11.654189Z",
            "url": "https://files.pythonhosted.org/packages/9b/07/df054f7413bdfff5e98f75056e4ed0977d0c8716424011fac2587864d1d3/XlsxWriter-3.2.2-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": null,
            "digests": {
                "blake2b_256": "a10826f69d1e9264e8107253018de9fc6b96f9219817d01c5f021e927384a8d1",
                "md5": "6b3e766967a327ac937ba4195181cdf1",
                "sha256": "befc7f92578a85fed261639fb6cde1fd51b79c5e854040847dde59d4317077dc"
            },
            "downloads": -1,
            "filename": "xlsxwriter-3.2.2.tar.gz",
            "has_sig": false,
            "md5_digest": "6b3e766967a327ac937ba4195181cdf1",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.6",
            "size": 205202,
            "upload_time": "2025-01-28T20:23:14",
            "upload_time_iso_8601": "2025-01-28T20:23:14.387427Z",
            "url": "https://files.pythonhosted.org/packages/a1/08/26f69d1e9264e8107253018de9fc6b96f9219817d01c5f021e927384a8d1/xlsxwriter-3.2.2.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2025-01-28 20:23:14",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "jmcnamara",
    "github_project": "XlsxWriter",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "lcname": "xlsxwriter"
}
        
Elapsed time: 0.52936s