Issue using Excel and variables in name mapping
I am using variables in name mapping objects to pull data from an Excel sheet and then verify with Property Checkpoints.
It is working fine for the first 3 rows in my sheet. But on the fourth row I am getting an error for the address. The previous 3 addresses worked fine. The local variable was updated and checkpoint passed. Also the first four checkpoints for this fourth row of data worked fine, it just fails on the address.
I cannot figure out why this fourth one is failing. Any ideas? Lots of info/screenshots below that will hopefully help.
Name Mapping object using variable:
Project level variable:
Excel sheet with address data:
function ReadManifestData()
{
// Get the sheet of the Excel file
var excelFile = Excel.Open(Project.ConfigPath + "Datasheet.xlsx");
var excelSheet = excelFile.SheetByTitle("ViewData");
// Read data from the Excel file
var RowIndex = KeywordTests.CheckManifestScreen.Variables.RowIndex_KW;
var Order_Num = excelSheet.Cell("A", RowIndex).Value;
var HIN_Num = excelSheet.Cell("B", RowIndex).Value;
var TrackNum = excelSheet.Cell("C", RowIndex).Value;
var Forecasted = excelSheet.Cell("D", RowIndex).Value;
var Street_Addr = excelSheet.Cell("E", RowIndex).Value;
var ServiceLevel = excelSheet.Cell("F", RowIndex).Value;
var Commit_Time = excelSheet.Cell("G", RowIndex).Value;
var Cons_Name = excelSheet.Cell("H", RowIndex).Value;
var Floor_Num = excelSheet.Cell("I", RowIndex).Value;
var Postal_Code = excelSheet.Cell("J", RowIndex).Value;
var City_Name = excelSheet.Cell("K", RowIndex).Value;
var State_Name = excelSheet.Cell("L", RowIndex).Value;
var Country_Code = excelSheet.Cell("M", RowIndex).Value;
var Urbanization = excelSheet.Cell("N", RowIndex).Value;
Project.Variables.Order_Num_KW = Order_Num;
Project.Variables.HIN_Num_KW = HIN_Num;
Project.Variables.TrackNum_KW = TrackNum;
Project.Variables.Forecasted_KW = Forecasted;
Project.Variables.StreetAddr_KW = Street_Addr;
Project.Variables.ServiceLevel_KW = ServiceLevel;
Project.Variables.Commit_Time_KW = Commit_Time;
Project.Variables.ConsName_KW = Cons_Name;
Project.Variables.Floor_Num_KW = Floor_Num;
Project.Variables.Postal_Code_KW = Postal_Code;
Project.Variables.City_Name_KW = City_Name;
Project.Variables.State_Name_KW = State_Name;
Project.Variables.Country_Code_KW = Country_Code;
Project.Variables.Urbanization_KW = Urbanization;
}
Keyword test:
Log:
Thank you for letting me know Guru2 ! We are on it.
In the meantime, here's the direct link - https://smartbear.wistia.com/medias/nngm44mhaw