3
3
# Example of how to use the XlsxWriter module to write hyperlinks
5
# Copyright 2013, John McNamara, jmcnamara@cpan.org
5
# Copyright 2013-2015, John McNamara, jmcnamara@cpan.org
16
16
# Add the standard url link format.
17
17
url_format = workbook.add_format({
22
22
# Add a sample alternative link format.
23
23
red_format = workbook.add_format({
30
30
# Add an alternate description string to the URL.
34
34
tip = 'Get the latest Python news here.'
36
36
# Write some hyperlinks
37
worksheet.write('A1', 'http://www.python.org/') # Implicit format.
38
worksheet.write('A3', 'http://www.python.org/', url_format, string)
39
worksheet.write('A5', 'http://www.python.org/', url_format, string, tip)
40
worksheet.write('A7', 'http://www.python.org/', red_format)
41
worksheet.write('A9', 'mailto:jmcnamaracpan.org', url_format, 'Mail me')
37
worksheet.write_url('A1', 'http://www.python.org/') # Implicit format.
38
worksheet.write_url('A3', 'http://www.python.org/', url_format, string)
39
worksheet.write_url('A5', 'http://www.python.org/', url_format, string, tip)
40
worksheet.write_url('A7', 'http://www.python.org/', red_format)
41
worksheet.write_url('A9', 'mailto:jmcnamaracpan.org', url_format, 'Mail me')
43
43
# Write a URL that isn't a hyperlink
44
44
worksheet.write_string('A11', 'http://www.python.org/')