[JVM] How to take testdata from excel spreadsheet to feed Cucumber-JVM tests (with Webdriver )

[Isaac Mova]

Hi,

Any ideas on data parameterization with Excel for Cucumber-JVM tests on WebDriver.

I know that we take test data from feature files most of the times, but is there a way that we can feed test data from spreadsheet like how TestNG supports parameterization.

The reason why i am asking this is, i do not want to give system admin login details in feature files or some config.java file. I just want to keep all this data in a excel workbook and use it repeatedly. 

Regards,

Isaac

[aslak hellesoy]

You can read Excel sheets with Apache POI in your step definitions.

Aslak

 

Regards,

Isaac

--
-- Rules --
 
1) Please prefix the subject with [Ruby], [JVM] or [JS].
2) Please use interleaved answers http://en.wikipedia.org/wiki/Posting_style#Interleaved_style
3) If you have a question, don't reply to an existing message. Start a new topic instead.
 
You received this message because you are subscribed to the Google Groups Cukes group. To post to this group, send email to cu...@googlegroups.com. To unsubscribe from this group, send email to cukes+un...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/cukes?hl=en
---
You received this message because you are subscribed to the Google Groups "Cukes" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cukes+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[Peter DoMySEO]

You may consider http://openl-tablets.sourceforge.net/features

Usage:

http://openl-tablets.sourceforge.net/docs/openl-tablets/5.10.2/OpenL%20Tablets%20-%20Developer%20Guide/index.html

[Srisowrabha Kumar]

Hi Aslak,

May I know, once we read the data from the spread sheet, how Cucumber enters the value into the required field? For instance, below is my step definition method which enters value into a text field.

@And("Enter Person in \"([^\"]*)\" field \"([^\"]*)\"")

public void enterPersonName(String fieldLabel, String value){

String locator = getLocator("textFieldWithLabel").replaceAll("toReplaceWithFieldLabel", fieldLabel); // This syntax will read an xpath from a property file and replace few stuffs

type(locator, value);

}

Here, I need to enter "value" into a text field. If I have written a method to read a spread sheet and return a value, how does Cucumber do this job, as I have specified in the "And" annotation to look for the value from the feature file.

Thanks,

Sowrabha

[Aslak Hellesøy]

On Friday, 7 November 2014 at 05:49, Srisowrabha Kumar wrote:

Hi Aslak,

I have a policy to not answer questions directed at me personally on this list.

Please send a new email where you're addressing the group.

Thanks!

Aslak 

--
Posting rules: http://cukes.info/posting-rules.html

---
You received this message because you are subscribed to the Google Groups "Cukes" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cukes+un...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Srisowrabha Kumar]

Very sorry. As a thread already existed, thought of posting here.

[Suresh Sa]

Hi,

Do u have solution for this on. Right now I am searching solution for this one.

Thanks,

Suresh

[Roberto Lo Giacco]

Il giorno giovedì 23 giugno 2016 22:34:08 UTC+2, Suresh Sa ha scritto:

Hi,

Do u have solution for this on. Right now I am searching solution for this one.

Why do you expect Cucumber to infer the data from your spreadsheet? Cucumber is unaware of your rows/columns all together. Aslak was suggesting to read the data from the csv/excel within a step implementation and do whatever you want with that data, he never said Cucumber parser will ever be aware of that data.

Are you sure you are not trying to use Cucumber as a testing framework? Do those data have a meaning in defining your business requirement?