natergj/excel4node

Support for multi-cell array formulas?

Opened this issue · 0 comments

Is your feature request related to a problem? Please describe.

Excel functions can return arrays. Excel supports the ability to write the results of these functions to multiple cells. A good explanation is here:
https://exceljet.net/glossary/multi-cell-array-formula

I could not find information about multi-cell array functions in the documentation. Is it supported?

Describe the solution you'd like

If it is supported, it would be great to have an example in the README. If it is not, I would propose an API like:

ws.cell(1, 3).multiCellFormula(FUNCTION, COL_RANGE, ROW_RANGE);

Where
FUNCTION is the function (i.e. =myMultCellFn())
COL_RANGE is the number of columns to cover
ROW_RANGE is the number of rows to cover