Sha256: c3cb54eecbd8ade7e257196aa09d42280996fab8472089b3bdc7d58afef94bba
Contents?: true
Size: 1.15 KB
Versions: 30
Compression:
Stored size: 1.15 KB
Contents
#!/usr/bin/ruby -w
# -*- coding: utf-8 -*-
###############################################################################
#
# Example of how to use the WriteExcel module to write a basic multiple
# worksheet Excel file.
#
# reverse('©'), March 2001, John McNamara, jmcnamara@cpan.org
#
# original written in Perl by John McNamara
# converted to Ruby by Hideo Nakamura, cxn03651@msj.biglobe.ne.jp
#
require 'rubygems'
require 'writeexcel'
workbook = 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
30 entries across 30 versions & 3 rubygems