Contents

#!/usr/bin/env ruby -w -s
# -*- coding: utf-8 -*-
$LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib"

#```ruby
require 'axlsx'

p = Axlsx::Package.new
wb = p.workbook
wb.add_worksheet(:name => 'hyperlinks') do |sheet|
  # external references
  sheet.add_row ['axlsx']
  sheet.add_hyperlink :location => 'https://github.com/randym/axlsx', :ref => sheet.rows.first.cells.first
  # internal references
  sheet.add_row ['next sheet']
  sheet.add_hyperlink :location => "'Next Sheet'!A1", :target => :sheet, :ref => 'A2'
end

wb.add_worksheet(:name => 'Next Sheet') do |sheet|
  sheet.add_row ['hello!']
end

p.serialize 'hyperlinks.xlsx'

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
axlsx-1.3.3	examples/hyperlinks.rb
axlsx-1.3.2	examples/hyperlinks.rb
axlsx-1.3.1	examples/hyperlinks.rb
axlsx-1.2.3	examples/hyperlinks.rb
axlsx-1.2.2	examples/hyperlinks.rb
axlsx-1.2.1	examples/hyperlinks.rb