Spreadsheet::Excel - A module for generating Excel compatable files on any platform. Version 0.2.3, based on version .26 of Spreadsheet::WriteExcel.
require "spreadsheet/excel"
include Spreadsheet
workbook = Excel.new("test.xls")
# There are three ways to create a format
format = workbook.add_format(:color=>"blue",:bold=>1,:underline=>1)
format2 = Format.new(
:color => "green",
:bold => true,
:underline => true
)
workbook.add_format(format2)
format3 = Format.new{ |f|
f.color = "red"
f.bold = true
f.underline = true
}
workbook.add_format(format3)
worksheet1 = workbook.add_worksheet
worksheet2 = workbook.add_worksheet("Numbers")
worksheet3 = workbook.add_worksheet("Text")
worksheet1.write(0,0,"Hello",format)
worksheet1.write(1,1,["Matz","Larry","Guido"])
worksheet2.write(1,3,8876,format2)
worksheet2.write_column(4,4,[1,2,3])
worksheet3.write(2,2,"World",format3)
worksheet3.write(3,3,[[1,2,3],[4,5,6],[7,8,9]])
workbook.close
Excel#new(<filename>)Returns a workbook object. You may only have one workbook per file. A .xls extension for your filename is recommended but not enforced.
Excel#VERSIONReturns the current version of the module as a string.
Workbook#add_worksheet(<sheet name>)Adds a worksheet to the workbook object. You may optionally pass a sheet name. Otherwise, it will default to 'Sheet1', 'Sheet2', etc.
Workbook#add_format(<attributes|Format object>)Adds a Format to the workbook. When included as part of the 'write' method, the cells specified are formatted appropriately.
See the synopsis above for different ways to add formats.
Workbook#closeCloses the workbook (and the file). Be sure to do this.
Worksheet#write(row,column,value,<format>)Writes data to the cell you provide. If <value> is an Array, the write_row method is called internally.
If <value> is a multi-dimensional array, then each element of the array is written within its own row at the appropriate column. In other words, it's written to the spreadsheet in the same manner you would visualize it.
If a format is provided, the cells are each formatted appropriately.
Worksheet#write_row(row,column,Array,<format>)Writes a row of data starting at <row> and <column> in a left to right manner, with one array element per cell.
Any formatting will be applied to each cell.
Worksheet#write_column(row,column,Array,<format>)Writes a column of data starting at <row> and <column> in a top to bottom manner, with one array element per cell.
Any formattnig will be applied to each cell.
Format#new({attributes})Creates a new Format object. See the Format documentation for details.
This is a port of John McNamara's Spreadsheet::WriteExcel module, version .26 There is no support for formulas yet.
The only somewhat major change was to make OLEWriter a subclass of File, rather than store a filehandle as an attribute within the class. This seems to have worked out fine. Other changes consisted mostly of minor code optimizations. Occasionally I was more terse than John was (for better or for worse).
Questions about MS Excel should be directed to Microsoft. Questions about the MS Excel format should be directed to Microsoft. Questions about why I use the hex values that I use should be directed to John McNamara (jmcnamara at cpan dot org).
Add support for files > 7MB Add formulas. Better install/configuration Add comments - for now you can find all appropriate comments in John's module. ;)
Many thanks go to John McNamara for his tireless dedication to a very useful (and probably very popular) module. I also thank him for taking the time to answer some of the questions I had for him while porting his code.
© 2002-2003, Daniel J. Berger All Rights Reserved. This module is free software. It may be used, redistributed and/or modified under the same terms as Ruby itself.
Daniel J. Berger djberg96 at yahoo dot com