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": "",
"docs_url": null,
"requires_python": ">=3.6",
"maintainer_email": "",
"keywords": "",
"author": "John McNamara",
"author_email": "jmcnamara@cpan.org",
"download_url": "https://files.pythonhosted.org/packages/a6/c3/b36fa44a0610a0f65d2e65ba6a262cbe2554b819f1449731971f7c16ea3c/XlsxWriter-3.2.0.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\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.0",
"project_urls": {
"Homepage": "https://github.com/jmcnamara/XlsxWriter"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "a7ea53d1fe468e63e092cf16e2c18d16f50c29851242f9dd12d6a66e0d7f0d02",
"md5": "da6cf22be34e96a455008eb829a93f80",
"sha256": "ecfd5405b3e0e228219bcaf24c2ca0915e012ca9464a14048021d21a995d490e"
},
"downloads": -1,
"filename": "XlsxWriter-3.2.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "da6cf22be34e96a455008eb829a93f80",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.6",
"size": 159925,
"upload_time": "2024-02-18T23:11:21",
"upload_time_iso_8601": "2024-02-18T23:11:21.559490Z",
"url": "https://files.pythonhosted.org/packages/a7/ea/53d1fe468e63e092cf16e2c18d16f50c29851242f9dd12d6a66e0d7f0d02/XlsxWriter-3.2.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "a6c3b36fa44a0610a0f65d2e65ba6a262cbe2554b819f1449731971f7c16ea3c",
"md5": "86f1c46dc20ca2b87aacbb2e1fc9c1ea",
"sha256": "9977d0c661a72866a61f9f7a809e25ebbb0fb7036baa3b9fe74afcfca6b3cb8c"
},
"downloads": -1,
"filename": "XlsxWriter-3.2.0.tar.gz",
"has_sig": false,
"md5_digest": "86f1c46dc20ca2b87aacbb2e1fc9c1ea",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.6",
"size": 198732,
"upload_time": "2024-02-18T23:11:24",
"upload_time_iso_8601": "2024-02-18T23:11:24.444483Z",
"url": "https://files.pythonhosted.org/packages/a6/c3/b36fa44a0610a0f65d2e65ba6a262cbe2554b819f1449731971f7c16ea3c/XlsxWriter-3.2.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-02-18 23:11:24",
"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
