Tiffany,
I've generated r-doc documentation for the XLS class and uploaded it to
the watir site
(http://wiki.openqa.org/display/WTR/Excel+interface+class).  It includes
some short comments on the methods used to write to excel (also listed
below).  There should be examples of using each of the methods in the
associated unit tests.

Here are the methods for writing to excel:
def write2DArray(data, myRange,sheet = nil)
#writes out the 2D Array  *data* starting at the specified range
*myRange* on the specified sheet

def writeArrayHash(data, myRange,sheet = nil)
#writes out the Array hash  *data* starting at the specified range
*myRange* on the specified sheet.
#the keys are used as column headers starting at the specified range.

def save #saves the current workbook
def addSheet(sheetName)# Adds a new worksheet to workbook
def deleteSheet(sheetName)# Deletes a worksheet from the workbook

-David

---------------------------------------------------------------
I've been using the XLS interface class to get data for data-driven
tests, but now I'd like to write data out to an Excel spreadsheet.

Does anyone know if there is a list of the available methods for the XLS
interface class?  The documentation at
http://wiki.openqa.org/display/WTR/Excel+interface+class mentions that
you can write to Excel, but doesn't show the methods to use.  I've
checked the rdoc as well, but I don't see any information there either.

Thanks!

-Tiffany
_______________________________________________
Wtr-general mailing list
Wtr-general@rubyforge.org
http://rubyforge.org/mailman/listinfo/wtr-general

Reply via email to