Comments by Member 10562086 (Top 28 by date)

Sir . I have one excel sheet,the excel sheet data and what ever data from datatable data both are same . i want compare both "datatable" data and excel sheet each cell data .please help on that ,if both data is same then i want display message ,,other wise i have to display message ,,like "data miss match in excel sheet and Datatable data in row no 8 and column 10" like that ,please help me

thanks for your reply :)

hello sir I need one help. I want display meaasge inside message box ,message is like "this sheet have non zero amount in the pariculor(row no) and and pariculor ( column no) please check it"
I am comparing pariculor cell value with "0" by the method Assert.AreEqual("0", values); and once it catch it will go to catch and display message like what I mention in above and my test case should be fail .
but what ever I declare row and column variable ,how to use inside the catch and how to display that row and column in the meaasge box .bellow code is there

try
{
int row;
int column;
for (Row = 22; Row <=23; Row++)
{
for (Colm = 5; Colm <= 18; Colm++)
{
excelProperties.excelCell.Set_CellIndices(Row, Colm);
string values = excelProperties.excelCell.Get_CellValue();

Assert.AreEqual("0", values);
Playback.Wait(500);
}

}

MessageBox.Show("There is no zero data in revenue input sheet");

}
catch (Exception ex)
{

MessageBox.Show("This sheet contains non zero amount, please check it in row " + Row + " and column " + Colm);
Assert.IsNull(ex, ex.Message);
}
}

thank you Shankar.i have one question ,why you initialize i=2 and j=1 ,which is row and which is column .suppose I want check data from particular row range(10th row to 25 th row )and particular column range (column "E" to "G" column )on this condition how to check