Example of how to set diagonal borders in a cell.
See set_diag_border()
, set_diag_type()
and set_diag_border()
for details.
##############################################################################
#
# A simple formatting example that demonstrates how to add diagonal cell
# borders with XlsxWriter.
#
# SPDX-License-Identifier: BSD-2-Clause
# Copyright 2013-2023, John McNamara, jmcnamara@cpan.org
#
import xlsxwriter
workbook = xlsxwriter.Workbook('diag_border.xlsx')
worksheet = workbook.add_worksheet()
format1 = workbook.add_format({'diag_type': 1})
format2 = workbook.add_format({'diag_type': 2})
format3 = workbook.add_format({'diag_type': 3})
format4 = workbook.add_format({
'diag_type': 3,
'diag_border': 7,
'diag_color': 'red',
})
worksheet.write('B3', 'Text', format1)
worksheet.write('B6', 'Text', format2)
worksheet.write('B9', 'Text', format3)
worksheet.write('B12', 'Text', format4)
workbook.close()