A Python module for creating Excel XLSX files.
Alternatives To Xlsxwriter
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Sheetjs33,6144,3793,8162 months ago170March 24, 2022129apache-2.0JavaScript
📗 SheetJS Spreadsheet Data Toolkit -- New home https://git.sheetjs.com/SheetJS/sheetjs
Easyexcel28,85998101a month ago68May 30, 2023319apache-2.0Java
Excelize16,0163572 days ago186April 09, 202388bsd-3-clauseGo
Go language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
Luckysheet14,70227 days ago9October 17, 2022664mitJavaScript
Luckysheet is an online spreadsheet like excel that is powerful, simple to configure, and completely open source.
Phpspreadsheet12,5241,4736114 days ago46June 14, 2023181mitPHP
A pure PHP library for reading and writing spreadsheet files
9 days ago35July 20, 202358mitGo
A developer-friendly API for converting numerous document formats into PDF files, and more!
Xlsx5,5266329516 days ago45May 23, 20231otherGo
Go library for reading and writing XLSX files.
Closedxml3,9835343632 days ago76June 24, 2023419mitC#
ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.
Unioffice3,9431717 days ago49August 06, 202334otherGo
Pure go library for creating and processing Office Word (.docx), Excel (.xlsx) and Powerpoint (.pptx) documents
Exceldatareader3,5854922204 days ago21June 18, 202364mitC#
Lightweight and fast library written in C# for reading Microsoft Excel files
Alternatives To Xlsxwriter
Select To Compare

Alternative Project Comparisons


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:

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')


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

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

Popular Xlsx Projects
Popular Excel Projects
Popular Data Formats Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.