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"
}
JSON
