Can we use webstorm to use excel data some how?

Webstorm provides no support for excel. I'm not however sure what kind of support you are expecting here and how it is related to node.js. Please can you clarify?

I am very thankful that you replied.

I am a bachelor's final year student. And fascinated by a project in which my guide said that i have to take only one variable as input.

Project is about Civil engineering and topic is optimal solution for 2d truss.

So there are 4 things that software must define for user that has given required length as only input.

1) type of truss to uses

2) height of truss

3) material used to avoid failure condition

4) finally a complete model of that final truss (simple line diagram)

To do this my guide said to use nodejs as base and use Excel and data sheets.

We have huge data base ( search steel table, - useful for determining which section/shape to take of steel structure member)

My seniors have used vba for the same but it did not gave details.

So we have their database ready in Excel.

It took them 3-4 months to just type the database from book to excel.

I know the math and the logic of calculation

So i was thinking if we can only import or extract or just take value from excel by cell reference or any other way it would save me lot of time.

I am Civil engineer student and did not know what is nodejs a month back.

If for not my project i still want to learn nodejs.

Please guide me and refer me good sources to learn.

Well.. If you are looking for a way to parse excel data with Node.js, you can try some packages available on the web. For example;

node-xlsx (https://github.com/mgcrea/node-xlsx)

var xlsx = require('node-xlsx');

var obj = xlsx.parse(__dirname + '/myFile.xlsx'); // parses a file

var obj = xlsx.parse(fs.readFileSync(__dirname + '/myFile.xlsx')); 

exceljs (https://github.com/guyonroche/exceljs)

// read from a file
var workbook = new Excel.Workbook();
workbook.xlsx.readFile(filename)
    .then(function() {
        // use workbook
    });

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

xlsx (https://www.npmjs.com/package/xlsx):

var XLSX = require('xlsx');
var workbook = XLSX.readFile('Master.xlsx');
var sheet_name_list = workbook.SheetNames;
console.log(XLSX.utils.sheet_to_json(workbook.Sheets[sheet_name_list[0]]))

See https://www.quora.com/How-do-I-read-a-xls-file-in-nodejs, for example

Anyway, this has absolutely nothing to do with WebStorm, and no excel integration is required