Example: Simple Unicode with Python 3

To write Unicode text in UTF-8 to a xlsxwriter file in Python 3 you just need to encode the file as UTF-8.

_images/unicode_python3.png
###############################################################################
#
# A simple Unicode spreadsheet in Python 3 using the XlsxWriter Python module.
#
# SPDX-License-Identifier: BSD-2-Clause
# Copyright 2013-2022, John McNamara, jmcnamara@cpan.org
#

# To write Unicode text in UTF-8 to a xlsxwriter file in Python 3 you just
# need to encode the file as UTF-8.
import xlsxwriter

workbook = xlsxwriter.Workbook('unicode_python3.xlsx')
worksheet = workbook.add_worksheet()

worksheet.write('B3', 'Это фраза на русском!')

workbook.close()