Support for multi-cell array formulas?
Opened this issue · 0 comments
KurtPreston commented
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