How to access HTML table using selenium C#

Question

I'm trying to access html using selenium c# web driver.

Part of my html as follows (Full html is here ).



  
     No
     Inst Catg
     Inst - Branch
     CF Type
     CF Stat
     Own - Shp
     Crcy
     Amount Granted / Limit
     Current Balance
     Arrears Amount
     Installment Amount
     Amount Written Off
     Reported Date
     First Disburse Date
     Latest Payment Date
     Restruct Date
      End  Date 
     Repay Type
     Purp.
     Coverage
  
  
     1
     CBC
     OWN-072
     LOAN
     ACTV
     OWN
     LKR
     4,000,000
     3,731,292
     0
     94,290
     
     30-Jun-2018
     14-Feb-2018
     
     
     
     MNLY
     01:001
     FS & OG
  
  
     2
     CBC
     
     CRCD
     ACTV
     OWN
     LKR
     800,000
     0
     0
     
     
     31-Jul-2018
     25-Apr-2018
     
     
     
     DMND
     03:001
     US & NG

In my html there have multiple inner tables. full html code To access this html file, I used following Selenium code.

var table = driver.FindElement(By.Id("reportcontainerstyle-Ver2"));
var rows = table.FindElements(By.TagName("tr"));

//To get days arrears details
var mainTable = driver.FindElement(By.Name("ConsumerCreditDetails_Version3"));
var subTables = mainTable.FindElements(By.Id("bandstyle-Ver2"));

for (int i = 0; i < rows.Count; i++)
{
    if (i != 0)//Skip header
    {
        var row = rows[i];
        var rowTds = row.FindElements(By.TagName("td"));

        if ((rowTds[3].Text.Trim().Equals("LOAN") || rowTds[3].Text.Trim().Equals("LEAS") || rowTds[3].Text.Trim().Equals("CRCD") || rowTds[3].Text.Trim().Equals("OVDR")) && rowTds[4].Text.Trim().Equals("ACTV") && rowTds[5].Text.Trim().Equals("OWN"))
        //if(true)
        {

        }

    }
}

In the HTML file, there have tables with id = bandstyle-Ver2 I need to access 2nd table's data. To achive that I used above selenium code. But when I accessing table like that code. this error is occured.

Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index

can anyone please tell me how to access those data.

Updated: according to @sers answer I used following code:

    var rows = driver.FindElements(By.XPath("//table[.//td[normalize-space(.)='Credit Facility (CF) Details']][1]/following-sibling::table[1]//tr[not(@type='table-header')]"));

    foreach (IWebElement row in rows)
    {
        var cfType = row.FindElement(By.XPath("td[4]")).Text.Trim();
        var cfStat = row.FindElement(By.XPath("td[5]")).Text.Trim();

        if ((cfType.Equals("LOAN") || cfType.Equals("LEAS") || cfType.Equals("CRCD") || cfType.Equals("OVDR")) && cfStat.Equals("ACTV") && cfStat.Equals("OWN"))
        {

        }
    }

Then I also have a problem. I need to access these tables. this is that HTML part In this table I need to get the largest number of each table and if that number > 90 there have logic. to achieve that I used following code.

for (int i = 0; i < rows.Count; i++)
{
    if (i != 0)//Skip header
    {
        var row = rows[i];
        var rowTds = row.FindElements(By.TagName("td"));

        if ((rowTds[3].Text.Trim().Equals("LOAN") || rowTds[3].Text.Trim().Equals("LEAS") || rowTds[3].Text.Trim().Equals("CRCD") || rowTds[3].Text.Trim().Equals("OVDR")) && rowTds[4].Text.Trim().Equals("ACTV") && rowTds[5].Text.Trim().Equals("OWN"))
        {
            for (int subTab = 0; subTab < subTables.Count; subTab++)
            {
                if (subTab > 1)
                {
                    var colsDaysArrers = subTables[subTab].FindElements(By.TagName("td"));
                    if (colsDaysArrers.Count > 0)
                    {
                        if (colsDaysArrers[0].Text.Equals(crib.NO.ToString()))
                        {
                            for (int j = 1; j <= colsDaysArrers.Count - 1; j++)
                            {

                                var text = colsDaysArrers[j].Text;
                                if (!(text.Equals("--") || text.Equals("OK") || text.Equals("")))
                                {
                                    var val = double.Parse(text);
                                    if (val > 90)
                                    {
                                        crib.FACILITYARREARSSTATUS = "Irrigular";
                                        break;
                                    }
                                    else
                                    {
                                        crib.FACILITYARREARSSTATUS = "Regular";
                                    }

                                }
                            }

                            break;

                        }
                    }
                }
            }

        }

    }
}

Please tell me is this code is fine to do this? or have any otherway to do this?

Sers · Accepted Answer

First "Credit Facility (CF) Details" table:

driver.FindElement(By.Xpath("//table[.//td[normalize-space(.)='Credit Facility (CF) Details']][1]/following-sibling::table[1]"));

Second "Credit Facility (CF) Details" table:

driver.FindElement(By.Xpath("//table[.//td[normalize-space(.)='Credit Facility (CF) Details']][2]/following-sibling::table[1]"));

"Details of Settled Credit Facilities (Last 5 Years)" table:

driver.FindElement(By.Xpath("//td[normalize-space(.)='Details of Settled Credit Facilities (Last 5 Years)' and @class='tblHeader']/ancestor::table[1]"));

"Summary of Potential and Current Liabilities (Excluding Settlements)" table:

driver.FindElement(By.Xpath("//td[normalize-space(.)='Summary of Potential and Current Liabilities (Excluding Settlements)' and @class='tblHeader']/ancestor::table[2]//table[2]"));

Get all rows except header of first "Credit Facility (CF) Details" table:

var rows = driver.FindElements(By.Xpath("//table[.//td[normalize-space(.)='Credit Facility (CF) Details']][1]/following-sibling::table[1]//tr[not(@type='table-header')]"));

foreach (IWebElement row in rows)
{
    var cfType = row.FindElement(By.Xpath(".//td[4]")).Text.Trim();
    var cfStat = row.FindElement(By.Xpath(".//td[5]")).Text.Trim();

    if ((cfType.Equals("LOAN") || cfType.Equals("LEAS") || cfType.Equals("CRCD") || cfType.Equals("OVDR")) && cfStat.Equals("ACTV") && cfStat.Equals("OWN"))
    {
        foreach (IWebElement colsDaysArrers in driver.FindElements(By.Xpath("//tr[./td[@class='textbrownNew' and @counter='true']]/td[not(@counter='true')]")))
        {
            var text = colsDaysArrers.Text;
            if (!(text.Equals("--") || text.Equals("OK") || text.Equals("")))
            {
                if (double.Parse(text) > 90)
                {
                    crib.FACILITYARREARSSTATUS = "Irrigular";
                    break;
                }
                else
                {
                    crib.FACILITYARREARSSTATUS = "Regular";
                }
            }
        }
    }
}

How to access HTML table using selenium C#

Answers (2)

Related Questions