Getting row number from the data bind excel sheet in coded step.

Hello,

I apologize for the delay getting back to you on this. We are temporarily overloaded in support at the moment.

But i am not getting the currently selected rowindex from excel.

I'm afraid our data driven testing doesn't work that way. During test initialization Test Studio reads all of the data from the datasource and creates an in-memory .NET DataTable object with the data put into it. Once the data has been fully read Test Studio closes the datasource (e.g. Excel file). It then begins iterating through these rows of data.

We do provide a way to get at the full data source specification in code:

Using the above information along with:
this.Data.IterationIndex; // The current iteration, always starts at 0

You could calculate the correct place in the Excel file to write into. I hope this helps.

Regards,
Cody
Telerik

Hi Cody,
As you said, i have use following code in my script:
  ExecutionContext.Current.Test.DataInfo.DataProvider;
  ExecutionContext.Current.Test.DataInfo.DataTable;
  ExecutionContext.Current.Test.DataInfo.DataRangeString;

I can able to fetch this.Data.IterationIndex; property in code, it is working properly when we use it in script test.
But when i am  trying to capture it inside the namespace class method then couldn't found Data.IterationIndex property.

I have already created forum for that http://www.telerik.com/automated-testing-tools/community/forums/test-studio/general-discussions/unable-to-get-data-iterationindex-property-inside-class-method.aspx
Please give me solutions for that at earliest as possible.

Thanks,

Hello Priyanka,

"Data" is an object that is defined in the base class "BaseWebAiiTest", which is the base class for all Test Studio test code behind files. Since your utility class does not derive from this base class, you are not inheriting its definition. But please do NOT use BaseWebAiiTest for your utility class because the base class will not get initialized properly, including the Data object.

Instead you can do one of two things:

• Pass "Data" as a parameter to your utility class methods
• Pass "Data" as a parameter to the constructor of your utility class, store it in a variable and refer to the variable in your utility class methods

Regards,
Cody
Telerik

Hello Priyanka,

"Data" is an object that is defined in the base class "BaseWebAiiTest", which is the base class for all Test Studio test code behind files. Since your utility class does not derive from this base class, you are not inheriting its definition. But please do NOT use BaseWebAiiTest for your utility class because the base class will not get initialized properly, including the Data object.

Instead you can do one of two things:

• Pass "Data" as a parameter to your utility class methods
• Pass "Data" as a parameter to the constructor of your utility class, store it in a variable and refer to the variable in your utility class methods

Regards,
Cody
Telerik

Hi cody,

Thanks for your help,I am passing Data as parameter to utility class methods and it is working properly.
I have also try to Pass "Data" as a parameter to the constructor of  utility class, but i am not getting it. Is it possible to you to explain me in detail.
I have write the following code in my UtilityClass.
UtilityClass.test

  public static class Utility
    {
        public static void Validate(string mypath, string alertmsg, string comparemsg, string passmsg)
        {
            Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel.Workbook workbook = excelApp.Workbooks.Open(mypath);
            System.Threading.Thread.Sleep(1000);
            
            if(alertmsg == comparemsg )
            {
                 excelApp.Cells[ 2, 1] = passmsg; ---------------------------------------- Here, i want to pass Data.IterationIndex+2 instead of 2
            }
            else
            {
                excelApp.Cells[2 , 1] = "Pass: Record save";---------------------------Here, i want to pass Data.IterationIndex+2 instead of 2
            }
           
            excelApp.Visible = true;
            excelApp.ActiveWorkbook.Save();
            workbook.Close(false, Type.Missing, Type.Missing);
            excelApp.Workbooks.Close();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(workbook);
            excelApp.Quit();
            GC.Collect();
            System.Runtime.InteropServices.Marshal.ReleaseComObject(excelApp);
        }
    }
       
I am calling that Validate method in another test i.e. SSN_Duplicate.test

[CodedStep(@"New Coded Step")]
        public void SSN_Duplicate_CodedStep()
        {
            ArtOfTest.WebAii.Core.Browser radwindow=ActiveBrowser.Frames["Radwindow1"];
            ArtOfTest.WebAii.Controls.HtmlControls.HtmlDiv condiv=radwindow.Find.ById<ArtOfTest.WebAii.Controls.HtmlControls.HtmlDiv>("jpopup_container");
            ArtOfTest.WebAii.Controls.HtmlControls.HtmlDiv popupdiv=condiv.Find.ById<ArtOfTest.WebAii.Controls.HtmlControls.HtmlDiv>("popup_message");
            string msg=popupdiv.InnerText;
           
            string path= @"C:\Users\priyanka.kadam\Desktop\Automation_excel\Data_Driven_Test.xlsx";
            Utility.Validate(path,msg,"Attention!SSN #Already exists.","Fail:SSN Duplication");
        }

Hi Priyanka,

I have also try to Pass "Data" as a parameter to the constructor of  utility class, but i am not getting it. Is it possible to you to explain me in detail.

Sure. First to do this you can't use static class or static method. Here is sample code to demonstrate the approach:

Regards,
Cody
Telerik

Hello,

The code to put in your Test Studio test didn't make it through. Here it is:

Regards,
Cody
Telerik

Hi cody,

Thanks for explaning this things in details and it is working properly.
Thanks for your valuable guidance.

I have write another forum but didn't get replay yet.
Can you please help me out to solve that problem, its urgent.
Please check out the following forum.
http://www.telerik.com/automated-testing-tools/community/forums/test-studio/general-discussions/how-to-pass-excel-worksheet-name-path-as-string.aspx

Thanks,

Hi,

I see that Velin has answered your other forum post.

Regards,
Cody
Telerik