Contents

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

#######################################################################
#
# A simple example of how to use the Excel::Writer::XLSX module to
# write text and numbers to an Excel xlsx file.
#
# reverse(c), March 2001, John McNamara, [e-mail]
# convert to ruby by Hideo NAKAMURA, [e-mail]
#

require 'write_xlsx'

# Create a new workbook called simple.xls and add a worksheet
workbook  = WriteXLSX.new('a_simple.xlsx')
worksheet = workbook.add_worksheet

# The general syntax is write(row, column, token). Note that row and
# column are zero indexed
#

# Write some text
worksheet.write(0, 0, "Hi Excel!")

# Write some numbers
worksheet.write(2, 0, 3)          # Writes 3
worksheet.write(3, 0, 3.00000)    # Writes 3
worksheet.write(4, 0, 3.00001)    # Writes 3.00001
worksheet.write(5, 0, 3.14159)    # TeX revision no.?

# Write some formulas
worksheet.write(7, 0, '=A3 + A6')
worksheet.write(8, 0, '=IF(A5>3,"Yes", "No")')

# Write a hyperlink
hyperlink_format = workbook.add_format(
                     :color     => 'blue',
                     :underline => 1
                                      )

worksheet.write(10, 0, 'http://www.ruby-lang.org/', hyperlink_format)

workbook.close

Version data entries

18 entries across 18 versions & 1 rubygems

Version	Path
write_xlsx-0.90.0	examples/a_simple.rb
write_xlsx-0.89.0	examples/a_simple.rb
write_xlsx-0.88.0	examples/a_simple.rb
write_xlsx-0.87.0	examples/a_simple.rb
write_xlsx-0.86.0	examples/a_simple.rb
write_xlsx-0.85.11	examples/a_simple.rb
write_xlsx-0.85.10	examples/a_simple.rb
write_xlsx-0.85.9	examples/a_simple.rb
write_xlsx-0.85.8	examples/a_simple.rb
write_xlsx-0.85.7	examples/a_simple.rb
write_xlsx-0.85.6	examples/a_simple.rb
write_xlsx-0.85.5	examples/a_simple.rb
write_xlsx-0.85.4	examples/a_simple.rb
write_xlsx-0.85.3	examples/a_simple.rb
write_xlsx-0.85.2	examples/a_simple.rb
write_xlsx-0.85.1	examples/a_simple.rb
write_xlsx-0.83.0	examples/a_simple.rb
write_xlsx-0.81.1	examples/a_simple.rb