biikej
3 years agoOccasional Visitor
Reading Excel Data with groovy and execute request
Hi Everyone
I want to use Excel as a Datasource (Testdata) to execute an request where it creates me a Person with information about him.
I want to be able to execute one or five testdatas at once.
I saw some videos regarding this issue but somehow I am not able to do it since my data is different then theirs and im not very good in groovy script.
My dataset looks like this:
Attribute | Dataset1 | Dataset2 | Dataset3 |
Language | de | fr | en |
Name | QW | ER | TZ |
Surname | AS | DF | GH |
Degree | False | True | False |
Gender | Male | Female | Male |
Birthdate | 1988-01-01 | 1989-01-01 | 1990-01-01 |
Could someone help me with the groovy script?
Vallalarasu_P I tried your version with csv and that would work but the birthdate is changing for me from "yyyy-mm-dd" to "dd-mm-yyyy" when I save the file.