Open KurtPreston opened 4 years ago
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
FUNCTION
=myMultCellFn()
COL_RANGE
ROW_RANGE
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:
Where
FUNCTIONis the function (i.e.=myMultCellFn())COL_RANGEis the number of columns to coverROW_RANGEis the number of rows to cover