Contents

#!/usr/bin/env ruby
# -*- coding: utf-8 -*-

###############################################################################
#
# Example of how to use the Excel::Writer::XLSX module to write hyperlinks
#
# See also hyperlink2.pl for worksheet URL examples.
#
# reverse(c), May 2004, John McNamara, [e-mail]
# convert to ruby by Hideo NAKAMURA, [e-mail]
#

require 'write_xlsx'

# Create a new workbook and add a worksheet
workbook = WriteXLSX.new('hyperlink.xlsx')

worksheet = workbook.add_worksheet('Hyperlinks')

# Format the first column
worksheet.set_column('A:A', 30)
worksheet.set_selection('B1')

# Add a sample format.
red_format = workbook.add_format(
  color:     'red',
  bold:      1,
  underline: 1,
  size:      12
)

# Add an alternate description string to the URL.
str = 'Perl home.'

# Add a "tool tip" to the URL.
tip = 'Get the latest Perl news here.'

# Write some hyperlinks
worksheet.write('A1', 'http://www.perl.com/')
worksheet.write('A3', 'http://www.perl.com/', nil, str)
worksheet.write('A5', 'http://www.perl.com/', nil, str, tip)
worksheet.write('A7', 'http://www.perl.com/', red_format)
worksheet.write('A9', 'mailto:[e-mail]', nil, 'Mail me')

# Write a URL that isn't a hyperlink
worksheet.write_string('A11', 'http://www.perl.com/')

workbook.close

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
write_xlsx-1.12.1	examples/hyperlink1.rb
write_xlsx-1.12.0	examples/hyperlink1.rb
write_xlsx-1.11.2	examples/hyperlink1.rb
write_xlsx-1.11.1	examples/hyperlink1.rb
write_xlsx-1.11.0	examples/hyperlink1.rb
write_xlsx-1.10.2	examples/hyperlink1.rb
write_xlsx-1.10.1	examples/hyperlink1.rb