xlsxwriter

A Python module for creating Excel XLSX files.

https://github.com/jmcnamara/xlsxwriter

Science Score: 36.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • CITATION.cff file
  • codemeta.json file
    Found codemeta.json file
  • .zenodo.json file
    Found .zenodo.json file
  • DOI references
  • Academic publication links
  • Committers with academic emails
    1 of 55 committers (1.8%) from academic institutions
  • Institutional organization owner
  • JOSS paper metadata
  • Scientific vocabulary similarity
    Low similarity (9.7%) to scientific vocabulary

Keywords

charts libxlsxwriter pandas python spreadsheet xlsx xlsx-files xlsxwriter

Keywords from Contributors

pallets jinja fuzzing sphinx docs documentation-tool restructuredtext templates property-based-testing pytest
Last synced: 7 months ago · JSON representation

Repository

A Python module for creating Excel XLSX files.

Basic Info
Statistics
  • Stars: 3,813
  • Watchers: 111
  • Forks: 650
  • Open Issues: 19
  • Releases: 0
Topics
charts libxlsxwriter pandas python spreadsheet xlsx xlsx-files xlsxwriter
Created over 13 years ago · Last pushed 8 months ago
Metadata Files
Readme Changelog Contributing Funding License

README.rst

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.8+ 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

Owner

  • Name: John McNamara
  • Login: jmcnamara
  • Kind: user
  • Location: Ireland

anyone lived in a pretty how town with up so floating many bells down

GitHub Events

Total
  • Issues event: 79
  • Watch event: 185
  • Issue comment event: 158
  • Push event: 64
  • Pull request event: 15
  • Fork event: 30
  • Create event: 5
Last Year
  • Issues event: 79
  • Watch event: 185
  • Issue comment event: 158
  • Push event: 64
  • Pull request event: 15
  • Fork event: 30
  • Create event: 5

Committers

Last synced: 9 months ago

All Time
  • Total Commits: 1,409
  • Total Committers: 55
  • Avg Commits per committer: 25.618
  • Development Distribution Score (DDS): 0.067
Past Year
  • Commits: 68
  • Committers: 3
  • Avg Commits per committer: 22.667
  • Development Distribution Score (DDS): 0.029
Top Committers
Name Email Commits
John McNamara j****a@c****g 1,314
Jonas Diemer j****r@g****m 14
percious c****s@p****m 11
Hugo van Kemenade h****k 4
jkyeung g****e@g****m 4
Dieter Vandenbussche d****7@g****m 4
Alexander Beedie a****e 3
Dieter Vandenbussche d****e@a****m 3
Daniel Quinn d****n 2
Eddie Chapman e****4@g****m 2
Javier Santacruz j****c@g****m 2
krysros k****i@g****m 2
Paul p****x@g****m 2
Alexander Afanasiev a****v@g****m 1
Alex Yakovlev a****v@r****u 1
Abhishek Kumar Singh t****t 1
zrkn z****n@e****u 1
ziembla w****j@z****m 1
xmo-odoo x****o@o****m 1
sax s****o@g****m 1
rosie ❤ r****a@g****m 1
mojaie m****e@a****m 1
tablet-mode t****e@m****c 1
Adam Chainz a****m@a****u 1
Adrian Stachlewski a****i@g****m 1
Andrey Maksimov n****l@m****m 1
Augusto Destrero a****u@a****t 1
nu_no n****n@g****m 1
moogleshoogle2 m****e@s****m 1
greateggsgreg 3****g 1
and 25 more...

Issues and Pull Requests

Last synced: 7 months ago

All Time
  • Total issues: 233
  • Total pull requests: 38
  • Average time to close issues: about 2 months
  • Average time to close pull requests: 2 months
  • Total issue authors: 200
  • Total pull request authors: 31
  • Average comments per issue: 3.33
  • Average comments per pull request: 3.0
  • Merged pull requests: 13
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 51
  • Pull requests: 15
  • Average time to close issues: 11 days
  • Average time to close pull requests: 5 days
  • Issue authors: 46
  • Pull request authors: 10
  • Average comments per issue: 1.92
  • Average comments per pull request: 2.0
  • Merged pull requests: 4
  • Bot issues: 0
  • Bot pull requests: 0
Top Authors
Issue Authors
  • jmcnamara (10)
  • youth54 (5)
  • CanePlayz (5)
  • areqq (4)
  • 80avin (3)
  • m-tmatma (2)
  • aersam (2)
  • thomas-richard-veeva (2)
  • pombears (2)
  • healthmatrice (2)
  • muriloOEM (2)
  • wayner9 (2)
  • bob-schumaker (2)
  • laurelgr (2)
  • chrisjdixon (2)
Pull Request Authors
  • alexander-beedie (2)
  • bob-schumaker (2)
  • shiplu (2)
  • Lennzyyy (2)
  • tjpartridge (2)
  • DanilFilippov123 (2)
  • cxo05 (2)
  • srdgtr (2)
  • dhergenroed2 (2)
  • ennamarie19 (2)
  • alanb-sony (2)
  • fwitte (2)
  • sblondon (2)
  • jkyeung (2)
  • husainshaikh895 (1)
Top Labels
Issue Labels
bug (93) question (64) feature request (62) awaiting user feedback (23) under investigation (11) wont_fix (8) medium term (7) in progress (6) ready to close (5) short term (4) someday (3) long term (3)
Pull Request Labels

Packages

  • Total packages: 41
  • Total downloads:
    • pypi 43,489,752 last-month
  • Total docker downloads: 68,495,587
  • Total dependent packages: 484
    (may contain duplicates)
  • Total dependent repositories: 4,271
    (may contain duplicates)
  • Total versions: 318
  • Total maintainers: 3
pypi.org: xlsxwriter

A Python module for creating Excel XLSX files.

  • Versions: 171
  • Dependent Packages: 433
  • Dependent Repositories: 3,828
  • Downloads: 43,489,752 Last month
  • Docker Downloads: 68,495,587
Rankings
Dependent packages count: 0.1%
Downloads: 0.1%
Dependent repos count: 0.2%
Docker downloads count: 0.9%
Average: 0.9%
Stargazers count: 1.8%
Forks count: 2.7%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.18: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 1.8%
Forks count: 2.9%
Stargazers count: 4.1%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.18: py3-xlsxwriter-pyc

Precompiled Python bytecode for py3-xlsxwriter

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 1.8%
Forks count: 2.9%
Stargazers count: 4.1%
Maintainers (1)
Last synced: 8 months ago
alpine-v3.11: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 2
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.3%
Stargazers count: 2.7%
Average: 3.3%
Dependent packages count: 8.1%
Maintainers (1)
Last synced: 7 months ago
alpine-edge: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 18
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Average: 3.6%
Forks count: 4.1%
Stargazers count: 4.1%
Dependent packages count: 6.0%
Maintainers (1)
Last synced: 8 months ago
alpine-v3.14: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.4%
Stargazers count: 2.8%
Average: 4.3%
Dependent packages count: 12.1%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.5: py-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 0.9%
Stargazers count: 1.0%
Average: 4.3%
Dependent packages count: 15.5%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.7: py-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 1.9%
Stargazers count: 1.9%
Average: 4.5%
Dependent packages count: 14.3%
Maintainers (1)
Last synced: 7 months ago
conda-forge.org: xlsxwriter

XlsxWriter is a Python module that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.

  • Versions: 48
  • Dependent Packages: 30
  • Dependent Repositories: 221
Rankings
Dependent packages count: 2.2%
Dependent repos count: 2.3%
Average: 4.6%
Forks count: 6.7%
Stargazers count: 7.2%
Last synced: 7 months ago
alpine-v3.9: py-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.1%
Stargazers count: 2.2%
Average: 4.7%
Dependent packages count: 14.6%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.9: py3-xlsxwriter

A Python module for creating Excel XLSX files - python3

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.1%
Stargazers count: 2.2%
Average: 4.7%
Dependent packages count: 14.6%
Maintainers (1)
Last synced: 8 months ago
alpine-v3.10: py-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 2
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.2%
Stargazers count: 2.3%
Average: 4.9%
Dependent packages count: 15.0%
Maintainers (1)
Last synced: 8 months ago
alpine-v3.6: py3-xlsxwriter

A Python module for creating Excel XLSX files - python3

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 1.1%
Stargazers count: 1.1%
Average: 5.1%
Dependent packages count: 18.3%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.6: py-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 1.1%
Stargazers count: 1.1%
Average: 5.1%
Dependent packages count: 18.3%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.15: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.4%
Stargazers count: 3.0%
Average: 5.5%
Dependent packages count: 16.5%
Maintainers (1)
Last synced: 7 months ago
alpine-edge: py3-xlsxwriter-pyc

Precompiled Python bytecode for py3-xlsxwriter

  • Versions: 14
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 4.1%
Stargazers count: 4.3%
Average: 5.6%
Dependent packages count: 14.1%
Maintainers (1)
Last synced: 8 months ago
alpine-v3.16: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.4%
Stargazers count: 3.2%
Average: 6.1%
Dependent packages count: 18.7%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.13: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.4%
Stargazers count: 2.7%
Average: 6.2%
Dependent packages count: 19.5%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.17: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.7%
Stargazers count: 3.8%
Average: 6.4%
Dependent packages count: 19.0%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.5: py2-xlsxwriter

A Python module for creating Excel XLSX files - python2

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 0.9%
Stargazers count: 1.0%
Average: 6.5%
Dependent packages count: 24.1%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.5: py3-xlsxwriter

A Python module for creating Excel XLSX files - python3

  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 0.9%
Stargazers count: 1.0%
Average: 6.5%
Dependent packages count: 24.1%
Maintainers (1)
Last synced: 8 months ago
alpine-v3.12: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.3%
Stargazers count: 2.5%
Average: 6.6%
Dependent packages count: 21.5%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.7: py3-xlsxwriter

A Python module for creating Excel XLSX files - python3

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 1.9%
Stargazers count: 1.9%
Average: 6.8%
Dependent packages count: 23.4%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.7: py2-xlsxwriter

A Python module for creating Excel XLSX files - python2

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 1.9%
Stargazers count: 1.9%
Average: 6.8%
Dependent packages count: 23.4%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.9: py2-xlsxwriter

A Python module for creating Excel XLSX files - python2

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.1%
Stargazers count: 2.2%
Average: 6.9%
Dependent packages count: 23.2%
Maintainers (1)
Last synced: 8 months ago
alpine-v3.6: py2-xlsxwriter

A Python module for creating Excel XLSX files - python2

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 1.1%
Stargazers count: 1.1%
Average: 7.3%
Dependent packages count: 27.1%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.8: py2-xlsxwriter

A Python module for creating Excel XLSX files - python2

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.0%
Stargazers count: 2.1%
Average: 7.3%
Dependent packages count: 25.2%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.8: py-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.0%
Stargazers count: 2.1%
Average: 7.3%
Dependent packages count: 25.2%
Maintainers (1)
Last synced: 8 months ago
alpine-v3.8: py3-xlsxwriter

A Python module for creating Excel XLSX files - python3

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.0%
Stargazers count: 2.1%
Average: 7.3%
Dependent packages count: 25.2%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.10: py3-xlsxwriter

A Python module for creating Excel XLSX files - python3

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.2%
Stargazers count: 2.3%
Average: 8.5%
Dependent packages count: 29.6%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.10: py2-xlsxwriter

A Python module for creating Excel XLSX files - python2

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Forks count: 2.2%
Stargazers count: 2.3%
Average: 8.5%
Dependent packages count: 29.6%
Maintainers (1)
Last synced: 7 months ago
pypi.org: xlsxwriterchan

A Python module for creating Excel XLSX files.

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 1
Rankings
Stargazers count: 1.4%
Forks count: 2.1%
Average: 8.8%
Dependent packages count: 10.0%
Dependent repos count: 21.7%
Maintainers (1)
Last synced: 8 months ago
anaconda.org: xlsxwriter

XlsxWriter is a Python module that can be used to write text, numbers, formulas and hyperlinks to multiple worksheets in an Excel 2007+ XLSX file.

  • Versions: 31
  • Dependent Packages: 5
  • Dependent Repositories: 221
Rankings
Dependent packages count: 8.7%
Average: 12.5%
Dependent repos count: 12.9%
Forks count: 14.1%
Stargazers count: 14.5%
Last synced: 7 months ago
alpine-v3.19: py3-xlsxwriter-pyc

Precompiled Python bytecode for py3-xlsxwriter

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 100%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.20: py3-xlsxwriter-pyc

Precompiled Python bytecode for py3-xlsxwriter

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 100%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.22: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 100%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.21: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 100%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.22: py3-xlsxwriter-pyc

Precompiled Python bytecode for py3-xlsxwriter

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 100%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.21: py3-xlsxwriter-pyc

Precompiled Python bytecode for py3-xlsxwriter

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 100%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.20: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 100%
Maintainers (1)
Last synced: 7 months ago
alpine-v3.19: py3-xlsxwriter

A Python module for creating Excel XLSX files

  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
Rankings
Dependent repos count: 0.0%
Dependent packages count: 0.0%
Average: 100%
Maintainers (1)
Last synced: 7 months ago

Dependencies

.github/workflows/python-app.yml actions
  • actions/checkout v2 composite
  • actions/setup-python v2 composite