Contents

#!/usr/bin/ruby -w

###############################################################################
#
# Example of how to use the WriteExcel module to write a basic multiple
# worksheet Excel file.
#
# reverse('©'), March 2001, John McNamara, [e-mail]
#
# original written in Perl by John McNamara
# converted to Ruby by Hideo Nakamura, [e-mail]
#

require 'rubygems'
require 'WriteExcel'

workbook = Spreadsheet::WriteExcel.new("regions.xls")

# Add some worksheets
north = workbook.add_worksheet("North")
south = workbook.add_worksheet("South")
east  = workbook.add_worksheet("East")
west  = workbook.add_worksheet("West")

# Add a Format
format = workbook.add_format()
format.set_bold()
format.set_color('blue')

# Add a caption to each worksheet
workbook.sheets.each do |worksheet|
    worksheet.write(0, 0, "Sales", format)
end

# Write some data
north.write(0, 1, 200000)
south.write(0, 1, 100000)
east.write(0, 1, 150000)
west.write(0, 1, 100000)

# Set the active worksheet
bp=1
south.activate()

# Set the width of the first column
south.set_column(0, 0, 20)

# Set the active cell
south.set_selection(0, 1)

workbook.close

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
WriteExcel-0.2.0	examples/regions.rb