如何从excel(XLSX)excel量角器读取数据? [英] How to read data from excel(XLSX) excel Protractor?
本文介绍了如何从excel(XLSX)excel量角器读取数据?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我对量角器非常陌生.因此,任何机构都可以帮助我将xlsx文件中的日期获取到Web应用程序中.下面是我编写的代码.
var testData1 = require('path/book1.xlsx');var a = element(by.id("Name"));var b = element(by.id("Description")));a.sendKeys(testData1 [0] .Name);b.sendKeys(testData1 [0] .Description);browser.sleep(3000);
我遇到此错误`
消息:失败:无效或意外的令牌堆:D:\量角器\ book1.xlsx:1(函数(导出,需求,模块,__ filename,__ dirname){PK♥♦¶
这是xlsx文件
^`
解决方案
安装
//文件夹 node_modues
结构:
I am Very much new to Protractor . So can any body please help me to get the date from xlsx file to the web apps. Below is the code which I wrote.
var testData1 = require('path/book1.xlsx');
var a = element(by.id("Name"));
var b = element(by.id("Description"));
a.sendKeys(testData1[0].Name);
b.sendKeys(testData1[0].Description);
browser.sleep(3000);
I am Getting this error`
Message:
Failed: Invalid or unexpected token
Stack:
D:\Protractor\book1.xlsx:1
(function (exports, require, module, __filename, __dirname) { PK♥♦¶
this if xlsx file
^`
解决方案
Install node-xlsx as project dependency by execute npm install -S node-xlsx
//excelAgent.js
var xlsx = require('node-xlsx');
exports.read = function(_file) {
var xlsObject = xlsx.parse(_file);
return xlsObject? xlsObject:[];
}
// test.js
var excelAgent = require('./excelAgent.js');
var excelFile = '';
var data = excelAgent.read(excelFile)[0].data; // first sheet's data
var data = excelAgent.read(excelFile)[1].data; // second sheet's data
// project folder structure:
// folder node_modues
structure:
这篇关于如何从excel(XLSX)excel量角器读取数据?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文