[Wtr-general] Excel Or Text File?

2006-12-05 Thread Fletch
Hello Again, I have currently got a WATIR Script running, and use a text file to hold all the constants. However I have had a request to change this text file to a Spreadsheet - does it make sense to use a spreadsheet to hold all the constants? From what I have seen, I would have to call the ce

Re: [Wtr-general] Excel Or Text File?

2006-12-05 Thread Charley Baker
Here's an excellent page on scripting Excel through Ruby: http://wiki.rubygarden.org/Ruby/page/show/ScriptingExcel You could have a column with your constants and the next column over be the values and iterate through the rows assigning those to a constant Hash or something of the sort. There are

Re: [Wtr-general] Excel Or Text File?

2006-12-05 Thread John Lolis
If these are just a couple of simple constants why not make it a ruby file? require a file somewhere in your scripts and do something like $name = 'name' $password = 'password' $url = 'url' its easy to figure out, and no need to parse anything. ---

Re: [Wtr-general] Excel Or Text File?

2006-12-06 Thread Fletch
That is what I have at the minute, but I am under pressure to use a Spreadsheet. I thought that the text file was a much better and more simple idea. - Posted via Jive Forums http://forums.openqa.org/thread.jspa?threadID=5619&mes

Re: [Wtr-general] Excel Or Text File?

2006-12-06 Thread Chris McMahon
On 12/6/06, Fletch <[EMAIL PROTECTED]> wrote: That is what I have at the minute, but I am under pressure to use a Spreadsheet. I thought that the text file was a much better and more simple idea. There is a fair amount in the archives on this subject. My own opinion is to use a spreadsheet w

Re: [Wtr-general] Excel Or Text File?

2006-12-06 Thread Michael Bolton
rge.org Subject: Re: [Wtr-general] Excel Or Text File? That is what I have at the minute, but I am under pressure to use a Spreadsheet. I thought that the text file was a much better and more simple idea. - Posted via J

Re: [Wtr-general] Excel Or Text File?

2006-12-06 Thread Charley Baker
Chris has some salient points. Another advantage of using a delimited file that you can use through Excel is version control. Using a delimited file makes it easier to diff and/or merge through Subversion or whatever your SCM tool might be as opposed to using an Excel file. -Charley On 12/6/06,

Re: [Wtr-general] Excel Or Text File?

2006-12-06 Thread Danny Faught
Fletch wrote: > That is what I have at the minute, but I am under pressure to use a > Spreadsheet. I thought that the text file was a much better and more simple > idea. A comma-delimited (comma-separated-value / csv) file is a great compromise, as was mentioned earlier. A spreadsheet applicat

Re: [Wtr-general] Excel Or Text File?

2006-12-08 Thread Fletch
Thanks for all your replies. I will look in to using the CSV files - sounds like the solution I was looking for. PMF - Posted via Jive Forums http://forums.openqa.org/thread.jspa?threadID=5619&messageID=15858#15858 __

Re: [Wtr-general] Excel Or Text File?

2006-12-11 Thread Cain, Mark
that comes with Ruby. --Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fletch Sent: Friday, December 08, 2006 1:25 AM To: wtr-general@rubyforge.org Subject: Re: [Wtr-general] Excel Or Text File? Thanks for all your replies. I will look in to using

Re: [Wtr-general] Excel Or Text File?

2006-12-19 Thread Bret Pettichord
Charley Baker wrote: > Chris has some salient points. Another advantage of using a delimited > file that you can use through Excel is version control. Using a > delimited file makes it easier to diff and/or merge through Subversion > or whatever your SCM tool might be as opposed to using an Exce

Re: [Wtr-general] Excel Or Text File?

2006-12-19 Thread Lou Wilson
In another thread I described how I handle that problem. I maintain the constants and variables in an Excel sheet. But I have a macro on the sheet that writes those out to another file. You have a choice at that point: to have the macro write all or part of your .RB file and execute it, as I am