Sha256: 975224019737e6bdc6fe2ebf6b0dfbc51d0610b7e04afba29868b2a2eda6b763
Contents?: true
Size: 1.48 KB
Versions: 38
Compression:
Stored size: 1.48 KB
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, jmcnamara@cpan.org
# convert to ruby by Hideo NAKAMURA, cxn03651@msj.biglobe.ne.jp
#
require 'rubygems'
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 the standard url link format.
url_format = workbook.add_format(
:color => 'blue',
:underline => 1
)
# 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/', url_format)
worksheet.write('A3', 'http://www.perl.com/', url_format, str)
worksheet.write('A5', 'http://www.perl.com/', url_format, str, tip)
worksheet.write('A7', 'http://www.perl.com/', red_format)
worksheet.write('A9', 'mailto:jmcnamara@cpan.org', url_format, 'Mail me')
# Write a URL that isn't a hyperlink
worksheet.write_string('A11', 'http://www.perl.com/')
workbook.close
Version data entries
38 entries across 38 versions & 1 rubygems