javascript - Data Driven testing with Protractor -

javascript - Data Driven testing with Protractor -

i have been working protractor couple of weeks , have been impressed . 1 thing getting stuck on how go doing info driven testing in protractor when info comes , excel spreadsheet.

for illustration have spreadsheet phone call users.xls

user.xls has 2 columns , 4 rows this.

|uesrid| password| |user1 | pass1 | |user2 | pass2 | |user3 | pass3 |

how can read excel spread sheet loop thru info passing value user.xls test.

wow! no 1 answered question 6 months?

you need utilize csvtojson plugin convert csv file json , protractor test read json file. improve integrate gulp gulp regenerate json file changes made csv file

sample code:

var gulp = require('gulp'); var convert = require('gulp-convert'); var rename = require('gulp-rename'); var watch = require('gulp-watch'); gulp.task('convertcsv', function() { console.log('converting'); gulp.src('./testdata/*.csv') .pipe(convert({from: 'csv', to:'json'})) .pipe(rename({extname: '.json'})) .pipe(gulp.dest('./testdata/json/')); }); gulp.task('csv', function () { console.log('watching'); gulp.watch('./testdata/*.csv', ['convertcsv']); });

to utilize data:

describe('loginpage.', function() { var loginpage = require('../pageobjects/loginpage.js'); var logindata = require('../testdata/json/logindata.json'); logindata.foreach(function (data) { it(data.description, function () { loginpage.usernamefield.sendkeys(data.username); loginpage.passwordfield.sendkeys(data.password); loginpage.loginbutton.click(); }); }); });

javascript excel protractor