Description
Spreadsheet::Excel - A module for generating Excel compatable files on any platform. Version 0.2.3, based on version .26 of Spreadsheet::WriteExcel.
Synopsis
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
Classes
Excel
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#VERSION-
Returns the current version of the module as a string.
Workbook
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#close-
Closes the workbook (and the file). Be sure to do this.
Worksheet
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
Format#new({attributes})-
Creates a new Format object. See the Format documentation for details.
Notes
This is a port of John McNamara's Spreadsheet::WriteExcel module, version .26 There is no support for formulas yet.
Design Changes
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
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).
Future Plans
Add support for files > 7MB Add formulas. Better install/configuration Add comments - for now you can find all appropriate comments in John's module. ;)
Thanks
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.
Copyright
© 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.
Author
Daniel J. Berger djberg96 at yahoo dot com