Contents

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

###############################################################################
#
# Example of how to create defined names in a WriteExcel file.
#
# reverse('ｩ'), September 2008, John McNamara, [e-mail]
#
# original written in Perl by John McNamara
# converted to Ruby by Hideo Nakamura, [e-mail]
#

require 'writeexcel'

workbook   = WriteExcel.new('defined_name.xls')
worksheet1 = workbook.add_worksheet
worksheet2 = workbook.add_worksheet

workbook.define_name('Exchange_rate', '=0.96')
workbook.define_name('Sales',         '=Sheet1!$G$1:$H$10')
workbook.define_name('Sheet2!Sales',  '=Sheet2!$G$1:$G$10')

workbook.sheets.each do |worksheet|
  worksheet.set_column('A:A', 45)
  worksheet.write('A2', 'This worksheet contains some defined names,')
  worksheet.write('A3', 'See the Insert -> Name -> Define dialog.')
end

worksheet1.write('A4', '=Exchange_rate')

workbook.close

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
writeexcel-0.5.0	examples/defined_name.rb
writeexcel-0.4.3	examples/defined_name.rb
writeexcel-0.4.2	examples/defined_name.rb
writeexcel-0.4.1	examples/defined_name.rb
writeexcel-0.4.0	examples/defined_name.rb