1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
|
##############################################################################
#
# An example of adding document properties to a XlsxWriter file.
#
# SPDX-License-Identifier: BSD-2-Clause
# Copyright 2013-2023, John McNamara, jmcnamara@cpan.org
#
import xlsxwriter
workbook = xlsxwriter.Workbook("doc_properties.xlsx")
worksheet = workbook.add_worksheet()
workbook.set_properties(
{
"title": "This is an example spreadsheet",
"subject": "With document properties",
"author": "John McNamara",
"manager": "Dr. Heinz Doofenshmirtz",
"company": "of Wolves",
"category": "Example spreadsheets",
"keywords": "Sample, Example, Properties",
"comments": "Created with Python and XlsxWriter",
"status": "Quo",
}
)
worksheet.set_column("A:A", 70)
worksheet.write("A1", "Select 'Workbook Properties' to see properties.")
workbook.close()
|
