Wednesday, 15 March 2017

How to I set up nodeJS to pull data from a spreadsheet

I trying to develop a node JS script that pulls data from a spreadsheet to use in the script.

My script starts like this:

var webdriverio = require('webdriverio');
var Excel = require('exceljs');
var testData = require('xlsx-extract');
//var Excel = require ('xlsx-style')
var options = {
    desiredCapabilities: {
        //browserName: 'phantomjs'
        browserName: 'chrome'
    }
};

var count = (1);
var testDate = new Date();
var Login = ('#button.mb24.secondary.wide')
var workbook = new Excel.Workbook();
workbook.xlsx.readFile('Myspreadsheet_v1.xlsx')
    .then(function() {
        getCell('A2').value
        console.log('url is: ' + getCell('A2').value);
    });

//var workbook = new Excel.Workbook();
//stream.pipe(workbook.xlsx.createInputStream('./Myspreadsheet_v1.xlsx'));

var worksheet = workbook.getWorksheet(1);
var sfurl = worksheet.getCell('A2').value;
var loginName = worksheet.getCell('B2').value;
var loginPassword = worksheet.getCell('C2').value;

However, I get an error when I try to run it:

xxxxxxx/xxxxxxx/xxxxx.js:32
var sfurl = worksheet.getCell('A2').value;
                     ^

TypeError: Cannot read property 'getCell' of undefined
    at Object.<anonymous> (xxxxxxx/xxxxxxx/xxxxx.js:32:22)
    at Module._compile (module.js:570:32)
    at Object.Module._extensions..js (module.js:579:10)
    at Module.load (module.js:487:32)
    at tryModuleLoad (module.js:446:12)
    at Function.Module._load (module.js:438:3)
    at Module.runMain (module.js:604:10)
    at run (bootstrap_node.js:394:7)
    at startup (bootstrap_node.js:149:9)
    at bootstrap_node.js:509:3

I am really at a loss for what I did wrong and how to fix it. I have npn in stalled and I installed node-xlxs and node-exceljs as well. I nodeJS installed on my system.

I used these links to try to get started: https://www.npmjs.com/package/xlsx https://www.npmjs.com/package/exceljs

Any help would be greatly appreciated.

Thanks.



via ironmantis7x

No comments:

Post a Comment