Re: [Wtr-general] Using Excel
May be This ... http://rubygarden.org/Ruby/page/show/ScriptingExcel ___ Wtr-general mailing list Wtr-general@rubyforge.org http://rubyforge.org/mailman/listinfo/wtr-general
Re: [Wtr-general] Using Excel
That page has been down for me for a while, so just in case, here's another link that someone posted last week: http://wiki.openqa.org/display/WTR/Excel+interface+class Adam -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of san Sent: Monday, June 25, 2007 6:46 AM To: wtr-general@rubyforge.org Subject: Re: [Wtr-general] Using Excel May be This ... http://rubygarden.org/Ruby/page/show/ScriptingExcel ___ Wtr-general mailing list Wtr-general@rubyforge.org http://rubyforge.org/mailman/listinfo/wtr-general ___ Wtr-general mailing list Wtr-general@rubyforge.org http://rubyforge.org/mailman/listinfo/wtr-general
Re: [Wtr-general] Using Excel
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 Message was edited by: tcfodor ___ Wtr-general mailing list Wtr-general@rubyforge.org http://rubyforge.org/mailman/listinfo/wtr-general
Re: [Wtr-general] Using Excel
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
Re: [Wtr-general] Using Excel
Thanks so much David! I've been using your XLS class for lots of data-driven tests - I really appreciate all the work you've put into it! It's certainly made my life easier. -Tiffany ___ Wtr-general mailing list Wtr-general@rubyforge.org http://rubyforge.org/mailman/listinfo/wtr-general
Re: [Wtr-general] Using Excel
On 22/06/07, Daniel Kurtz [EMAIL PROTECTED] wrote: I hear the DataManager library is something of a turkey and will probably be pulled from future distros of Watir. Is there a good Ruby alternative for reading (and writing) Excel files from Watir scripts? Have a look at this: http://wiki.openqa.org/display/WTR/Excel+interface+class Aidy ___ Wtr-general mailing list Wtr-general@rubyforge.org http://rubyforge.org/mailman/listinfo/wtr-general
[Wtr-general] Using Excel
I hear the DataManager library is something of a turkey and will probably be pulled from future distros of Watir. Is there a good Ruby alternative for reading (and writing) Excel files from Watir scripts? Thanks. daniel ___ Wtr-general mailing list Wtr-general@rubyforge.org http://rubyforge.org/mailman/listinfo/wtr-general
Re: [Wtr-general] Using Excel
Have a look at this: http://wiki.openqa.org/display/WTR/Excel+interface+class Cool! Thanks. daniel ___ Wtr-general mailing list Wtr-general@rubyforge.org http://rubyforge.org/mailman/listinfo/wtr-general