How to assert decimal Excel value with the web value using Selenium WebDriver?

Question

The value mentioned in the Excel file is 21.650 and same value is presented on the page. But when script executes, it reads Excel value as 21.65 and my assert condition becomes false.

List<string> rowValue = new List<string> { };
var ExcelFilePath = "D:\\testexcel.xlsx";

Excel.Application xlApp = new Excel.Application(ExcelFilePath);
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(ExcelFilePath);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;

int rowCount = xlRange.Rows.Count;

for (int i = 1; i <= rowCount; i++)
{
    rowValue.Add(xlRange.Cells[i, j].Value2.ToString());

    IWebElement element = driver.FindElement(By.Id(weight_field));
    ((IJavaScriptExecutor)driver).ExecuteScript("arguments[0].scrollIntoView(true);", element);

    string weight = driver.FindElement(By.Id(weight_field)).Text;

    if (mpuid == i)
    {  
        Assert.AreEqual(weight,rowValue[0]);
        Console.WriteLine(" Expected Value: " + rowValue[0] + " is equal to Actual Value: " + weight);
        break;
    }

    rowValue.Clear();
}

score 0 · Accepted Answer · edited Sep 23 '15 at 08:45

0

In your Excel file, change your cell Category as Text.

edited Sep 23 '15 at 08:45

halfer

19,824
17
99
186

answered Sep 23 '15 at 06:25

Mahsum Akbas

1,523
3
21
38

score 0 · Answer 2 · edited May 23 '17 at 12:14

0

Use DataFormatter class as suggested in answer forThis SO question. As this will return the exact text from excel file as it is displayed.

edited May 23 '17 at 12:14

Community

1
1

answered Sep 23 '15 at 06:31

MKay

818
9
32

How to assert decimal Excel value with the web value using Selenium WebDriver?

2 Answers2