Sha256: c20afde912c8eb500df8c56c51f024c34aa6464ea7044d02d243bfa63a85b2dc
Contents?: true
Size: 1.12 KB
Versions: 5
Compression:
Stored size: 1.12 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 '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 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
5 entries across 5 versions & 1 rubygems
Version | Path |
---|---|
writeexcel-1.0.9 | examples/regions.rb |
writeexcel-1.0.8 | examples/regions.rb |
writeexcel-1.0.7 | examples/regions.rb |
writeexcel-1.0.6 | examples/regions.rb |
writeexcel-1.0.5 | examples/regions.rb |