Question: C# Selenium: Read rows from html table until the last row is found, and Store in array

Question

The following snapshot is what I see when I do a view of class and Ids in using IE Developer tool. It consists of a table and inside the table there are links. I need to read all the link names, and store the link names in a string array.

https://stackoverflow.com/questions/6510758/c-selenium-read-rows-from-html-table-until-the-last-row-is-found-and-store-in

When I use Firebug to get the Xpath of each of the links, I get:

/html/body/table/tbody/tr/td[2]/table/tbody/tr/td[2]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr/td[4]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr[3]/td[2]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr[3]/td[4]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr[5]/td[2]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr[5]/td[4]/font/a

I had the following method initially, but QuickWatch showed arrTopics as null. It should have given me at least 10 labels. The value of arrTopics should have been something like {"Administration", "Banking", "Marketing", ...} I think this has to do with my xpath (("//a[@class='wlcategoryLinkBold']/@href").

 public List<string> Search(ISelenium Sel)    
{        
    Sel.Click(//*[@id="Search_Tab_Search"]);       
    List<string> topics = new List<string>();        
    int se = (int) Sel.GetXpathCount("//a[@class='wlcategoryLinkBold']/@href");
    for (int i = 1; i <= se; i++)
        {
            if (Sel.IsElementPresent("//a[@class='wlcategoryLinkBold']/@href[" + i + "]"))
            {
                string value = Sel.GetSelectedLabel("//a[@class='wlcategoryLinkBold']/@href[" + i + "]");
                topics.Add(value);
            }
        }

        string[] arrTopics = topics.ToArray();
        return arrTopics;    
}

How do I use

/html/body/table/tbody/tr/td[2]/table/tbody/tr/td[2]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr/td[4]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr[3]/td[2]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr[3]/td[4]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr[5]/td[2]/font/a

/html/body/table/tbody/tr/td[2]/table/tbody/tr[5]/td[4]/font/a
.
.
.

instead of ("//a[@class='wlcategoryLinkBold']/@href) in the Sel.GetXpath()? I see that I need to have another loop that takes care of tr[3], tr[5], td[2], td[4].

Answer 1

Here are some potential problems:

• //a[@class='wlcategoryLinkBold']/@href is an Xpath to an href, not to an "a" tag. Furthermore, //a[@class='wlcategoryLinkBold']/@href[i] is the Xpath to the i'th href of an "a" tag, which is nonsensical. I believe you want to use (//a[@class='wlcategoryLinkBold'][@href])[i].
• GetSelectedLabel gets option label (visible text) for selected option in the specified select element. You seem to want to return the label for an "a" tag, so you want to use GetText.

Please try this instead:

public List<string> Search(ISelenium Sel)    
{        
    Sel.Click(//*[@id="Search_Tab_Search"]);       
    List<string> topics = new List<string>();        
    int se = (int) Sel.GetXpathCount("//a[@class='wlcategoryLinkBold'][@href]");
    for (int i = 1; i <= se; i++)
        {
           string value = Sel.GetText("(//a[@class='wlcategoryLinkBold'][@href])[" + i + "]");
           topics.Add(value);
        }

    string[] arrTopics = topics.ToArray();
    return arrTopics;    
}

Answer 2

You seem to be trying to select the a tags based on an attribute which is on a font tag. Instead, try the xpath selector //a[@target='SearchFrame'] to select all the links. You can use Driver.SelectElements to return these as an IEnumerable<IWebElement>. Sorry if the selector isn't quite right, I'm trying this on my phone so can't check back to the DOM you pasted.

If you need the hrefs themselves, just project these using a lambda expression, such as:

query.Select(e => e.GetAttribute<string>("href"));

This will give you an IEnumerable<string> containing the individual hrefs. Otherwise if you want the link texts, just select

query.Select(e => e.Text);