CODEWITHSUNDEEP
javascriptnode.jsexcelspreadsheet
tamis
tamis

Reputation: 135

Evaluating spread sheets from nodejs?

I'm working on a project that requires a series of calculations involving specialists in different fields all with there own nomenclature and methodology. These calculations can change over time. In particular any changes based in law and calculating taxes are subject to frequent change.

These specialists don't know how to code but do build spreadsheets on a regular basis.

In order to avoid having to become a specialist in each field myself It would be a great time saver if I could load spreadsheets into my node js javascript code and evaluate them.

Something like this:

const file = module.loadSpreadsheetFile('file.spreadsheet')
const mysheet = file.sheet('mysheet')
const output = mysheet.evaluate(input)

Where input would look something like:

const input = {
  cellname1 = 10,
  cellname2 = 20,
  ...
}

Modules I have found so far only allow you to read and write from spreadsheets. Is anyone aware of a way to actually evaluate spread sheets and do calculations from nodejs?

Upvotes: 0

Views: 113

Answers (1)

Mayer János
Mayer János

Reputation: 61

I don't think this feature exists but maybe you don't need it. You could evaluate these calculations inside the sheet itself, put the results in certain cells and use any module that you've already found to just read the results from those cells.

Upvotes: 0

Related Questions