K
K
Kappy2019-04-22 13:45:57
JavaScript
Kappy, 2019-04-22 13:45:57

Implementing calculations from Excel to JS?

Please tell me, there is an Excel file, it has a lot of formulas, its own calculation method. But strictly formulas.
There was an idea to rewrite it in JS, but now I’m thinking, what if the formulas are changed, then the code will have to be changed as well. But it is possible to integrate this file, but I can substitute the data, excel will calculate, and then I will pull out the desired cell?
I took the Sheet JS library, I do everything according to the documentation, I just can't read the files.
For example here:

var wb =  XLSX.read('Calc.xlsx');
console.log(wb)

And in the end comes this:
5cbd9b247ac91583514576.png
Where there is nothing. But if you specify another file, then even less data comes there.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question