Search
 
 

Display results as :
 


Rechercher Advanced Search

Latest topics
» FlexMonkium Download Not available under Gorillalogic site
Thu Dec 08, 2016 5:40 pm by bhanu.praveen

» Selenium Script issue
Tue Dec 06, 2016 9:48 pm by njain213

» Difference between QTP, Selenium and Silk test
Tue Dec 06, 2016 7:58 pm by jessicacyrus1

» Where does selenium script pick browser from
Tue Dec 06, 2016 1:52 pm by janbaskt

» Safari throws an HTTP ERROR: 404
Tue Dec 06, 2016 1:51 pm by janbaskt

» Access Denied Error in Selenium RC
Tue Dec 06, 2016 1:51 pm by janbaskt

» Automating Flex application through selenium webdriver
Fri Dec 02, 2016 2:06 pm by abhinay.krs

» Starting with Selenium, what is Selenium?
Mon Nov 28, 2016 4:00 pm by Foma

» Getting started with Selenium
Mon Nov 28, 2016 3:23 pm by Rebbelx

Navigation
 Portal
 Index
 Memberlist
 Profile
 FAQ
 Search

How to import the values from excel

View previous topic View next topic Go down

How to import the values from excel

Post by gchandrasekaran82 on Wed Feb 16, 2011 4:01 pm

Hi Folks,

Thanks in advance.

can you please let me know that how come we import the values from excel?

Every time i want to select the different value...it would be better to take the values from Excel...

Please let me know is there any for Selenium IDE to import?

Regards,
Chandra

gchandrasekaran82
Regular Participant
Regular Participant

Posts : 33
Join date : 2011-02-16

Back to top Go down

Re: How to import the values from excel

Post by Adviser on Wed Feb 16, 2011 8:02 pm

hi,

It's a tricky task for selenium IDE. You can run your javascript which can read your excel at run time and pass that value into variable and use that variable into script.

First make the code working in javascript without any error and call it into command storeEval which save the value return from your snippet.

But if you will use RC, it's very easy through programming features.
Hope this will help. Best of luck.

Adviser
------------------------
------------------------

Posts : 379
Join date : 2009-07-30
Location : India

http://seleniumforum.forumotion.net

Back to top Go down

Re: How to import the values from excel

Post by gchandrasekaran82 on Wed Feb 16, 2011 8:51 pm

Can you please let me know how to install RC?

gchandrasekaran82
Regular Participant
Regular Participant

Posts : 33
Join date : 2011-02-16

Back to top Go down

Re: How to import the values from excel

Post by monkey121 on Mon May 09, 2011 7:50 pm

Could someone show a simple example how to import and export vales from/to excel

monkey121

Posts : 3
Join date : 2011-05-09

Back to top Go down

Re: How to import the values from excel

Post by selenium.testing07 on Tue May 10, 2011 6:37 pm

My question........to MR. monkey and gchandra
Which API you guys are using?
Then i'll show out with example.

Cheers,

selenium.testing07
Regular Participant
Regular Participant

Posts : 26
Join date : 2010-11-20

Back to top Go down

Re: How to import the values from excel

Post by monkey121 on Tue May 10, 2011 9:27 pm

Hi selenium.testing07

I am using IDE to make the script then adding in JavaScript to pull in random valves and running it from RC (But do plan to add in some php code)

monkey121

Posts : 3
Join date : 2011-05-09

Back to top Go down

multiple values for a variable

Post by phoenix1 on Sun Dec 30, 2012 2:20 am

I have no experience of Selenium but have used other products to automate web pages and I am looking at how to use Selenium as a replacement.
< Steps :
Reading the excel spreadsheet is the first step, automatically creating the selenium variables from the spreadsheet headers would be the second step.
How can a variable in selenium contain multiple values to form an array of values under the single variable name ? eg
seq user password
1 bill organise
2 jen orange
3 dave apple
< Expected Result :
A simple array of values for each specified variable.
${seq} with ${seq[0]}==1, ${seq[1]}==2 and ${seq[2]}==3
${user} with ${user[0]}==bill, ${user[1]}==jen and ${user[2]}==dave
${password} with ${password[0]}==organise, ${password[1]}==orange and ${password[2]}==apple
How can this be done ?

phoenix1

Posts : 1
Join date : 2012-12-30

Back to top Go down

Re: How to import the values from excel

Post by Sponsored content Today at 8:11 am


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum