Data Driven Testing with JXL in Selenium -- Part 8 (Framework Design and Development Video)

This video is the continuation of Part 7, in this video we are going to extend our JXL code as a reusable library.

[shrikanthabm]

I got error when i use this code then i used this line in main to over come that erro . am i write ?? --> ex.ColumnDictionary();
public class googlesearch {

public static void main(String[] args) throws InterruptedException, BiffException, IOException {
// TODO Auto-generated method stub

WebDriver driver= new FirefoxDriver();
GoogleHomepageObject page= new GoogleHomepageObject(driver);

ExcelSheetDriver ex= new

ex.ColumnDictionary();
System.out.println(ex.ReadCell(ex.GetCell("search"), 1));

Thread.sleep(5000);
page.searchgoogle(ex.ReadCell(ex.GetCell("search"), 1));

[GA-htmf]

Karthik:  I still have no luck to get the code read from the second or the third column.  I retype the same code for fourth time.

[coolchandu]

Did you save your excel with first column as 'TestCaseID' ? If so....for loop returns nothing. Please check once

[JyotiSingh-knls]

Hi Karthik, our videos have been of great help to me. thanks alot for uploading the videos.
I have one request, if possible can we have a video series to explain coded ui automation framework development and what is the meaning of automation framework?

[eraheem]

Hi Karthik:

When I run the code (around 5:47 min of your video), I get the following error message:

Exception in thread "main" Element is not currently visible and so may not be interacted with
Command duration or timeout: 23 milliseconds

Can you provide me with any clue why this might be happening? Thanks!

[GA-htmf]

Hi Karthik:

When I run the code you developed in the video number 8, the code was reading the first column only in the spreadsheet and ignoring the index name of the column hat specified in the code. So, I was playing to read data from column three and four but the code keep pulling data from column one and populate the webpages.

[indratan]

I seems can't find where did you call the "ColumnDictionary()" method.. need to call this method somewhere to populate the hashtable (dictionary).. but I rewatched and paused, just cant find where this method is called from?btw. great tutorial.. pls advise. thanks

[preetishkumar]

hi karthik
any video for hybrid framework..

[rickjwn]

Hi,
I don't see use of Keywords in this framework. Hybrid = Data+keywords. Thank You

[AshokAkurathi]

Hi Karthik, can u paramerize the sheet details just like column name.

Thanks in advance.

[webreaver]

Don't you have like a "foreach" in Java?