working on updated excel file from previous test cases

Class library usage, coding and language questions.
c676228
Posts: 176
Joined: Mon Apr 06, 2015 5:40 am

working on updated excel file from previous test cases

Post by c676228 » Tue Jun 09, 2015 11:53 pm

Hi,

I have read some posts about modifying data in excel. I am still not so clear.

I have an excel sheet with the last column named result being marked either success or fail in test case 1 after each iteration.
My plan is in test case 2, the data will be fetched with the same excel file with with rows marked "success" from test case 1, and further working on the data.

Will it be ok?

Thanks,
Betty

User avatar
Support Team
Site Admin
Site Admin
Posts: 11710
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: working on updated excel file from previous test cases

Post by Support Team » Wed Jun 17, 2015 1:26 pm

Hi Betty,

In general writing data into an excel file can be done using the .NET Framework.
There are already some forum posts including code snippet showing how to do that.

http://www.ranorex.com/forum/desperatel ... tml#p16024

http://www.ranorex.com/forum/problem-wi ... tml#p25967

I hope this helps.

Regards,
Bernhard
.
Image

c676228
Posts: 176
Joined: Mon Apr 06, 2015 5:40 am

Re: working on updated excel file from previous test cases

Post by c676228 » Thu Jun 18, 2015 2:22 am

Hi Benhard,

Sorry for the confusion. That's not what I am asking.

As you know, when you run a test suite, following the initial opening a web application, login and then staring to run other test cases. These test cases doesn't have to do the initial opening a web application, login etc since it runs in series and the test pages are available when the test cases running
However if a user choose to run a single or a couple of test cases among the test suite, what I am trying to do is let the program check, if the test case is running individually or not, if there is no available page ready for the test case to act on. Prepare that page(opening a browser, login in etc.) for that test case to act on.

So what I was asking is what is the best way to do that.

Thanks,
Betty

User avatar
Support Team
Site Admin
Site Admin
Posts: 11710
Joined: Fri Jul 07, 2006 4:30 pm
Location: Graz, Austria

Re: working on updated excel file from previous test cases

Post by Support Team » Mon Jun 22, 2015 9:43 pm

Hi Betty,

I am sorry, but I don't understand the use case and what do you exactly want to do.
Maybe it is better to discuss the issue in a remote session.
Please send an email to [email protected] in order to schedule a meeting.
Thank you.

Regards,
Bernhard
.
Image