Writing to Excel

[Kumar]

Hi,

How can i write my result to excel sheet?.

Regards
Kumar

[Cody]

Hi Kumar,

Are you asking how to write code that writes to an Excel spreadsheet? Here's one link of many from a Google search:

http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/ef11a193-54f3-407b-9374-9f5770fd9fd7

Are you asking how to log the pass/fail of a test? This must be done in the [TestCleanup()] section. You can refer to the TestContext.CurrentTestOutcome property to determine the results of a test, then write it to your Excel file.

        [TestCleanup()]

All the best,

Cody

the Telerik team

[Swaroop]

HI COdy,
How can I write the value of an extracted variable into an excel sheet using coded step?
I am capturing the value from the application dynamically while executing the steps using "Extraction" option

Thanks,
Swar.

[Cody]

Hello Swaroop,

You can fetch the value of an extracted variable with code like this:

string newReq = (string)GetExtractedValue("varname");

From there it's just a matter of storing the value into your Excel file (or any other data file) using code like shown in the link of my previous post.

Greetings,
Cody
the Telerik team

[Swaroop]

Thanks Cody.
I have tried the code mentioned in the previous post. But I am getting as I am not using the correct NameSpace.
Could you please let me me know which type of Namespace to be used to make the code work?

[Cody]

Hi Swaroop,

The GetExtractedValue function is contained in BaseWebAiiTest, which our standard code behind files use as a base like this:

    public class WebAiiTest1_7 : BaseWebAiiTest
    {

        [CodedStep("MyCustom Step Description")]
        public void MyCustomStep()
        {
<rest of code snipped>

Are you using our standard code behind model? You posted this in our Telerik Testing Framework forum. That product doesn't include BaseWebAiiTest (nor does it reference coded steps from Test Studio).

It might help if you sent me your entire test project for me to analyze. Put the entire folder into a .zip and attach that file. You may want to open up a new support ticket to keep it private between you and my support team.

Regards,
Cody
the Telerik team