Contents

#!/usr/bin/ruby -w

###############################################################################
#
# 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

6 entries across 6 versions & 1 rubygems

Version	Path
writeexcel-0.3.5	examples/defined_name.rb
writeexcel-0.3.4	examples/defined_name.rb
writeexcel-0.3.3	examples/defined_name.rb
writeexcel-0.3.2	examples/defined_name.rb
writeexcel-0.3.1	examples/defined_name.rb
writeexcel-0.3.0	examples/defined_name.rb