How can I create "Test Suite" using excel

[Bhagwat Sharma]

Hi all,
I am reading data from a excel sheet and it is working fine. I have
attached a excel sheet with sample data and a format which I m using.
However, now I am facing problem to while creating test suite. Suppose
I want to test two sites "Yahoo" and "gmail". I have added sample test
data to test gmail. Now how can I add test data for yahoo. I need to a
test suite which includes 2 test case. One for to test gmail and
another to test yahoo

Can any one please help?

Regards,
Bhawgat Sharma

[natraj p]

It nice..Will u  send me the script used to read the Excel

--
You received this message because you are subscribed to the Google Groups "Selenium Users" group.
To post to this group, send email to seleniu...@googlegroups.com.
To unsubscribe from this group, send email to selenium-user...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/selenium-users?hl=en.

--
Thanks&Regards,
  Nataraj.P.

[Bhagwat Sharma]

Please find script in attachment.

[Bhagwat Sharma]

Hi All,

I got. It was there in the code it self. Natraj, the script I provided
includes reading data from excel sheet for test suite as well.

On Thu, Jan 6, 2011 at 11:19 AM, Bhagwat Sharma

[BillR]

You could use a different Excel file for each test case, or if you
want to have both test cases in one file, you could interoduce a new
convention like END, e.g. have NEXT to indicate the beginning of a new
case, or just look beyond END to see if there is another. This is a
general programming problem with a variety of possible solutions.

>  Test_ cases for_ selenium.xlsx
> 14KViewDownload

[Bhagwat Sharma]

Actually now we are maintaing all the different test cases in
different excel sheets. Along with this we are using another excel
sheet as a test suite, which only keeps the name of different excel
sheet (where test cases have been written). Now I am facing two
problem.

1. When I read the second sheet or even again first, by browser is
taking login credetails from cookies. It is taking it from
"c://MyDocuments". how I can overcome this issues?

2. If we have 10 test cases, so in the format we started following
will require 11 excel shhet (1 for test suit and 10 for test cases).
We want to make our automation testing user friendly. So could any one
please provide different way to create farme work or any modification
which can make our task easier and better?