Re: Read from XLS and substitute values in Ruby (Watir)

Also,Is there a way to read from csv file or xls file because currently
I am trying to read from a txt file.
Should I Require/import any particular libraries before trying to read
from a CSV or an xls file.
Any help appreciated.

Thanks again,
Madu

Madu Nar wrote:
Hello Paul,
Thank you so much for the Info...
I tried and it did work. But, how do I pass each of those split
tokens as separate parameters for the text fields.

Ex: ie.text_field(:name,
"SearchFormHandler.searchTerms").set("Brian Kantz")
ie.select_list(:name,
"SearchFormHandler.state").select("California")

So the values Brian Kantz, California should be automatically
substituted from the file... Your help is greatly appreciated...

Thanks,
Madu

Paul Lutus wrote:

Madu Nar wrote:

I need to pass each row of records into a text_fields for username and
password and click on go...

I need to do this till the end of the file... could somebody tell me as
to how I parameterize the values for the text fields so that it
automatically picks up the records for each row...

In your example above, one of the field names is "User Name", with a
space.
Yet the field separator for the data records below it appears to uses
one
or more spaces as delimiters. On the other hand, it might be tabs, hard
to
tell from your post.

Let's assume that tabs are used instead of spaces between the fields. If
that is true, then (untested):

File.read("filename").each do |record|
record.split("\t").each do |field|
# your turn
end
end


--
Posted via http://www.ruby-forum.com/.

.

Relevant Pages

  • Hidden rows still visuale under CSV
    ... The file Extension .CSV stands for Comma Separated Values. ... When you save an Excel .xls file as a .CSV file only the ...
    (microsoft.public.excel.misc)
  • RE: Convert .CSV format to .XLS format in C#
    ... But how it is usfull in converting .csv file to .xls file. ... I used delimited and set a special delimiter character | to match your data. ... .TextFilePromptOnRefresh = False ...
    (microsoft.public.excel.programming)
  • Re: Cant Prevent Recalculation
    ... Unfortunately opening a CSV file triggers a recalculation, ... updated the tabs from the CSV files, ... I have the workbook set to MANUAL for recalculation. ... SkipBlanks _ ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Access and Outlook Express
    ... field to one of the unused ones such as Business Phone, Business Fax, etc. ... > OE has 5 tabs in which it can store data, ... >>>I dont get the ability to link the CSV file with Express. ... I am trying to go from Access to Outlook ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Numbers are interpreted as varchar columns by the text file connection
    ... I am using a Text File connection and the input is a CSV file ... and the first row of the file as column headers. ... a .xls file and use a .XLS file as the connection with column headers ...
    (microsoft.public.sqlserver.dts)