Skip to content

jkyeung/XlsxWriter

This branch is 3 commits ahead of, 409 commits behind jmcnamara/XlsxWriter:master.

Folders and files

NameName
Last commit message
Last commit date

Latest commit

2217157 · May 16, 2016
May 14, 2016
May 14, 2016
Apr 17, 2016
May 14, 2016
Jan 5, 2016
Sep 20, 2015
May 10, 2016
May 16, 2016
May 10, 2016
Jan 26, 2013
Sep 12, 2013
May 14, 2016
May 10, 2016
Jan 5, 2016
May 14, 2016
Oct 9, 2014
May 14, 2016
Aug 22, 2013

Repository files navigation

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 images.
  • Rich multi-format strings.
  • Cell comments.
  • Integration with Pandas.
  • Textboxes.
  • Memory optimization mode for writing large files.

It supports Python 2.5, 2.6, 2.7, 3.1, 3.2, 3.3, 3.4, 3.5, Jython and PyPy 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')

workbook.close()

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

See the full documentation at: http://xlsxwriter.readthedocs.org

Release notes: http://xlsxwriter.readthedocs.org/changes.html

About

A Python module for creating Excel XLSX files.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Python 98.0%
  • CSS 0.7%
  • HTML 0.5%
  • Makefile 0.3%
  • Shell 0.2%
  • Batchfile 0.2%
  • Perl 0.1%